https://bugs.freedesktop.org/show_bug.cgi?id=76266
Priority: medium
Bug ID: 76266
Assignee: [email protected]
Summary: [PIVOTABLE][FILEOPEN][FUNCTION]: Opening .xlsx file
with Pivot table displays the wrong Data Field
Function
Severity: major
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.2.2.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 95936
--> https://bugs.freedesktop.org/attachment.cgi?id=95936&action=edit
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.
Results:
The data fields are empty because the pivot table uses “Sum” instead of
“Count”.
Expected results:
It should display the data fields correctly (in this case “Count” function).
Facts:
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.
--
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
