https://bugs.documentfoundation.org/show_bug.cgi?id=89139

            Bug ID: 89139
           Summary: DATALOSS FILESAVE: native xlsx pivot table corrupted
                    after save with LO and re-open with MS Office
           Product: LibreOffice
           Version: 4.2.8.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: blocker
          Priority: highest
         Component: filters and storage
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 113150
  --> https://bugs.documentfoundation.org/attachment.cgi?id=113150&action=edit
affected file

The attached file is corrupted after saving with LibreOffice.

1) Open the attached file (created with MS Office)
2) Go on Tools -> Options -> LibreOffice Calc -> Formula
3) Set Formula syntax as "Excel A1"
4) open the sheet "pivot" (it's the last one)
5) Rx click -> Refresh (the Pivot Table is ok)
6) Save the file with the same file format (xlsx)
7) Close the file
8) Re open with MS Office. MS Office shows a dataloss message.
9) Click ok and try to recover the file
10) open the sheet "pivot"

The Pivot Table is gone. There is only a flat table. If you try to open the
file with LibreOffice the Pivot Table is ok.

Tested on: 

* Version: 4.5.0.0.alpha0+
* Build ID: 1845b6af3991ca5521eef48aafe1d0489e2ff8f6
* TinderBox: Win-x86@42, Branch:master, Time: 2015-02-02_09:30:48
* Locale: it_IT
* OS: Windows 7 Home Premium SP1 x86

* Version: 4.2.8.2
* Build ID: 48d50dbfc06349262c9d50868e5c1f630a573ebd
* Locale: it_IT
* OS: Windows 7 Home Premium SP1 x86

* Version: 4.5.0.0.alpha0+
* Build ID: 52d1de87e9a77fc7929309b0365bd786406ce022
* TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time:
2015-02-04_01:50:43
* Locale: it_IT
* OS: Ubuntu 14.04.1 x86_64

* Version: 4.3.6.1
* Build ID: 9629686a67dd1f357477c13325e45a66f3452bb9
* Locale: it_IT
* OS: Ubuntu 14.04.1 x86_64

Office 365
* Version: 15.0.4675.1003
* Locale: it_IT
* OS: Windows 7 Home Premium SP1 x86

-- 
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

Reply via email to