/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 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.