Shrink To Fit Cell Size problem

Since a few weeks Shrink To Fit Cell Size does not work (cell 2 in the image)
If I use Clear Direct Formatting, the text, while maintaining the same Font Size, is reduced to an almost illegible size aligned at the bottom left (cell 3 of the image)
Furthermore, the text in cell 2 is not visible in the print preview.
Some idea?

2021-09-15_112215

I created a new file. It seems all ok but in print celle 3 is again reduced to an almost illegible size aligned at the bottom left

Untitled 1.ods (10.4 KB)

It looks like tdf#143978 for shrink to fit, although present earlier it is more noticeable in LO 7.2. according to bug report. The text I see in 7.1.5.2 is bigger than the same text in 7.2.0.4.
The text in cell 2 not being visible in print preview does not occur on my PC. You would probably have to share a sample spreadsheet showing the problem. Click the pencil icon to edit your question and upload an .ods file. Cheers, Al

That appears to be bug tdf#143978.

Try latest version LibreOffice 7.2.4

https://bugs.documentfoundation.org/show_bug.cgi?id=143978

I have the same problem on a Mac with LO 7.2.1.2 Either no shrinking at all or a weird over-shrinking with microscopic characters. I would appreciate a tip or a fix from the programmers. Thanks.

That isn’t an answer.

1 Like