| Summary: | formula corrupted by xlsx export | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Dirk Thomas <third-chance> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | unspecified | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
correct file
wrongly saved-as file |
||
Created attachment 49662 [details]
wrongly saved-as file
|
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: =FLOOR(A2;0,25;1) 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: =FLOOR(A2;0,25;1;1) (Note the duplicated ";1" which makes it invalid and return Err:504)