[gnumeric] Update documentation for Manage Sheets, R1C1 notation, sheet ranges. 1.12 updates, typo corrections
- From: Andreas J. Guelzow <guelzow src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [gnumeric] Update documentation for Manage Sheets, R1C1 notation, sheet ranges. 1.12 updates, typo corrections
- Date: Tue, 18 Jun 2013 05:05:49 +0000 (UTC)
commit 3a9f63b086b55770add8a1bba41ec1cf07c18e43
Author: Darrell Tangman <dgtangman acm org>
Date: Mon Jun 17 23:04:24 2013 -0600
Update documentation for Manage Sheets, R1C1 notation, sheet ranges. 1.12 updates, typo corrections,
misc. cleanup.
2013-06-17 Andreas J. Guelzow <aguelzow pyrshep ca>
for Darrell Tangman <dgtangman acm org>
* data-types.xml: Document R1C1 format cell references.
Describe sheet range references. Other minor updates.
* gui-menus.xml: Updates for 1.12. Link to Manage Sheets dialog.
* gui-toolbars.xml: Fix misdirected xref link.
* quick-start.xml: Updates for 1.12. Other minor updates.
* worksheets.xml: Document the Manage Sheets dialog.
* figures/icon-locked.png: New
* figures/icon-unlocked.png: New
* figures/icon-visible.png: New
* figures/worksheet-managing-dialog.png: New
* figures/Makefile.am: Include the above.
NEWS | 2 +
doc/C/ChangeLog | 17 +-
doc/C/data-types.xml | 66 +++-
doc/C/figures/Makefile.am | 4 +
doc/C/figures/icon-locked.png | Bin 0 -> 950 bytes
doc/C/figures/icon-unlocked.png | Bin 0 -> 860 bytes
doc/C/figures/icon-visible.png | Bin 0 -> 644 bytes
doc/C/figures/worksheet-managing-dialog.png | Bin 0 -> 46694 bytes
doc/C/gui-menus.xml | 268 +++++--------
doc/C/gui-toolbars.xml | 4 +-
doc/C/quick-start.xml | 254 +++++++------
doc/C/worksheets.xml | 551 ++++++++++++++++++---------
12 files changed, 676 insertions(+), 490 deletions(-)
---
diff --git a/NEWS b/NEWS
index 2a2e26b..3593984 100644
--- a/NEWS
+++ b/NEWS
@@ -32,6 +32,8 @@ Darrell Tangman:
* Update documentation for Edit and Insert menus. [#700596]
* Update documentation for comments and hyperlinks. [#700797]
* Consolidate comment, hyperlinks, names documentation.
+ * Update documentation for Manage Sheets, R1C1 notation,
+ sheet ranges. 1.12 updates, typo corrections, misc. cleanup.
Dmitry Smirnov:
* Fixes to the gnumeric and ssconvert manual pages.
diff --git a/doc/C/ChangeLog b/doc/C/ChangeLog
index 4518eea..121ed5c 100644
--- a/doc/C/ChangeLog
+++ b/doc/C/ChangeLog
@@ -1,3 +1,18 @@
+2013-06-17 Andreas J. Guelzow <aguelzow pyrshep ca>
+ for Darrell Tangman <dgtangman acm org>
+
+ * data-types.xml: Document R1C1 format cell references.
+ Describe sheet range references. Other minor updates.
+ * gui-menus.xml: Updates for 1.12. Link to Manage Sheets dialog.
+ * gui-toolbars.xml: Fix misdirected xref link.
+ * quick-start.xml: Updates for 1.12. Other minor updates.
+ * worksheets.xml: Document the Manage Sheets dialog.
+ * figures/icon-locked.png: New
+ * figures/icon-unlocked.png: New
+ * figures/icon-visible.png: New
+ * figures/worksheet-managing-dialog.png: New
+ * figures/Makefile.am: Include the above.
+
2013-06-14 Andreas J. Guelzow <aguelzow pyrshep ca>
* graphics-plots.xml: fix entity usage
@@ -36,7 +51,7 @@
* figures/menu-edit-modify-names.png: Update
* figures/menu-insert-comment.png: New
* figures/menu-insert-hyperlink.png: New
- * Makefile.am: Include the above.
+ * figures/Makefile.am: Include the above.
2013-05-18 Andreas J. Guelzow <aguelzow pyrshep ca>
for Darrell Tangman <dgtangman acm org>
diff --git a/doc/C/data-types.xml b/doc/C/data-types.xml
index a213d4a..4609575 100644
--- a/doc/C/data-types.xml
+++ b/doc/C/data-types.xml
@@ -451,11 +451,15 @@ FUNCTIONNAME(ARGUMENTS)
<para>
Each cell in a spreadsheet is named by its column and row
- labels. The column labels are letters and the row labels are
+ labels. By default, the column labels are letters and the row labels are
numbers. The first cell, therefore, is called A1. One column
- over and two rows down from cell A1 is the cell B3. The right
+ over and two rows down from cell A1 is the cell B3.
+ In a worksheet of the default size, the right
most and bottom most cell is cell IV65536 which is the cell in
column IV and in row 65536.
+ An alternative cell reference notation uses numbers for both row
+ and column identification.
+ See <xref linkend="sect-data-formulas-references-r1c1" /> below for details.
</para>
<para>
@@ -483,7 +487,7 @@ FUNCTIONNAME(ARGUMENTS)
referencing), or by using absolute referencing. Absolute
referencing means that when the cell is copied, the cell
reference does not change. Normally, auto-filling a cell range
- or moving cell will change its cell reference to so that it
+ or moving a cell will change its cell reference so that it
maintains a relation to the original cell. Absolute
referencing prevents these changes.
</para>
@@ -518,13 +522,12 @@ FUNCTIONNAME(ARGUMENTS)
<para>
The format for absolute cell referencing is to use a '$' in
- front of the cell coordinate that the you want to stay
- constant. The column, row, sheet, or any combination of these
- can be held constant.
+ front of the cell coordinate that you want to stay
+ constant. The column, the row, or both can be held constant.
</para>
<example id="cell-refer-absolute-reference">
- <title>Absolute cell referencing examples</title>
+ <title>Cell referencing examples</title>
<para>
What happens when a given formula is entered into cell B2,
@@ -588,6 +591,28 @@ FUNCTIONNAME(ARGUMENTS)
</example>
</sect4>
+ <sect4 id="sect-data-formulas-references-r1c1">
+ <title>References using R1C1 Notation</title>
+ <para>
+ From the <guimenuitem>Format ▶ Sheet</guimenuitem> submenu you can
+ select R1C1 notation for a worksheet.
+ This causes all cell references on the sheet to be shown as
+ “R<emphasis role="italic">r</emphasis>C<emphasis role="italic">c</emphasis>”,
+ where <emphasis role="italic">r</emphasis> is the row number and
+ <emphasis role="italic">c</emphasis> is the column number.
+ When R1C1 notation is selected, the column headers show numbers rather than letters.
+ </para>
+ <para>
+ When <emphasis role="italic">r</emphasis> and <emphasis role="italic">c</emphasis>
+ are positive integers, as in “R1C1”, the reference is absolute.
+ To produce a relative reference, enclose a number in square brackets; if the number
+ is zero, it can be omitted along with the brackets.
+ For example, “RC[-2]” refers to the cell two columns to the left
+ in the current row, while “R[1]C1” refers to the cell in the first
+ column of the next row down from the referencing cell.
+ The second example combines a relative row reference with an absolute column reference.
+ </para>
+ </sect4>
<sect4 id="sect-data-formulas-references-multi">
<title>Referencing multiple cells</title>
@@ -698,15 +723,23 @@ FUNCTIONNAME(ARGUMENTS)
It is possible to reference cells which are not part of the
current sheet. This is done using the SHEETNAME!CELLLIST
syntax, where SHEETNAME is an identifier (usually a sheet
- name) and CELLLIST is a regular cell reference as described in
+ name) and CELLLIST is a reference to a cell or range of cells as described in
the previous sections.
+ If SHEETNAME contains spaces or other special characters, you must
+ quote the whole name to allow &gnum; to recognize it as a single name.
+ See the examples below.
</para>
<para>
- Note that if SHEETNAME contains spaces, you need to quote the
- whole name to allow &gnum; to
- group the separate words in SHEETNAME as single name. For
- example, you should use 'Name With Spaces'.
+ When the reference is to a range of cells, the worksheet name only
+ needs to be given with the first cell reference. The ending cell of
+ the range is assumed to be on the same worksheet if an explicit sheet
+ name is not specified. Note, however, that “Sheet1!A1:Sheet3!C5”
+ is a legitimate cell range description. It identifies a range three columns
+ wide and five rows deep on each of the worksheets from Sheet1 through Sheet3.
+ The preferred form of such a reference is “Sheet1:Sheet3!A1:C5”,
+ which is the form &gnum; will display if you subsequently edit the contents
+ of a cell containing such a reference.
</para>
<example id="simple-sheet-ref">
@@ -714,7 +747,7 @@ FUNCTIONNAME(ARGUMENTS)
<programlisting>
='Sheet 0'!A1+'Sheet 3'!A5
-=SUM('Sheet 1'!A1:'Sheet 1'!A5)
+=SUM(Sheet1!A1:A5)
</programlisting>
</example>
@@ -726,9 +759,10 @@ FUNCTIONNAME(ARGUMENTS)
<para>
It is possible to reference cells in other files. The
canonical form for these references is
- =[filename]SHEETNAME!CELLLIST. Note that, even if the name of the file
- contains spaces, you may not surround the filename with
- quotes, since these quotes would be interpreted as part of the filename.
+ [<emphasis role="italic">filename</emphasis>]SHEETNAME!CELLLIST.
+ The square brackets serve to quote <emphasis role="italic">filename</emphasis>,
+ so you should use quotation marks only if they are actually part of the file name.
+ Note that the sheet name must be present in references of this form.
</para>
<example id="simple-file-ref">
diff --git a/doc/C/figures/Makefile.am b/doc/C/figures/Makefile.am
index 40063d4..1a137f9 100644
--- a/doc/C/figures/Makefile.am
+++ b/doc/C/figures/Makefile.am
@@ -299,6 +299,9 @@ EXTRA_DIST = \
graphs-types-stock.png \
graphs-types-surface.png \
graphs-types-xyplot.png \
+ icon-locked.png \
+ icon-unlocked.png \
+ icon-visible.png \
info-area.png \
menubar.png \
menu-context-col-row-header.png \
@@ -421,6 +424,7 @@ EXTRA_DIST = \
worksheet-data-2.png \
worksheet-data-3.png \
worksheet-data-4.png \
+ worksheet-managing-dialog.png \
worksheet-rows-1.png \
worksheet-running-calc-1.png
diff --git a/doc/C/figures/icon-locked.png b/doc/C/figures/icon-locked.png
new file mode 100644
index 0000000..c05637c
Binary files /dev/null and b/doc/C/figures/icon-locked.png differ
diff --git a/doc/C/figures/icon-unlocked.png b/doc/C/figures/icon-unlocked.png
new file mode 100644
index 0000000..c7a27d1
Binary files /dev/null and b/doc/C/figures/icon-unlocked.png differ
diff --git a/doc/C/figures/icon-visible.png b/doc/C/figures/icon-visible.png
new file mode 100644
index 0000000..211122a
Binary files /dev/null and b/doc/C/figures/icon-visible.png differ
diff --git a/doc/C/figures/worksheet-managing-dialog.png b/doc/C/figures/worksheet-managing-dialog.png
new file mode 100644
index 0000000..43c6cc2
Binary files /dev/null and b/doc/C/figures/worksheet-managing-dialog.png differ
diff --git a/doc/C/gui-menus.xml b/doc/C/gui-menus.xml
index c8d114f..32b484f 100644
--- a/doc/C/gui-menus.xml
+++ b/doc/C/gui-menus.xml
@@ -875,8 +875,6 @@
Search and replace operations.
</term>
<listitem>
- <para>These menu entries relate to search and replace operations. Each
- entry is explained in detail below. </para>
<itemizedlist>
@@ -916,25 +914,18 @@
Other operations on worksheets.
</term>
<listitem>
- <para>These menu entries do not group together logically. Each
- entry is explained in detail below. </para>
<itemizedlist>
<listitem>
<para>
- <guimenuitem>Sheet</guimenuitem> — The
- <guimenuitem>Sheet</guimenuitem> menu item opens up a
- submenu which allows users to perform operations on the
- worksheet. Note that this is the same set of choices as are
- available from the context menu which appears by clicking
- (usually with the right mouse button) on one of the
- worksheet tabs. The worksheet can be duplicated to create a
- second sheet with the same contents. A new worksheet can be
- inserted immediately following the current sheet. The
- current sheet can be renamed. The
- sheets can be re-ordered or the current sheet can be
- deleted.
- </para>
+ <guimenuitem>Sheet</guimenuitem> — From the
+ <guimenuitem>Sheet</guimenuitem> submenu you can perform operations
+ on the worksheet as a whole. These functions are also available
+ from the worksheet tab context menu. You can create, duplicate,
+ rename, re-order, or delete worksheets. These functions are
+ described in detail in
+ <xref linkend="sect-worksheets-managing-process-contextmenu" />.
+ </para>
</listitem>
<listitem>
@@ -1153,7 +1144,7 @@
<itemizedlist>
<listitem>
<para>
- If the selection is at least partially visible does
+ If the selection is at least partially visible and does
not include the cell
A1, &gnum; freezes the
portion of the worksheet above or to the left of the
@@ -1185,7 +1176,7 @@
</para>
</listitem>
</itemizedlist>
- <para>In all cases, the region of the worksheet above or to the right
+ <para>In all cases, the region of the worksheet above or to the left
of the currently visible region will become inaccessible until the
view is unfrozen.
</para>
@@ -1315,16 +1306,11 @@
<varlistentry>
<term>
<emphasis role="bold">3</emphasis>
- Zoom Menu Item
</term>
<listitem>
<para>
- <guimenuitem>Zoom...</guimenuitem> — The
- <guimenuitem>Zoom</guimenuitem> menu item opens a
- dialog which allows the user to set the magnification
- of all worksheets in the current workbook. This item
- is separated from the previous ones since it always acts
- on all views of a worksheet.
+ <guimenuitem>Zoom...</guimenuitem> opens a dialog where you can set
+ the magnification of one or more worksheets in the current workbook.
</para>
</listitem>
</varlistentry>
@@ -1812,13 +1798,17 @@
<listitem>
- <para>
- <guimenuitem>Sheet</guimenuitem> — The <guimenuitem>Sheet</guimenuitem>
- menu item opens a submenu with operations to change properties of the
- worksheet. This submenu has three sections.
+<!-- Do NOT introduce any whitespace AROUND the <anchor>. -->
+ <para><anchor id="format-menu-sheet"
+ xreflabel="Format ▶ Sheet"
+ /><guimenuitem>Sheet</guimenuitem> opens a submenu where you can change
+ properties of the current worksheet.
+ With the exception of <guimenuitem>Manage Sheets...</guimenuitem> and
+ <guimenuitem>Zoom...</guimenuitem>,
+ all operations on this submenu apply to just the current worksheet.
</para>
<figure id="menu-format-sheet.png">
- <title>The <guimenu>Sheet</guimenu> Submenu.</title>
+ <title><guimenu>Sheet</guimenu> Submenu</title>
<screenshot>
<mediaobject>
<imageobject>
@@ -1836,118 +1826,100 @@
<varlistentry>
<term>
<emphasis role="bold">1</emphasis>
- Sheet Management Items
+ Sheet Management
</term>
<listitem>
<para>
- The first section contains menu items used to modify sheets indirectly.
- Note that these items are also
- available from the context menu which appears by clicking
+ These items are also on the worksheet tab context menu, accessed
+ by clicking
(usually with the right mouse button) on one of the
worksheet tabs.
</para>
<para>
- <itemizedlist>
- <listitem>
- <para>
- <guimenuitem>Manage Sheets...</guimenuitem> —- This opens a
- dialog with the names and properties of all the sheets.
- A user can click on
- one of the names in the dialog and then click on the up and
- down arrows, as appropriate, to move the selected sheet in
- front or behind others. The tabs for the sheets will move at
- the same time. This dialog also allows the user to delete
- sheets, to rename sheets, and to change many other sheet
- properties.
- </para>
- </listitem>
- <listitem>
+ <guimenuitem>Manage Sheets...</guimenuitem> opens a dialog from
+ which the names and many properties of all the sheets can be
+ managed. Properties that can be managed from this dialog include
+ locking, worksheet visibility, column display order (left to right
+ or right to left), sheet name, sheet order, and sheet tab appearance.
+ From this dialog you can also add new worksheets and duplicate
+ or remove existing worksheets.
+ For more information, see <xref linkend="sect-worksheets-managing-process-dialog" />.
+ </para>
<para>
- <guimenuitem>Rename</guimenuitem> — After selecting this
- item the sheet name in the sheet tab is selected and can now be
- changed there.
+ <guimenuitem>Rename...</guimenuitem> opens the <guilabel>Rename
+ Sheet</guilabel> dialog. Edit the sheet name in the <guilabel>New
+ Name:</guilabel> field and press <keysym>Enter</keysym> or click
+ <guibutton>OK</guibutton> to change the worksheet name.
</para>
</listitem>
- </itemizedlist>
- </para>
- </listitem>
</varlistentry>
<varlistentry>
<term>
<emphasis role="bold">2</emphasis>
- Toggle Items
+ Sheet Display Toggles
</term>
<listitem>
- <para>The second section contains various toggle menu items
- used to switch sheet
- properties directly.
+ <para>The second section contains various toggles that control how
+ a worksheet is displayed.
+ If a toggle is enabled, a small check mark is displayed to the left
+ of the menu item.
</para>
<para>
<itemizedlist>
<listitem>
<para>
- <guimenuitem>Display Formulas</guimenuitem> — This menu item
- acts as a toggle. By default it is unset and formula results
- are displayed. If this menu item is clicked, it will display a
- little check mark on the left. The worksheet will show the
- actual formulae for all cells with formulae instead of showing
- the calculated result. This is useful for quickly assessing
- which cells contain formulae and which contain data.
- </para>
+ <guimenuitem>Display Formulas</guimenuitem> — When this property
+ is enabled, the worksheet will show the actual formulae for all cells
+ with formulae, instead of showing the calculated result.
+ You can use this property to quickly determine which cells contain data
+ and which contain formulae.
+ </para>
</listitem>
<listitem>
<para>
- <guimenuitem>Use R1C1 Notation</guimenuitem> — This
- menu item acts as a toggle. If this menu item is clicked,
- &gnum; display a check mark on the left of the menu item.
- &gnum; will also use R1C1 style notation to address cells
+ <guimenuitem>Use R1C1 Notation</guimenuitem> — When this property
+ is enabled, &gnum; uses R1C1-style notation to address cells,
rather than A1 notation.
</para>
</listitem>
<listitem>
<para>
- <guimenuitem>Hide Zeros</guimenuitem> — This menu item acts as
- a toggle. Click on this menu item will cause a check mark to
- appear on the left. The sheet will then display all the cells
- which display zeros as empty cells. This is useful in sheets
- with many zero results, to quickly find cells with data.
+ <guimenuitem>Hide Zeros</guimenuitem> — When this property
+ is enabled, &gnum; displays all cells which would display a zero
+ value as empty cells.
+ This can be used to more easily find cells with non-zero data in
+ sheets with many zero results.
</para>
</listitem>
<listitem>
<para>
- <guimenuitem>Hide Gridlines</guimenuitem> — This menu item
- acts as a toggle. If this menu item is clicked, &gnum; will
- display a check mark to the left of the menu item. The lines
- which separate all the cells will then be hidden and &gnum;
- will appear to be a blank background. This is useful to make
- certain data look pretty on screen.
+ <guimenuitem>Hide Gridlines</guimenuitem> — When this property
+ is enabled, &gnum; does not draw the grid lines that ordinarily separate
+ cells.
</para>
</listitem>
<listitem>
<para>
- <guimenuitem>Hide Column Headers</guimenuitem> — This
- menu item acts as a toggle. If this menu item is clicked,
- &gnum; display a check mark on the left of the menu item.
- &gnum; will also hide the boxes with the alphabetical names
- of the columns.
+ <guimenuitem>Hide Column Headers</guimenuitem> — When this property
+ is enabled, &gnum; does not display the column headers, which leaves room
+ in the cell grid for roughly one more row of cells of default height.
</para>
</listitem>
<listitem>
<para>
- <guimenuitem>Hide Row Header</guimenuitem> — This
- menu item acts as a toggle. If this menu item is clicked,
- &gnum; display a check mark on the left of the menu item.
- &gnum; will also hide the boxes with the numeric names
- of the rows.
+ <guimenuitem>Hide Row Header</guimenuitem> — When this property
+ is enabled, &gnum; does not display the row headers, which leaves
+ slightly more room to display the contents of cells.
</para>
</listitem>
<listitem>
<para>
- <guimenuitem>Direction</guimenuitem> — This
- menu item acts as a toggle. When selected
- &gnum; will change from left-to-right sheets to
- right-to-left sheets.
+ <guimenuitem>Direction</guimenuitem> — When this menu item
+ is selected, &gnum; switches between left-to-right sheets and
+ right-to-left sheets. If row headers are displayed, they are moved
+ to the right-hand side of the cell grid when the worksheet
+ is displayed right to left.
</para>
</listitem>
</itemizedlist>
@@ -1958,17 +1930,12 @@
<varlistentry>
<term>
<emphasis role="bold">3</emphasis>
- Zoom Menu Item
+ Zoom...
</term>
<listitem>
<para>
- <guimenuitem>Zoom...</guimenuitem> — The
- <guimenuitem>Zoom</guimenuitem> menu item opens a
- dialog which allows the user to set the magnification
- of all worksheets in the current workbook. This item is
- also included in the
- <guimenuitem>View</guimenuitem> menu discussed in
- <xref linkend="View-Menu" />,
+ <guimenuitem>Zoom...</guimenuitem> opens a dialog where you can set
+ the magnification of one or more worksheets in the current workbook.
</para>
</listitem>
</varlistentry>
@@ -2691,33 +2658,39 @@
</sect2>
-<sect2 id="menu-context-tabs">
- <title>The Context Menu for Worksheet Tabs</title>
- <para>The Context Menu for Worksheet Tabs.</para>
- <figure id="menu-context-tabs.png">
- <title>The Context Menu.</title>
- <screenshot>
- <mediaobject>
- <imageobject>
- <imagedata fileref="figures/menu-context-tabs.png" />
- </imageobject>
- <textobject>
- <phrase>An image of the context menu for worksheet tabs.</phrase>
- </textobject>
- </mediaobject>
- </screenshot>
- </figure>
- <para>The context menu for tabs provides the same functions as are provided
- in the <guimenuitem>Sheet</guimenuitem> menu item in the
- <guimenu>Edit</guimenu> menu. These options are explained at the bottom of
- <xref linkend="Edit-Menu" />. In addition, this context menu provides for two
- submenus to select any of the existing sheets, whether their tab is currently
- visible or not. The first submenu lists the sheets in their current order,
- the second submenu lists them alphabetically.
- </para>
+ <sect2 id="menu-context-tabs">
+ <title>Context Menu for Worksheet Tabs</title>
+ <para>
+ The context menu for worksheet tabs provides access to functions
+ that manipulate worksheets as a whole, rather than their contents.
+ </para>
-</sect2>
+ <figure id="menu-context-tabs.png">
+ <title>The Context Menu for Worksheet Tabs</title>
+ <screenshot>
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="figures/menu-context-sheet-tabs.png" />
+ </imageobject>
+ <textobject>
+ <phrase>An image of the context menu of the worksheet tabs.</phrase>
+ </textobject>
+ </mediaobject>
+ </screenshot>
+ </figure>
+ <para>
+ The context menu for the worksheet tabs provides the same functions as the
+ <guimenuitem>Sheet</guimenuitem> submenu of the <guimenu>Edit</guimenu>
+ menu. These functions are explained in
+ <xref linkend="sect-worksheets-managing-process-contextmenu" />.
+ There are also two submenus where you can select one of the
+ existing sheets, whether its tab is currently visible or not.
+ The first submenu lists the sheets in their current order,
+ the second submenu lists them alphabetically.
+ </para>
+
+ </sect2>
<sect2 id="menu-context-object">
@@ -2870,41 +2843,6 @@
</para>
</sect2>
-<sect2 id="menu-context-sheet-tabs">
- <title>The Context Menu for Sheet Tabs</title>
- <para>The Context Menu for Sheet Tabs</para>
- <figure id="menu-context-sheet-tabs.png">
- <title>The Context Menu for Sheet Tabs.</title>
- <screenshot>
- <mediaobject>
- <imageobject>
- <imagedata fileref="figures/menu-context-sheet-tabs.png" />
- </imageobject>
- <textobject>
- <phrase>An image of the context menu of the sheet tabs.</phrase>
- </textobject>
- </mediaobject>
- </screenshot>
- </figure>
-
- <para>
- The sheet tab context menu merely provides an extra way to access &gnum;
- commands related to sheets and to select the desired sheet.
- The <guimenuitem>Manage Sheets...</guimenuitem>, <guimenuitem>Insert</guimenuitem>,
- <guimenuitem>Append</guimenuitem>, <guimenuitem>Duplicate</guimenuitem>,
- <guimenuitem>Remove</guimenuitem>, <guimenuitem>Rename</guimenuitem>, and
- <guimenuitem>Resize...</guimenuitem>
- commands are taken from the <guimenu>Sheet</guimenu> submenu of the
- <guimenu>Edit</guimenu> menu and are explained in
- <xref linkend="Edit-Menu" />.
- The <guimenuitem>Select</guimenuitem> and <guimenuitem>Select (sorted)</guimenuitem>
- submenus provided for an easy way of selecting an existing sheet. The
- <guimenuitem>Select</guimenuitem> submenu lists the sheets in the order they appear
- in the workbook while the <guimenuitem>Select (sorted)</guimenuitem> submenu lists
- them in alphabetic order.
- </para>
-
-</sect2>
</sect1>
diff --git a/doc/C/gui-toolbars.xml b/doc/C/gui-toolbars.xml
index 5b87e99..e359635 100644
--- a/doc/C/gui-toolbars.xml
+++ b/doc/C/gui-toolbars.xml
@@ -47,9 +47,9 @@
<title>General Toolbar Behavior</title>
<para>
- The toolbar context menu described in <xref linkend="menu-context-sheet-tabs" />
+ The toolbar context menu described in <xref linkend="menu-context-toolbars" />
can be used to determine where each toolbar (above the sheets, to the left of the
- sheets, or to the right of the sheets) is being displayed. The
+ sheets, or to the right of the sheets) is displayed. The
<guimenuitem>Toolbars</guimenuitem> submenu of the <guimenu>View</guimenu>
menu (see <xref linkend="View-Menu"/>) can be used to determine which toolbars are
visible.
diff --git a/doc/C/quick-start.xml b/doc/C/quick-start.xml
index 53893c3..d03b793 100644
--- a/doc/C/quick-start.xml
+++ b/doc/C/quick-start.xml
@@ -18,15 +18,15 @@
<note>
<para>
- The terminology can be confusing. A spreadsheet file contains a
+ A spreadsheet file contains a
workbook and possibly some other information about the
- file. (Because the workbook is far more important than the extra
- information, the files themselves are often called workbooks.) A
- workbook contains one or more worksheets. Each worksheet
- contains a large number of cells usually arranged into a two
+ file. Because a spreadsheet file contains exactly one workbook,
+ the files themselves are often called workbooks. A
+ workbook contains one or more worksheets. A worksheet
+ consists of a number of cells, usually arranged in a two
dimensional grid made up of columns and rows.
We introduce the names of the parts of
- &gnum; below in
+ &gnum; in
<xref linkend="quick-parts-of-gnumeric" /> and explain the parts
further in <xref linkend="chapter-gui-elements"/>.
</para>
@@ -45,15 +45,14 @@
<title>Starting Gnumeric the First Time</title>
<para>
- &gnum; can be started in several ways
- on every computer operating system and desktop environment. Each
- of the approaches described below are equivalent; they result in a
- gnumeric window appearing on your monitor as shown in <xref
- linkend="fig-gnumeric-first-start" />
+ &gnum; can be started in several ways, depending
+ on your computer operating system and desktop environment.
+ The approaches described below are equivalent; they result in a
+ &gnum; window appearing on your monitor as shown below.
</para>
<figure id="fig-gnumeric-first-start">
- <title>The Gnumeric spreadsheet when first opened.</title>
+ <title>The Gnumeric spreadsheet when first opened</title>
<screenshot>
<mediaobject>
<imageobject>
@@ -70,21 +69,8 @@
</figure>
<note>
- <title>Starting is the hardest step</title>
<para>
- Starting &gnum; the first time is the most difficult
- step. Unfortunately, this is also the step which we cannot
- effectively explain in this manual. &gnum; can be installed
- many different ways so no generic instructions can possibly
- suffice. The pointers below will hopefully help you get past this
- first step.
- </para>
- </note>
-
- <note>
- <para>
- We assume that the &gnum; program is
- already installed program on your machine.
+ We assume that &gnum; is already installed on your machine.
Installing &gnum; depends
on the particular operating system and distribution used on your
machine and is therefore beyond the scope of this manual. If
@@ -99,8 +85,8 @@
<title>Starting Gnumeric from the GNOME desktop</title>
<para>
- If you are a GNOME user, you should have a `panel' somewhere on
- your desktop. This panel contains icons, and at least two menus.
+ If you are a GNOME user, you should have a ‘panel’ somewhere on
+ your desktop. This panel contains icons and at least two menus.
One of these menus is called <guimenu>Applications</guimenu> and
has an icon which looks like the outline of a foot. If you click
on this menu name, a menu will appear. Drag the cursor down to
@@ -120,8 +106,8 @@
If you run a UNIX-like operating system (called *NIX in this
manual) such as GNU/Linux, GNU on some other kernel, or a
commercial UNIX (TM) system, or if you use a commercially
- distributed version of GNOME, of the KDE (K Desktop
- Environment), or of a similar desktop system, you will have to
+ distributed version of GNOME, KDE (K Desktop
+ Environment), or a similar desktop system, you will have to
find a way to launch &gnum;
yourself. Hunt around the menus until you find something named
"Gnumeric", possibly with the
@@ -136,7 +122,7 @@
</para>
</textobject>
</inlinemediaobject>
- icon and then click on that menu entry.
+ icon, and then click on that menu entry.
</para>
<warning>
<para>
@@ -152,16 +138,17 @@
<para>
You can also start &gnum; from the
command line in an <application>xterm</application> window or
- equivalent terminal emulator. Open a terminal, and, at the shell
+ equivalent terminal emulator. Open a terminal. At the shell
prompt type:
<screen>
-gnumeric &
- </screen>
- which will start the program and send it into the background.
+gnumeric &</screen>
+ This will start the program and send it into the background, which
+ means that you can run other commands in the terminal window or
+ close it while &gnum; runs in its own window.
</para>
<warning>
<para>
- You must be running the X window system to run
+ On UNIX-like operating systems, you must be running the X window system to run
&gnum;.
</para>
</warning>
@@ -188,13 +175,11 @@ gnumeric &
which will be called <filename>gnumeric.exe</filename>. You
can either move to that directory and type:
<screen>
-gnumeric
- </screen>
+gnumeric</screen>
or you can type the whole name of the path and file, which
will be something like:
<screen>
-c:\Program Files\Gnome-Office\gnumeric
- </screen>
+c:\Program Files\Gnome-Office\gnumeric</screen>
either of which should start the program.
</para>
</sect3>
@@ -259,7 +244,7 @@ c:\Program Files\Gnome-Office\gnumeric
<para>
The part names are listed below along with a reference to
the section that discusses that element. If you are reading this document
- on a computers, you may be able to click on the references to jump to
+ on a computer, you may be able to click on a reference to jump to
that section of the manual.
</para>
@@ -302,7 +287,7 @@ c:\Program Files\Gnome-Office\gnumeric
<para>
The format toolbar changes the display properties of data in
the workbook. We present it in <xref linkend="fmt-toolbar"
- />, part of the general discussion of toolbars of <xref
+ />, part of the general discussion of toolbars in <xref
linkend="sect-gui-toolbars" />.
</para>
</listitem>
@@ -438,7 +423,7 @@ c:\Program Files\Gnome-Office\gnumeric
keys which you can use to trigger that command. For instance,
to save the file which you are currently using, you can
jointly type the control key and the s key
- (i.e. <keycombo><keysym>Ctrl</keysym><keysym>S</keysym></keycombo>).
+ (i.e. <keycombo><keycap>Ctrl</keycap><keycap>S</keycap></keycombo>).
For further information, see <xref linkend="keybinding"/>.
</para>
</sect2>
@@ -476,7 +461,7 @@ c:\Program Files\Gnome-Office\gnumeric
representation, which is what is actually shown. Understanding
this distinction is complicated and make take some time if you are new
to spreadsheets.
- time. This distinction between value and representation is one of the
+ This distinction between value and representation is one of the
reasons spreadsheets are so useful.
</para>
@@ -535,8 +520,8 @@ c:\Program Files\Gnome-Office\gnumeric
you may occasionally need to actively select these
parameters of the cells, which we explain in <xref
linkend="quick-format" /> below. The next two sections explain
- how to get data into a cell, first by moving the selection box
- to a desired cell and then by typing the data.
+ how to get data into a cell, by first moving the selection box
+ to a desired cell and then typing the data.
</para>
<sect3 id="quick-data-input-moveselection">
@@ -564,10 +549,12 @@ c:\Program Files\Gnome-Office\gnumeric
<tip>
<para>
- The selection box also causes the header of the column and
- row to change slightly. The headers will turn a darker shade
- of gray and the font of the letters and numbers turn
- bold. This helps indicate what is currently being selected.
+ The location of the selection box also causes the column and
+ row headers to change slightly.
+ The letters and numbers turn bold, and colors of the headers
+ (the text color and the header background color) change in ways
+ that depend on the version of &gnum;.
+ This helps indicate what is currently selected.
</para>
</tip>
@@ -590,32 +577,35 @@ c:\Program Files\Gnome-Office\gnumeric
<title>Data input</title>
<para>
- In order to enter data into a selected cell, you can simply
+ To enter data into a selected cell, you can simply
start typing. The characters will then become part of the
- spreadsheet when you change the selection either by typing the
+ spreadsheet when you change the selection either by pressing the
<keycap>Enter</keycap> key, which moves the selection down one
- cell, by typing the <keycap>Tab</keycap> key, which moves the
+ cell, by pressing the <keycap>Tab</keycap> key, which moves the
selection one cell to the right, or by selecting any other
cell with the mouse.
+ If the cursor is in the cell and not in the data entry area,
+ pressing any of the cursor movement keys also causes &gnum; to
+ record the data in the cell and select another cell.
</para>
<para>
For example, you could use the mouse to select the cell four
columns over (Column D) and three rows down (Row 3). Then you
- could type "Hello, this is a line of text." and then type
+ could type "Hello, this is a line of text." and then press
the <keycap>Enter</keycap> key. The text would then appear in
cell "D3" and, if the cells to the right are empty, would span
into those cells so that the whole entry is visible. The
- selection box moves when you type the <keycap>Enter</keycap>
- and will therefore appear afterwards in cell "D4", ready
+ selection box moves to cell “D4” when you press
+ <keycap>Enter</keycap>, ready
for the input of more data.
</para>
<note>
<para>
Note that as the data text is entered it appears in both the
- cell and in the data entry area (the area below the toolbars
- to the right of the equals (=) sign).
+ cell and the data entry area (the area below the toolbars
+ and to the right of the equals (=) sign).
</para>
</note>
@@ -623,18 +613,17 @@ c:\Program Files\Gnome-Office\gnumeric
You can correct mistakes you make during data entry by
using the <keycap>Backspace</keycap> key or the
<keycap>Delete</keycap> key. Finer control can be obtained if
- the cursor is moved to the text entry area by clicking in the
- box to the right of the equals (=) sign with the
- mouse. Editing in the text entry area enables the arrow keys
- to navigate backwards and forwards within the text being
- entered and also enables the mouse to be used to move the
- cursor.
+ the cursor is moved to the data entry area by clicking
+ with the mouse in the box to the right of the equals (=) sign.
+ Editing in the data entry area lets you use the arrow keys
+ to move backward and forward in the text.
+ You can also use the mouse to move the cursor.
</para>
<para>
- You can simply change the contents of a cell by selecting the
+ To change the contents of a cell, select the
cell again and either type the new contents or edit the
- existing contents of the cells.
+ existing contents of the cell in the data entry area.
</para>
<note>
@@ -685,8 +674,8 @@ c:\Program Files\Gnome-Office\gnumeric
<title>Entering text</title>
<para>
- To enter text, you simply select the appropriate cell,
- type the text and then the <keycap>Enter</keycap> key. If the
+ To enter text, select the appropriate cell,
+ type the text, and then press the <keycap>Enter</keycap> key. If the
text is too large to fit in its own cell, and the cell to its
right is empty, the text will span into the cell on the
right. By default, &gnum; uses a
@@ -705,8 +694,8 @@ c:\Program Files\Gnome-Office\gnumeric
<title>Entering numbers</title>
<para>
- To enter numbers, select the appropriate cell,
- type in a number and then the <keycap>Enter</keycap>
+ To enter a number, select the appropriate cell,
+ type in the number and then press the <keycap>Enter</keycap>
key. &gnum; recognizes several
types of information to be numbers.
</para>
@@ -721,12 +710,12 @@ c:\Program Files\Gnome-Office\gnumeric
default (comma as thousand separator, period as decimal
symbol) but will adopt the symbols appropriate for a different
locality if &gnum; is launched in
- a particular way. For instance, in a French setting the period
+ a particular way (see <xref linkend="sect-configuration-localization" />).
+ For instance, in a French setting the period
is the thousand separator symbol and the comma the decimal
separator symbol.
-<!-- TODO: add xref to localization -->
- By default, &gnum; will display
- these numeric values lined up against the right side of the
+ By default, &gnum; displays
+ numeric values lined up against the right side of the
cell.
</para>
@@ -739,8 +728,9 @@ c:\Program Files\Gnome-Office\gnumeric
<itemizedlist mark='circle'>
<listitem>
<para>
- Dates in the standard format of the locale are recognized
- as numbers. By default, when you 11/21/1970 it will be
+ Dates in the standard format of the locale (see
+ <xref linkend="sect-configuration-localization" />) are recognized
+ as numbers. By default, 11/21/1970 will be
recognized as the twenty-first of November of the year
nineteen seventy. &gnum;
stores the value as the number of days since the first day
@@ -763,8 +753,12 @@ c:\Program Files\Gnome-Office\gnumeric
</listitem>
<listitem>
<para>
- Fractions can be input and are recognized as values.
-<!-- TODO: add example of a fraction. -->
+ Fractions and mixed numbers are recognized as numbers.
+ For example, “1 1/2” is equivalent to 1.5.
+ Note that a simple fraction, such as “3/12”,
+ may be interpreted by &gnum; as a date. You can prevent
+ that by including a sign (for example, “+3/12”)
+ or by entering the fraction as a formula (“=3/12”).
</para>
</listitem>
<listitem>
@@ -786,8 +780,8 @@ c:\Program Files\Gnome-Office\gnumeric
<sect3 id="quick-data-input-boolean">
<title>Entering a Boolean</title>
<para>
- To enter a boolean values, select the appropriate
- cell, type in either "TRUE" or "FALSE" and then the
+ To enter a boolean value, select the appropriate
+ cell, type in either "TRUE" or "FALSE" and then press the
<keycap>Enter</keycap> key.
</para>
</sect3>
@@ -796,8 +790,8 @@ c:\Program Files\Gnome-Office\gnumeric
<title>Entering a formula</title>
<para>
- To enter a formula, select a cell and type in the
- equals sign (=) and then a valid formula. If
+ To enter a formula, select a cell and type the
+ equals sign (=) followed by a valid formula. If
&gnum; cannot understand the
formula which is entered, it will open a dialog box which may
have an explanation and gives you a chance either to
@@ -821,10 +815,9 @@ c:\Program Files\Gnome-Office\gnumeric
</para>
<para>
- A valid formula can be a simple arithmetic equation such as
+ A valid formula can be a simple arithmetic expression such as
<screen>
-=3+4-1
- </screen>
+=3+4-1</screen>
which uses a formula to make the cell equal to the value
6.
</para>
@@ -839,22 +832,22 @@ c:\Program Files\Gnome-Office\gnumeric
</para>
<para>
- Certain functions return not just a single value but an array of
- values. To enter those functions one need to first select a range
- of cells and then type the key combination
+ Certain functions return not just a single value but an array of
+ values. To enter such a function, first select a range of cells
+ to receive the result, then enter the formula to generate the
+ array, and then press the key combination
<keycombo>
<keycap>Ctrl</keycap>
<keycap>Shift</keycap>
<keycap>Enter</keycap>
</keycombo>
- rather than just the <keycap>Enter</keycap> key by itself. More
- detail on this can be found in <xref
- linkend="sect-data-formulas-array" />.
+ rather than just the <keycap>Enter</keycap> key. For more
+ details see <xref linkend="sect-data-formulas-array" />.
</para>
<para>
As was shown in the example above, formulas may contain
- `references' to the contents of another cell. In the example
+ references to the contents of another cell. In the example
given above, the contents of the cell in the second column and
the second row was used in a calculation by using the cell
name "B2". These references mean that complex calculations can
@@ -870,7 +863,7 @@ c:\Program Files\Gnome-Office\gnumeric
name of the sheet, followed by an exclamation point, followed
by the letter(s) of the column name, followed by the number of the
row. For example, a complete reference could be
- "[my_file.gnumeric]"Sheet3"!C3". These complete references can
+ "[my_file.gnumeric]Sheet3!C3". These complete references can
be shortened if the filename or sheet names are the same as
that of the reference. "AE34" would refer to the cell in the
current file, in the current worksheet which is in column "AE"
@@ -878,9 +871,9 @@ c:\Program Files\Gnome-Office\gnumeric
</para>
<para>
- References can refer to a range of contiguous range of
+ References can identify a contiguous range of
cells. For instance, the reference "A1:E5" refers to all the
- cells from the top-left most cell of the current sheet to the
+ cells from the top left corner of the current sheet to the
cell five rows down and five rows over. This can be useful in
a formula which uses a function such as MAX(). The formula
"=MAX(A1:E5)" would display the value of the largest number
@@ -895,7 +888,7 @@ c:\Program Files\Gnome-Office\gnumeric
<para>
- For a more discussion of the use of formulas see <xref
+ For more on the use of formulas see <xref
linkend="sect-data-formulas" /> later in this manual. For a
list of the functions available, see the function reference
appendix, <xref linkend="function-reference" />, or click on
@@ -1013,9 +1006,9 @@ c:\Program Files\Gnome-Office\gnumeric
<para>
For example, if you enter "12/25/2000" (without the quotes),
&gnum; guesses that this is a date
- and stores the value (serial number) 36885. (Usuallyy, the value
+ and stores the value (serial number) 36885. (Usually, the value
&gnum; uses for dates is the number
- of days since the January 1st, 1900.)
+ of days since January 1st, 1900.)
<footnote>
<para>
For the sake of compatibility with <application>Excel</application>,
@@ -1064,13 +1057,14 @@ c:\Program Files\Gnome-Office\gnumeric
<para>
If you need to alter the data type of a whole column prior
to data entry, you can do this in one formatting
- operation. First you select the whole column by clicking
- on the column header (the letters at the top). Next, you can format
- the selected cells at once by clicking the right
- mouse button to obtain the context menu or by selecting the
+ operation.
+ You can click the right mouse button on the column header
+ (the letters at the top) and select <guilabel>Format 1 Column</guilabel>
+ from the context menu, or you can first select the whole column
+ by clicking on the column header, then selecting the
<guimenu>Format</guimenu> menu and the
<guimenuitem>Cells...</guimenuitem> menu entry. This quick
- approach to pre-formatting cells can also be done for any
+ approach to pre-formatting cells can be done for any
group of selected cells.
</para>
</tip>
@@ -1105,9 +1099,27 @@ c:\Program Files\Gnome-Office\gnumeric
The most common way to select an arbitrary shaped or
discontinuous group of cells is to hold down the
<keycap>Ctrl</keycap> key while using the mouse to select
- cells. As long as you hold the <keycap>Ctrl</keycap> key down,
+ cells.
+ If the cell containing the mouse cursor when you click
+ is not part of the selection, it is added, as are any other cells
+ enclosed in the selection box when the mouse button is released.
+ If the cell initially containing the mouse cursor is already
+ selected, the click or click-and-drag action instead removes
+ all the enclosed cells from the selection.
+ As long as you hold the <keycap>Ctrl</keycap> key down,
all of the cells included by a click or a click and drag motion
- will be added to the selection.
+ will be added to or removed from the selection.
+ </para>
+
+ <para>
+ For example, to perform an operation on all the cells in a
+ square area except those on its diagonal, begin by clicking
+ and dragging to select the square area. Next press and hold
+ the <keycap>Ctrl</keycap> key and click on each of the cells
+ on the diagonal, removing them from the selection. You could
+ now use <guimenuitem>Format ▶
+ Cells ▶ Format...</guimenuitem> to apply a format
+ change to all but the diagonal elements of the square area.
</para>
<note>
@@ -1164,8 +1176,8 @@ c:\Program Files\Gnome-Office\gnumeric
either using the <guimenu>Edit</guimenu> menu, the toolbar
buttons (a pair of scissors or two pieces of paper, respectively),
the right mouse button context menu or keyboard shortcuts
- (<keycombo><keysym>Ctrl</keysym><keysym>X</keysym></keycombo> or
- <keycombo><keysym>Ctrl</keysym><keysym>C</keysym></keycombo>
+ (<keycombo><keycap>Ctrl</keycap><keycap>X</keycap></keycombo> or
+ <keycombo><keycap>Ctrl</keycap><keycap>C</keycap></keycombo>
respectively). If cells are "cut" the contents will be removed
from the current location. If cells are "copied", the contents
will be duplicated in the new location. These two operations
@@ -1190,7 +1202,7 @@ c:\Program Files\Gnome-Office\gnumeric
<guimenuitem>Paste</guimenuitem> menu entry, the toolbar button
with a clipboard, the context menu
<guimenuitem>Paste</guimenuitem> menu entry or the
- <keycombo><keysym>Ctrl</keysym><keysym>V</keysym></keycombo>
+ <keycombo><keycap>Ctrl</keycap><keycap>V</keycap></keycombo>
keyboard shortcut.
</para>
@@ -1201,7 +1213,7 @@ c:\Program Files\Gnome-Office\gnumeric
the thick white selection border. If you click and hold the left hand
button, you can drag the selected cells to a new
location resulting in the same operation as a "cut" and a
- "paste". If you hold down the <keysym>Ctrl</keysym> key during
+ "paste". If you hold down the <keycap>Ctrl</keycap> key during
the click and drag of the mouse, the result is the same as a
"copy" and "paste" operation and can be repeated several times.
</para>
@@ -1210,7 +1222,7 @@ c:\Program Files\Gnome-Office\gnumeric
Both the <guimenu>Edit</guimenu> menu and the context menu have
an extra menu entry called <guimenuitem>Paste
Special...</guimenuitem> which can be used during a cut and
- paste operation to selectively transfer some of the original the
+ paste operation to selectively transfer some of the original
cell contents or to alter the contents in specific ways. This
option allows the transfer of only the cell contents, only the
cell formats or only the calculated values of the cells. The
@@ -1287,9 +1299,9 @@ c:\Program Files\Gnome-Office\gnumeric
</para>
<para>
- The names of sheets can be changed. You can do this by editing
- the tab directly. Clicking twice on a tab will highlight the text
- and then standard editing operations will alter the text contents.
+ To change the name of a worksheet, right-click on its tab to
+ access the Worksheets context menu and select <guimenuitem>Rename</guimenuitem>.
+ Edit the New Name field and click on OK to set the new worksheet name.
</para>
<para>
@@ -1302,22 +1314,18 @@ c:\Program Files\Gnome-Office\gnumeric
<para>
Instead of an empty sheet, you can add a copy of the current worksheet
to the workbook after the current sheet by selecting the
- <guimenuitem>Duplicate this Sheet</guimenuitem> menu entry from
+ <guimenuitem>Duplicate</guimenuitem> menu entry from
the context menu.
</para>
<para>
- You can remove the current sheet using the <guimenuitem>Remove
- this Sheet</guimenuitem> menu entry from the context
+ You can remove the current sheet using the <guimenuitem>Remove</guimenuitem>
+ menu entry from the context
menu.
</para>
<para>
- You can re-order worksheets by clicking and holding the left
- mouse button on a tab, then dragging that tab to the left or to
- the right. Little arrows will appear showing the location where
- the sheet will be placed. Releasing the mouse button will then
- move the sheet to this new position.
+ You can re-order worksheets from the <guilabel>Manage Sheets</guilabel> dialog.
</para>
<para>
@@ -1788,7 +1796,7 @@ c:\Program Files\Gnome-Office\gnumeric
</inlinemediaobject>
in the tool bar. Finally saving with a keyboard shortcut simply
requires typing
- <keycombo><keysym>Ctrl</keysym><keysym>S</keysym></keycombo>.
+ <keycombo><keycap>Ctrl</keycap><keycap>S</keycap></keycombo>.
</para>
@@ -1854,7 +1862,7 @@ c:\Program Files\Gnome-Office\gnumeric
<phrase>An image of the "Open File" button.</phrase>
</textobject>
</inlinemediaobject>,
- can be used or the <keysym>F3</keysym> key clicked. All three of
+ can be used or the <keycap>F3</keycap> key clicked. All three of
these open the <interface>Open File</interface> dialog. You can
then select the spreadsheet file you wish to open.
&gnum; can open many different types
diff --git a/doc/C/worksheets.xml b/doc/C/worksheets.xml
index 319fee0..8d34c0d 100644
--- a/doc/C/worksheets.xml
+++ b/doc/C/worksheets.xml
@@ -1,13 +1,13 @@
<sect1 id="sect-worksheets-overview">
- <title>Overview</title>
+ <title>Worksheet Overview</title>
<para>
Worksheets contain the elements, such as the cell grid area, which
provide the principal work entities for &gnum; users. The
worksheet grid area allows users to enter data, develop analyses
of these data, and display both data and results. Worksheets also
- contain graphical elements such as graphs and widgets. The
- worksheets are themselves grouped into a workbook which will be
+ contain graphical elements such as graphs and widgets.
+ Worksheets are grouped into a workbook which is
stored in a &gnum; file. The manipulation of workbooks is
explained in <xref linkend="sect-workbooks"/> while the material
below explains the manipulation of worksheets.
@@ -119,13 +119,13 @@
A worksheet is created with the number of rows and columns specified
by the preference setting that can be adjusted on the <guilabel>Windows
</guilabel> tab of the Preference Dialog (see <xref
- linkend="sect-configuration-preferences-windows"/>);
+ linkend="sect-configuration-preferences-windows"/>).
</para>
<note>
<para>
- The maximum number of supported rows in a sheet is 16,777,216 and the
- maximum number of supported columns is 16384. The numbers of rows and
- columns of a sheet must always be powers of 2.
+ The maximum number of rows in a sheet is 16,777,216 and the
+ maximum number of columns is 16384. The dimensions of a sheet
+ can only be set to powers of 2.
</para>
</note>
<para>
@@ -139,118 +139,64 @@
<sect2 id="sect-worksheets-display-appearance">
- <title>Appearance</title>
+ <title>Worksheet Appearance</title>
<para>
-
+ A number of aspects of how a worksheet is displayed in the cell grid
+ can be modified. To adjust the display of formulas or results, A1 or R1C1
+ notation for cell references, how cells with a value of zero are displayed,
+ the presence or absence of grid lines or row or column headers, or whether
+ columns are ordered left to right or right to left, see the description
+ of the <xref linkend="format-menu-sheet" /> submenu.
</para>
- <sect3 id="sect-worksheets-display-appearance-cell">
- <title>The cell content appearance</title>
-
- <para>
- This section has not yet been written.
- </para>
-
- <sect4 id="sect-worksheets-display-appearance-cell-formulas">
- <title>Displaying Formulas or Results</title>
+ </sect2>
- <para>
- This section has not yet been written.
- </para>
- </sect4>
+ <sect2 id="sect-worksheets-display-appearance-book">
+ <title>Workbook Appearance</title>
- <sect4 id="sect-worksheets-display-appearance-zeros">
- <title>Displaying Zeros or Blank cells</title>
+ <para>
+ This section has not yet been written.
+ </para>
- <para>
- This section has not yet been written.
- </para>
- </sect4>
+ <sect3 id="sect-worksheets-display-appearance-book-zoom">
+ <title>Zoom: Changing the Scale of a Sheet</title>
+ <para>
+ This section has not yet been written.
+ </para>
</sect3>
-
- <sect3 id="sect-worksheets-display-appearance-grid">
- <title>The grid area appearance</title>
+ <sect3 id="sect-worksheets-display-appearance-book-full">
+ <title>Full Screen Mode</title>
<para>
This section has not yet been written.
</para>
- <sect4 id="sect-worksheets-display-appearance-grid-lines">
- <title>Displaying Gridlines</title>
-
- <para>
- This section has not yet been written.
- </para>
-
- </sect4>
-
- <sect4 id="sect-worksheets-display-appearance-grid-headers">
- <title>Displaying Row and Column Headers</title>
-
- <para>
- This section has not yet been written.
- </para>
-
- </sect4>
-
</sect3>
-
-
- <sect3 id="sect-worksheets-display-appearance-book">
- <title>The workbook appearance</title>
+ <sect3 id="sect-worksheets-display-appearance-tabs">
+ <title>Displaying Workbook Tabs</title>
<para>
This section has not yet been written.
</para>
+ </sect3>
- <sect4 id="sect-worksheets-display-appearance-book-zoom">
- <title>Zoom: Changing the Scale of a View</title>
-
- <para>
- This section has not yet been written.
- </para>
- </sect4>
-
-
- <sect4 id="sect-worksheets-display-appearance-book-full">
- <title>Full Screen Mode</title>
-
- <para>
- This section has not yet been written.
- </para>
-
- </sect4>
-
- <sect4 id="sect-worksheets-display-appearance-tabs">
- <title>Displaying Workbook Tabs</title>
-
- <para>
- This section has not yet been written.
- </para>
-
- </sect4>
-
- <sect4 id="sect-worksheets-display-appearance-scroolbars">
- <title>Displaying Grid Area Scrollbars</title>
-
- <para>
- This section has not yet been written.
- </para>
+ <sect3 id="sect-worksheets-display-appearance-scroolbars">
+ <title>Displaying Grid Area Scrollbars</title>
- </sect4>
+ <para>
+ This section has not yet been written.
+ </para>
</sect3>
-
-
</sect2>
@@ -337,146 +283,385 @@
<title>Managing Worksheets</title>
<para>
-
+ This section discusses functions that manipulate worksheets as a whole,
+ rather than their contents.
</para>
- <para>
- This section has not yet been written.
- </para>
- <sect2 id="sect-worksheets-managing-process">
- <title>Alternative Approaches</title>
+ <sect2 id="sect-worksheets-managing-process-menu">
+ <title>Worksheets and the Menubar</title>
<para>
- This section has not yet been written.
+ &gnum; provides a number of options for manipulating worksheets as a whole,
+ rather than the contents of the worksheets. These operations are documented
+ in the later section <xref linkend="sect-worksheets-managing-process-contextmenu" />.
+ In addition to the worksheet tab context menu and the <guimenuitem>Sheet</guimenuitem>
+ submenu of the <guimenu>Edit</guimenu> menu, some of these operations are also
+ available from other menus:
</para>
-
-
- <sect3 id="sect-worksheets-managing-process-menu">
- <title>Using the menu</title>
-
- <para>
- This section has not yet been written.
- </para>
-
- </sect3>
-
-
-
-
- <sect3 id="sect-worksheets-managing-process-mouse">
- <title>Using the mouse</title>
-
- <para>
- This section has not yet been written.
- </para>
-
- </sect3>
-
-
-
-
- <sect3 id="sect-worksheets-managing-process-contextmenu">
- <title>Using the context menu</title>
-
- <para>
- This section has not yet been written.
- </para>
-
- </sect3>
-
-
-
-
- <sect3 id="sect-worksheets-managing-process-dialog">
- <title>Using the sheet management dialog</title>
-
- <para>
- This section has not yet been written.
- </para>
-
- </sect3>
-
-
- </sect2>
-
-
-
-
-
-
-
- <sect2 id="sect-worksheets-managing-adding">
- <title>Adding a Blank Worksheet</title>
+ <itemizedlist>
+ <listitem>
+ <para>
+ The <guilabel>Insert</guilabel> function is also available as
+ <guimenuitem>Sheet</guimenuitem> on the <guimenu>Insert</guimenu> menu.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ The <guilabel>Rename</guilabel> and <guilabel>Manage Sheets</guilabel>
+ dialogs are also available on the
+ <guimenuitem>Format ▶ Sheet</guimenuitem> submenu.
+ </para>
+ </listitem>
+ </itemizedlist>
<para>
- This section has not yet been written.
+ In addition to worksheet manipulation, &gnum; provides the ability to
+ control various aspects of how or whether a worksheet is displayed in
+ the cell grid. Several such controls are included in the
+ <xref linkend="sect-worksheets-managing-process-dialog" />, described
+ in a later section. Other worksheet display controls are located in
+ the <xref linkend="format-menu-sheet" /> submenu, which are described there.
</para>
</sect2>
-
- <sect2 id="sect-worksheets-managing-duplicating">
- <title>Duplicating a Worksheet</title>
+ <sect2 id="sect-worksheets-managing-process-contextmenu">
+ <title>Worksheet Tab Context Menu</title>
<para>
- This section has not yet been written.
+ Except for the addition of the two <guimenuitem>Select</guimenuitem>
+ submenus, which appear only on the context menu, this is the same as
+ the <guimenuitem>Edit ▶ Sheet</guimenuitem> submenu.
+ The <guimenuitem>Manage sheets...</guimenuitem> dialog is discussed in
+ <xref linkend="sect-worksheets-managing-process-dialog" />, which
+ follows the description of the context menu.
</para>
- </sect2>
-
-
-
- <sect2 id="sect-worksheets-managing-copyPaste">
- <title>Copying or Pasting a Worksheet</title>
+ <figure id="menu-context-sheet-tabs.png">
+ <title>The Context Menu for Worksheet Tabs</title>
+ <screenshot>
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="figures/menu-context-sheet-tabs.png" />
+ </imageobject>
+ <textobject>
+ <phrase>An image of the context menu of the worksheet tabs.</phrase>
+ </textobject>
+ </mediaobject>
+ </screenshot>
+ </figure>
<para>
- This section has not yet been written.
+ <itemizedlist>
+ <listitem>
+ <para>
+ <guimenuitem>Insert</guimenuitem> — Select this menu
+ item to insert a new, empty worksheet ahead of the current worksheet.
+ The new worksheet is the same size as the current one.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <guimenuitem>Append</guimenuitem> — Select this menu
+ item to add a new, empty worksheet at the end of the existing
+ worksheets.
+ The new worksheet has the default size, which can be set in the
+ <guilabel>Gnumeric Preferences</guilabel> dialog in the
+ “Windows” tab.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <guimenuitem>Duplicate</guimenuitem> — Select this menu
+ item to add a copy of the selected worksheet immediately after the
+ selected worksheet.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <guimenuitem>Remove</guimenuitem> — Select this menu
+ item to delete the selected worksheet.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <guimenuitem>Rename</guimenuitem> — Select this menu
+ item to access the <guilabel>Rename Sheet</guilabel> dialog,
+ which lets you change the name of a single worksheet. To
+ rename more than one worksheet, the
+ <guilabel>Manage Sheets</guilabel> dialog may be more convenient.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <guimenuitem>Resize...</guimenuitem> — Select this menu
+ item to access the <guilabel>Resize Sheet</guilabel> dialog.
+ Use the sliders to adjust the size of the sheet, then click
+ <guilabel>OK</guilabel>.
+ Worksheet dimensions are restricted to powers of two.
+ By default the
+ <guilabel>Resize Sheet</guilabel> dialog changes the sizes of
+ all worksheets in the current workbook. To change the size
+ of a single worksheet, clear the check mark next to <guilabel>Apply
+ change to all sheets</guilabel> before clicking <guilabel>OK</guilabel>.
+ </para>
+ </listitem>
+ <listitem>
+ <para>
+ <guimenuitem>Select</guimenuitem> and
+ <guimenuitem>Select (sorted)</guimenuitem> — Select one of these
+ menu items to access a menu of worksheet names. Click on one of the
+ names to select that worksheet. The displayed tabs are adjusted
+ so that the selected worksheet's tab is visible, and the selected
+ worksheet is displayed in the cell grid.
+ </para>
+ </listitem>
+ </itemizedlist>
</para>
</sect2>
-
- <sect2 id="sect-worksheets-managing-renaming">
- <title>Renaming a Worksheet</title>
+ <sect2 id="sect-worksheets-managing-process-dialog">
+ <title>Manage Sheets dialog</title>
<para>
- This section has not yet been written.
+ The <guilabel>Manage Sheets</guilabel> dialog can be accessed
+ from the worksheet tab context menu, from the
+ <guimenuitem>Edit ▶ Sheet</guimenuitem> submenu, or
+ from the <guimenuitem>Format ▶ Sheet</guimenuitem> submenu.
</para>
- </sect2>
-
-
- <sect2 id="sect-worksheets-managing-reorder">
- <title>Reordering Worksheets in a Workbook</title>
+ <figure id="worksheet-managing-dialog.png">
+ <title><guimenu>Manage Sheets</guimenu> dialog</title>
+ <screenshot>
+ <mediaobject>
+ <imageobject>
+ <imagedata fileref="figures/worksheet-managing-dialog.png" />
+ </imageobject>
+ <textobject>
+ <phrase>An image of the Tools menu.</phrase>
+ </textobject>
+ </mediaobject>
+ </screenshot>
+ </figure>
<para>
- This section has not yet been written.
+ The worksheets contained in the current workbook are listed in the
+ upper left portion of the dialog. When <guilabel>Show advanced sheet
+ properties</guilabel> is enabled, the <guilabel>Dir</guilabel>,
+ <guilabel>Rows</guilabel>, and <guilabel>Cols</guilabel> fields are included.
+ A worksheet can be selected by clicking anywhere in in its line, although
+ clicking one of the icons will toggle its associated property along with
+ selecting the worksheet.
+ Multiple selection, using the <keysym>Shift</keysym> and <keysym>Ctrl</keysym>
+ keys, can be used to operate on more than one worksheet at a time.
+ The current worksheet shown in the cell grid tracks the selected worksheet
+ in this dialog.
+ That is, selecting a single worksheet from the list also causes that
+ worksheet to be displayed in the cell grid.
+ When more than one worksheet is selected in the list, the first one in
+ the list is set as the current worksheet in the cell grid.
+ Some operations are not available when more than one worksheet is
+ selected.
+ The buttons for those operations are dimmed when they are unavailable.
+ </para>
+ <para>
+ The <guilabel>Lock</guilabel> column of the list shows an icon to indicate whether
+ the worksheet is locked,
+ <inlinemediaobject>
+ <imageobject>
+ <imagedata fileref="figures/icon-locked.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <para>Locked icon</para>
+ </textobject>
+ </inlinemediaobject>
+ , or unlocked,
+ <inlinemediaobject>
+ <imageobject>
+ <imagedata fileref="figures/icon-unlocked.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <para>Unlocked icon</para>
+ </textobject>
+ </inlinemediaobject>
+ . Click on the displayed icon to toggle the sheet's lock status.
+ Locking a worksheet prevents accidental modification of the data on
+ that worksheet.
+ </para>
+ <para>
+ The <guilabel>Viz</guilabel> column of the list shows an icon,
+ <inlinemediaobject>
+ <imageobject>
+ <imagedata fileref="figures/icon-visible.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <para>Visible icon</para>
+ </textobject>
+ </inlinemediaobject>
+ , if the worksheet is currently visible. The <guilabel>Viz</guilabel> column
+ is blank if the worksheet is not visible.
+ Click in this column to toggle the worksheet's visibility.
+ When the visibility attribute is turned off, the worksheet does not get a
+ tab at the bottom of the &gnum; window.
+ Its data is preserved, and references to cells on the non-visible
+ sheet continue to access the expected values.
+ Note that a non-visible worksheet cannot be selected from the list, although
+ the active fields in the list continue to function.
+ To apply functions that require selecting the worksheet, such as
+ <guilabel>Insert</guilabel> or <guilabel>Remove</guilabel>, first click in
+ the <guilabel>Viz</guilabel> column to make it visible.
+ </para>
+ <para>
+ The <guilabel>Dir</guilabel> column of the list shows a right-pointing or
+ left-pointing arrow, depending on whether the sheet is currently set to
+ be displayed left-to-right or right-to-left.
+ Click on the arrow to toggle a worksheet's display direction.
+ </para>
+ <para>
+ The <guilabel>Rows</guilabel> and <guilabel>Cols</guilabel> columns show
+ the current size of each worksheet.
+ Worksheet size cannot be adjusted here.
+ </para>
+ <para>
+ To change the name of a worksheet, click in its <guilabel>New Name</guilabel>
+ field until the contents of the field, if any, are highlighted, then type the
+ desired new name and press <keysym>Enter</keysym>. If the new name duplicates
+ a name already in use, a warning is displayed. You can change the new name
+ or you can assign a new name to the other worksheet with that name.
+ Name changes are not applied immediately. Instead, &gnum; waits until you
+ click on the <guilabel>Apply Name Changes</guilabel> button and makes all
+ the name changes at once. When you apply the name changes, &gnum; automatically
+ updates all cell references that include worksheet names to use the new names.
+ </para>
+ <para>
+ The worksheets can be re-ordered in the workbook by pressing the left mouse
+ button in a worksheet's line and dragging it up or down in the list of
+ worksheets.
+ You can also select a single worksheet and then click on the <guilabel>Up</guilabel>
+ or <guilabel>Down</guilabel> button to move it up or down in the list.
+ Alternatively, you can sort the worksheets into ascending or descending
+ order by name by clicking on the <guilabel>Ascending</guilabel> or
+ <guilabel>Descending</guilabel> button.
+ </para>
+ <para>
+ You can add an empty worksheet by clicking on <guilabel>Insert</guilabel>, to
+ add the worksheet ahead of the selected worksheet, or on <guilabel>Append</guilabel>,
+ to add the worksheet after the last sheet in the list.
+ <guilabel>Insert</guilabel> creates a new worksheet the same size as the
+ currently selected worksheet, while <guilabel>Append</guilabel> creates a
+ new worksheet of the default size.
+ </para>
+ <para>
+ Click on <guilabel>Remove</guilabel> to delete the currently selected worksheet
+ or worksheets.
+ </para>
+ <para>
+ Click on <guilabel>Duplicate</guilabel> to add an exact copy of the selected
+ worksheet to the list immediately following the selected sheet.
+ The name of the new worksheet is the same as the name of the duplicated
+ worksheet, but with “(<emphasis role="italic">n</emphasis>)”
+ appended, where <emphasis role="italic">n</emphasis> is the smallest
+ integer greater than 1 that produces a unique worksheet name.
+ If the worksheet name already ends in
+ “(<emphasis role="italic">n</emphasis>)”, nothing is
+ appended. Instead, the value of <emphasis role="italic">n</emphasis>
+ is increased to the smallest value that produces a unique worksheet name.
+ </para>
+ <para>
+ To change the background color of the tabs for the selected worksheets,
+ click on the background color fill button,
+ <inlinemediaobject>
+ <imageobject>
+ <imagedata fileref="figures/button-fill.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <para>Background color button</para>
+ </textobject>
+ </inlinemediaobject>
+ to set the background color to the color shown below the bucket icon, or
+ click on the downward-pointing arrow to access the color selection dialog.
+ </para>
+ <para>
+ Similarly, to change the color of the text in the tabs of the selected worksheets,
+ click on the text color button,
+ <inlinemediaobject>
+ <imageobject>
+ <imagedata fileref="figures/button-text-colour.png" format="PNG"/>
+ </imageobject>
+ <textobject>
+ <para>Text color button</para>
+ </textobject>
+ </inlinemediaobject>
+ to set the text color to the color shown below the character icon, or
+ click on the downward-pointing arrow to access the color selection dialog.
</para>
</sect2>
- <sect2 id="sect-worksheets-managing-tabAppearance">
- <title>Changing the appearance of Worksheet Tabs</title>
+ <sect2 id="sect-worksheets-managing-adding">
+ <title>Adding a Blank Worksheet</title>
<para>
- This section has not yet been written.
+ A new, empty worksheet can be added to a workbook by insertion ahead of the
+ worksheet currently displayed in the cell grid or by appending one after
+ the last worksheet.
+ </para>
+ <para>
+ A new worksheet can be inserted ahead of the current worksheet by selecting
+ <guimenuitem>Sheet</guimenuitem> from the <guimenuitem>Insert</guimenuitem>
+ menu or <guimenuitem>Insert</guimenuitem> from the worksheet tab context menu
+ or by using the <guilabel>Insert</guilabel>
+ function of the <guilabel>Manage Sheets</guilabel> dialog described above.
+ The new worksheet will be the same size as the one currently displayed.
+ </para>
+ <para>
+ A new worksheet can be added to the end of the list by selecting
+ <guimenuitem>Append</guimenuitem> from the worksheet tab context menu or
+ by using the <guilabel>Append</guilabel>
+ function of the <guilabel>Manage Sheets</guilabel> dialog described above.
+ The new worksheet will be the default size.
</para>
</sect2>
- <sect2 id="sect-worksheets-managing-removing">
- <title>Deleting Worksheets</title>
+ <sect2 id="sect-worksheets-managing-copyPaste">
+ <title>Copying or Pasting a Worksheet</title>
<para>
- This section has not yet been written.
+ &gnum; does not directly support copying and pasting of worksheets,
+ however copying blocks of cells provides a very similar function. For example,
+ to replace the contents of worksheet Sheet3 with the contents of Sheet1,
+ begin by selecting the worksheet tab for Sheet1. Select all the cells
+ in Sheet1 by clicking on the blank rectangle at the top of the row headers,
+ to the left of the column headers, or by selecting <guimenuitem>Select ▶ All</guimenuitem>
+ from the <guilabel>Edit</guilabel> menu. Next use <guimenuitem>Edit ▶ Copy</guimenuitem>
+ or <guimenuitem>Edit ▶ Cut</guimenuitem> to copy the worksheet contents
+ to the clipboard, depending on whether you want to copy or move the information.
+ Select the worksheet tab for Sheet3 and select cell A1 or the entire worksheet,
+ then use <guimenuitem>Paste</guimenuitem> or <guimenuitem>Paste Special</guimenuitem>
+ from the <guilabel>Edit</guilabel> menu to copy the contents of Sheet1 into Sheet3.
+ </para>
+ <warning><para>
+ Use of <guilabel>Paste Link</guilabel> in the <guilabel>Paste Special</guilabel>
+ dialog should be avoided when operating on whole worksheets, as it creates links
+ to every selected cell in the first worksheet, 16,777,216 cells in a worksheet of
+ the default size, and has no option to skip empty cells in the first worksheet.
+ </para></warning>
+ <para>
+ A similar operation can be performed using the <guilabel>Manage Sheets</guilabel> dialog.
+ Duplicate the worksheet to be copied, then move the copy to precede or follow
+ the worksheet it is to replace. Delete the second worksheet and rename the copy.
+ This operation is similar to the copy and paste technique described above,
+ but this method also copies metadata, such as the display appearance controlled
+ by the <guimenuitem>Format ▶ Sheet</guimenuitem> submenu.
</para>
-
</sect2>
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
