Bug 39615 - formula corrupted by xlsx export
Summary: formula corrupted by xlsx export
Status: RESOLVED DUPLICATE of bug 38592
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2011-07-28 03:50 UTC by Dirk Thomas
Modified: 2011-07-28 11:02 UTC (History)
0 users

See Also:
Crash report or crash signature:

correct file (11.31 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-07-28 03:50 UTC, Dirk Thomas
wrongly saved-as file (6.55 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2011-07-28 03:52 UTC, Dirk Thomas

Note You need to log in before you can comment on or make changes to this bug.
Description Dirk Thomas 2011-07-28 03:50:34 UTC
Created attachment 49661 [details]
correct file

I am using LibreOffice 3.3.2 which is the current package of Ubuntu Natty.

When saving (to xlsx) a spreadsheet with a formula like:
the formula is modified during export.

The attached file example.ods contains the correct formula.
When saving this file as an Office Open XML Spreadsheet (.xlsx) document the formula is different after reloading the saved file.
The formula is changed to:
(Note the duplicated ";1" which makes it invalid and return Err:504)
Comment 1 Dirk Thomas 2011-07-28 03:52:59 UTC
Created attachment 49662 [details]
wrongly saved-as file
Comment 2 Markus Mohrhard 2011-07-28 11:02:58 UTC
floor and ceiling have an additional parameter in calc that needs to be erased for the excel export

I have no good idea yet how to solve this

*** This bug has been marked as a duplicate of bug 38592 ***