Bug 74370

Summary: Pivot table COUNT field imported as SUM field from xlsx
Product: LibreOffice Reporter: Andras Timar <timar74>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: gracz, suokunlong
Version: 4.1.4.2 release   
Hardware: Other   
OS: All   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=58691
Whiteboard:
i915 platform: i915 features:
Attachments: Pivot table and chart not imported from xlsx
PDF shows the file open with MSO 2010

Description Andras Timar 2014-02-02 12:17:18 UTC
Created attachment 93215 [details]
Pivot table and chart not imported from xlsx
Comment 1 Kevin Suo 2014-03-10 09:34:16 UTC
Comment on attachment 93215 [details]
Pivot table and chart not imported from xlsx

Corrected MIME type.
Comment 2 Kevin Suo 2014-03-10 10:17:03 UTC
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".
Comment 3 Kevin Suo 2014-03-10 10:19:27 UTC
Changing status to NEW,

and chaning Title
from: FILEOPEN: Pivot table and chart not imported from xlsx
to: FILEOPEN: Pivot table COUNT field imported as SUM field from xlsx

If you disagree, feel free to change it back.
Comment 4 Kevin Suo 2014-03-10 10:22:10 UTC
Created attachment 95495 [details]
PDF shows the file open with MSO 2010
Comment 5 Kevin Suo 2014-03-22 09:42:41 UTC
*** Bug 76266 has been marked as a duplicate of this bug. ***

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.