Text overflow means to show text exceeding the column width in the adjacent cells. Like "Hello brave new world" in A1 going into A2, if empty. If A2 contains any content a small triangle is shown. And per Tools > Options > Calc > View > Text Overflow only this triangle can be disabled. The request is to block overflow completely- expected this with the option. And actually I'd like to clock overflow per column respectively cell. In some cases you want to read the full text but there are as many situations where empty cells in the adjacent column are normal and you search for the few that have content. This workflow is not possible with the overflow mechanism.
Moving to NEW
clock => block
*** Bug 139601 has been marked as a duplicate of this bug. ***
*** Bug 150514 has been marked as a duplicate of this bug. ***
Related Ask.LO questions: - https://ask.libreoffice.org/t/prevent-text-overflow-in-other-cell/15329 - https://ask.libreoffice.org/t/libreoffice-refuses-to-hide-text-overflow/10787/7 Heiko, now that Text Overflow is only about the indicator and has moved to Options > LibreOffice > Application Colors (since 7.6 and the fix for bug 154080), where do you suggest to have such a setting? In my opinion, best to have it as a cell formatting option in Format > Cells > Alignment. (Rather than a global setting.) But that would require: - checking with what ODF supports (I assume it would be an extension, Regina?) - thinking about how it behaves in relation to other properties in that dialog. Another option in the Alignment drop down (probably easier), or orthogonal to Alignment as an extra option in the Properties section? Google Sheets has three Text Alignment options available: - overflow - wrap - clip (what we want) But that clip property doesn't even seem to be written to XLSX or ODS in any way: export and import back into Google Sheets doesn't restore the property.
Created attachment 194391 [details] screenshot of Google Sheets text alignment options
It is related to cell property fo:wrap-option (20.230, part 3, ODF 1.3). It specifies, "If wrapping is disabled, it is implementation-defined whether the overflow text is visible or hidden." That means, LibreOffice can do what it wants. But we need do document it in https://wiki.documentfoundation.org/Development/ODF_Implementer_Notes/List_of_LibreOffice_ODF_implementation-defined_items But it also means, that any solution cannot be written to file as cell style property but could only be written as general setting and would as such affect all cells. To get a solution for individual cells, an extension to ODF is needed. Remark: For any solution you have to consider, that the writing direction in cells need not be horizontal left-to-right and that we have additional options like "Shrink to fit cell size". And you need to consider interoperability with Excel.
(In reply to Stéphane Guillou (stragu) from comment #5) > In my opinion, best to have it as a cell formatting option in Format > Cells > > Alignment. (Rather than a global setting.) In this tab we have "[ ] Wrap text automatically", and likewise GSheets we could enhance this into a multiple choice option. "Wrap on" disables "[ ] Shrink to fit", but shrink on does not prevent wrap on. I could imagine to add shrink as another option to the proposed dropdown (or maybe bettwer radio buttons). And I think it's needed as a per-cell option.