https://bugs.freedesktop.org/show_bug.cgi?id=74370
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from [email protected] --- Tested with LO 4.1.5.4: 1. Pivot table is imported, but NOT imported properly. LO is showing "SUM - Gyártó" field, which result in empty results because there are only TEXT values in Gyártó. When unzip the xlsx file I found the following in pivotTables\pivotTable1.xml: <dataField name="Darab / Gyártó" fld="1" subtotal="count" baseField="0" baseItem="0" /> When open with MSO 2010 it shows correctly "count" field, rather than "sum" field. 2. Chart is imported, but it's an empty chart. (so no problem with chart import, chart is empty because Pivot table "sum" field is empty) 3. When I creat a fresh xlsx file with MSO 2010, input some data and insert a pivot table with COUNT dataField, then I can reopen it correctly with LO 4.1.5.4. My UI language is zh_CN, so maybe it's because of locale issue? "Gyártó" is Hungarian. 4. When "save as" xlsx again, the pivot table become a normal table, which is the same issue as in "Bug 58691 - PIVOTTABLE: export to Excel 2007/2010 breaks functionality". -- 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
