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: libreoffice-bugs@lists.freedesktop.org Reporter: xy8...@gmail.com 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.