https://bugs.documentfoundation.org/show_bug.cgi?id=150332
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #4 from Mike Kaganski <[email protected]> --- The element appearing in the value box of the format represents a Calc's data. The data can be a number, a string, or a reference. As always, a string is delimited by double quotes. Consider a normal formula in a cell, where you compare another cell to a string. This is a correct formula: =I12="work" This is an incorrect formula: =I12=work Likewise, your string must be enclosed in double quotes in your condition: not work but "work" Closing NOTABUG. -- You are receiving this mail because: You are the assignee for the bug.
