https://bugs.documentfoundation.org/show_bug.cgi?id=150904
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Mike Kaganski <[email protected]> --- (In reply to Kurosh Tavassoli from comment #0) > When I want add a condition to a cell when its empty, I add the following > condition: > > IF &Cell is equal to "" THEN [condition] Not exactly. It is not "&Cell", but "Cell value" - and that is really important. Empty cell does *not* have a value at all, so you can't check what its value is. Instead, use "Formula is", and use ISEMPTY(cell), which expresses the intention explicitly. IMO, it has no reason to try to add another option to the drop-down for every thinkable condition (which is impossible). The existence of formula condition gives user everything required to construct any condition they need. -- You are receiving this mail because: You are the assignee for the bug.
