<HTML
><HEAD
><TITLE
>Worksheet overview.</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.54"><LINK
REL="HOME"
TITLE="Gnumeric's user manual"
HREF="gnumeric.html"><LINK
REL="PREVIOUS"
TITLE="Date and Time formatting"
HREF="x683.html"><LINK
REL="NEXT"
TITLE="Working with files."
HREF="files.html"></HEAD
><BODY
CLASS="CHAPTER"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Gnumeric's user manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="x683.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="files.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="CHAPTER"
><H1
><A
NAME="WORKSHEET"
>Chapter 4. Worksheet overview.</A
></H1
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="AEN695"
>The Worksheet</A
></H1
><P
>After opening up gnumeric, you're presented with a view of a
    worksheet. This is where the majority of the work on the
    spreadsheet is done, and provides access to all the various sub
    dialogs of Gnumeric.</P
><P
>The worksheet view is split into several main areas. The menu
    bar, the button bar, the entry area, the main cell area, and the
    info area. See <A
HREF="worksheet.html#WORKSHEET-ALL-1.JPG"
>Figure 4-1</A
> </P
><DIV
CLASS="FIGURE"
><A
NAME="WORKSHEET-ALL-1.JPG"
></A
><P
><B
>Figure 4-1. A example of the entire worksheet.</B
></P
><P
><IMG
SRC="images/worksheet-all-1.jpg"></P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="MENU-BAR"
>The Menu bar</A
></H2
><P
>The default location of the menu bar is the top of the application window.
      It provides a quick and organized access to some of the more common
      operations available.</P
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN707"
><SPAN
CLASS="GUIMENU"
><SPAN
CLASS="ACCEL"
>F</SPAN
>ile</SPAN
></A
></H3
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>N</SPAN
>ew</SPAN
></DT
><DD
><P
>Create a new worksheet. This opens a new
	  worksheet in a window.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>O</SPAN
>pen</SPAN
></DT
><DD
><P
>Open an existing worksheet. A new window is
	  created with the file selected in it.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>S</SPAN
>ave</SPAN
></DT
><DD
><P
>Save the current worksheet. If the file has been named and saved before, this
	      will silently save the file to the current filename. If it has not been saved before, this 
	      will prompt for a filename and path.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
>S<SPAN
CLASS="ACCEL"
>a</SPAN
>ve
	  as..</SPAN
></DT
><DD
><P
>Save a file with a new name. Save a newly created file or save
	      a file with a different name. </P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>P</SPAN
>lugins</SPAN
></DT
><DD
><P
>Open the plugins dialog. For loading, saving of plugins. This 
	      shows the listing of pre loaded plugins and allows the user the user to add more.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>C</SPAN
>lose</SPAN
></DT
><DD
><P
>Close the current worksheet.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>Q</SPAN
>uit</SPAN
></DT
><DD
><P
>Close the open worksheets and quit Gnumeric</P
></DD
></DL
></DIV
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN754"
><SPAN
CLASS="GUIMENU"
><SPAN
CLASS="ACCEL"
>E</SPAN
>dit</SPAN
></A
></H3
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>C</SPAN
>ut</SPAN
></DT
><DD
><P
>Remove the content in the currently selected cells and save it.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
>C<SPAN
CLASS="ACCEL"
>o</SPAN
>py</SPAN
></DT
><DD
><P
>Make a copy of the current selection to be pasted later.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>P</SPAN
>aste</SPAN
></DT
><DD
><P
>Paste whatever is in the cut buffer at the cursor.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
>P<SPAN
CLASS="ACCEL"
>a</SPAN
>ste Special</SPAN
></DT
><DD
><P
>Paste from the cut buffer, but with more options as to what to paste.
	      Useful for pasting just format, or just values, etc.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>S</SPAN
>elect All</SPAN
></DT
><DD
><P
>Select every cell in the worksheet.</P
></DD
><DT
><SPAN
CLASS="GUISUBMENU"
>Clear -&#62;</SPAN
></DT
><DD
><P
>	      <P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>A</SPAN
>ll</SPAN
></DT
><DD
><P
>Clear every cell.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>F</SPAN
>ormats</SPAN
></DT
><DD
><P
>Clear the format from selected cells.</P
></DD
></DL
></DIV
>
	    </P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>G</SPAN
>oto Cell</SPAN
></DT
><DD
><P
>Let the user specify a cell to "jump" to.</P
></DD
></DL
></DIV
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN813"
><SPAN
CLASS="GUIMENU"
><SPAN
CLASS="ACCEL"
>V</SPAN
>iew</SPAN
></A
></H3
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>Z</SPAN
>oom</SPAN
></DT
><DD
><P
>Zoom in. To show a area of the spreadsheet in more detail.</P
></DD
></DL
></DIV
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN824"
><SPAN
CLASS="GUIMENU"
><SPAN
CLASS="ACCEL"
>I</SPAN
>nsert</SPAN
></A
></H3
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>C</SPAN
>ells</SPAN
></DT
><DD
><P
>Insert a new cell.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>R</SPAN
>ows</SPAN
></DT
><DD
><P
>Insert a Row of cells.</P
></DD
><DT
><SPAN
CLASS="GUIMENUITEM"
>C<SPAN
CLASS="ACCEL"
>o</SPAN
>lumns</SPAN
></DT
><DD
><P
>Insert a Column of cells.</P
></DD
></DL
></DIV
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN847"
><SPAN
CLASS="GUIMENU"
>F<SPAN
CLASS="ACCEL"
>o</SPAN
>rmat</SPAN
></A
></H3
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><SPAN
CLASS="GUIMENUITEM"
><SPAN
CLASS="ACCEL"
>C</SPAN
>ells</SPAN
></DT
><DD
><P
>Open the cell format dialog. Used to change formatting, color, etc</P
></DD
></DL
></DIV
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN858"
><SPAN
CLASS="GUIMENU"
><SPAN
CLASS="ACCEL"
>H</SPAN
>elp</SPAN
></A
></H3
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><SPAN
CLASS="GUIMENUITEM"
>Cells</SPAN
></DT
><DD
><P
>View the online help for Gnumeric</P
></DD
></DL
></DIV
></DIV
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="BUTTONBAR-BUTTONS"
>The Button Bar</A
></H2
><P
>The Button bar contains many icons representative of some the more common
      operations a user may need to use. It is intended to provide fast access to these
      tools.</P
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/stock_new.gif">
	    New File.
	  </SPAN
></DT
><DD
><P
>Create a New file</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/stock_open.gif">
	    Open
	  </SPAN
></DT
><DD
><P
>Open an existing file.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/stock_save.gif">
	    Save
	  </SPAN
></DT
><DD
><P
>Save the current worksheet to disk.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/stock_cut.gif">
	    Cut
	  </SPAN
></DT
><DD
><P
>Copy the cells in the current selection to the cut buffer and delete them.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/stock_copy.gif">
	    Copy
	  </SPAN
></DT
><DD
><P
>Copy the cells in the current selection to the cut buffer.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/stock_paste.gif">
	    Paste
	  </SPAN
></DT
><DD
><P
>Paste the contents of the cut buffer into the active cell.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/align-left.gif">
	    Left justify..
	  </SPAN
></DT
><DD
><P
>Justify the contents of the cell to the left of the cell.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/align-center.gif">
	    Center
	  </SPAN
></DT
><DD
><P
>Center the content of the cells.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/align-right.gif">
	    Right Justify
	  </SPAN
></DT
><DD
><P
>Justify the content of the cells to the right side of the cells</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/bold.gif">
	    Bold
	  </SPAN
></DT
><DD
><P
>Change the style of the current cell to be bold, or un bold it if it is already bold.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/italic.gif">
	    Italic
	  </SPAN
></DT
><DD
><P
>Change the style of the current cell to be italicized  .</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/line.gif">
	    Line
	  </SPAN
></DT
><DD
><P
>Draw a line on the worksheet.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/arrow.gif">
	    Arrow
	  </SPAN
></DT
><DD
><P
>Draw a line with a arrow at one end. A pointer.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/rect.gif">
	    Box
	  </SPAN
></DT
><DD
><P
>Draw a box onto the worksheet.</P
></DD
><DT
><SPAN
CLASS="GUIICON"
><IMG
SRC="images/oval.gif">
	    Ellipse
	  </SPAN
></DT
><DD
><P
>Draw an ellipse or a circle on the worksheet.</P
></DD
></DL
></DIV
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="WORKSHEET-DATA-ENTRY"
>Data entry area.</A
></H2
><P
>Immediately under the button bar is the data entry
      area. This is a small area, which contains a current cell
      indicator, a <SPAN
CLASS="GUIBUTTON"
>confirm</SPAN
> and a
      <SPAN
CLASS="GUIBUTTON"
>cancel</SPAN
> button, and an entry area for
      detailed editing of the cell contents.  See <A
HREF="worksheet.html#WORKSHEET-DATA-1"
>Figure 4-2</A
></P
><DIV
CLASS="FIGURE"
><A
NAME="WORKSHEET-DATA-1"
></A
><P
><B
>Figure 4-2. The Data Entry area.</B
></P
><P
><IMG
SRC="images/worksheet-data-1.jpg"></P
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN972"
>Current Cell Indicator.</A
></H3
><P
>On the far left of the Data Entry area is the current cell indicator
	area.  If a single cell is selected, it will show the address for the cell.
	If a region is selected, it shows the size of the region in the format:</P
><BLOCKQUOTE
CLASS="BLOCKQUOTE"
><P
>4Lx5C</P
></BLOCKQUOTE
><P
>Where L is the number of rows and C is the number of columns. In the example
	above, this would be a selection of 4 rows by 5 columns.</P
><DIV
CLASS="FIGURE"
><A
NAME="WORKSHEET-DATA-2"
></A
><P
><B
>Figure 4-3. The Current Cell Indicator.</B
></P
><P
><IMG
SRC="images/worksheet-data-2.jpg"></P
></DIV
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN982"
><SPAN
CLASS="GUIBUTTON"
>The Confirm Button</SPAN
></A
></H3
><P
>While entering data in the entry area, you can confirm the
	current cell contents by pressing the green return button
	<SPAN
CLASS="GUIBUTTON"
>	  <IMG
SRC="images/worksheet-data-3.jpg">
	</SPAN
>.
      </P
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN988"
><SPAN
CLASS="GUIBUTTON"
>The Cancel Button</SPAN
></A
></H3
><P
>If a user decides that the data entered into a cell is
	not what they want, the Cancel button will cancel the current
	data and return the cell to the state it was at before. The
	data being entered into the cell can be canceled by pressing
	the red X button
	<SPAN
CLASS="GUIBUTTON"
>	  <IMG
SRC="images/worksheet-data-4.jpg">
	</SPAN
>.
      </P
><P
>The most common use of this is when overwriting the contents
	of a cell with new data. If the user decided to revert the change
	before confirming it, the cancel button is the answer.</P
></DIV
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN995"
>The Cell area</A
></H2
><P
>Most of the work done on a spreadsheet is done to the main Cell area, the large
      grid like part of the worksheet. This is where all the formulas and data are entered,
      and is the center of activity for the spreadsheet.</P
><P
>The sheet is bordered by a column label and a row label. Columns are labeled
      alphabetically and are labeled horizontally across the top of the sheet. See <A
HREF="worksheet.html#WORKSHEET-COLS-1"
>Figure 4-4</A
>. Rows are
	labeled vertically along size the left side of the sheet and are sorted numerically.
	See <A
HREF="worksheet.html#WORKSHEET-ROWS-1"
>Figure 4-5</A
></P
><DIV
CLASS="FIGURE"
><A
NAME="WORKSHEET-COLS-1"
></A
><P
><B
>Figure 4-4. The column labels at the top of the worksheet.</B
></P
><P
><IMG
SRC="images/worksheet-cols-1.jpg"></P
></DIV
><DIV
CLASS="FIGURE"
><A
NAME="WORKSHEET-ROWS-1"
></A
><P
><B
>Figure 4-5. The row labels at the left side of the worksheet.</B
></P
><P
><IMG
SRC="images/worksheet-rows-1.jpg"></P
></DIV
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN1009"
>The Info Area</A
></H2
><P
>The section at the very bottom of the worksheet view is the info area. It contains
      information about the currently selected cells, and also provides access to buttons
      for zooming in and out. This is also where the sheet indicator lives.</P
><DIV
CLASS="FIGURE"
><A
NAME="WORKSHEET-INFO-1"
></A
><P
><B
>Figure 4-6. The info area.</B
></P
><P
><IMG
SRC="images/worksheet-info-1.jpg"></P
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN1016"
>Sheet indicator</A
></H3
><P
>To the left side is the sheet indicator. In workbooks where there are more
	than one sheet, this indicates how many sheets are there, and also allows the user to 
	move to another sheet by clicking the proper tag. This is not implemented yet. </P
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN1019"
>The Zoom buttons</A
></H3
><P
>The <SPAN
CLASS="GUIBUTTON"
>Zoom in</SPAN
> (<A
HREF="worksheet.html#WORKSHEET-ZOOMIN-1"
>Figure 4-7</A
>) and
	  <SPAN
CLASS="GUIBUTTON"
>Zoom out</SPAN
> (<A
HREF="worksheet.html#WORKSHEET-ZOOMOUT-1"
>Figure 4-8</A
>) buttons are also in the info area.
	    Pressing <SPAN
CLASS="GUIBUTTON"
>Zoom in</SPAN
> enlarges the spreadsheet and shows a more detailed 
	    view of the sheet. <SPAN
CLASS="GUIBUTTON"
>Zoom out</SPAN
> shows a wider area of the spreadsheet
	    with less detail. The view of the sheet can also be changed by using the <SPAN
CLASS="GUIMENU"
>View</SPAN
>
	    menu and the <SPAN
CLASS="GUIMENUITEM"
>Zoom</SPAN
> option. </P
><DIV
CLASS="FIGURE"
><A
NAME="WORKSHEET-ZOOMIN-1"
></A
><P
><B
>Figure 4-7. The Zoom in button.</B
></P
><P
><IMG
SRC="images/worksheet-zoomin-1.jpg"></P
></DIV
><DIV
CLASS="FIGURE"
><A
NAME="WORKSHEET-ZOOMOUT-1"
></A
><P
><B
>Figure 4-8. The Zoom out button</B
></P
><P
><IMG
SRC="images/worksheet-zoomout-1.jpg"></P
></DIV
></DIV
><DIV
CLASS="SECT3"
><H3
CLASS="SECT3"
><A
NAME="AEN1038"
>The running calculation area</A
></H3
><P
>In the bottom right hand corner, is an info area that shows some constantly calculated
	values. The default set is to show the Sum of all the currently selected cells.</P
><P
>There is a right click option that includes a few more options.  This can include
	Sum, Min, Max, Average, Count.</P
><DIV
CLASS="FIGURE"
><A
NAME="WORKSHEET-RUNNING-CALC-1"
></A
><P
><B
>Figure 4-9. The running calculation area.</B
></P
><P
><IMG
SRC="images/worksheet-running-calc-1.jpg"></P
></DIV
></DIV
></DIV
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="x683.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="gnumeric.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="files.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Date and Time formatting</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
>&nbsp;</TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Working with files.</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>