Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Options

Specify the settings for calculating and presenting subtotals.

To access this command...

Choose Data - Subtotals - Options tab.

Page break between groups

Inserts a new page after each group of subtotalled data.

Case-sensitive

Recalculates subtotals when you change the case of a data label.

Pre-sort area according to groups

Sorts the area that you selected in the Group by box of the Group tabs according to the columns that you selected.

Sort

Include formats

Considers formatting attributes when sorting.

Custom sort order

Uses a custom sorting order that you defined in the Options dialogue box at Office Calc - Sort Lists.

Ascending

Sorts beginning with the lowest value. You can define the sort rules on Data - Sort - Options. You define the default on Tools - Options - Language settings - Languages.

Descending

Sorts beginning with the highest value. You can define the sort rules on Data - Sort - Options. You define the default on Tools - Options - Language settings - Languages.