https://bugs.documentfoundation.org/show_bug.cgi?id=147398
Bug ID: 147398
Summary: In Calc ver 7.3.0.3. =Sum covering a range of cells
fails to adjust when additional values are added
within the range
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I ran an auto update to ver 7.3.0.3. yesterday and when I added a new entry to
my existing spreadsheet running in Ubuntu 20.04 I have found that the simple
=Sum(:) will not calculate beyond the last old entry before the update. I have
ensured that the references to the cells include those in which I have put the
new entries but the calc just ignores the new entries. if there were 20 entries
before the update and I add a further 3 entries it still includes only 20, even
though the range of fields include the new entries. I have checked that the
cell format is numeric and it is.
Copying the offending sheet contents (mark all/copy/paste) to a new document
still repeats the anomaly.
Description:
A calculated cell dependent on several other calculated cells does not update
even what certain antecedent cells see a change in data and update correctly.
Copied versions of the sheet contents in other sheets seem to vary in which
antecedent cell dependencies do not trigger update of the dependent cell.
Toggling auto-calculate has no effect.
Toggling (and restarting) multi-threading seems to have no effect.
Dependent cell does update after hard recalculate.
Only the built-in SUM and COUNTA functions are in use at any level.
Steps to Reproduce:
1.Create a multi column sheet with a row for Sum and an additional row for
CountA.
2.Set the Sum to cover the data entered and some additional empty cells in the
column.
3.Set the CountA as per step 2 above
4.In a separate cell set the formula =Sum(*:*)/Sum(*.*) the first Sum being the
sum of the column Sum cells the second being the sum of the CountA cell values.
The objective being to give an overall avg.
Actual Results:
When established the O/A Avg is produced ok. However when additional data is
added into the data columns in cells covered by the column Sum and CountA the
O/A Avg does not recognise the changed values displayed in the column Sum &
CountA.
Expected Results:
The O/A Avg should adjust to reflect the new values in the column Sum and
Count.
Reproducible: Always
User Profile Reset: No
Additional Info:
A copy of the calc has been provided on Ask LibrsOffice.org and @Joshua4 has
had the same result on his system.
--
You are receiving this mail because:
You are the assignee for the bug.
