Options

Specify the settings for calculating and presenting subtotals.

To access this command...

From the menu bar:

Choose Data - Subtotals - Options tab.

From the tabbed interface:

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

~Theyrjet e faqeve në mes të grupeve

Inserts a new page after each group of subtotaled data.

I ndjeshëm në madhësinë e shkronjave

Recalculates subtotals when you change the case of a data label.

Zona e para~klasifikuar sipas grupeve

Sorts the area that you selected in the Group by box of the Group tabs according to the columns that you selected.

Summary below data

By default, the summary appears above the data. When selected, it moves below the data.

Rendit

Përfshij ~formatet

Considers formatting attributes when sorting.

Renditja e klasifikimit e ~zgjedhur sipas dëshirës

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

Në rritje

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.

Në zvogëlim

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