Description: I have a file with a list of figures in currency format. When I selected the entire column and change the color to red, the numbers remained black. They did appear red whilst typing in a new figure but turned to default/ black one I moved away from the cell I had just edited. Steps to Reproduce: 1. enter a column of figures in currency format (have not tried other formats) 2. select column 3. change color to red Actual Results: Nothing happens. numbers and symbol of currency (Eur in this case) remain black. Expected Results: Numbers should turn red as selected. Reproducible: Didn't try User Profile Reset: No Additional Info: n/a
Please attach a sample file, and paste the information in Menu/Help/About LibreOffice, there is an icon to copy.
Have you enabled? Menu/View/Value highlighting. Please don't use private message, there is the option to include attachments, on top of the first message.
Check the following setting: * Menu Tools > Options > LibreOffice > Accessibility > Use automatic font color for screen display (set OFF, unchecked box) * OK * CTRL+SHIFT+F9 (Recalculate Hard) Does that help?
(In reply to m.a.riosv from comment #2) > Have you enabled? > Menu/View/Value highlighting. > > Please don't use private message, there is the option to include > attachments, on top of the first message. That helped - yes.
(In reply to ady from comment #3) > Check the following setting: > > * Menu Tools > Options > LibreOffice > Accessibility > Use automatic font > color for screen display (set OFF, unchecked box) > > * OK > * CTRL+SHIFT+F9 (Recalculate Hard) > > Does that help? Already unchecked. CTRL+Shift+F9 turns my mic on/off like F9 on its own does. No. It did not help but the other reply did.
Issue seems solved. Thanks
I am setting this as invalid, because this is not even a real (potential) bug report. Please next time go to <https://ask.libreoffice.org>.