Libreoffice refuses to hide text overflow

I read and understand the official documentation. I had easily found the setting, and followed the instructions to the letter, as well as corroborated it with several online guides.

After many hour of trying, it simply doesn’t work. The setting appears to be broken. “text overflow” checkbox is merely a decoration with no actual functionality.

OS: Centos7


Build ID:

Aka: Mcbuggypants

Just to put it absolutely clear: You are missing the little red triangle (surrounded by a thin black line) hinting the existence of not displayed parts of the text content of a Calc cell in the case of a neighbour cell not accepting being used for the overflow to display or at the left or right border of all the sheet.
You are also aware of the effects of invisible content and of hidden columns and of the feature not applying to vertical overflow or to rotated orientation.

(For those who may take the original subject “Libreoffice {Calc} refuses to hide text overflow” litterally and may not have read and understood the complete documentation)

The option > ‘Tools’ > ‘Options’ (‘Preferences’) > ‘LibreOffice Calc’ > ‘View’ > ‘Display’ > ‘Text overflow’ does not afflict the overflow itself but its indication by an ‘overflow marker’.

The overflow itself is unchangeable default (afaik). To anyhow prevent the overflow itself you have to use specific means:

  1. Create (invisible) content for the cells potentially afflicted by the overflow. There are different ways to do so.

  2. Set the ‘Alignment’ property ‘Wrap text automatically’ or ‘Shrink to fit cell size’ for the potential source of overflow.

  3. Create a column containing any content whether visible or not in the concerned rows and hide it.

There is one strange thing I found (V4.3.3): Having wrapped content (by autmatic wrapping or by forced linebreaks) in a cell not fiitting into its display size because of too small row height you will get the overflow mark at the right side independent of the horizontal cell alignment.

I found this question still isn’t answered properly when googling. The solution I found:
Select the cells → format cells → alignment → text alignment → horizontal → set to ‘filled’

You find a comment on this suggestion by @mikekaganski here.

Yes, this fixed my spreadsheet: The solution I found: Select the cells → format cells → alignment → text alignment → horizontal → set to ‘filled’

@JAKE2: did you read the two comments above yours, and in specific the comment by @mikekaganski in the thread I linked to?
To set the alignment to Horizontal=Filled or to Wrap... or to Shrink... is a workaround at best.
A solution would require to introduce a new alignment attribute like Allow overflow with values like No and Yes or, better, No, Left side only, Right side only, Both sides.