https://bugs.freedesktop.org/show_bug.cgi?id=74747
Priority: medium
Bug ID: 74747
Assignee: [email protected]
Summary: FILESAVE corrupts references to cells on another sheet
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: NEW
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
Problem description: Sheet references are broken when a document created in
Excel as xlsx is opened and subsequently re-saved as an xlsx using Calc. If the
document is opened and saved in calc then subsequently opened in Calc the
referenced text appears as 0. Opening the file in Excel the text shows
correctly, saving the file from Excel fixes the problem.
Steps to reproduce:
1. Create a new spreadsheet in Excel 2010
2. Enter 'Example text' in cell a1 on sheet 1
3. On sheet 2 in cell b1 enter a reference to sheet 1 a1
4. save the sheet as docx and close Excel
5. Open the sheet in Calc. The cell sheet 2 b1 shows the expected text.
6. Make a change to another cell so that the sheet has changed
7. click the save button
8. click the 'Use Microsoft Excel 2007/2010/2013 XML Format'
9. close the Calc application
10. Open the file again in Calc
11. Observer the presented value in sheet 2 cell b1.
Current behavior: After opening the re-saved sheet in calc the referenced text
in b1 appears as '0'
Expected behavior: The referenced text should appear in cell b1
--
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
