From 940b4d1848e8c70ab7642901a68594e8016caffc Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 27 Apr 2024 18:51:28 +0200 Subject: Adding upstream version 1:7.0.4. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/scalc/01/12050200.xhp | 58 ++++++++++++++++++++++++++ 1 file changed, 58 insertions(+) create mode 100644 helpcontent2/source/text/scalc/01/12050200.xhp (limited to 'helpcontent2/source/text/scalc/01/12050200.xhp') diff --git a/helpcontent2/source/text/scalc/01/12050200.xhp b/helpcontent2/source/text/scalc/01/12050200.xhp new file mode 100644 index 000000000..ab8b830c5 --- /dev/null +++ b/helpcontent2/source/text/scalc/01/12050200.xhp @@ -0,0 +1,58 @@ + + + + + +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 %PRODUCTNAME - PreferencesTools - 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 %PRODUCTNAME - PreferencesTools - Options - Language settings - Languages. +
+ +
+ + -- cgit v1.2.3