Issue 48586

Summary: Pivot/DataPilot import and grouping
Product: Calc Reporter: tboerkel <thomas>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, niklas.nebel, pagalmes.lists
Version: OOo 2.0 BetaKeywords: usability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Example none

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?