Defining a Database Range

You can define a range of cells in a spreadsheet to use as a database. Each row in this database range corresponds to a database record and each cell in a row corresponds to a database field. You can sort, group, search, and perform calculations on the range as you would in a database.

Hoiatav ikoon

You can only edit and access a database range in the spreadsheet that contains the range. You cannot access the database range in the LibreOffice Data Sources view.


Andmebaasivahemiku määramine

  1. Select the range of cells that you want to define as a database range.

  2. Vali Andmed - Määra vahemik.

  3. In the Name box, enter a name for the database range.

  4. Klõpsa Rohkem.

  5. Specify the options for the database range.

  6. Klõpsa Sobib.

Sarnased teemad

Sorting Data

Filtering Cell Ranges