https://bugs.documentfoundation.org/show_bug.cgi?id=150904
--- Comment #2 from Kurosh Tavassoli <[email protected]> --- (In reply to Mike Kaganski from comment #1) > (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. Yes, I totally agree. Thanks -- You are receiving this mail because: You are the assignee for the bug.
