Public bug reported:
I was sent a spreadsheet document with a cell range containing numbers,
and a cell containing a SUM formula. The SUM is not working as it
should. It seems to retain a value from a previous sum calculation. You
can copy and paste the cell range and the issue persists. Also, if you
write a new fomula with SUM on the same sheet, the problem is re-
produced. If you copy to a new sheet the issue persists, but if you copy
to a new document the issue resolves itself, and the SUM works
correctly.
I do not know how to re-produce the issue from a clean document - it
only seems to be an issue in the document I was sent.
Unzipping the document, and finding the cell in the content.xml file,
this is the XML data for the cell in question.
<table:table-cell table:style-name="ce1"
table:formula="of:=SUM([.A1:.A8])" office:value-type="float"
office:value="260"><text:p>260</text:p></table:table-cell>
Steps to reproduce:
1. Open attached sheet
2. make SUM formula to add up some cells in column above the formula cell
3. change the values of the cells in the specified range
Expected behavior: the formula cell will update
Observed behavior: the formula cell does not update
** Affects: openoffice.org (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/918050
Title:
SUM() does not add up range, but retains cached value
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/918050/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
