[Solved] Unexpected text color in cells; can't change

Discuss the spreadsheet application
Locked
DWDun
Posts: 111
Joined: Thu Aug 29, 2019 11:08 pm
Location: OK

[Solved] Unexpected text color in cells; can't change

Post by DWDun »

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.
Last edited by MrProgrammer on Sun Mar 16, 2025 9:26 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved]
Open Office 4.1.15, Windows 11
User avatar
RoryOF
Moderator
Posts: 35210
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Random unintentional formatting changes

Post by RoryOF »

Turn off /View /Value Highlighting.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
DWDun
Posts: 111
Joined: Thu Aug 29, 2019 11:08 pm
Location: OK

Re: Random unintentional formatting changes

Post by DWDun »

Will do, and THANK YOU very much!!
Open Office 4.1.15, Windows 11
Locked