[Libreoffice-ux-advise] [Bug 150271] [UI][RFE] clearly visible hint or tooltip when entering a non-number Conditional Formatting condition

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #13 from Eike Rathke <erack at redhat.com> ---
The message "Strings without quotes are interpreted as column/row labels" is
nonsense anyway. Strings without quotes are interpreted as whatever the formula
expression context evaluates them to, that *may* be column/row labels, or cell
references or named ranges or named expressions or database range names, ...
i.e. the warning goes away if input is completed to such valid expression.

The important part is that if one wants to compare against a literal string
then one has to enclose the text in double quotes, as in any formula
expression.

Entering a single + character is just the same as entering  =+  as cell formula
(which if closed evaluates to Err:520 syntactical error).

An additional check probably could test the compilation result of the formula
expression, but you don't want that for every key pressed..

Furthermore there are errors that are detected only by the interpreter and can
be even position dependent, which comes into play if the conditional format is
copied around. There's not much that can be done there except interpreting the
formula expression once *on the position where it is defined* when entering it.

-- 
You are receiving this mail because:
You are on the CC list for the bug.