https://bugs.freedesktop.org/show_bug.cgi?id=67489
Priority: medium
Bug ID: 67489
Assignee: [email protected]
Summary: EDITING: copied and pasted cells containing formulas
are not recalculated properly
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
The result of a formula is not recalculated properly if the formula has been
copied and pasted with some constant context. Things work correctly if only the
cell containing the formula is copied and pasted. The error is triggered when
e.g. that cell and the cell right above it, containing no formula, are copied
and pasted. Problem is that the formula may be recalculated at a later time,
e.g. if some input value of the formula is altered, resulting in transiently
wrong values which may go unnoticed.
Steps to reproduce:
1. create a new table
2. enter the number "1" in cell A2
3. enter the number "2" in cell A4
4. enter the formula "=A4" in cell B4
5. mark cells B3 and B4
6. copy the marked cells
7. paste the marked cells into B1. Note the value in B2
8. enter the number "3" in cell A2
Current behavior:
B2 points to cell A2 but displays "2" in step 7. The correct value is displayed
in step 8, after the cell pointed to has been altered and the formula was
recalculated.
Expected behavior:
B2 is supposed to display the same value as A2 in step 7, i.e. "1"
I haven't noticed this bug in 4.0.4.2 although it might have been present
there. I'm pretty sure that it did not exist in versions 3.x.
Operating System: Windows XP
Version: 4.1.0.4 release
--
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
