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@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
CC: olivier.hal...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs