Issue 93781 - Only static data instead of Pivot table shown in particular OOXML spreadsheet
Summary: Only static data instead of Pivot table shown in particular OOXML spreadsheet
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO300m5
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-09-11 17:10 UTC by safway
Modified: 2014-02-05 13:28 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Example File (555.38 KB, application/
2008-09-11 17:11 UTC, safway
no flags Details
What I expect to see (227.82 KB, image/jpeg)
2008-09-11 17:12 UTC, safway
no flags Details
screenshot of spreadsheet (117.64 KB, image/png)
2014-01-15 18:00 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description safway 2008-09-11 17:10:43 UTC
Environment: Testing MS Office 2007 files using OO.o 3.0 rc1 (build OOO300_m5)

Issue: The pivot table is not showing up in attached spreadsheet file.

Notes: See attached file and sheet 'TCEs'.
Comment 1 safway 2008-09-11 17:11:52 UTC
Created attachment 56431 [details]
Example File
Comment 2 safway 2008-09-11 17:12:33 UTC
Created attachment 56432 [details]
What I expect to see
Comment 3 Edwin Sharp 2014-01-15 18:00:02 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1557669
2014-01-14_04:11:13 - Rev. 1557927
Comment 4 Edwin Sharp 2014-01-15 18:00:44 UTC
Created attachment 82295 [details]
screenshot of spreadsheet
Comment 5 Rainer Bielefeld 2014-02-05 13:13:05 UTC
NOT reproducible with "AOO 4.0.1 – German UI / German locale [Rev. 1524958 2013-09-20 11:40:29]" on German WIN7 Home Premium (64bit)", “historic” 4.0 User Profile used for all predecessor versions:

1. From AOO Start Center open reporter's sample document
2. Switch to sheet "TCEs"
   Expected: Working Pivot table, for example you can select different 
   Actual: only static data

Additional Info:
(a) same problem with LibO 4.1, SoftMaker FreOffice, Gnumeric, Calligra
(b) My MS EXCEL Viewer also shows something what looks like static data
(d) works with EXCEL Starter 2010, I can select course in TECs.B1, and data in
    list below will change.
(e) I doubt that that's a macro / VBA problem, because sample document works fine
    with Excel Starter, what does not support VBA.
Comment 6 Rainer Bielefeld 2014-02-05 13:28:26 UTC
Some day I will learn to copy paste ....

Of course I wanted to tell "IS Reproducible with "AOO 4.0.1 – German UI ..."