https://bugs.documentfoundation.org/show_bug.cgi?id=146303
Bug ID: 146303
Summary: Cell range not properly adding up with cell that
includes a reference
Product: LibreOffice
Version: 6.4.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
My spreadsheet has a range of cells to total up. The total is not including a
cell when references a cell in another sheet within that same file. The total
is correct in Google Sheets, but is not working correctly in LibreOffice calc,
Version: 6.4.6.2. The correct amount shows in the referenced cell, but that is
not being included in calculating the total of the range.
Steps to Reproduce:
1.Enter a formula to sum a range of cells
2.Enter a reference to a cell in another sheet in the same file
3.The total does not include the cell in #2 like it used to
Actual Results:
The SUM is correct for the range, except for that one referenced cell. The cell
is correctly included in the SUM formula, but the SUM procedure is ignoring the
referenced amount.
Expected Results:
The SUM total should include the amount in the cell referenced in the other
sheet in the same file.
Reproducible: Always
User Profile Reset: No
Additional Info:
The SUM total should include the amount in the cell referenced in the other
sheet in the same file.
--
You are receiving this mail because:
You are the assignee for the bug.
