Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In OpenOffice Calc, the only feature I miss from Excel is the ability to create those dropdown dialogs to sort data:

enter image description here

Does OpenOffice Calc have the same feature and I just missed it?

Note: I know the Data>Sort dialog, but I am looking for something that does not require to select the area every time.

share|improve this question

2 Answers 2

up vote 3 down vote accepted

AFAIK openoffice doesn't have a sort option built into the AutoFilter Dropdown box, as Excel has. But sorting doesn't require to manually select the data area (only if there are empty rows/columns in the data area), so just use the sort buttons from the command bar to sort the data.

share|improve this answer
    
Thanks! The sort buttons from the command bar just sort according to the first column, as far as I know. –  Nicolas Raoul Jun 13 '11 at 9:27
    
hmm - it depends on which cell is selected. If you select, for example, C2, the data should get sorted according to the third column. Even header cells seem to be recognized (this is why i proposed C 2 :-) ) –  tohuwawohu Jun 13 '11 at 9:38
    
Indeed! That's perfect. –  Nicolas Raoul Jun 13 '11 at 10:11

If I understand correctly, you want to:

  • Select one or more contiguous columns
  • Go to menu Data::Filter::AutoFilter (or whatever i18n'd menu name you see in your version - position in the menu tree should be the same)
  • See the new dropdown handle appear on all column headers
  • Click on handle to apply the kind of filter or sort rule that you want.

Illustration: [Sorry, my screenshot was rejected due to missing "reputation".]

Valid for OOo 3.3 and LibreOffice 4.2 (where the screenshot comes from).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.