https://bugs.documentfoundation.org/show_bug.cgi?id=98883
Bug ID: 98883
Summary: EDITING: Formula broken when Pasting column to other
sheet
Product: LibreOffice
Version: 4.2.8.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 123843
--> https://bugs.documentfoundation.org/attachment.cgi?id=123843&action=edit
File contains a brief example suitable to produce the bug.
Example of the bug including description in the attached file.
If I cut a column and paste it to another sheet in the same file
corresponding formulas will change but they do not reflect the
paste-to-new-sheet operation and their displayed result will not change.
Recalculating all cells with F9 does not bring up a different result.
If I edit one of these cells and do NOT change anything, but just enter a
trailing blank, the cell will be recalculated and display a different result.
If I restore the status quo ante with CTRL-Z, the formulas are NOT changed back
to their original content, which is a source for possible miscalculations the
user may overlook.
"The expected result of the cut/paste-operation would be that the formulas
would reflect the new location of the pasted cells or they would change to an
error (#REF or #DIV/0 or similar)"
If you however assign names to the cut cells, and use it in the formulas, all
works well.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
