Bug 146303

Summary: Cell range not properly adding up with cell that includes a reference
Product: LibreOffice Reporter: TomC <xy82za>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: miguelangelrv
Priority: medium    
Version: 6.4.6.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:

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.