[Bug 159167] Check whether formula in conditional formatting are valid

[bugzilla-daemon at bugs.documentfoundation.org]

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

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |87351
                 CC|libreoffice-ux-advise at lists |heiko.tietze at documentfounda
                   |.freedesktop.org            |tion.org
                 OS|Windows (All)               |All
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW
            Summary|Conditional formatting of   |Check whether formula in
                   |cells based on rules for    |conditional formatting are
                   |checking values greater     |valid
                   |than or less than           |
           Keywords|needsUXEval                 |

--- Comment #16 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(In reply to Rafael Lima from comment #5)
> AFAIK it is not possible to define a conditional formatting rule where the
> condition is a range. 
I wouldn't expect a range for simple comparisons like "is equal to" but when it
comes to "is in top N elements" the situation is less clear. 
https://help.libreoffice.org/24.2/en-US/text/scalc/01/05120100.html

> It has to be either a single cell or the result of a formula.
Using MIN(A$1:A$2) as suggested in comment 3 works well. The issue was that
"$Tabelle1.$A$2:$E$2" is not a formula; less than a range does not compute.

Nevertheless I agree with room for improvement. If a function does not return a
simple value like A1:A2 or MIN() without parameter, it should trigger a warning
and not become accepted.

I'll change the summary accordingly. If you disagree, Alexander, feel free to
revert.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=87351
[Bug 87351] [META] Conditional formatting bugs and enhancements
-- 
You are receiving this mail because:
You are on the CC list for the bug.