https://bugs.freedesktop.org/show_bug.cgi?id=77912
Priority: medium
Bug ID: 77912
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FILEOPEN: Excel cell formulas referring to other
sheets are changed arbitrarily
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: oundha...@gmail.com
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 97938
--> https://bugs.freedesktop.org/attachment.cgi?id=97938&action=edit
Zip file containing original & corrupted excel files
Problem description:
When I open an excel file which has cell formulas referring to other sheets
(within the same file), Calc resets the column numbers to some arbitrary large
value.
Steps to reproduce:
1. Open excel file in Libreoffice.
2. Change some numerical values.
3. Save the file.
4. Open again in Libreoffice
Current behavior:
The formula in cell C4 of sheet STAAD_Comp is originally "=$profil.A6". On
saving the file in Calc, the formula gets changed to "=$profil.IW6" Similar
changes occur in every cell and on every sheet.
Expected behavior:
Formulas should not change
Operating System: Ubuntu
Version: 4.2.0.4 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
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
