1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3cdf0e10cSrcweir 4cdf0e10cSrcweir 5*122b4424SAndrew Rist<!--*********************************************************** 6cdf0e10cSrcweir * 7*122b4424SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 8*122b4424SAndrew Rist * or more contributor license agreements. See the NOTICE file 9*122b4424SAndrew Rist * distributed with this work for additional information 10*122b4424SAndrew Rist * regarding copyright ownership. The ASF licenses this file 11*122b4424SAndrew Rist * to you under the Apache License, Version 2.0 (the 12*122b4424SAndrew Rist * "License"); you may not use this file except in compliance 13*122b4424SAndrew Rist * with the License. You may obtain a copy of the License at 14*122b4424SAndrew Rist * 15*122b4424SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 16*122b4424SAndrew Rist * 17*122b4424SAndrew Rist * Unless required by applicable law or agreed to in writing, 18*122b4424SAndrew Rist * software distributed under the License is distributed on an 19*122b4424SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20*122b4424SAndrew Rist * KIND, either express or implied. See the License for the 21*122b4424SAndrew Rist * specific language governing permissions and limitations 22*122b4424SAndrew Rist * under the License. 23*122b4424SAndrew Rist * 24*122b4424SAndrew Rist ***********************************************************--> 25*122b4424SAndrew Rist 26*122b4424SAndrew Rist 27cdf0e10cSrcweir 28cdf0e10cSrcweir 29cdf0e10cSrcweir <helpdocument version="1.0"> 30cdf0e10cSrcweir<meta> 31cdf0e10cSrcweir<topic id="textshared0201170004xml" indexer="include" status="PUBLISH"> 32cdf0e10cSrcweir<title id="tit" xml-lang="en-US">Special Tips for Table Controls</title> 33cdf0e10cSrcweir<filename>/text/shared/02/01170004.xhp</filename> 34cdf0e10cSrcweir</topic> 35cdf0e10cSrcweir</meta> 36cdf0e10cSrcweir<body> 37cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3109850"><bookmark_value>table controls; properties</bookmark_value> 38cdf0e10cSrcweir<bookmark_value>controls; properties of table controls</bookmark_value> 39cdf0e10cSrcweir<bookmark_value>table controls;keyboard-only edit mode</bookmark_value> 40cdf0e10cSrcweir</bookmark> 41cdf0e10cSrcweir<paragraph role="heading" id="hd_id3109850" xml-lang="en-US" level="1" l10n="U" oldref="124">Special Tips for Table Controls</paragraph> 42cdf0e10cSrcweir<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> 43cdf0e10cSrcweir<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> 44cdf0e10cSrcweir<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> 45cdf0e10cSrcweir<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> 46cdf0e10cSrcweir<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> 47cdf0e10cSrcweir<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> 48cdf0e10cSrcweir<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> 49cdf0e10cSrcweir<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> 50cdf0e10cSrcweir<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> 51cdf0e10cSrcweir<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> 52cdf0e10cSrcweir<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> 53cdf0e10cSrcweir<paragraph role="heading" id="hd_id3147275" xml-lang="en-US" level="2" l10n="U" oldref="73">Column</paragraph> 54cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152996" xml-lang="en-US" l10n="U" oldref="74">Opens the properties dialog of the selected column.</paragraph> 55cdf0e10cSrcweir<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> 56cdf0e10cSrcweir<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> 57cdf0e10cSrcweir<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> 58cdf0e10cSrcweir<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> 59cdf0e10cSrcweir<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> 60cdf0e10cSrcweir<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> 61cdf0e10cSrcweir<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> 62cdf0e10cSrcweir<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> 63cdf0e10cSrcweir<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> 64cdf0e10cSrcweir<paragraph role="heading" id="hd_id3153349" xml-lang="en-US" level="2" l10n="U" oldref="127">Keyboard-only control of Table Controls</paragraph> 65cdf0e10cSrcweir<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> 66cdf0e10cSrcweir<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> 67cdf0e10cSrcweir<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> 68cdf0e10cSrcweir<list type="ordered"> 69cdf0e10cSrcweir<listitem> 70cdf0e10cSrcweir<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> 71cdf0e10cSrcweir</listitem> 72cdf0e10cSrcweir<listitem> 73cdf0e10cSrcweir<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> 74cdf0e10cSrcweir</listitem> 75cdf0e10cSrcweir<listitem> 76cdf0e10cSrcweir<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> 77cdf0e10cSrcweir</listitem> 78cdf0e10cSrcweir<listitem> 79cdf0e10cSrcweir<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> 80cdf0e10cSrcweir</listitem> 81cdf0e10cSrcweir<listitem> 82cdf0e10cSrcweir<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> 83cdf0e10cSrcweir</listitem> 84cdf0e10cSrcweir<listitem> 85cdf0e10cSrcweir<paragraph role="listitem" id="par_id3145419" xml-lang="en-US" l10n="U" oldref="135">Press the Escape key to exit the edit mode.</paragraph> 86cdf0e10cSrcweir</listitem> 87cdf0e10cSrcweir</list> 88cdf0e10cSrcweir</body> 89cdf0e10cSrcweir</helpdocument> 90