https://bugs.documentfoundation.org/show_bug.cgi?id=157389

--- Comment #4 from ady <[email protected]> ---
(In reply to Lazarus from comment #0)
> A2 and A3 should not be white. The format is text, but the
> conditional format still doesn't apply even if I change the format to number.

When you change the format from text to number, the content is ("almost")
modified too; look at the input box (formula bar) and you will see an initial
apostrophe before the number.

You are using color scale as conditional format; colors are applied according
to a scale of numeric values.

You need to actually have numeric values (not numbers formatted as text) for a
color scale conditional format to be correctly used.

Generally speaking, I would suggest using https://ask.libreoffice.org or the
users mailing list in order to ask questions and to confirm whether there is
really a bug to report.

This report should be considered either not a bug or invalid.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to