Revision as of 14:31, 5 October 2010

Better Defaults

Default spreadsheets should only have one sheet

Especially since Kohey's patch.

Grouping in DataPilots

The problem

There is a nice a convenient grouping feature for Data Pilots that is unfortunately not easily discoverable.

Proposal

It should be possible to access this function using the contextual menu.

The contextual menu for a DataPilot counts fewer items than the regular context menu (7 menu entries, 1 separator / 10 menu entries, 4 separators ), so adding one more entry should be acceptable.

+----------------+
|Start...        |
|Refresh         |
|Filter...       |
|Group Data...   |
|Delete          |
+----------------+
|Cut             |
|Copy            |
|Paste           |
+----------------+

Additional Proposal

This function should not be accessible with Data > Group and Outline > Group but with Data > DataPilot > Group Data...

Formatting in DataPilot

The problem

Because formatting of data pilots is Style-based, every data pilot of a same file will have the same formatting. This is a problem when you need to have plain numbers and percentage, for instance. This problem is made worse by the fact that refreshing of a dataPilot overwrites direct formatting.