Bug 146303 - Cell range not properly adding up with cell that includes a reference
Summary: Cell range not properly adding up with cell that includes a reference
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.6.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-12-18 16:23 UTC by TomC
Modified: 2021-12-21 21:41 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description TomC 2021-12-18 16:23:13 UTC 
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.
Comment 1 m_a_riosv 2021-12-19 00:32:20 UTC 
Please, can you attach a sample file.
Comment 2 TomC 2021-12-21 16:05:23 UTC 
I opened up a spreadsheet today to edit out as much personal info as possible prior to submitting the sample as requested. Surprisingly, the totals are coming up correct now. I don't understand it, as nothing has changed, except that I've edited the spreadsheet in question a few times in Google Sheets. At this point, I'm unable to replicate the issue, so you can either close this or place it on hold, pending a recurrence of the problem. Thank you.