Strange formatting problem

[bkarlan1]

I can’t figure out what happened. I was making some changes in the preferences but nothing that should affect the color and formatting of these two columns. In Calc, the Dates were formatted as Date, and the Currency column was formatted as Number ($1,234) with negative numbers in Red and positive in Black. However, what is most odd is that in Excel, PlanMaker, Numbers, OnlyOffice, using the same file, the formatting is correct which is Black for Dates and Black and Red for Currency. But only in Calc are both displaying as Blue font and I’m unable to change it back.
LibreOffice Calc:

PlanMaker:

Excel:

Numbers:

[robleyd]

You have (inadvertently) turned on View | Value Highlighting. Simply toggle that setting, or use keyboard shortcut Ctrl+F8 to toggle it.

[bkarlan1]

Thank you. That fixed it. But what is Value Highlighting? I see no obvious reason for this feature.
Also, I’m seeing that Value Formatting is turning itself on automatically. I turned it off and then I tried to format the page to print and then Value Formatting was on again.

[LeroyG]

@robleyd

Value Highlighting

Value Highlighting don’t show negative numbers in red; and with Conditional Formatting only shows the background color, not the font color. (Version 7.1.8.1)

I think that it could be an issue with the file type (not an .ods).

[EarnestAl]

@bkarlan1

Also, I’m seeing that Value Formatting is turning itself on automatically

In that case you might have accidentally enabled it by default. Click Tools > Options > LibreOffice Calc > View and under Display, untick Value Highlighting

Value Highlighting is used for quick error checking to see if data is consistent, is calculated, is in the correct format not just apparently correct, etc. An example might be a cell containing 4 Apr 22, it will show as black if text, blue if an actual date, green if a calculated date

[bkarlan1]

Nope, not turned on.

[EarnestAl]

Value highlighting doesn’t print. See File > Print preview
It isn’t enabled by Undo or Redo
Maybe you have an icon for it on a toolbar that is getting pressed accidentally, it looks like: @
Maybe you accidentally press Ctrl instead of Fn on the keyboard when selecting the alternative function for F8