https://bugs.freedesktop.org/show_bug.cgi?id=84540
Priority: medium
Bug ID: 84540
Assignee: [email protected]
Summary: EDITING: adding/removing/sorting out rows will not
update formulas in Calc spreadsheet
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.3.1.2 release
Component: Spreadsheet
Product: LibreOffice
Occurring since this spring (can't remember version, so entering latest I have
on the mac)
Occurred this spring on Fedora 19 too, I have not tested lately. The bug is on
OS X 10.6.8 for months too.
When I add or remove rows for adding values, or sort out rows, in a simple
spreadsheet with only a few sums after, the formulas don't update to the new
subsequent cell names, generating wrong sums or errors.
Occurs with formulas like =sum(A:B) =sum(A;B)
Sums using =A+B+… seem to be immune though I can't be definitive.
(letters are cells ID)
Work around for now : never adding rows in the middle of others, always at the
end of the ones with data, and never sort rows.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
