[Libreoffice-bugs] [Bug 137715] New: Spreadsheet functions need clarification that they ignore text

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137715
           Summary: Spreadsheet functions need clarification that they
                    ignore text
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com
                CC: olivier.hallot at libreoffice.org

Help for SUM [1] includes this note:

> SUM ignores any text or empty cell within a range or array. If you suspect
> wrong results of the SUM function, look for text in the data ranges. Use the
> value highlighting feature to highlight the text contents in the range that
> may represent a number.

However, this applies not only to SUM, but also to AVERAGE [2], SUMSQ [3], and
PRODUCT [4], all of them not having similar note. They should get it.

[1]
https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060106.html?&DbPAR=CALC#Section16
[2]
https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060184.html?&DbPAR=CALC#average
[3]
https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060106.html?DbPAR=CALC#Section25
[4]
https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060106.html?DbPAR=CALC#Section26

-- 
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/20201024/01ab056f/attachment-0001.htm>