Options

Specify the settings for calculating and presenting subtotals.

Toiminnon käyttäminen:

Valikkoriviltä:

Choose Data - Subtotals - Options tab.

Välilehdellisestä käyttöliittymästä:

On the Data menu of the Data tab, choose Subtotals - Options tab.

Page break between groups

Inserts a new page after each group of subtotaled data.

Kirjainkoon erottelu

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.

Järjestä

Sisällytä muodot

Considers formatting attributes when sorting.

Mukautettu lajittelujärjestys

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

Nouseva

Sorts beginning with the lowest value. You can define the sort rules on Data - Sort - Options. You define the default on - Languages and Locales - General.

Laskeva

Sorts beginning with the highest value. You can define the sort rules on Data - Sort - Options. You define the default on - Languages and Locales - General.

Using Subtotal Tool