1*cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2*cdf0e10cSrcweir 3*cdf0e10cSrcweir 4*cdf0e10cSrcweir 5*cdf0e10cSrcweir<!-- 6*cdf0e10cSrcweir *********************************************************************** 7*cdf0e10cSrcweir * 8*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 9*cdf0e10cSrcweir * 10*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 11*cdf0e10cSrcweir * 12*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 13*cdf0e10cSrcweir * 14*cdf0e10cSrcweir * This file is part of OpenOffice.org. 15*cdf0e10cSrcweir * 16*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 17*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 18*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 19*cdf0e10cSrcweir * 20*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 21*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 22*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 23*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 24*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 27*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 28*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 29*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 30*cdf0e10cSrcweir * 31*cdf0e10cSrcweir ************************************************************************ 32*cdf0e10cSrcweir --> 33*cdf0e10cSrcweir 34*cdf0e10cSrcweir 35*cdf0e10cSrcweir <helpdocument version="1.0"> 36*cdf0e10cSrcweir<meta> 37*cdf0e10cSrcweir<topic id="textshared0201170004xml" indexer="include" status="PUBLISH"> 38*cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Special Tips for Table Controls</title> 39*cdf0e10cSrcweir<filename>/text/shared/02/01170004.xhp</filename> 40*cdf0e10cSrcweir</topic> 41*cdf0e10cSrcweir</meta> 42*cdf0e10cSrcweir<body> 43*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3109850"><bookmark_value>table controls; properties</bookmark_value> 44*cdf0e10cSrcweir<bookmark_value>controls; properties of table controls</bookmark_value> 45*cdf0e10cSrcweir<bookmark_value>table controls;keyboard-only edit mode</bookmark_value> 46*cdf0e10cSrcweir</bookmark> 47*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3109850" xml-lang="en-US" level="1" l10n="U" oldref="124">Special Tips for Table Controls</paragraph> 48*cdf0e10cSrcweir<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> 49*cdf0e10cSrcweir<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> 50*cdf0e10cSrcweir<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> 51*cdf0e10cSrcweir<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> 52*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SVX_HID_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> 53*cdf0e10cSrcweir<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> 54*cdf0e10cSrcweir<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> 55*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SVX_HID_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> 56*cdf0e10cSrcweir<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> 57*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SVX_HID_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> 58*cdf0e10cSrcweir<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> 59*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3147275" xml-lang="en-US" level="2" l10n="U" oldref="73">Column</paragraph> 60*cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152996" xml-lang="en-US" l10n="U" oldref="74">Opens the properties dialog of the selected column.</paragraph> 61*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SVX_HID_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> 62*cdf0e10cSrcweir<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> 63*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SVX_HID_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> 64*cdf0e10cSrcweir<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> 65*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SVX_HID_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> 66*cdf0e10cSrcweir<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> 67*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/cui: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> 68*cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/SVX_HID_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> 69*cdf0e10cSrcweir<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> 70*cdf0e10cSrcweir<paragraph role="heading" id="hd_id3153349" xml-lang="en-US" level="2" l10n="U" oldref="127">Keyboard-only control of Table Controls</paragraph> 71*cdf0e10cSrcweir<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> 72*cdf0e10cSrcweir<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> 73*cdf0e10cSrcweir<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> 74*cdf0e10cSrcweir<list type="ordered"> 75*cdf0e10cSrcweir<listitem> 76*cdf0e10cSrcweir<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> 77*cdf0e10cSrcweir</listitem> 78*cdf0e10cSrcweir<listitem> 79*cdf0e10cSrcweir<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> 80*cdf0e10cSrcweir</listitem> 81*cdf0e10cSrcweir<listitem> 82*cdf0e10cSrcweir<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> 83*cdf0e10cSrcweir</listitem> 84*cdf0e10cSrcweir<listitem> 85*cdf0e10cSrcweir<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> 86*cdf0e10cSrcweir</listitem> 87*cdf0e10cSrcweir<listitem> 88*cdf0e10cSrcweir<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> 89*cdf0e10cSrcweir</listitem> 90*cdf0e10cSrcweir<listitem> 91*cdf0e10cSrcweir<paragraph role="listitem" id="par_id3145419" xml-lang="en-US" l10n="U" oldref="135">Press the Escape key to exit the edit mode.</paragraph> 92*cdf0e10cSrcweir</listitem> 93*cdf0e10cSrcweir</list> 94*cdf0e10cSrcweir</body> 95*cdf0e10cSrcweir</helpdocument> 96