Bug 119421 - Documentation for "Formula is" in Conditional Formatting is wrong (and info missing).
Summary: Documentation for "Formula is" in Conditional Formatting is wrong (and info m...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Help-Changes-Features
  Show dependency treegraph
 
Reported: 2018-08-22 11:33 UTC by Nis Jørgensen
Modified: 2019-04-16 14:22 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nis Jørgensen 2018-08-22 11:33:37 UTC
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:
Comment 1 Buovjaga 2018-09-29 13:53:32 UTC
Can you provide a proposal of how exactly you would correct and add to the text?

Removing meta bug "HelpGaps" as this is not about a new feature.
Comment 2 Nis Jørgensen 2018-09-29 15:17:45 UTC
(In reply to Buovjaga from comment #1)
> Can you provide a proposal of how exactly you would correct and add to the
> text?
> 
> Removing meta bug "HelpGaps" as this is not about a new feature.

As a very minimum, I would change it to

"If you select *Formula is* as the condition type, enter a formula. If the formula evaluates to  a value other than zero, the condition matches."

Then - possibly  with a different wording:

"The formula will be evaluated as if it was entered in the cell, and can use both absolute and relative references. If defining a condition for a range of cells, relative reference should be given relative to the topmost cell in the leftmost column of the range."

This is based on my limited understanding of what the program actually does.

The label "Formula is" should probably be changed to just "Formula".