1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--
5***********************************************************************
6 *
7 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 *
9 * Copyright 2000, 2010 Oracle and/or its affiliates.
10 *
11 * OpenOffice.org - a multi-platform office productivity suite
12 *
13 * This file is part of OpenOffice.org.
14 *
15 * OpenOffice.org is free software: you can redistribute it and/or modify
16 * it under the terms of the GNU Lesser General Public License version 3
17 * only, as published by the Free Software Foundation.
18 *
19 * OpenOffice.org is distributed in the hope that it will be useful,
20 * but WITHOUT ANY WARRANTY; without even the implied warranty of
21 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
22 * GNU Lesser General Public License version 3 for more details
23 * (a copy is included in the LICENSE file that accompanied this code).
24 *
25 * You should have received a copy of the GNU Lesser General Public License
26 * version 3 along with OpenOffice.org.  If not, see
27 * <http://www.openoffice.org/license.html>
28 * for a copy of the LGPLv3 License.
29 *
30 ************************************************************************
31 -->
32
33
34<meta>
35      <topic id="textscalcguidedatabase_definexml" indexer="include" status="PUBLISH">
36         <title xml-lang="en-US" id="tit">Defining Database Ranges</title>
37         <filename>/text/scalc/guide/database_define.xhp</filename>
38      </topic>
39   </meta>
40   <body>
41<bookmark xml-lang="en-US" branch="index" id="bm_id3154758"><bookmark_value>tables; database ranges</bookmark_value>
42      <bookmark_value>database ranges; defining</bookmark_value>
43      <bookmark_value>ranges; defining database ranges</bookmark_value>
44      <bookmark_value>defining;database ranges</bookmark_value>
45</bookmark>
46<paragraph xml-lang="en-US" id="hd_id3154758" role="heading" level="1" l10n="U"
47                 oldref="31"><variable id="database_define"><link href="text/scalc/guide/database_define.xhp" name="Defining Database Ranges">Defining a Database Range</link>
48</variable></paragraph>
49      <paragraph xml-lang="en-US" id="par_id3153768" role="paragraph" l10n="U" oldref="81">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.</paragraph>
50      <paragraph xml-lang="en-US" id="par_id3145801" role="warning" l10n="CHG" oldref="82">You can only edit and access a database range in the spreadsheet that contains the range. You cannot access the database range in the %PRODUCTNAME Data Sources view. </paragraph>
51      <paragraph xml-lang="en-US" id="par_idN10648" role="paragraph" l10n="NEW">To define a database range</paragraph>
52      <list type="ordered">
53         <listitem>
54            <paragraph xml-lang="en-US" id="par_id3155064" role="listitem" l10n="CHG" oldref="41">Select the range of cells that you want to define as a database range.</paragraph>
55         </listitem>
56         <listitem>
57            <paragraph xml-lang="en-US" id="par_idN10654" role="listitem" l10n="NEW">Choose <item type="menuitem">Data - Define Range</item>.</paragraph>
58         </listitem>
59         <listitem>
60            <paragraph xml-lang="en-US" id="par_id3153715" role="listitem" l10n="U" oldref="72">In the <emph>Name</emph> box, enter a name for the database range.</paragraph>
61         </listitem>
62         <listitem>
63            <paragraph xml-lang="en-US" id="par_idN1066A" role="listitem" l10n="NEW">Click <emph>More</emph>.</paragraph>
64         </listitem>
65         <listitem>
66            <paragraph xml-lang="en-US" id="par_id3154253" role="listitem" l10n="U" oldref="42">Specify the options for the database range.</paragraph>
67         </listitem>
68         <listitem>
69            <paragraph xml-lang="en-US" id="par_idN10675" role="listitem" l10n="NEW">Click <emph>OK</emph>.</paragraph>
70         </listitem>
71      </list>
72      <section id="relatedtopics">
73         <embed href="text/scalc/guide/database_sort.xhp#database_sort"/>
74         <embed href="text/scalc/guide/database_filter.xhp#database_filter"/>
75      </section>
76   </body>
77</helpdocument>