Issue 48586 - Pivot/DataPilot import and grouping
Summary: Pivot/DataPilot import and grouping
Status: CONFIRMED
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:
URL:
Keywords: usability
Depends on:
Blocks:
 
Reported: 2005-05-03 07:00 UTC by tboerkel
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Example (19.50 KB, application/vnd.ms-excel)
2005-05-03 07:00 UTC, tboerkel 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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]
Example
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.

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