Issue 48586 - Pivot/DataPilot import and grouping
Summary: Pivot/DataPilot import and grouping
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: usability
Depends on:
Reported: 2005-05-03 07:00 UTC by tboerkel
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Example (19.50 KB, application/
2005-05-03 07:00 UTC, tboerkel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description tboerkel 2005-05-03 07:00:08 UTC
I can import an Excel Pivot table with multiple column grouping (for ex. month
and year) quite nicely. But then I cannot redefine (enlarge) the source area for
the DataPilot.
Also, I am not able to construct such a DataPilot from scratch, only by
importing it from Excel. So, there is something lacking in the UI of the DataPilot.
Attaching example excel file.
Comment 1 tboerkel 2005-05-03 07:00:44 UTC
Created attachment 25737 [details]
Comment 2 frank 2005-06-07 11:19:32 UTC
seems to be a double to Issue 23658

*** This issue has been marked as a duplicate of 23658 ***
Comment 3 frank 2005-06-07 11:20:16 UTC
closed double
Comment 4 tboerkel 2005-06-19 12:55:31 UTC
Only the first part (enlarge source area) is a duplicate. The second part
(construct DataPilot with multiple column grouping) is not a duplicate.
Comment 5 frank 2005-06-29 14:56:30 UTC
So I re-assign this to the requirements team

Please double click the DATE field in the data pilot definition window and have
a look at the dialopg opened by clicking on options.

Comment 6 niklas.nebel 2005-06-30 17:35:57 UTC
Grouping is done using the Data/Outline/Group menu entry, see for details.
Comment 7 pagalmes.lists 2007-12-28 13:31:29 UTC
any news?