doc/sheets/commands.docbook

0001 <chapter id="commands">
0002 <chapterinfo>
0003 <authorgroup>
0004 <author>
0005 <firstname>Pamela</firstname>
0006 <surname>Robert</surname>
0007 <affiliation>
0008 <address><email>pamroberts@blueyonder.co.uk</email></address>
0009 </affiliation>
0010 </author>
0011 <!-- TRANS:ROLES_OF_TRANSLATORS -->
0012 </authorgroup>
0013 </chapterinfo>
0014 <title>Command Reference</title>
0015
0016 <sect1 id="filemenu">
0017 <title>The File Menu</title>
0018 <para>
0019 <variablelist>
0020 <varlistentry>
0021 <term><menuchoice>
0022 <shortcut>
0023 <keycombo action="simul">&Ctrl;<keycap>N</keycap></keycombo>
0024 </shortcut>
0025 <guimenu>File</guimenu>
0026 <guimenuitem>New</guimenuitem>
0027 </menuchoice></term>
0028 <listitem><para><action>Create a new document.</action></para></listitem>
0029 </varlistentry>
0030
0031 <varlistentry>
0032 <term><menuchoice>
0033 <shortcut>
0034 <keycombo action="simul">&Ctrl;<keycap>O</keycap></keycombo>
0035 </shortcut>
0036 <guimenu>File</guimenu>
0037 <guimenuitem>Open...</guimenuitem>
0038 </menuchoice></term>
0039 <listitem><para><action>Open an existing document.</action></para></listitem>
0040 </varlistentry>
0041
0042 <varlistentry>
0043 <term><menuchoice>
0044 <guimenu>File</guimenu>
0045 <guisubmenu>Open Recent</guisubmenu>
0046 </menuchoice></term>
0047 <listitem><para><action>Open an existing document</action> by selecting it
0048 from a combo box of recently used files.</para></listitem>
0049 </varlistentry>
0050
0051 <varlistentry>
0052 <term><menuchoice>
0053 <shortcut>
0054 <keycombo action="simul">&Ctrl;<keycap>S</keycap></keycombo>
0055 </shortcut>
0056 <guimenu>File</guimenu>
0057 <guimenuitem>Save</guimenuitem>
0058 </menuchoice></term>
0059 <listitem><para><action>Save the document.</action></para></listitem>
0060 </varlistentry>
0061
0062 <varlistentry>
0063 <term><menuchoice>
0064 <guimenu>File</guimenu>
0065 <guimenuitem>Save As...</guimenuitem>
0066 </menuchoice></term>
0067 <listitem><para><action>Save and change the current document to a new name or format.
0068 If you want to keep the name and format of the document use <guimenuitem>Export...</guimenuitem></action>
0069 </para></listitem>
0070 </varlistentry>
0071
0072 <varlistentry>
0073 <term><menuchoice>
0074 <guimenu>File</guimenu>
0075 <guimenuitem>Reload</guimenuitem>
0076 </menuchoice></term>
0077 <listitem><para><action>Reloads the document.</action>
0078 </para></listitem>
0079 </varlistentry>
0080 <!--
0081 <varlistentry>
0082 <term><menuchoice>
0083 <guimenu>File</guimenu>
0084 <guimenuitem>Versions</guimenuitem>
0085 </menuchoice></term>
0086 <listitem><para><action>FIXME define different versions of the document + open them in new windows</action>
0087 </para></listitem>
0088 </varlistentry>
0089 -->
0090 <varlistentry>
0091 <term><menuchoice>
0092 <guimenu>File</guimenu>
0093 <guimenuitem>Import...</guimenuitem>
0094 </menuchoice></term>
0095 <listitem><para><action>Import other documents.</action>
0096 </para>
0097 <para>Tables of data are often held in text files with the values in a
0098 line being separated by a comma, space, tab or other character,
0099 for example <emphasis>123, 456, 789, abcd, efgh</emphasis>. Such files
0100 are commonly called <quote><acronym>CSV</acronym></quote> (Comma Separated
0101 Values) files, even though the separating character may not be a comma.</para>
0102 <para>If you ask &sheets; to open a text file it assumes that the file is
0103 in <acronym>CSV</acronym> format and launches a dialog box that allows you to
0104 specify the delimiter (separating character) used by the file, and shows how
0105 the data items will be placed into different spreadsheet cells.</para>
0106 <para>Other options in this dialog box let you define the <guilabel>Format</guilabel>
0107 of the spreadsheet cells, whether text quote characters should be
0108 removed, and whether the first line(s) of the file should be ignored.</para>
0109 </listitem>
0110 </varlistentry>
0111
0112 <varlistentry>
0113 <term><menuchoice>
0114 <guimenu>File</guimenu>
0115 <guimenuitem>Export...</guimenuitem>
0116 </menuchoice></term>
0117 <listitem><para><action>Save a document to any supported format.</action>
0118 The document does not become the exported file.
0119 </para></listitem>
0120 </varlistentry>
0121
0122 <varlistentry>
0123 <term><menuchoice>
0124 <guimenu>File</guimenu>
0125 <guimenuitem>Mail...</guimenuitem>
0126 </menuchoice></term>
0127 <listitem><para><action>Send the file as an email attachment.</action></para>
0128 </listitem>
0129 </varlistentry>
0130
0131 <varlistentry>
0132 <term><menuchoice>
0133 <guimenu>File</guimenu>
0134 <guimenuitem>Create Template From Document...</guimenuitem>
0135 </menuchoice></term>
0136 <listitem><para>Create a &sheets; <link linkend="templates">template</link>
0137 based on this document.
0138 </para></listitem>
0139 </varlistentry>
0140
0141 <varlistentry>
0142 <term><menuchoice>
0143 <shortcut>
0144 <keycombo action="simul">&Ctrl;<keycap>P</keycap></keycombo>
0145 </shortcut>
0146 <guimenu>File</guimenu>
0147 <guimenuitem>Print...</guimenuitem>
0148 </menuchoice></term>
0149 <listitem><para><action>Print the document.</action></para></listitem>
0150 </varlistentry>
0151
0152 <varlistentry>
0153 <term><menuchoice>
0154 <guimenu>File</guimenu>
0155 <guimenuitem>Print Preview...</guimenuitem>
0156 </menuchoice></term>
0157 <listitem><para><action>View the document as it will be printed.</action></para>
0158 </listitem>
0159 </varlistentry>
0160 <!--
0161 <varlistentry>
0162 <term><menuchoice>
0163 <guimenu>File</guimenu>
0164 <guimenuitem>Export as PDF...</guimenuitem>
0165 </menuchoice></term>
0166 <listitem><para><action>FIXME</action></para>
0167 </listitem>
0168 </varlistentry>
0169 -->
0170 <varlistentry>
0171 <term><menuchoice>
0172 <guimenu>File</guimenu>
0173 <guimenuitem>Document Information</guimenuitem>
0174 </menuchoice></term>
0175 <listitem><para><action>View or enter information about the document and
0176 author.</action></para>
0177 </listitem>
0178 </varlistentry>
0179
0180 <varlistentry>
0181 <term><menuchoice>
0182 <shortcut>
0183 <keycombo action="simul">&Ctrl;<keycap>W</keycap></keycombo>
0184 </shortcut>
0185 <guimenu>File</guimenu>
0186 <guimenuitem>Close</guimenuitem>
0187 </menuchoice></term>
0188 <listitem><para><action>Close the current document but leave &sheets; running.
0189 </action></para></listitem>
0190 </varlistentry>
0191 <varlistentry>
0192
0193 <term><menuchoice>
0194 <shortcut>
0195 <keycombo action="simul">&Ctrl;<keycap>Q</keycap></keycombo>
0196 </shortcut>
0197 <guimenu>File</guimenu>
0198 <guimenuitem>Quit</guimenuitem>
0199 </menuchoice></term>
0200 <listitem><para><action>Quit</action> &sheets;.</para></listitem>
0201 </varlistentry>
0202 </variablelist>
0203 </para>
0204
0205 </sect1>
0206
0207 <sect1 id="editmenu">
0208 <title>The Edit Menu</title>
0209 <para>
0210 <variablelist>
0211
0212 <varlistentry>
0213 <term><menuchoice>
0214 <shortcut>
0215 <keycombo action="simul">&Ctrl;<keycap>Z</keycap></keycombo>
0216 </shortcut>
0217 <guimenu>Edit</guimenu>
0218 <guimenuitem>Undo</guimenuitem>
0219 </menuchoice></term>
0220 <listitem><para><action>Undo the last action.</action></para></listitem>
0221 </varlistentry>
0222
0223 <varlistentry>
0224 <term><menuchoice>
0225 <shortcut>
0226 <keycombo action="simul">&Ctrl;&Shift;<keycap>Z</keycap></keycombo>
0227 </shortcut>
0228 <guimenu>Edit</guimenu>
0229 <guimenuitem>Redo</guimenuitem>
0230 </menuchoice></term>
0231 <listitem><para><action>Redo the last undone action.</action>
0232 </para></listitem>
0233 </varlistentry>
0234
0235 <varlistentry>
0236 <term><menuchoice>
0237 <shortcut>
0238 <keycombo action="simul">&Ctrl;<keycap>X</keycap></keycombo>
0239 </shortcut>
0240 <guimenu>Edit</guimenu>
0241 <guimenuitem>Cut</guimenuitem>
0242 </menuchoice></term>
0243 <listitem><para><action>Put selected item(s) into the clipboard and remove
0244 them from the original location.</action> If you then
0245 do a <guimenuitem>Paste</guimenuitem> the item(s) will be inserted at
0246 the new location.
0247 </para></listitem>
0248 </varlistentry>
0249
0250 <varlistentry>
0251 <term><menuchoice>
0252 <shortcut>
0253 <keycombo action="simul">&Ctrl;<keycap>C</keycap></keycombo>
0254 </shortcut>
0255 <guimenu>Edit</guimenu>
0256 <guimenuitem>Copy</guimenuitem>
0257 </menuchoice></term>
0258 <listitem><para><action>Copy selected item(s) to the clipboard.</action>
0259 </para></listitem>
0260 </varlistentry>
0261
0262 <varlistentry>
0263 <term><menuchoice>
0264 <shortcut>
0265 <keycombo action="simul">&Ctrl;<keycap>V</keycap></keycombo>
0266 </shortcut>
0267 <guimenu>Edit</guimenu>
0268 <guimenuitem>Paste</guimenuitem>
0269 </menuchoice></term>
0270 <listitem><para><action>Paste item(s) from the clipboard to the selected
0271 cell(s).</action>
0272 </para></listitem>
0273 </varlistentry>
0274
0275 <varlistentry>
0276 <term><menuchoice>
0277 <guimenu>Edit</guimenu>
0278 <guimenuitem>Special Paste...</guimenuitem>
0279 </menuchoice></term>
0280 <listitem><para><action>Special forms of Paste.
0281 </action> See the sections <link linkend="specialpaste">Other Paste
0282 Modes</link> and <link linkend="sumspecialpaste">Arithmetic using Special
0283 Paste</link> for more details.
0284 </para></listitem>
0285 </varlistentry>
0286
0287 <varlistentry>
0288 <term><menuchoice>
0289 <guimenu>Edit</guimenu>
0290 <guimenuitem>Paste with Insertion</guimenuitem>
0291 </menuchoice></term>
0292 <listitem><para><action>Move content of the paste area either to the right
0293 or down and paste item(s) from the clipboard to the selected cell(s).</action>
0294 </para></listitem>
0295 </varlistentry>
0296
0297 <varlistentry>
0298 <term><menuchoice>
0299 <guimenu>Edit</guimenu>
0300 <guisubmenu>Fill</guisubmenu>
0301 </menuchoice></term>
0302 <listitem><para><action>Fills up the selected area with the values from the
0303 first item-set.</action> All four directions are supported. Note that the
0304 term "item-set" describes the first set of values seen in the fill direction.
0305 If the fill direction is Left then the first item-set is the last column of the
0306 selection.
0307 </para></listitem>
0308 </varlistentry>
0309 <!--
0310 <varlistentry>
0311 <term><menuchoice>
0312 <shortcut>
0313 <keycombo action="simul">&Ctrl;<keycap>A</keycap></keycombo>
0314 </shortcut>
0315 <guimenu>Edit</guimenu>
0316 <guimenuitem>Select All</guimenuitem>
0317 </menuchoice></term>
0318 <listitem><para><action>FIXME</action>
0319 </para></listitem>
0320 </varlistentry>
0321 -->
0322 <varlistentry>
0323 <term><menuchoice>
0324 <shortcut>
0325 <keycombo action="simul">&Ctrl;<keycap>F</keycap></keycombo>
0326 </shortcut>
0327 <guimenu>Edit</guimenu>
0328 <guimenuitem>Find...</guimenuitem>
0329 </menuchoice></term>
0330 <listitem><para><action>Find cell containing given text.</action>
0331 </para></listitem>
0332 </varlistentry>
0333
0334 <varlistentry>
0335 <term><menuchoice>
0336 <shortcut>
0337 <keysym>F3</keysym>
0338 </shortcut>
0339 <guimenu>Edit</guimenu>
0340 <guimenuitem>Find Next</guimenuitem>
0341 </menuchoice></term>
0342 <listitem><para><action>Find the next cell containing given text.</action>
0343 </para></listitem>
0344 </varlistentry>
0345
0346 <varlistentry>
0347 <term><menuchoice>
0348 <shortcut>
0349 <keycombo action="simul">&Shift;<keycap>F3</keycap></keycombo>
0350 </shortcut>
0351 <guimenu>Edit</guimenu>
0352 <guimenuitem>Find Previous</guimenuitem>
0353 </menuchoice></term>
0354 <listitem><para><action>Find the previous cell containing given text.</action>
0355 </para></listitem>
0356 </varlistentry>
0357
0358 <varlistentry>
0359 <term><menuchoice>
0360 <shortcut>
0361 <keycombo action="simul">&Ctrl;<keycap>R</keycap></keycombo>
0362 </shortcut>
0363 <guimenu>Edit</guimenu>
0364 <guimenuitem>Replace...</guimenuitem>
0365 </menuchoice></term>
0366 <listitem><para><action>Find and replace given text in cell(s).</action>
0367 </para></listitem>
0368 </varlistentry>
0369
0370 <varlistentry>
0371 <term><menuchoice>
0372 <guimenu>Edit</guimenu>
0373 <guisubmenu>Clear</guisubmenu>
0374 </menuchoice></term>
0375 <listitem><para><action>Clear <guimenuitem>All</guimenuitem> or <guimenuitem>Contents</guimenuitem>,
0376 <guimenuitem>Comment</guimenuitem>, <guimenuitem>Conditional Styles</guimenuitem>,
0377 <guimenuitem>Link</guimenuitem> or <guimenuitem>Validity</guimenuitem> from selected cell(s).</action>
0378 </para></listitem>
0379 </varlistentry>
0380
0381 <varlistentry>
0382 <term><menuchoice>
0383 <guimenu>Edit</guimenu>
0384 <guimenuitem>Delete</guimenuitem>
0385 </menuchoice></term>
0386 <listitem><para><action>Delete <guimenuitem>Cells</guimenuitem>, <guimenuitem>Columns</guimenuitem>,
0387 <guimenuitem>Rows</guimenuitem> or <guimenuitem>Sheet</guimenuitem>.</action>
0388 </para></listitem>
0389 </varlistentry>
0390 <!--
0391 <varlistentry>
0392 <term><menuchoice>
0393 <guimenu>Edit</guimenu>
0394 <guimenuitem>Conditional Cell Attributes...</guimenuitem>
0395 </menuchoice></term>
0396 <listitem><para><action>Add or modify conditional cell attributes.</action>
0397 </para></listitem>
0398 </varlistentry>
0399
0400 -->
0401 <varlistentry>
0402 <term><menuchoice>
0403 <shortcut>
0404 <keycap>F2</keycap>
0405 </shortcut>
0406 <guimenu>Edit</guimenu>
0407 <guimenuitem>Modify Cell</guimenuitem>
0408 </menuchoice></term>
0409 <listitem><para><action>To modify selected cell in-situ.</action>
0410 </para></listitem>
0411 </varlistentry>
0412
0413 </variablelist>
0414 </para>
0415 </sect1>
0416
0417 <sect1 id="viewmenu">
0418 <title>The View Menu</title>
0419 <para>
0420 <variablelist>
0421
0422 <varlistentry>
0423 <term><menuchoice>
0424 <guimenu>View</guimenu>
0425 <guimenuitem>New View</guimenuitem>
0426 </menuchoice></term>
0427 <listitem><para><action>Open a new instance of &sheets;
0428 with the same document.</action>
0429 </para></listitem>
0430 </varlistentry>
0431 <!--
0432 <varlistentry>
0433 <term><menuchoice>
0434 <shortcut>
0435 <keycombo action="simul">&Ctrl;&Shift;<keycap>W</keycap></keycombo>
0436 </shortcut>
0437 <guimenu>View</guimenu>
0438 <guimenuitem>Close All Views</guimenuitem>
0439 </menuchoice></term>
0440 <listitem><para><action>Close all open instances of &sheets;</action>
0441 </para></listitem>
0442 </varlistentry>
0443
0444 <varlistentry>
0445 <term><menuchoice>
0446 <guimenu>View</guimenu>
0447 <guimenuitem>Split View</guimenuitem>
0448 </menuchoice></term>
0449 <listitem><para><action>Split current view into two parts.</action>
0450 </para></listitem>
0451 </varlistentry>
0452
0453 <varlistentry>
0454 <term><menuchoice>
0455 <guimenu>View</guimenu>
0456 <guimenuitem>Remove View</guimenuitem>
0457 </menuchoice></term>
0458 <listitem><para><action>Remove current view.</action> (Where the window
0459 contains two or more views)
0460 </para></listitem>
0461 </varlistentry>
0462
0463 <varlistentry>
0464 <term><menuchoice>
0465 <guimenu>View</guimenu>
0466 <guisubmenu>Splitter Orientation</guisubmenu>
0467 </menuchoice></term>
0468 <listitem><para><action>Change view split to <guilabel>Horizontal</guilabel> or <guilabel>Vertical</guilabel>.</action>
0469 </para></listitem>
0470 </varlistentry>
0471
0472 <varlistentry>
0473 <term><menuchoice>
0474 <guimenu>View</guimenu>
0475 <guimenuitem>Goto Cell...</guimenuitem>
0476 </menuchoice></term>
0477 <listitem><para><action>Change &sheets;'s focus to show defined cell.</action>
0478 </para></listitem>
0479 </varlistentry>
0480 -->
0481 <varlistentry>
0482 <term><menuchoice>
0483 <guimenu>View</guimenu>
0484 <guimenuitem>Page Borders</guimenuitem>
0485 </menuchoice></term>
0486 <listitem><para><action>Toggle marking of printed page borders in the sheet
0487 with red lines.
0488 </action>
0489 </para></listitem>
0490 </varlistentry>
0491 <!--
0492 <varlistentry>
0493 <term><menuchoice>
0494 <guimenu>View</guimenu>
0495 <guimenuitem>Show/Hide Comment Indicator</guimenuitem>
0496 </menuchoice></term>
0497 <listitem><para><action>Toggle marking of cell comments.</action>
0498 If a cell contains a comment and this option is selected, a small red triangle
0499 is shown in the upper right corner of the cell.
0500 </para></listitem>
0501 </varlistentry>
0502 -->
0503 <!--FIXME missing Zoom In Zoom Out-->
0504 <varlistentry>
0505 <term><menuchoice>
0506 <guimenu>View</guimenu>
0507 <guisubmenu>Zoom</guisubmenu>
0508 </menuchoice></term>
0509 <listitem><para><action>Increase or decrease the magnification used to display
0510 the spreadsheet. Range from 33% to 500%.
0511 </action>
0512 </para></listitem>
0513 </varlistentry>
0514 <!--FIXME Full Screen Mode-->
0515
0516 </variablelist>
0517 </para>
0518 </sect1>
0519
0520 <sect1 id="gomenu">
0521 <title>The Go Menu</title>
0522 <para>In this menu you find actions to navigate between the sheets of the currently
0523 opened spreadsheet and the <guimenuitem>Goto Cell</guimenuitem> action to jump to a single
0524 cell or to select a range of cells.</para>
0525 </sect1>
0526
0527 <sect1 id="insertmenu">
0528 <title>The Insert Menu</title>
0529 <para>
0530 <variablelist>
0531
0532 <!-- OBSOLETE <varlistentry>
0533 <term><menuchoice>
0534 <guimenu>Insert</guimenu>
0535 <guimenuitem>Sheet</guimenuitem>
0536 </menuchoice></term>
0537 <listitem><para><action>Add another worksheet.</action>
0538 </para></listitem>
0539 </varlistentry>-->
0540
0541 <varlistentry>
0542 <term><menuchoice>
0543 <guimenu>Insert</guimenu>
0544 <guisubmenu>Comment</guisubmenu>
0545 </menuchoice></term>
0546 <listitem><para>Add or modify a comment.
0547 </para></listitem>
0548 </varlistentry>
0549
0550 <varlistentry>
0551 <term><menuchoice>
0552 <guimenu>Insert</guimenu>
0553 <guimenuitem>Function...</guimenuitem>
0554 </menuchoice></term>
0555 <listitem><para><action>Insert a mathematical function.</action> See the
0556 section <link linkend="formulas">Formulae</link> for more details.
0557 </para></listitem>
0558 </varlistentry>
0559
0560 <varlistentry>
0561 <term><menuchoice>
0562 <guimenu>Insert</guimenu>
0563 <guimenuitem>Series...</guimenuitem>
0564 </menuchoice></term>
0565 <listitem><para><action>Insert a series.</action> See the section
0566 <link linkend="series">Series</link> for more details.
0567 </para></listitem>
0568 </varlistentry>
0569
0570 <varlistentry>
0571 <term><menuchoice>
0572 <guimenu>Insert</guimenu>
0573 <guimenuitem>Link...</guimenuitem>
0574 </menuchoice></term>
0575 <listitem><para><action>Insert a link into the selected cell.</action>
0576 See the section
0577 <link linkend="hyper">Link Cells</link> for more details.
0578 </para></listitem>
0579 </varlistentry>
0580
0581 <varlistentry>
0582 <term><menuchoice>
0583 <guimenu>Insert</guimenu>
0584 <guimenuitem>Special Character...</guimenuitem>
0585 </menuchoice></term>
0586 <listitem><para><action>Insert a special character into the selected cell.</action>
0587 </para></listitem>
0588 </varlistentry>
0589 <!--FIXME missing Cells Columns Rows Sheet-->
0590 <!--
0591 <varlistentry>
0592 <term><menuchoice>
0593 <guimenu>Insert</guimenu>
0594 <guisubmenu>Object</guisubmenu>
0595 </menuchoice></term>
0596 <listitem><para><action>Embed another &koffice; document into the sheet.</action>
0597 </para></listitem>
0598 </varlistentry>
0599
0600 <varlistentry>
0601 <term><menuchoice>
0602 <guimenu>Insert</guimenu>
0603 <guimenuitem>Chart</guimenuitem>
0604 </menuchoice></term>
0605 <listitem><para><action>Insert a chart.</action> See the section
0606 <link linkend="insertchart">Inserting a Chart</link> for more details.
0607 </para></listitem>
0608 </varlistentry>
0609
0610 <varlistentry>
0611 <term><menuchoice>
0612 <guimenu>Insert</guimenu>
0613 <guimenuitem>Picture</guimenuitem>
0614 </menuchoice></term>
0615 <listitem><para><action>Opens the standard &kde; file dialog</action>
0616 to insert a picture.
0617 </para></listitem>
0618 </varlistentry>
0619 -->
0620 <varlistentry>
0621 <term><menuchoice>
0622 <guimenu>Insert</guimenu>
0623 <guisubmenu>External Data</guisubmenu>
0624 </menuchoice></term>
0625 <listitem><para><action>Insert data <guilabel>From Database...</guilabel>,
0626 <guilabel>From Text File...</guilabel> or <guilabel>From
0627 Clipboard...</guilabel>.</action> See the section <link linkend="insertdata">Inserting
0628 External Data</link> for more details.
0629 </para></listitem>
0630 </varlistentry>
0631
0632 </variablelist>
0633 </para>
0634 </sect1>
0635
0636 <sect1 id="formatmenu">
0637 <title>The Format Menu</title>
0638 <para><variablelist>
0639
0640 <varlistentry>
0641 <term><menuchoice>
0642 <shortcut>
0643 <keycombo action="simul">&Alt;&Ctrl;<keycap>F</keycap></keycombo>
0644 </shortcut>
0645 <guimenu>Format</guimenu>
0646 <guimenuitem>Cell Format...</guimenuitem>
0647 </menuchoice></term>
0648 <listitem><para><action>Format selected cell(s).</action> See the
0649 <link linkend="formatspread">Spreadsheet Formatting</link> section for more
0650 details.
0651 </para></listitem>
0652 </varlistentry>
0653
0654 <varlistentry>
0655 <term><menuchoice>
0656 <guimenu>Format</guimenu>
0657 <guimenuitem>Style Manager</guimenuitem>
0658 </menuchoice></term>
0659 <listitem><para><action>Create, Modify or delete cell format styles.</action>
0660 </para></listitem>
0661 </varlistentry>
0662
0663 <varlistentry>
0664 <term><menuchoice>
0665 <guimenu>Format</guimenu>
0666 <guisubmenu>Style</guisubmenu>
0667 </menuchoice></term>
0668 <listitem><para><action>Apply a style to selected cell(s).</action>
0669 To manage styles use <menuchoice>
0670 <guimenu>Format</guimenu><guimenuitem>Style Manager...</guimenuitem>
0671 </menuchoice>
0672 </para></listitem>
0673 </varlistentry>
0674
0675 <varlistentry>
0676 <term><menuchoice>
0677 <guimenu>Format</guimenu>
0678 <guimenuitem>Create Style From Cell...</guimenuitem>
0679 </menuchoice></term>
0680 <listitem><para><action>Create a new style from the format of the
0681 selected cell.</action>
0682 To manage styles use <menuchoice>
0683 <guimenu>Format</guimenu><guimenuitem>Style Manager...</guimenuitem>
0684 </menuchoice>
0685 </para></listitem>
0686 </varlistentry>
0687 <!--FIXME missing Conditional Styles-->
0688 <varlistentry>
0689 <term><menuchoice>
0690 <guimenu>Format</guimenu>
0691 <guimenuitem>AutoFormat...</guimenuitem>
0692 </menuchoice></term>
0693 <listitem><para><action>Autoformat the selected cells: a dialog let you choose betwen two proposed formats.</action>
0694 </para></listitem>
0695 </varlistentry>
0696
0697 <varlistentry>
0698 <term><menuchoice>
0699 <guimenu>Format</guimenu>
0700 <guimenuitem>Merge Cells</guimenuitem>
0701 </menuchoice></term>
0702 <listitem><para><action>Merge selected cells.</action>
0703 </para></listitem>
0704 </varlistentry>
0705
0706 <varlistentry>
0707 <term><menuchoice>
0708 <guimenu>Format</guimenu>
0709 <guimenuitem>Dissociate Cells</guimenuitem>
0710 </menuchoice></term>
0711 <listitem><para><action>Dissociate (split apart) previously merged cells.
0712 </action>
0713 </para></listitem>
0714 </varlistentry>
0715
0716 <varlistentry>
0717 <term><menuchoice>
0718 <guimenu>Format</guimenu>
0719 <guimenuitem>Adjust Row &amp; Column</guimenuitem>
0720 </menuchoice></term>
0721 <listitem><para><action>Set row and column sizes to show selected cell(s)
0722 properly.</action>
0723 </para></listitem>
0724 </varlistentry>
0725
0726 <varlistentry>
0727 <term><menuchoice>
0728 <guimenu>Format</guimenu>
0729 <guisubmenu>Row</guisubmenu>
0730 </menuchoice></term>
0731 <listitem><para><action>Resize, equalize, hide or show row(s).</action>
0732 </para></listitem>
0733 </varlistentry>
0734
0735 <varlistentry>
0736 <term><menuchoice>
0737 <guimenu>Format</guimenu>
0738 <guisubmenu>Column</guisubmenu>
0739 </menuchoice></term>
0740 <listitem><para><action>Resize, equalize, hide or show column(s).</action>
0741 </para></listitem>
0742 </varlistentry>
0743
0744 <varlistentry>
0745 <term><menuchoice>
0746 <guimenu>Format</guimenu>
0747 <guisubmenu>Sheet</guisubmenu>
0748 </menuchoice></term>
0749 <listitem><para><action>Hide, show worksheet or configure
0750 advanced sheet properties.</action>
0751 </para></listitem>
0752 </varlistentry>
0753
0754 <varlistentry>
0755 <term><menuchoice>
0756 <guimenu>Format</guimenu>
0757 <guimenuitem>Page Layout...</guimenuitem>
0758 </menuchoice></term>
0759 <listitem><para><action>Format printed page layout.</action>
0760 </para></listitem>
0761 </varlistentry>
0762
0763 <varlistentry>
0764 <term><menuchoice>
0765 <guimenu>Format</guimenu>
0766 <guisubmenu>Print Range</guisubmenu>
0767 </menuchoice></term>
0768 <listitem><para><action>Define or reset the print range.</action>
0769 </para></listitem>
0770 </varlistentry>
0771
0772  <!--FIXME missing Manual Page Breaks, Anchors, Document Settings-->
0773 </variablelist></para>
0774 </sect1>
0775
0776 <sect1 id="datamenu">
0777 <title>The Data Menu</title>
0778 <para><variablelist>
0779
0780 <varlistentry>
0781 <term><menuchoice>
0782 <guimenu>Data</guimenu>
0783 <guimenuitem>Sort...</guimenuitem>
0784 </menuchoice></term>
0785 <listitem><para><action>Sort data in selected cells.</action> See the section
0786 <link linkend="sort">Sorting Data</link> for more details.
0787 </para></listitem>
0788 </varlistentry>
0789 <!--FIXME missing Filter-->
0790 <varlistentry>
0791 <term><menuchoice>
0792 <guimenu>Data</guimenu>
0793 <guimenuitem>Text to Columns...</guimenuitem>
0794 </menuchoice></term>
0795 <listitem><para>This option attempts to interpret text in the selected cell(s)
0796 as <acronym>CSV</acronym> data, placing each
0797 item into a different cell in the row.
0798 </para></listitem>
0799 </varlistentry>
0800
0801 <varlistentry>
0802 <term><menuchoice>
0803 <shortcut>
0804 <keycombo action="simul">&Ctrl;&Shift;<keycap>G</keycap></keycombo>
0805 </shortcut>
0806 <guimenu>Data</guimenu>
0807 <guimenuitem>Named Areas...</guimenuitem>
0808 </menuchoice></term>
0809 <listitem><para><action>Open</action> the <guilabel>Named Areas</guilabel> dialog
0810 to select, add, edit and remove named areas. See the section
0811 <link linkend="namedareas">Named Cells and Areas</link> for further details.
0812 </para></listitem>
0813 </varlistentry>
0814
0815 <varlistentry>
0816 <term><menuchoice>
0817 <guimenu>Data</guimenu>
0818 <guimenuitem>Consolidate...</guimenuitem>
0819 </menuchoice></term>
0820 <listitem><para><action>Consolidate data.</action> See the section
0821 <link linkend="consolidate">Consolidating Data</link> for more details.
0822 </para></listitem>
0823 </varlistentry>
0824
0825 <varlistentry>
0826 <term><menuchoice>
0827 <guimenu>Data</guimenu>
0828 <guimenuitem>Subtotals...</guimenuitem>
0829 </menuchoice></term>
0830 <listitem><para><action>Create different kinds of subtotals to a
0831 database.</action>
0832 </para></listitem>
0833 </varlistentry>
0834
0835 <varlistentry>
0836 <term><menuchoice>
0837 <guimenu>Data</guimenu>
0838 <guimenuitem>Validity...</guimenuitem>
0839 </menuchoice></term>
0840 <listitem><para><action>Set or modify the error checking criteria and error
0841 alert message for selected cell(s).</action> See <link linkend="validcheck">
0842 Validity Checking</link> for more details.
0843 </para></listitem>
0844 </varlistentry>
0845
0846 <varlistentry>
0847 <term><menuchoice>
0848 <guimenu>Data</guimenu>
0849 <guimenuitem>Goal Seek...</guimenuitem>
0850 </menuchoice></term>
0851 <listitem><para><action>Open the Goal Seek dialog box</action>. See
0852 <link linkend="goalseek">Goal Seeking</link> for details.
0853 </para></listitem>
0854 </varlistentry>
0855
0856 <varlistentry>
0857 <term><menuchoice>
0858 <guimenu>Data</guimenu>
0859 <guimenuitem>Pivot...</guimenuitem>
0860 </menuchoice></term>
0861 <listitem><para><action>Open the Pivot Table configuration dialog</action>. See
0862 <link linkend="pivottable">Pivot Table</link> for details.
0863 </para></listitem>
0864 </varlistentry>
0865
0866 </variablelist></para>
0867 </sect1>
0868
0869 <sect1 id="toolsmenu">
0870 <title>The Tools Menu</title>
0871 <para><variablelist>
0872
0873 <varlistentry>
0874 <term><menuchoice>
0875 <guimenu>Tools</guimenu>
0876 <guimenuitem>Spelling...</guimenuitem>
0877 </menuchoice></term>
0878 <listitem><para><action>Check spelling of words in the worksheet.</action>
0879 </para></listitem>
0880 </varlistentry>
0881
0882 <varlistentry>
0883 <term><menuchoice>
0884 <guimenu>Tools</guimenu>
0885 <guimenuitem>Custom Lists...</guimenuitem>
0886 </menuchoice></term>
0887 <listitem><para><action>View or amend the special series of words recognized
0888   by &sheets;. These list can be used to insert special <link linkend="series">series</link> into the worksheet.</action>
0889 </para></listitem>
0890 </varlistentry>
0891
0892 <varlistentry>
0893 <term><menuchoice>
0894 <guimenu>Tools</guimenu>
0895 <guimenuitem>Protect Sheet...</guimenuitem>
0896 </menuchoice></term>
0897 <listitem><para>
0898 <action>Protect the sheet with a password. A dialog pops up prompting you for a password. Unchecking this option will prompt you for the password in order to unprotect the sheet. Protecting a sheet means protecting all cells in the sheet. In a protected sheet, the cells cannot be reformatted or overwritten.</action>
0899 </para></listitem>
0900 </varlistentry>
0901
0902 <varlistentry>
0903 <term><menuchoice>
0904 <guimenu>Tools</guimenu>
0905 <guimenuitem>Protect Document...</guimenuitem>
0906 </menuchoice></term>
0907 <listitem><para>
0908 <action>Protect the whole document with a password. A dialog pops up prompting
0909 you for a password. Unchecking this option will prompt you for the password in
0910 order to unprotect the document. In a protected document you cannot rename or
0911 remove a sheet. Document protection does not mean that each individual sheet
0912 is protected.</action>
0913 </para></listitem>
0914 </varlistentry>
0915
0916 <varlistentry>
0917 <term><menuchoice>
0918 <shortcut>
0919 <keycombo action="simul">&Shift;<keysym>F9</keysym></keycombo>
0920 </shortcut>
0921 <guimenu>Tools</guimenu>
0922 <guimenuitem>Recalculate Sheet</guimenuitem>
0923 </menuchoice></term>
0924 <listitem><para><action>Recalculate formulae in the current sheet.</action>
0925 </para></listitem>
0926 </varlistentry>
0927
0928 <varlistentry>
0929 <term><menuchoice>
0930 <shortcut>
0931 <keysym>F9</keysym>
0932 </shortcut>
0933 <guimenu>Tools</guimenu>
0934 <guimenuitem>Recalculate Document</guimenuitem>
0935 </menuchoice></term>
0936 <listitem><para><action>Recalculate all sheets.</action>
0937 </para></listitem>
0938 </varlistentry>
0939 <!--
0940 <varlistentry>
0941 <term><menuchoice>
0942 <guimenu>Tools</guimenu>
0943 <guimenuitem>Insert Calendar...</guimenuitem>
0944 </menuchoice></term>
0945 <listitem><para><action>Insert a calendar in your sheet. A dialog asks you for the start and end dates. The corresponding calendar is then inserted from the current cell.
0946 </action>
0947 </para></listitem>
0948 </varlistentry>
0949 -->
0950
0951 <varlistentry>
0952 <term><menuchoice>
0953 <guimenu>Tools</guimenu>
0954 <guimenuitem>Execute Script File...</guimenuitem>
0955 </menuchoice></term>
0956 <listitem><para>Execute the chosen external script in &sheets;. &sheets; supports scripting in JavaScript, Python and Ruby. Default examples of the scripts can be found in the <menuchoice><guimenu>Tools</guimenu><guisubmenu>Scripts</guisubmenu></menuchoice> submenu.</para></listitem>
0957 </varlistentry>
0958
0959 <varlistentry>
0960 <term><menuchoice>
0961 <guimenu>Tools</guimenu>
0962 <guisubmenu>Scripts</guisubmenu>
0963 </menuchoice></term>
0964 <listitem><para>Here you can execute the script to export or import data in various formats, save your &sheets; log into file, use <ulink url="https://live.gnome.org/Orca">Orca speech</ulink> for accessibility, debug Python and Ruby scripts or add functions to display stock or weather condition values. You can even use some <ulink url="http://www.r-project.org/">R functions</ulink> (<ulink url="http://rpy.sourceforge.net/rpy.html">RPy module</ulink> should be installed).</para></listitem>
0965 </varlistentry>
0966
0967 <varlistentry>
0968 <term><menuchoice>
0969 <guimenu>Tools</guimenu>
0970 <guimenuitem>Script Manager...</guimenuitem>
0971 </menuchoice></term>
0972 <listitem><para><action>Opens</action> the <guilabel>Scripts Manager</guilabel> dialog to execute, load, unload, install, uninstall and get more scripts.
0973 </para></listitem>
0974 </varlistentry>
0975
0976 <varlistentry>
0977 <term><menuchoice>
0978 <guimenu>Tools</guimenu>
0979 <guimenuitem>Function Optimizer...</guimenuitem>
0980 </menuchoice></term>
0981 <listitem><para><action>Opens</action> the <guilabel>Function Optimizer</guilabel> dialog where you can choose an objective function cell, optimization target (<guilabel>Maximize</guilabel>, <guilabel>Minimize</guilabel> or enter the <guilabel>Value</guilabel>) and a set of decision parameter cells.
0982 </para></listitem>
0983 </varlistentry>
0984   </variablelist></para>
0985 </sect1>
0986
0987 <sect1 id="settingsmenu">
0988 <title>The Settings Menu</title>
0989 <para><variablelist>
0990
0991 <varlistentry>
0992 <term><menuchoice>
0993 <guimenu>Settings</guimenu>
0994 <guisubmenu>Toolbars Shown</guisubmenu>
0995 </menuchoice></term>
0996 <listitem><para><action>Show or hide the toolbars: <guilabel>File</guilabel>,
0997 <guilabel>Edit</guilabel>, <guilabel>Navigation</guilabel>, <guilabel>Font</guilabel>,
0998 <guilabel>Format</guilabel> and <guilabel>Color/Border</guilabel>.</action>
0999 </para></listitem>
1000 </varlistentry>
1001 <!--
1002 <varlistentry>
1003 <term><menuchoice>
1004 <guimenu>Settings</guimenu>
1005 <guimenuitem>Dockers</guimenuitem>
1006 </menuchoice></term>
1007 <listitem><para>FIXME
1008 </para></listitem>
1009 </varlistentry>
1010 -->
1011 <!--FIXME missing:
1012 Column Header / Row Header / Horizontal Scrollbar / Vertical Scrollbar
1013  -->
1014 <varlistentry>
1015 <term><menuchoice>
1016 <guimenu>Settings</guimenu>
1017 <guimenuitem>Status Bar</guimenuitem>
1018 </menuchoice></term>
1019 <listitem><para><action>Show or hide the Status Bar.</action>
1020 The Status Bar shows additional information for selected items and
1021 instant calculations of the selected cells.
1022 </para></listitem>
1023 </varlistentry>
1024
1025 <varlistentry>
1026 <term><menuchoice>
1027 <guimenu>Settings</guimenu>
1028 <guimenuitem>Tab Bar</guimenuitem>
1029 </menuchoice></term>
1030 <listitem><para><action>Show or hide the Tab Bar.</action>
1031 All Sheets of the current Document can be accessed through the Tab Bar.
1032 </para></listitem>
1033 </varlistentry>
1034
1035 <varlistentry>
1036 <term><menuchoice>
1037 <guimenu>Settings</guimenu>
1038 <guimenuitem>Configure Shortcuts...</guimenuitem>
1039 </menuchoice></term>
1040 <listitem><para><action>Configure the keyboard shortcuts used by &sheets;.
1041 </action> See the section on <link linkend="configshort">configuring shortcuts
1042 </link> for more details.
1043
1044 </para></listitem>
1045 </varlistentry>
1046
1047 <varlistentry>
1048 <term><menuchoice>
1049 <guimenu>Settings</guimenu>
1050 <guimenuitem>Configure Toolbars...</guimenuitem>
1051 </menuchoice></term>
1052 <listitem><para><action>Configure the toolbars.</action> The section on
1053 <link linkend="configtoolbars">configuring toolbars</link> has more
1054 information.
1055 </para></listitem>
1056 </varlistentry>
1057
1058 <varlistentry>
1059 <term><menuchoice>
1060 <guimenu>Settings</guimenu>
1061 <guimenuitem>Themes</guimenuitem>
1062 </menuchoice></term>
1063 <listitem><para><action>Choose the color theme for &sheets; window.</action> You can choose
1064 one of the predefined color schemes or select <guimenuitem>Configuration...</guimenuitem> to
1065 open <ulink url="help:/kcontrol/colors">&systemsettings; color selection module</ulink>.
1066 </para></listitem>
1067 </varlistentry>
1068
1069 <varlistentry>
1070 <term><menuchoice>
1071 <guimenu>Settings</guimenu>
1072 <guimenuitem>Active Author Profile</guimenuitem>
1073 </menuchoice></term>
1074 <listitem><para><action>Configure the author profile for the current document.</action> You can choose
1075 one of the profiles defined using <link linkend="configauthor">&sheets; configuration window</link>,
1076 <guimenuitem>Default Author Profile</guimenuitem> as defined by &systemsettings; data or
1077 blank <guimenuitem>Anonymous</guimenuitem> profile which can ensure your privacy.
1078 </para></listitem>
1079 </varlistentry>
1080
1081 <varlistentry>
1082 <term><menuchoice>
1083 <guimenu>Settings</guimenu>
1084 <guimenuitem>Configure Notifications...</guimenuitem>
1085 </menuchoice></term>
1086 <listitem><para><action>Configure &sheets; notification system.</action> There are no actions
1087 that you can be notified in the current version of &sheets;.
1088 </para></listitem>
1089 </varlistentry>
1090
1091 <varlistentry>
1092 <term><menuchoice>
1093 <guimenu>Settings</guimenu>
1094 <guimenuitem>Configure &sheets;...</guimenuitem>
1095 </menuchoice></term>
1096 <listitem><para><action>General &sheets; configuration.</action> See the
1097 section on <link linkend="configdialog">&sheets; configuration</link> for
1098 more details.
1099 </para></listitem>
1100 </varlistentry>
1101
1102 </variablelist></para>
1103 </sect1>
1104
1105 <sect1 id="helpmenu">
1106 <title>The Help Menu</title>
1107
1108 &help.menu.documentation;
1109
1110 </sect1>
1111
1112 <sect1 id="rmbmenu">
1113 <title>The Right Mouse Button Menu</title>
1114 <para>This section describes the items in the pop up menu obtained by
1115 <mousebutton>right</mousebutton> clicking on a selected cell or cells,
1116 row(s) or column(s).
1117 </para>
1118
1119 <para><variablelist>
1120 <varlistentry>
1121 <term><menuchoice>
1122 <shortcut>
1123 <keycombo action="simul">&Ctrl;&Alt;<keycap>F</keycap></keycombo>
1124 </shortcut>
1125 <guimenuitem>Cell Format...</guimenuitem>
1126 </menuchoice></term>
1127 <listitem><para><action>Format selected cell(s).</action> See the
1128 <link linkend="formatspread">Spreadsheet Formatting</link> section for more
1129 details.
1130 </para></listitem>
1131 </varlistentry>
1132
1133 <varlistentry>
1134 <term><menuchoice>
1135 <shortcut>
1136 <keycombo action="simul">&Ctrl;<keycap>X</keycap></keycombo>
1137 </shortcut>
1138 <guimenuitem>Cut</guimenuitem>
1139 </menuchoice></term>
1140 <listitem><para><action>Put selected item(s) into the clipboard.</action> If
1141 you then do a <guilabel>Paste</guilabel> the item(s) will be moved from the
1142 original location to the new one.
1143 </para></listitem>
1144 </varlistentry>
1145
1146 <varlistentry>
1147 <term><menuchoice>
1148 <shortcut>
1149 <keycombo action="simul">&Ctrl;<keycap>C</keycap></keycombo>
1150 </shortcut>
1151 <guimenuitem>Copy</guimenuitem>
1152 </menuchoice></term>
1153 <listitem><para><action>Copy selected item(s) into the clipboard.</action>
1154 </para></listitem>
1155 </varlistentry>
1156
1157 <varlistentry>
1158 <term><menuchoice>
1159 <shortcut>
1160 <keycombo action="simul">&Ctrl;<keycap>V</keycap></keycombo>
1161 </shortcut>
1162 <guimenuitem>Paste</guimenuitem>
1163 </menuchoice></term>
1164 <listitem><para><action>Paste item(s) from the clipboard to the selected cells.
1165 </action>
1166 </para></listitem>
1167 </varlistentry>
1168
1169 <varlistentry>
1170 <term><menuchoice>
1171 <guimenuitem>Special Paste...</guimenuitem>
1172 </menuchoice></term>
1173 <listitem><para><action>Special forms of Paste.
1174 </action> See the sections <link linkend="specialpaste">Other Paste
1175 Modes</link> and <link linkend="sumspecialpaste">Arithmetic using Special
1176 Paste</link> for more details.
1177 </para></listitem>
1178 </varlistentry>
1179
1180 <varlistentry>
1181 <term><menuchoice>
1182 <guimenuitem>Paste with Insertion</guimenuitem>
1183 </menuchoice></term>
1184 <listitem><para><action>Paste from the clipboard to the selected cell(s), moving the
1185 previous cell(s) to make room.</action>
1186 </para></listitem>
1187 </varlistentry>
1188
1189 <varlistentry>
1190 <term><menuchoice>
1191 <guimenuitem>All</guimenuitem>
1192 </menuchoice></term>
1193 <listitem><para><action>Delete contents of selected cell(s).</action>
1194 </para></listitem>
1195 </varlistentry>
1196
1197 <varlistentry>
1198 <term><menuchoice>
1199 <guimenuitem>Adjust Row &amp; Column</guimenuitem>
1200 </menuchoice></term>
1201 <listitem><para><action>Change size of row and column to display selected
1202 cell(s) completely.</action>
1203 </para></listitem>
1204 </varlistentry>
1205
1206 <varlistentry>
1207 <term><menuchoice>
1208 <guimenuitem>Default</guimenuitem>
1209 </menuchoice></term>
1210 <listitem><para><action>Set default formats for selected cell(s).</action>
1211 </para></listitem>
1212 </varlistentry>
1213
1214 <varlistentry>
1215 <term><menuchoice>
1216 <guimenuitem>Area Name...</guimenuitem>
1217 </menuchoice></term>
1218 <listitem><para><action>Name selected area.</action> See the section
1219 <link linkend="namedareas">Named Areas</link> for more details.
1220 </para></listitem>
1221 </varlistentry>
1222
1223 <varlistentry>
1224 <term><menuchoice>
1225 <guimenuitem>Resize Row...</guimenuitem>
1226 </menuchoice></term>
1227 <listitem><para><action>Change height of selected row.</action>
1228 </para></listitem>
1229 </varlistentry>
1230
1231 <varlistentry>
1232 <term><menuchoice>
1233 <guimenuitem>Adjust Row</guimenuitem>
1234 </menuchoice></term>
1235 <listitem><para><action>Change height of selected row to display cell(s)
1236 completely.</action>
1237 </para></listitem>
1238 </varlistentry>
1239
1240 <varlistentry>
1241 <term><menuchoice>
1242 <guimenuitem>Resize Column...</guimenuitem>
1243 </menuchoice></term>
1244 <listitem><para><action>Change width of selected column.</action>
1245 </para></listitem>
1246 </varlistentry>
1247
1248 <varlistentry>
1249 <term><menuchoice>
1250 <guimenuitem>Adjust Column</guimenuitem>
1251 </menuchoice></term>
1252 <listitem><para><action>Change width of selected column to display cell(s)
1253 completely.</action>
1254 </para></listitem>
1255 </varlistentry>
1256
1257 <varlistentry>
1258 <term><menuchoice>
1259 <guimenuitem>Insert Cells...</guimenuitem>
1260 </menuchoice></term>
1261 <listitem><para><action>Insert new cell(s) at selected location, moving
1262 existing cell(s) to make room.</action>
1263 </para></listitem>
1264 </varlistentry>
1265
1266 <varlistentry>
1267 <term><menuchoice>
1268 <guimenuitem>Delete Cells...</guimenuitem>
1269 </menuchoice></term>
1270 <listitem><para><action>Remove selected cell(s), moving other cell(s) to
1271 occupy the space left by the removed cell(s).</action>
1272 </para></listitem>
1273 </varlistentry>
1274
1275 <varlistentry>
1276 <term><menuchoice>
1277 <guimenuitem>Insert Rows</guimenuitem>
1278 </menuchoice></term>
1279 <listitem><para><action>Insert new row(s) above selected row(s).
1280 </action>
1281 </para></listitem>
1282 </varlistentry>
1283
1284 <varlistentry>
1285 <term><menuchoice>
1286 <guimenuitem>Delete Rows</guimenuitem>
1287 </menuchoice></term>
1288 <listitem><para><action>Delete selected row(s).</action>
1289 </para></listitem>
1290 </varlistentry>
1291
1292 <varlistentry>
1293 <term><menuchoice>
1294 <guimenuitem>Hide Rows</guimenuitem>
1295 </menuchoice></term>
1296 <listitem><para><action>Hides selected row(s).</action>
1297 </para></listitem>
1298 </varlistentry>
1299
1300 <varlistentry>
1301 <term><menuchoice>
1302 <guimenuitem>Show Rows</guimenuitem>
1303 </menuchoice></term>
1304 <listitem><para><action>Shows selected row(s).
1305 In order to show hidden rows you need to select a range of rows that
1306 includes the hidden rows.</action>
1307 </para></listitem>
1308 </varlistentry>
1309
1310 <varlistentry>
1311 <term><menuchoice>
1312 <guimenuitem>Insert Columns</guimenuitem>
1313 </menuchoice></term>
1314 <listitem><para><action>Insert new column(s) at left of selected column(s).
1315 </action>
1316 </para></listitem>
1317 </varlistentry>
1318
1319 <varlistentry>
1320 <term><menuchoice>
1321 <guimenuitem>Delete Columns</guimenuitem>
1322 </menuchoice></term>
1323 <listitem><para><action>Delete selected column(s).</action>
1324 </para></listitem>
1325 </varlistentry>
1326
1327 <varlistentry>
1328 <term><menuchoice>
1329 <guimenuitem>Hide Columns</guimenuitem>
1330 </menuchoice></term>
1331 <listitem><para><action>Hides selected column(s).</action>
1332 </para></listitem>
1333 </varlistentry>
1334
1335 <varlistentry>
1336 <term><menuchoice>
1337 <guimenuitem>Show Columns</guimenuitem>
1338 </menuchoice></term>
1339 <listitem><para><action>Shows selected column(s).
1340 In order to show hidden columns you need to select a range of columns that
1341 includes the hidden columns.</action>
1342 </para></listitem>
1343 </varlistentry>
1344
1345 <varlistentry>
1346 <term><menuchoice>
1347 <guimenuitem>Comment...</guimenuitem>
1348 </menuchoice></term>
1349 <listitem><para><action>Add or modify a comment to the selected cell.</action>
1350 </para></listitem>
1351 </varlistentry>
1352
1353 <varlistentry>
1354 <term><menuchoice>
1355 <guimenuitem>Selection List...</guimenuitem>
1356 </menuchoice></term>
1357 <listitem><para><action>Lets you select and paste text from any
1358 cell of the current selection of cells into the selected cell.</action>
1359 </para></listitem>
1360 </varlistentry>
1361 <!-- not in 2.4.0
1362 <varlistentry>
1363 <term><menuchoice>
1364 <guimenuitem>Show Related Words</guimenuitem>
1365 </menuchoice></term>
1366 <listitem><para><action>Opens the <guilabel>Related Words</guilabel> dialog box.</action>
1367 </para></listitem>
1368 </varlistentry>
1369 -->
1370 </variablelist></para>
1371 </sect1>
1372
1373 <sect1 id="othershort">
1374 <title>Other Shortcuts</title>
1375 <para>This section describes those &sheets; shortcut keys used for operations
1376 that do not appear in any of the menus.</para>
1377
1378 <variablelist>
1379
1380 <varlistentry>
1381 <term>
1382 <keycombo action="simul">&Ctrl;<keycap>H</keycap></keycombo>
1383 </term>
1384 <listitem><para>Toggle the display of the dockers.</para></listitem>
1385 </varlistentry>
1386
1387 <varlistentry>
1388 <term>
1389 <keycombo action="simul">&Ctrl;<keysym>Arrow keys</keysym></keycombo>
1390 </term>
1391 <listitem><para><action>If the selected cell is occupied then move the
1392 cell cursor to the start or end of the occupied block in the current row or
1393 column. If the selected cell is not occupied then move the cell cursor to
1394 the start or end of the block of unoccupied cells in the current row or column.
1395 </action>
1396 </para></listitem>
1397 </varlistentry>
1398
1399 <varlistentry>
1400 <term>
1401 <keycombo action="simul">&Ctrl;&Shift;<keysym>Arrow keys</keysym></keycombo>
1402 </term>
1403 <listitem><para><action>If the selected cell is occupied then select all
1404 occupied cells to the start or end of that block of occupied cells in the
1405 current row or column.
1406 If the selected cell is not occupied then select all unoccupied cells to the
1407 start or end of that block of unoccupied cells in the current row or column.
1408 </action>
1409 </para></listitem>
1410 </varlistentry>
1411
1412 <varlistentry>
1413 <term>
1414 <keysym>Page Down</keysym>
1415 </term>
1416 <listitem><para><action>Move the cell cursor 10 cells down.</action>
1417 </para></listitem>
1418 </varlistentry>
1419
1420 <varlistentry>
1421 <term>
1422 <keysym>Page Up</keysym>
1423 </term>
1424 <listitem><para><action>Move the cell cursor 10 cells up.</action>
1425 </para></listitem>
1426 </varlistentry>
1427
1428 <varlistentry>
1429 <term>
1430 <keycombo action="simul">&Ctrl;<keysym>Page Down</keysym></keycombo>
1431 </term>
1432 <listitem><para><action>Move to the next sheet.</action>
1433 </para></listitem>
1434 </varlistentry>
1435
1436 <varlistentry>
1437 <term>
1438 <keycombo action="simul">&Ctrl;<keysym>Page Up</keysym></keycombo>
1439 </term>
1440 <listitem><para><action>Move to the previous sheet.</action>
1441 </para></listitem>
1442 </varlistentry>
1443
1444 <varlistentry>
1445 <term>
1446 <keycap>F4</keycap>
1447 </term>
1448 <listitem><para><action>Change cell reference</action> between normal and
1449 <link linkend="absolute">absolute reference</link> types.
1450 </para></listitem>
1451 </varlistentry>
1452 <!-- does not work in 2.4.0
1453 <varlistentry>
1454 <term>
1455 <keycombo action="simul">&Ctrl;<keysym>&amp;</keysym></keycombo>
1456 </term>
1457 <listitem><para><action>Add a border to the selected cell(s).</action>
1458 </para></listitem>
1459 </varlistentry>
1460
1461 <varlistentry>
1462 <term>
1463 <keycombo action="simul">&Ctrl;<keysym>$</keysym></keycombo>
1464 </term>
1465 <listitem><para><action>Display the value of the selected cell(s) in Money
1466 format.</action>
1467 </para></listitem>
1468 </varlistentry>
1469
1470 <varlistentry>
1471 <term>
1472 <keycombo action="simul">&Ctrl;<keysym>%</keysym></keycombo>
1473 </term>
1474 <listitem><para><action>Display the value of the selected cell(s) in
1475 Percentage format.</action>
1476 </para></listitem>
1477 </varlistentry>
1478
1479 <varlistentry>
1480 <term>
1481 <keycombo action="simul">&Ctrl;<keysym>^</keysym></keycombo>
1482 </term>
1483 <listitem><para><action>Display the value of the selected cell(s) in
1484 Scientific format.</action>
1485 </para></listitem>
1486 </varlistentry>
1487
1488 <varlistentry>
1489 <term>
1490 <keycombo action="simul">&Ctrl;<keysym>#</keysym></keycombo>
1491 </term>
1492 <listitem><para><action>Display the value of the selected cell(s) in
1493 Date format</action>. The value is taken as the number of days since
1494 1 January 1900.
1495 </para></listitem>
1496 </varlistentry>
1497
1498 <varlistentry>
1499 <term>
1500 <keycombo action="simul">&Ctrl;<keysym>@</keysym></keycombo>
1501 </term>
1502 <listitem><para><action>Display the value of the selected cell(s) in
1503 Time format</action>. The value is taken as the number of seconds since
1504 midnight.
1505 </para></listitem>
1506 </varlistentry>
1507
1508 <varlistentry>
1509 <term>
1510 <keycombo action="simul">&Ctrl;<keysym>!</keysym></keycombo>
1511 </term>
1512 <listitem><para><action>Display the value of the selected cell(s) in
1513 normal Number format</action>.
1514 </para></listitem>
1515 </varlistentry>
1516 -->
1517 </variablelist>
1518
1519 </sect1>
1520
1521 </chapter>
1522
1523 <!--
1524 Local Variables:
1525 mode: sgml
1526 sgml-parent-document: ("index.docbook" "book" "chapter")
1527 sgml-minimize-attributes:nil
1528 sgml-general-insert-case:lower
1529 sgml-indent-step:0
1530 sgml-indent-data:nil
1531 End:
1532 -->