https://bugs.documentfoundation.org/show_bug.cgi?id=150271
--- Comment #13 from Eike Rathke <er...@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 the assignee for the bug.
