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.

แƒ’แƒแƒ•แƒ แƒ—แƒฎแƒ˜แƒšแƒ”แƒ‘แƒ˜แƒก แƒฎแƒแƒขแƒฃแƒšแƒ

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.


To define a database range

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

  2. Choose Data - Define Range.

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

  4. แƒ“แƒแƒแƒฌแƒ™แƒแƒžแƒฃแƒœแƒ”แƒ— แƒ“แƒแƒ›แƒแƒขแƒ”แƒ‘แƒแƒ–แƒ”.

  5. Specify the options for the database range.

  6. แƒ“แƒแƒแƒฌแƒ™แƒแƒžแƒฃแƒœแƒ”แƒ— แƒ“แƒแƒ›แƒแƒขแƒ”แƒ‘แƒแƒ–แƒ”.

D'oh! You found a bug (text/scalc/guide/database_filter.xhp#database_filter not found).

Please support us!