https://bugs.documentfoundation.org/show_bug.cgi?id=151909
Bug ID: 151909
Summary: Calc not including field (from other tab refer) in SUM
Product: LibreOffice
Version: 7.3.6.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Calc is not correctly totalling a group of cells that includes a reference
total from another tab. It basically ignores this one cell and doesn't include
it in the calculation of the column SUM.
Steps to Reproduce:
1.(column SUM is correct when I edit the spreadsheet in Google Sheets)
2.If the values in the SUM column are changed with LibreOffice, the SUM total
ignores the value from the 1st cell (which is the referenced value from another
tab/sheet)
3.
Actual Results:
The SUM cell contains a formula to add up the 5 cells above it. The 1st cell is
a total value brought over from another tab/sheet. Once any of the values are
edited in Calc, the SUM does not include that 1st value.
Expected Results:
All 5 cells should be included in the SUM, including the cell with the value
from another sheet.
Reproducible: Always
User Profile Reset: No
Additional Info:
This issue is a continuing problem with LibreOffice. I have reported it with
previous versions, but it has not been corrected.
--
You are receiving this mail because:
You are the assignee for the bug.
