https://bugs.documentfoundation.org/show_bug.cgi?id=93895
Bug ID: 93895
Summary: Problem with AutoCalculate when pasting data from
non-adjacent cells
Product: LibreOffice
Version: 5.0.0.5 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 118396
--> https://bugs.documentfoundation.org/attachment.cgi?id=118396&action=edit
Spreadsheet that illustrates AutoCalculate problem
Column sums do NOT automatically update when NON-adjacent cells (from elsewhere
in the same sheet) are selected (using CTRL-click), copied, and pasted into the
columns. When ADJACENT cells are selected, copied, and pasted into the columns
the sums DO update, as expected. A very simple spreadsheet is attached to
illustrate this problem. It was created from scratch in Calc 5.0.0.5.
This problem started with version 4.4 and carries forward into 5.0.0.5. The
problem is not present in version 4.3, or in other spreadsheet programs (such
as Excel).
In 4.4 a new option was added under Tools>Options>LibreOfficeCalc>General
(under Input Settings). This option is called “Update references when sorting
range of cells”. This would seem to be a likely culprit, although the behavior
described above is unchanged regardless of which setting is chosen.
Finally, please note the following:
- AutoCalculate is turned on
- CTRL-SHFT F9 updates the column sums
- closing and re-loading the spreadsheet also updates the column sums
This is the first bug report that I have submitted. I apologize in advance if
the report is incomplete or otherwise flawed.
dhagen
--
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
