helpcontent2/source/text/shared/02/01170004.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3
   4
   5 <!--
   6  ***********************************************************************
   7  *
   8  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   9  *
  10  * Copyright 2008 by Sun Microsystems, Inc.
  11  *
  12  * OpenOffice.org - a multi-platform office productivity suite
  13  *
  14  * $RCSfile: 01170004.xhp,v $
  15  * $Revision: 1.10.4.1 $
  16  *
  17  * This file is part of OpenOffice.org.
  18  *
  19  * OpenOffice.org is free software: you can redistribute it and/or modify
  20  * it under the terms of the GNU Lesser General Public License version 3
  21  * only, as published by the Free Software Foundation.
  22  *
  23  * OpenOffice.org is distributed in the hope that it will be useful,
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  26  * GNU Lesser General Public License version 3 for more details
  27  * (a copy is included in the LICENSE file that accompanied this code).
  28  *
  29  * You should have received a copy of the GNU Lesser General Public License
  30  * version 3 along with OpenOffice.org.  If not, see
  31  * <http://www.openoffice.org/license.html>
  32  * for a copy of the LGPLv3 License.
  33  *
  34  ************************************************************************
  35  -->
  36
  37
  38                 <helpdocument version="1.0">
  39 <meta>
  40 <topic id="textshared0201170004xml" indexer="include" status="PUBLISH">
  41 <title id="tit" xml-lang="en-US">Special Tips for Table Controls</title>
  42 <filename>/text/shared/02/01170004.xhp</filename>
  43 </topic>
  44 </meta>
  45 <body>
  46 <bookmark xml-lang="en-US" branch="index" id="bm_id3109850"><bookmark_value>table controls; properties</bookmark_value>
  47 <bookmark_value>controls; properties of table controls</bookmark_value>
  48 <bookmark_value>table controls;keyboard-only edit mode</bookmark_value>
  49 </bookmark>
  50 <paragraph role="heading" id="hd_id3109850" xml-lang="en-US" level="1" l10n="U" oldref="124">Special Tips for Table Controls</paragraph>
  51 <paragraph role="paragraph" id="par_id3153539" xml-lang="en-US" l10n="U" oldref="51">You can define a table control to display the records as you like. In other words you can define data fields for displaying or editing data like in a database form.</paragraph>
  52 <paragraph role="paragraph" id="par_id3152372" xml-lang="en-US" l10n="U" oldref="62">The following fields are possible in a table control: text, date, time and currency field, numeric field, pattern field, check box and combo box. In the case of combined date/time fields, two columns are created automatically.</paragraph>
  53 <paragraph role="paragraph" id="par_id3159194" xml-lang="en-US" l10n="U" oldref="125">The number of selected lines, if any are selected, is in parentheses after the total number of records.</paragraph>
  54 <paragraph role="paragraph" id="par_id3155616" xml-lang="en-US" l10n="U" oldref="52">To insert columns into the table control, click in the column heads and bring up the context menu. The following commands are available:</paragraph>
  55 <bookmark xml-lang="en-US" branch="hid/SID_FM_INSERTCOL" id="bm_id3147571" localize="false"/><paragraph role="heading" id="hd_id3150789" xml-lang="en-US" level="2" l10n="U" oldref="53">Insert Column</paragraph>
  56 <paragraph role="paragraph" id="par_id3153750" xml-lang="en-US" l10n="U" oldref="54"><ahelp hid="SID_FM_INSERTCOL">Calls a submenu to select a data field to adopt it in the table control.</ahelp></paragraph>
  57 <paragraph role="paragraph" id="par_id3155552" xml-lang="en-US" l10n="U" oldref="59">Configure the table control using drag and drop: Open the data source browser and drag the desired fields out of the data source browser and on to the column heads of the table control. A pre-configured column is created.</paragraph>
  58 <bookmark xml-lang="en-US" branch="hid/SID_FM_CHANGECOL" id="bm_id3145211" localize="false"/><paragraph role="heading" id="hd_id3149827" xml-lang="en-US" level="2" l10n="U" oldref="55">Replace with</paragraph>
  59 <paragraph role="paragraph" id="par_id3153345" xml-lang="en-US" l10n="U" oldref="56"><ahelp hid="SID_FM_CHANGECOL">Opens a submenu to select a data field to replace the data field selected in the table control.</ahelp></paragraph>
  60 <bookmark xml-lang="en-US" branch="hid/SID_FM_DELETECOL" id="bm_id3149095" localize="false"/><paragraph role="heading" id="hd_id3143267" xml-lang="en-US" level="2" l10n="U" oldref="57">Delete Column</paragraph>
  61 <paragraph role="paragraph" id="par_id3157958" xml-lang="en-US" l10n="U" oldref="58"><ahelp hid="SID_FM_DELETECOL">Deletes the currently selected column.</ahelp></paragraph>
  62 <paragraph role="heading" id="hd_id3147275" xml-lang="en-US" level="2" l10n="U" oldref="73">Column</paragraph>
  63 <paragraph role="paragraph" id="par_id3152996" xml-lang="en-US" l10n="U" oldref="74">Opens the properties dialog of the selected column.</paragraph>
  64 <bookmark xml-lang="en-US" branch="hid/SID_FM_HIDECOL" id="bm_id3163802" localize="false"/><paragraph role="heading" id="hd_id3148539" xml-lang="en-US" level="2" l10n="U" oldref="79">Hide Columns</paragraph>
  65 <paragraph role="paragraph" id="par_id3159157" xml-lang="en-US" l10n="U" oldref="80"><ahelp hid="SID_FM_HIDECOL">Hides the selected column.</ahelp> Its properties are not changed.</paragraph>
  66 <bookmark xml-lang="en-US" branch="hid/SID_FM_SHOWCOLS" id="bm_id3155135" localize="false"/><paragraph role="heading" id="hd_id3150771" xml-lang="en-US" level="2" l10n="U" oldref="81">Show columns</paragraph>
  67 <paragraph role="paragraph" id="par_id3159400" xml-lang="en-US" l10n="U" oldref="82"><ahelp hid="SID_FM_SHOWCOLS">Calls a submenu where you can select the columns to show again.</ahelp> To show only one column, click the column name. You see only the first 16 hidden columns. If there are more hidden columns, choose the <emph>More</emph> command to call the <emph>Show Columns</emph> dialog.</paragraph>
  68 <bookmark xml-lang="en-US" branch="hid/SID_FM_SHOWCOLS_MORE" id="bm_id3150669" localize="false"/><paragraph role="heading" id="hd_id3156193" xml-lang="en-US" level="3" l10n="U" oldref="83">More</paragraph>
  69 <paragraph role="paragraph" id="par_id3159269" xml-lang="en-US" l10n="U" oldref="84"><ahelp hid="SID_FM_SHOWCOLS_MORE">Calls the <emph>Show Columns</emph> dialog.</ahelp></paragraph>
  70 <bookmark xml-lang="en-US" branch="hid/SVX:LISTBOX:RID_SVX_DLG_SHOWGRIDCOLUMNS:1" id="bm_id3159148" localize="false"/><paragraph role="paragraph" id="par_id3149763" xml-lang="en-US" l10n="U" oldref="85"><ahelp hid="SVX:LISTBOX:RID_SVX_DLG_SHOWGRIDCOLUMNS:1">In the <emph>Show Columns</emph> dialog you can select the columns to be shown. Hold down the Shift or Ctrl (Mac: Command) key to select multiple entries.</ahelp></paragraph>
  71 <bookmark xml-lang="en-US" branch="hid/SID_FM_SHOWALLCOLS" id="bm_id3145119" localize="false"/><paragraph role="heading" id="hd_id3153561" xml-lang="en-US" level="3" l10n="U" oldref="86">All</paragraph>
  72 <paragraph role="paragraph" id="par_id3150504" xml-lang="en-US" l10n="U" oldref="87"><ahelp hid="SID_FM_SHOWALLCOLS">Click <emph>All </emph>if you want to show all columns.</ahelp></paragraph>
  73 <paragraph role="heading" id="hd_id3153349" xml-lang="en-US" level="2" l10n="U" oldref="127">Keyboard-only control of Table Controls</paragraph>
  74 <paragraph role="paragraph" id="par_id3149416" xml-lang="en-US" l10n="U" oldref="126">If you use the keyboard only to travel through controls in your document, you will find one difference to the other types of controls: the Tab key does not move the cursor to the next control, but moves to the next column inside the table control. Press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Tab to move to the next control, or press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Tab to move to the previous control.</paragraph>
  75 <paragraph role="heading" id="hd_id3153062" xml-lang="en-US" level="3" l10n="U" oldref="128">To enter the special keyboard-only edit mode for Table Controls:</paragraph>
  76 <paragraph role="paragraph" id="par_id3144510" xml-lang="en-US" l10n="U" oldref="129">The form document must be in <link href="text/shared/02/01170500.xhp" name="design mode">design mode</link>.</paragraph>
  77 <list type="ordered">
  78 <listitem>
  79 <paragraph role="listitem" id="par_id3154758" xml-lang="en-US" l10n="U" oldref="130">Press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F6 to select the document.</paragraph>
  80 </listitem>
  81 <listitem>
  82 <paragraph role="listitem" id="par_id3161657" xml-lang="en-US" l10n="CHG" oldref="131">Press Shift+F4 to select the first control. If the Table Control is not the first control, press Tab until it is selected.</paragraph>
  83 </listitem>
  84 <listitem>
  85 <paragraph role="listitem" id="par_id3151056" xml-lang="en-US" l10n="U" oldref="132">Press Enter to enter the edit mode. The handles are shown farther out from the control border.</paragraph>
  86 </listitem>
  87 <listitem>
  88 <paragraph role="listitem" id="par_id3154938" xml-lang="en-US" l10n="U" oldref="133">In the edit mode, you can open the edit mode context menu by pressing Shift+F10.</paragraph>
  89 </listitem>
  90 <listitem>
  91 <paragraph role="listitem" id="par_id3154365" xml-lang="en-US" l10n="U" oldref="134">If you want to edit columns, press Shift+Space to enter column edit mode. Now you can rearrange the order of columns with <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Arrow keys. The Delete key deletes the current column.</paragraph>
  92 </listitem>
  93 <listitem>
  94 <paragraph role="listitem" id="par_id3145419" xml-lang="en-US" l10n="U" oldref="135">Press the Escape key to exit the edit mode.</paragraph>
  95 </listitem>
  96 </list>
  97 </body>
  98 </helpdocument>