Apache OpenOffice (AOO) Bugzilla – Issue 89117
[RFE] DataPilot: Unnecessary limit to 8 Data Fields
Last modified: 2008-05-07 22:03:51 UTC
The current Data Pilot user interface (UI) let user drop at maximum 8 items into the Data Fields area. This is rather limiting in some cases and there is no real ground for the limitation. Though there exist a workaround - an alternative UI for creating pivot tables, see http://www.oooforum.org/forum/viewtopic.phtml?t=48636 , it would be much better to remove the limitation in the default UI - most user haven't the experience and time to find and try the alternative UI. Steps to reproduce: 1. In Calc, create a table with 9 or more columns 2. Select the table 3. Data > Data Pilot > Start - the data pilot UI pops up, click ok to display the puvot table config; you can now drag&drop the table's columns onto the Data Field area - but at max. 8 because then it becomes full and there is no way to increase it By the way, it would be also nice to be able to have the possibility to use a single column multiple times as a data field, for example using a differnent grouping function in each occurence - thus I could have both sum and average in the same table w/o the need to duplicate the column in the source data.
Created attachment 53447 [details] Table with 11 columns and a data pilot table only being able to hold 8 of them
You made two separate reports. The first one is a duplicate of Issue 5759, and the second one is another feature request. Could you file the second one as a separate issue? Usually we try to keep one issue per one item to make it easier for us.
closing this as a duplicate. *** This issue has been marked as a duplicate of 5759 ***
closing a dupe.