Difference between revisions of "User:Camillem/aboutCalc"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Proposal)
(Default spreadsheets should only have one sheet: To Erib: because I've never tried it.)
 
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
=Better Defaults=
 +
 +
==Default spreadsheets should only have one sheet==
 +
 +
Especially since Kohey's patch, that adds a "plus" sign to create a new sheet.
 +
 +
==F4 should switch between absolute/relative references==
 +
 +
At the moment, it's (Modifier)+F4, while F4 displays/hides the Data sources.
 +
 +
*It's a very basic/frequently used function of the spreadsheet, so the shortcut should be simple, with no modifier.
 +
 +
*It would make the transition with Excel easier.
 +
 
=Grouping in DataPilots=
 
=Grouping in DataPilots=
  
Line 7: Line 21:
 
==Proposal==
 
==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.
 
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.
<nowiki>+----------------+
+
+----------------+
|Start...        |
+
|Start...        |
|Refresh        |
+
|Refresh        |
|Filter...      |
+
|Filter...      |
|Group Data...  |
+
|Group Data...  |
|Delete          |
+
|Delete          |
+----------------+
+
+----------------+
|Cut            |
+
|Cut            |
|Copy            |
+
|Copy            |
|Paste          |
+
|Paste          |
+----------------+</nowiki>
+
+----------------+
 +
 
 +
==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.

Latest revision as of 15:01, 5 June 2011

Better Defaults

Default spreadsheets should only have one sheet

Especially since Kohey's patch, that adds a "plus" sign to create a new sheet.

F4 should switch between absolute/relative references

At the moment, it's (Modifier)+F4, while F4 displays/hides the Data sources.

  • It's a very basic/frequently used function of the spreadsheet, so the shortcut should be simple, with no modifier.
  • It would make the transition with Excel easier.

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.

Personal tools