Created attachment 95936 [details]
Pivot data field function is wrongly displayed
Steps to reproduce
1. Create 4x4 table with text in it (or use the uploaded file).
2. Create a Pivot table on a new sheet (put 1 field in “Columns”, “Rows” and “Values”, make sure that the function in the “Value” field is set to “Count”)
3. Save file in xlsx format.
4. Open the file with Calc.
The data fields are empty because the pivot table uses “Sum” instead of “Count”.
It should display the data fields correctly (in this case “Count” function).
This issue only works if you have only “Count” function in your Pivot table (I have used with several functions in the same time and the datas were perfectly displayed)
The problem does not show up If you save the .xlsx file in .odt (i.e: MS Office 2013) and open the .odt file with LibreOffice.
Created attachment 95974 [details]
New file from scratch that can't be opened.
I can't open sample file with, LibreOffice hangs:
Version: 18.104.22.168 Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
Version: 22.214.171.124 Build ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b
Version: 126.96.36.199 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f
Version: 188.8.131.52 Build ID: 3d4fc3d9dbf8f4c0aeb61498a81f91c5b7922f13
Version: 184.108.40.206.0+ Build ID: b5b9da46ceae23b25e963087d00b0ae5b4785c93
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-03-13_23:32:39
I can't reproduce the issue with:
Version: 220.127.116.11.0+ Build ID: 0b772a163b2536fc55aa3b4de925119e33af769
Version: 18.104.22.168.alpha0+ Build ID: 12ae7672f285da1d4c730315e8db23b3396b71cc
TinderBox: Win-x86@39, Branch:master, Time: 2014-03-14_00:18:00
Recreating the pivot table in a new spreadsheet and saving as xlsx, again I can not able to open this new file.
*** This bug has been marked as a duplicate of bug 74370 ***