From 874e9a0fe9a3ae594966f17792c615332bbc722b Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Wed, 25 Mar 2020 22:03:38 -0300 Subject: tdf#126923 Add guide for subtotals tool Change-Id: I941214be272d6e959c1129b074891bb6f229ba26 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91079 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/12050000.xhp | 6 ++++-- source/text/scalc/01/12050100.xhp | 35 +++++++---------------------------- source/text/scalc/01/12050200.xhp | 28 +++++++++++++--------------- 3 files changed, 24 insertions(+), 45 deletions(-) (limited to 'source/text/scalc/01') diff --git a/source/text/scalc/01/12050000.xhp b/source/text/scalc/01/12050000.xhp index f9a1f947f9..8b6ed83112 100644 --- a/source/text/scalc/01/12050000.xhp +++ b/source/text/scalc/01/12050000.xhp @@ -30,7 +30,7 @@
-

Subtotals

+

Subtotals

Calculates subtotals for the columns that you select. $[officename] uses the SUM function to automatically calculate the subtotal and grand total values in a labeled range. You can also use other functions to perform the calculation. $[officename] automatically recognizes a defined database area when you place the cursor in it.
@@ -42,6 +42,8 @@

Delete

Deletes the subtotal rows in the selected area. - +
+ +
diff --git a/source/text/scalc/01/12050100.xhp b/source/text/scalc/01/12050100.xhp index 4c317808f9..eee5400783 100644 --- a/source/text/scalc/01/12050100.xhp +++ b/source/text/scalc/01/12050100.xhp @@ -1,6 +1,4 @@ - - - @@ -33,41 +30,23 @@
-1st, 2nd, 3rd Group +

1st, 2nd, 3rd Group

Specify the settings for up to three subtotal groups. Each tab has the same layout.
-To insert subtotal values into a table: - - -Ensure that the columns of the table have labels. - - -Select the table or the area in the table that you want to calculate subtotals for, and then choose Data – Subtotals. - - -In the Group By box, select the column that you want to add the subtotals to. - - -In the Calculate subtotals for box, select the check boxes for the columns containing the values that you want to subtotal. - - -In the Use function box, select the function that you want to use to calculate the subtotals. - - -Click OK. - - -Group by +

Group by

Select the column that you want to control the subtotal calculation process. If the contents of the selected column change, the subtotals are automatically recalculated. -Calculate subtotals for +

Calculate subtotals for

Select the column(s) containing the values that you want to subtotal. -Use function +

Use function

Select the mathematical function that you want to use to calculate the subtotals. +
+ +
 diff --git a/source/text/scalc/01/12050200.xhp b/source/text/scalc/01/12050200.xhp index 6c178aa17e..ab8b830c5f 100644 --- a/source/text/scalc/01/12050200.xhp +++ b/source/text/scalc/01/12050200.xhp @@ -1,7 +1,4 @@ - - - - - - + Options @@ -34,27 +29,30 @@ -Options +

Options

Specify the settings for calculating and presenting subtotals.
-Page break between groups +

Page break between groups

Inserts a new page after each group of subtotaled data. -Case sensitive +

Case sensitive

Recalculates subtotals when you change the case of a data label. -Pre-sort area according to groups +

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 +

Sort

+

Include formats

Considers formatting attributes when sorting. -Custom sort order +

Custom sort order

Uses a custom sorting order that you defined in the Options dialog box at %PRODUCTNAME Calc - Sort Lists. -Ascending +

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 +

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