https://bugs.documentfoundation.org/show_bug.cgi?id=148843
Bug ID: 148843
Summary: Function AGGREGATE bug
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When the error is ignored by sum in the AGGREGATE function, the cell specified
next to the error cell is not summed.
Steps to Reproduce:
1.Enter numbers in some cells
2.Create a cell where the calculation formula becomes an error (example: = 1/0)
3.Calculate with the AGGREGATE function.(AGGREGATE(9,6,x,y,z,Error cell,...)
Actual Results:
The number in the cell to calculate before the error cell is ignored.
Expected Results:
I do not understand.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
If you put a number in the error cell, it will be calculated normally.
--
You are receiving this mail because:
You are the assignee for the bug.
