When I try to use text wrapping or insert a line break, it’s reflected accurately in the formula bar, but the multiple lines will display overlapped within the cell itself. The size dimensions of the cell don’t seem to matter, Calc treats it as one line and the optimal row height will always set to 0".
Version 7.5.1.2.
I guess it could be a corrupt user profile. In Calc, if you click Help > Restart in safe mode > Continue in safe mode does the same effect occur?
If it is OK then consider closing LibreOffice entirely, renaming your user folder to something like user_[YYYY-MM-DD], restarting LO, checking, and then copying back the folders you need. See LibreOffice user profile - The Document Foundation Wiki
Hey, thanks for responding! I was actually just about to edit in an update to this:
I’ve discovered that if I save the Calc file in certain file formats (.xlsx and .odf both seem to work, .csv does not) and then close and re-open the document, things work properly again. Seeing as restarting in safe mode and a fresh Calc file doesn’t fix it either, I’m wondering if this is a bug of some kind?
Have you restarted Windows? Click Start menu > Power > Restart, (Not Power Off as that defaults to Hibernate)
If no improvement, then try re-installing LibreOffice. Or in Control Panel\All Control Panel Items\Programs and Features right click LibreOffice and select Repair.
Shared computer, so I haven’t had the opportunity yet. I’ll give that a shot when I can and then update.
Sorry for the delay. I was told the program became unusable for some reason and got re-installed, which fixed this issue as well. Thank you!
I had the exact same problem today in LibreOffice Calc, probably appearing after my organization had upgraded to 7.6.4.1 (X86_64) / LibreOffice Community, on Windows 10.0. Text placement in a cell was completely bonkers and if top-aligned it would be nearly invisible (as if appearing in the cell above instead). When word wrapping was enabled all lines would be overlaid, as in the original poster’s screenshot, and the cell height wouldn’t increase.
After a while I noticed that if I changed font from the default Liberation Sans to almost anything else (e.g. Arial or Noto) things behaved normally again. So it was a font issue. New web searches with this in mind gave suggestions that some different font installation methods might have ended up causing something wrong.
My fix was to open the start menu, type “font” to and click the shortcut to Font Settings. Then I would search for Liberation and use the Uninstall button to remove all the variants of those fonts. I then re-ran my organization’s installer of the same LibreOffice version and restarted my computer. The Liberation fonts are back and now they work!