https://bugs.freedesktop.org/show_bug.cgi?id=81294
Priority: medium
Bug ID: 81294
Assignee: [email protected]
Summary: Insertion of a sheet changes values in other sheets
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 102702
--> https://bugs.freedesktop.org/attachment.cgi?id=102702&action=edit
Example file to show the effect.
How to reproduce:
Open the attached file and verify that cells C2 .. C5 in sheet 2 contain the
values 16, 19 and 5. Select the first sheet. Use Insert --> Sheet to insert a
new sheet before the first sheet. Goto sheet 2 and observe that the cells above
now contain zeros. Pressing Shift+CTRL+F9 to start a hard recalculation does
not solve the problem. Saving the spreadsheet and reloading it again seems to
fix it. Another way to fix it is to re-enter the formulas contained in these
cells, for example you can go to the input line, add a blank at the and of the
formula and press enter. Then the correct value reappears.
Expected behaviour:
Insertion of a sheet should not change the contents of other sheets.
Observed with Libre Office Version: 4.2.5.2 and Windows 7
--
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
