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