https://bugs.freedesktop.org/show_bug.cgi?id=76380
Priority: medium
Bug ID: 76380
Assignee: [email protected]
Summary: EDITING: Reference to another sheet's cell in the same
XLS / XLSX gets invalidated next time when we open
file
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: 4.2.1.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 96078
--> https://bugs.freedesktop.org/attachment.cgi?id=96078&action=edit
Example xlsx file with 2 sheets, one having cell that references a cell in
another sheet
Problem description:
Steps to reproduce:
1. Open a new document
2. Have 2 sheets in the document
3. In Sheet2, have some cell with some value
4. In Sheet1, refer that cell from Sheet2 (e.g. =Sheet2.B2)
5. Save the doc as .xls or .xlsx (with .ods, it works without any problem)
6. Close the document
7. Open the same document again, and the reference in Sheet1, the cell's
reference would have changed to =#REF!!... (e.g. =#REF!!B2). The cell still
shows the value from Sheet2, but if any change is done in that cell in Sheet2,
there is no reflection in Sheet1 of that change.
8. Later if we do any change in the Sheet2 and Sheet1 gets recalculated, the
cell with formula in Sheet1 becomes
Current behavior:
The references should remain intact. It was working fine in 4.1.x.
I have seen this happening on Windows 7 and 8 both.
In case of complex sheet with lot of references, any change in sheet that
triggers recalculations, sometimes makes the cells with such referenced formula
to be #REF and not even the original value.
If changes happen in second sheet, those are not reflected in Sheet1.
Expected behavior:
The references should be retained and all the recalculations should work
properly and the new values should be reflected in the cells which have
references to cells from other sheet.
Operating System: Windows 7
Version: 4.2.1.1 release
Last worked in: 4.1.5.3 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
