First time I ever encountered this and it has me treed.
For no reason that I can discern my entire sheet is now formatted as follows:
Keyboard-entered Text remains black, as it should.
Formula-derived Text, Dates and Numbers are now displayed in green.
Keyboard-entered Dates are displayed in blue.
These changes cannot be altered with the Text Color menu of colors, either individual cells or groups of highlighted cells, and I can find no method of formatting Spreadsheets as a whole. This color formatting does not carry over to the printer.
Appreciate any help.
[Solved] Unexpected text color in cells; can't change
[Solved] Unexpected text color in cells; can't change
Last edited by MrProgrammer on Sun Mar 16, 2025 9:26 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved]
Reason: Tagged ✓ [Solved]
Open Office 4.1.15, Windows 11
Re: Random unintentional formatting changes
Turn off /View /Value Highlighting.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
Re: Random unintentional formatting changes
Will do, and THANK YOU very much!!
Open Office 4.1.15, Windows 11