Options
/text/scalc/01/12050200.xhp
subtotals; sorting options
Options
Specify the settings for calculating and presenting subtotals.
Page break between groups
Inserts a new page after each group of subtotaled 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 dialog box at %PRODUCTNAME 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 .
Descending
Sorts beginning with the highest value. You can define the sort rules on Data - Sort - Options. You define the default on .