cannot apply color to text
1 Like
Hints:
- Switch off the âView - Value Highlightingâ feature.
- Switch off the âCell protectionâ feature.
- Please upload your small (ODF type) sample file here.
3 Likes
Another possibility is that you have High Contrast enabled and Use automatic font colour for screen display set in Tools > Options > LibreOffice > Accessibility. After changing those settings you might need to Hard Recalculate to display the colours.
1 Like
I had the same problem: Black text on screen. Colored text on printout.
My solution:
- Tools / Options / LibreOffice / Accessibility
- High Contrast = Disable (Automatic[*] showed all text in black)
- Use automatic font color for screen display = unchecked
Bonus:
If you want the Print Preview to show the actual font colors, you have to also deselect "Use sytem colors for page previews.
@LibreOffice really needs to make these Options way more clear.
[*] Automatic = Automatically detect high contrast mode of operating system. Switches LibreOffice into high contrast mode when the system background color is very dark.
Within the Tools / Options / LibreOffice Calc menuâŚyou must DE-SELECT the Display, Value Highlighting tick box.
By default the box is ticked, which causes Values to be displayed in blue font. I was always annoyed by both this default behavior, and the fact that I could not see my chosen text color without switching to a Print Preview window.
It seems that you CANNOT simultaneously have Fonts displayed in the user-selected color AND have Values displayed in the system-default color (blue). See screenshot:
This is a âsolutionâ that seems to be only accessible if you approach it from the "Value Highlighting" direction.
The original inquiry by Urgic ⸺ which was the same as my problem ⸺ revolved around choosing a Font color but not being able to see the changes on the screen. It only appeared on the Print Preview version of the document.
The suggested solutions, prior to my discovery today, did not work. As I pointed out, that was because LO installs itself with Value Highlighting on, by default.
I found Value Highlighting to be an annoying baked-in âfeatureâ of LO-Calc that I did NOT know that I could toggle off. I had also been annoyed with the ânon-WYSIWYGâ user-selected font coloring.
Elsewhere, it was suggested in other discussion groups that the non-WYSIWYG color issue was a bug within LO-Calc, and that it (and other bugs) were fixed in the more recent versions of LO.
Note here, that until today I was running the most-recent version of LO available through my âSynaptic Packageâ manager â V 7.3.7.2
I âforcedâ an update by manually installing V 26.2.2.2 and was very disappointed that the update did NOT automatically fix the ânon-WYSIWYGâ font-color issue that I and others have had.
If, as in my situation, one did not know that there was such a feature as Value Highlighting [which can be toggled on/off], one would not know how to look for it, let alone guess that toggling **Value** Highlighting might have ANYTHING to do with the display of user-chosen / user-driven font colors!
It is akin to using a dictionary to find a word that you know how to pronounce, but donât know whether the written word begins with a hard-C, a Ch-, or a K-
So, to be informed by Profile - robleyd - Ask LibreOffice âŚ
As is clearly stated in the [documentation](https://help.libreoffice.org/latest/en-GB/text/scalc/01/03080000.html?DbPAR=CALC#bm_id3151384)...
seems to be a bit⌠well ⌠rude. Why did you not point out this solution nearly a year ago? Why did you wait until today?
It is the âseemsâ that is being confirmed verified as not being able to have a font colour when value highlighting is enabled.
Value highlighting is off by default in a new install.
.
It âseemsâ that at some stage a setting has been changed in your Calc. To change the setting, click Tools > Options > LibreOffice Calc > View and, under Display, untick the box Value Highlighting. OK
3 Likes