Ubuntu
openoffice.org package

What is the key sequence to select only the total row value only in a sheet when using subtotal function ?

Asked by MURALI

When using subtotal function on a control break for each change of a particular column, we get the subtotal summary. Now i would like to know what is the key sequence to select only the subtotal summary rows to be pasted in a new sheet to have the summary presentation alone. We use ALT + ; to copy only the summarised items in excel. Does open office has similar feature addressed to solve this problem?

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Wrwrwr (wrwrwr) said : 		#1

I can't find a key stroke for you, it's possible there is no such thing

Maybe Data-->DataPilot can do what you are looking for, you should be able to create a nice summary rather easily with it (under "more" you have an option to place it in a new sheet).

Can you help with this problem?

Provide an answer of your own, or ask MURALI for more information if necessary.

To post a message you must log in.