[Libreoffice-bugs] [Bug 119421] New: Documentation for "Formula is" in Conditional Formatting is wrong (and info missing).

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119421
           Summary: Documentation for "Formula is" in Conditional
                    Formatting is wrong (and info missing).
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: nis at superlativ.dk
                CC: olivier.hallot at documentfoundation.org

Description:
The help file here

https://help.libreoffice.org/6.1/en-US/text/scalc/01/05120000.html?DbPAR=CALC#bm_id3153189

has this to say about the "Formula is" option:

"If you select *Formula is* as a reference, enter a cell reference. If the cell
reference is a value other than zero, the condition matches."

The reality is (I guess) that you can enter any formula, and if it evaluates to
a value other than 0, the condition matches. 

Now, since a cell reference is also a (very simple formula), you can use the
functionality as described, but this is missing the major parts of the
functionality.

Apart from this, there should also be information about how relative cell
references in the formula are resolved when the condition is applied to a range
of cells (I have not been able to find this info anywhere).

Also missing is information about how overlapping conditional formatting is
handled.

Steps to Reproduce:
1. Open the help for "Conditional Formatting", look at the "Formula is" line

Actual Results:
A sentence which describes a very limited part of the functionality.

Expected Results:
Precise information about how formulas in conditional formatting work.


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180822/b264a7a9/attachment.html>