https://bugs.documentfoundation.org/show_bug.cgi?id=157336
Bug ID: 157336
Summary: Spreadsheet Function AVERAGE Doesn't accept more than
30 arguments
Product: LibreOffice
Version: 7.6.1.2 release
Hardware: Other
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rmschal...@gmail.com
Description:
When AVERAGE function has more than 30 arguments,the result returned after
entering the function in the cell is #N/A. Note that you have to save the
change and then reopen the spreadsheet and you will see #N/A in the cell that
has more than 30 arguments for the AVERAGE function. This behavior was seen
with the MIN function as well. There maybe others that have the same behavior.
Microsoft excel has no issue using more than 30 arguments for these
spreadsheet functions.
Steps to Reproduce:
1. Create a row or column of 30 numbers.
2. In an unused cell, use the AVERAGE() to compute the average of step 1 above
3. Note that the value is correct for the 30 numbers used as arguments.
4. Repeat steps 1-3 but use another row or column of 31 numbers
5. Save and close the spreadsheet
6. Reopen the spreadsheet and note the result of step, it now displays #N/A
Actual Results:
#N/A is returned instead of the correct average of the 31 numbers
Expected Results:
The correct number representing the average of 31 numbers
Reproducible: Always
User Profile Reset: Yes
Additional Info:
.
--
You are receiving this mail because:
You are the assignee for the bug.
