Spreadsheet Missing Column Label Header A B C D E etc

I’m using Libreoffice Speadsheet for the first time … all the column label headers are barely showing the top of the letters A B C D E etc. How do I make the row height of the column label header cells taller? I’m using 7.5.2 with mac OS 13.6.3.

Here is a screenshot:

See if toggling View | Headers improves the situation.

Thanks for the suggestion, but it did not … still can’t see A B C D E etc.

I uninstalled 7.5.7.2, then installed 7.5.9.2 … still can’t see Label Headers A B C D E etc.

Did you try safe mode? Because new install will keep your old profile (wich may switch of your column-headers).

interestingly, the problem was spotted years ago in OO + MacOS …
https://forum.openoffice.org/en/forum/viewtopic.php?p=459784#p459784

Started up in Safe Mode, started Libre, opened Calc and the Columns Header Bar (re)appeared!

So that sent me down the path, I must have a “Login Item” conflicting with the header bar. I picked a couple of login items recently added by programs (Kensington Mouseworks and Drobo Dashboard … I know Drobo Dashboard is no long supported but I still have some Drobos I would like to use for backup … sorry for the sidebar), and turned them off, and restarted in normal mode. Opened Libre again and the header bar appeared like it should … great! Let me see which one is giving me problems … to make a longer story shorter, I still don’t really know because after turning on (1 at a time, or both), the header bar appears as they should. In other words, now I can reproduce the problem.

So all I can say for sure is that starting up in “Safe Mode”, opening Libre Calc, restarting in normal mode worked. Problem solved for now. Thank you Wanderer.

To me in the screenshot it looks like the headers are there, but with a height of just 1mm or so, i.e. tiny fragments of column letters and also the grid are visible, as if something was fiddling with the height of the headers. If a copy of the user profile was saved before starting in SafeMode and continuing with a fresh profile, you could diff the registrymodifications.xcu file to maybe spot a culprit (note there will probably be loads of differences and spotting the relevant might not be easy).

erAck, your suggestion is probably beyond my capability, or comfort level, of “exploring the solution”, however, I am curious as to where the user profile info and/or registrymodifications.xcs file(s) are located.

I know the following folders exist:
Applications/LibreOffice.app
User/(user)/Library/Saved Application State/org.libreoffice.script.savedState
private/var/folders/qj/v6vlss513n71nktib4tjsld40000gn/C/org.libreoffice.script
Users/(user)/Library/Application Support
Users/(user)/Preferences/org.libreoffice.scripts.plist

But I could not find the registrymodifications.xcs file.

Sorry, my bad, it’s registrymodifications.xcu (not .xcs), the user profile is located at
~/Library/Application Support/LibreOffice/4/user
see also LibreOffice user profile - The Document Foundation Wiki.

Found it … thank you.

erAck, your keen eye “To me in the screenshot it looks like the headers are there, but with a height of just 1mm or so, i.e. tiny fragments of column letters and also the grid are visible, as if something was fiddling with the height of the headers.” was right over the target. Through trail and error I discovered the font management program was the culprit … Font Explorer X (which also is a program that has gone by the wayside last year). When Font Explorer X was not loaded/activate the column header bar appeared … when Font Explorer X was activate the header bar disappeared. Exploring new font manager programs :slight_smile:

1 Like