Contido

# Datos

Use as ordes do menú Datos para editar os datos na folla actual. Pode definir intervalos, ordenación e filtrar os datos, calcular os resultados, contornar datos e abrir a táboa dinámica.

## Ordenar

Sorts the selected rows according to the conditions that you specify. LibreOffice automatically recognizes and selects database ranges.

## Orde ascendente

Sorts the data of the selected field or cell range in ascending order. Text fields are sorted alphabetically, numerical fields are sorted by number.

## Orde descendente

Sorts the data of the selected field or cell range in descending order. Text fields are sorted alphabetically, number fields are sorted by number.

## AutoFilter

Automatically filters the selected cell range, and creates one-row list boxes where you can choose the items that you want to display.

## More Filters

Shows commands to filter your data.

## Define Range

Defines a database range based on the selected cells in your sheet.

## Select Range

Selects a database range that you defined under Data - Define Range.

## Actualizar intervalo

Updates a data range that was inserted from an external database. The data in the sheet is updated to match the data in the external database.

## Táboa dinámica

Opens a submenu to create or edit a pivot table. A pivot table provides a summary of large amounts of data. You can then rearrange the pivot table to view different summaries of the data.

## Calcular

Ordes para calcular celas con fórmulas.

## Validity

Define que datos son válidos nunha cela ou intervalo de celas seleccionados.

## Subtotais

Calculates subtotals for the columns that you select. LibreOffice 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. LibreOffice automatically recognizes a defined database area when you place the cursor in it.

## Formulario

Un formulario de entrada de datos é unha ferramenta para facilitar a introdución de datos nas follas de cálculo. Cun formulario de entrada de datos pódense introducir, editar e eliminar rexistros (ou filas) de datos e evitar o desprazamento horizontal cando a táboa ten moitas columnas ou cando algunhas columnas son moi largas.

O formulario admite até 32 columnas.

## Streams

Create live data streams for spreadsheets.

## Fonte XML

Importar datos XML a unha folla de cálculo.

## Operacións múltiplas

Applies the same formula to different cells, but with different parameter values.

## Texto en columnas

Abre a caixa de diálogo Texto para columnas, na que se pode introducir a configuración para expandir o contido das celas seleccionadas a varias celas.

## Consolidar

Combines data from one or more independent cell ranges and calculates a new range using the function that you specify.

## Group and Outline

You can create an outline of your data and group rows and columns together so that you can collapse and expand the groups with a single click.

## Estatísticas

Use the data statistics in Calc to perform complex data analysis