[PDF] boris vian mouvement
[PDF] boris vian titres
[PDF] boris vian livre
[PDF] boris vian chansons
[PDF] boris vian chanteur
[PDF] boris vian le déserteur
[PDF] boris vian ecume des jours analyse
[PDF] boris vian l'arrache coeur pdf
[PDF] l'écume des jours résumé court
[PDF] l'écume des jours boris vian livre
[PDF] l écume des jours boris vian wiki
[PDF] boris vian biographie
[PDF] complainte du progrès boris vian
[PDF] boris vian l inventaire
[PDF] marcel mouloudji le déserteur
Getting Started with Calc:
The spreadsheet component of OpenOffice.org
Title: Getting Started with Calc: The spreadsheet component of
OpenOffice.org
Version: 1.0
First edition: January 2005
First English
edition: January 2005
Contents
Copyright and trademark information
Feedback
Acknowledgments
Modifications and updates
What is Calc?
Workbooks, worksheets and cells
Parts of the main Calc window
Title bar and Menu bar
Toolbars
Formula bar
Individual cells
Sheet tabs
Starting new workbooks
Opening existing workbooks
Saving workbooks
Navigating within worksheets
Going to a particular cell
Moving from cell to cell
Moving from sheet to sheet
Navigation shortcuts
Selecting items in a worksheet
To select a cell
To select a range of cells by dragging the mouse
To select a range of cells without dragging the mouse
To select cells which are not contiguous
To select an entire column, row or sheet
To select more than one worksheet
Inserting and deleting columns and rows
To insert a single column or row
Getting Started with Calci
To delete a column or row........................................................................................................13
To insert multiple columns or rows
To delete multiple columns or rows
Inserting and deleting worksheets
To insert new worksheets
To delete worksheets
Renaming worksheets
Worksheet views
Using the zoom function
Freezing rows and columns
Splitting the window
Entering data into a worksheet
Standard entry techniques
More entry techniques
Getting Started with Calcii
Overview
Overview
This chapter introduces Calc, the spreadsheet component of OpenOffice.org 1.x.
Copyright and trademark information
The contents of this Documentation are subject to the Public Documentation License, Version 1.0 (the "License"); you may only use this Documentation if you comply with the terms of this License. A copy of the License is available at: The Original Documentation is Calc: the spreadsheet component. The Initial Writers of the Original Documentation are Dave Le Huray and Jim Taylor © 2003. All Rights Reserved. (Initial Writer contacts: jttac@shaw.ca and dave@lehuray.org.uk. Contact the Initial Writers only to report errors in the documentation. For questions regarding how to use the software, subscribe to the Users Mail List and post your question there: http://support.openoffice.org/index.html All trademarks within this guide belong to legitimate owners.
Feedback
Please direct any comments or suggestions about this document to: authors@user-faq.openoffice.org.
Acknowledgments
Ken Jones reformatted and revised the original document. Peter Kupfer added some new material.
Modifications and updates
Version Date Description of Change
1.0 16 Jan 2005 First published edition
Getting Started with Calciii
What is Calc?
What is Calc?
Calc is the spreadsheet component of OpenOffice.org (OOo). You can enter data, usually numerical data, in a spreadsheet and then manipulate this data to produce certain results. Alternatively you can enter data and then use Calc in a 'What If...' manner by changing some of the data and observing the results without having to retype the entire workbook or sheet. A major advantage of electronic spreadsheets is that the data is easier to alter. If the correct functions and formulas have been used, the program will apply these changes automatically.
Workbooks, worksheets and cells
Calc works with elements called workbooks. Workbooks consist of a number of individual worksheets, each containing a block of cells arranged in rows and columns. These cells hold the individual elements; text, numbers, formulas etc., which make up the data to be displayed and manipulated. Each workbook can have many worksheets and each worksheet can have many individual cells. In version 1.x of OOo, each worksheet can have a maximum of 32,000 rows (1 through
32000) and a maximum of 245 columns (A through IV). This gives 7,840,000 individual
cells per worksheet.
Getting Started with Calc1
Parts of the main Calc window
Parts of the main Calc window
When Calc is started, the main window will look similar to Figure 1.
Figure 1. Parts of the Calc window
Title bar and Menu bar
The Title bar, at the top, shows the name of the current workbook and the version of OOo in use. If the workbook is new, then its name is Untitled X, with X being a number. When you save a new workbook for the first time, you will be prompted to enter a name. Under the Title bar is the Menu bar. When you choose one of the menus, a submenu appears with other options. The Menu bar can be modified, as discussed in the chapter titled "Menus and Toolbars" in the Common Features Guide.
Toolbars
Under the Menu bar by default are three toolbars: the Object bar, the Function bar, and the Formula bar. The Main toolbar runs vertically down the left hand side of the screen.
Getting Started with Calc2
Parts of the main Calc window
The icons on these toolbars provide a wide range of common commands and functions. The toolbars can be modified, as discussed in the chapter titled "Menus and Toolbars" in the
Common Features Guide.
Placing the mouse pointer over any of the icons displays a small yellow box, called a tool tip It gives a brief explanation of the button's function. Turning on Extended Tips under the Help menu, Help > Extended Tips, will provide a more detailed explanation of the buttons.
Some icons (buttons) have little green arrows
attached to them, as in Figure 2. These arrows indicate that there are further commands or functions associated with this button. For some of these, the initial behavior of these icons depends on whether or not a default has been set for that button. Where there is no default, clicking the button will cause a small window to open from which a function can be selected. The Draw
Functions window in Figure 2 is an example of
this. Other icons act a bit differently. For example, the first button in Figure 2, Insert, opens a dialog box from which you can select a graphic to be inserted. If you long-click (click and hold) on this button, a second menu pops up, like the draw functions in Figure 2, from which you can choose to insert a graphic or a special character. The next button, Insert Cells, inserts cells. Before clicking it, highlight the location where the cells are to be inserted. A popup menu opens with options about how the surrounding cells should be shifted. The next, Insert Object, inserts a chart. Any data that is highlighted when the Insert Object button is clicked becomes the data that makes up the chart. If this button is held down, a popup menu opens, with the following options: Insert Formula, Insert Floating Frame, Insert
OLE Object, and Insert Applet.
The behavior of the Draw Functions button is shown in the illustration. From the popup menu any of the drawing tools can be selected. If a draw function is chosen, such as square, the popup menu disappears and that function becomes the default. However, if you click the popup menu's title bar and move the menu, it will not disappear, but rather stay visible. For some of the buttons, such as Draw Functions and Show Form Functions, after you have selected one of the functions, that will be the default until you select a different function. For others, the Insert Cells button for example, you can change the default function (the one you get by just clicking on the button) by double-clicking on the button and holding the last click. A window opens, where you can select a behavior. This behavior is set only after you actually apply the function to something in the chart. In the Object bar and the Function bar there are rectangular areas on the left of these bars. They are the Load URL, Font Name, and Font Size menus. (See Figure 3.) If there is something already in the box, it tells what the current setting for the selected area is.
Getting Started with Calc3
Figure 2. Icons with little green arrows
Parts of the main Calc window
Click the little button with an inverted triangle
to the right of the box to open a menu.
From the Load URL menu you can open a
new document. From the Font Name and
Font Size menus, you can change the font and
its size in selected cells.
Formula bar
On the left of the Formula bar (see Figure 4) is a small text box, called the Sheet Area box, with a letter and number combination in it, such as D7. This is the column letter and row number, called the cell reference, of the current cell.
Figure 4. Formula Bar
To the right of the Sheet Area box are the the Function AutoPilot, the Sum button, and the
Equals button.
Clicking the Function AutoPilot button opens a dialog box from which you can search through a list of available functions. This can be very useful, because it also shows how the functions are formatted. The Sum button inserts a formula into the current cell that totals the numbers in the cells above, or to the left if there are no numbers above, the current cell. The Equals button inserts an equals sign into the selected cell and the Input Line, thereby setting the cell ready to accept a formula. When you enter new data into a cell that already contains something, the Sum and Equals buttons change to Cancel and Accept buttons The contents of the current cell (data, formula, or function) are displayed in the Input Line, the remainder of the Formula bar. You can edit the cell contents of the current cell here, or you can do that in the current cell. To edit inside the Input Line area, left-click the appropriate part of the Input Line area, then type your changes. To edit within the current cell, just double-click the current cell.
Getting Started with Calc4
Figure 3. Load URL, Font Name, and Font Size
Load URL
Font
NameFont
Size
Function
AutoPilot
Sum button
Equals button
Cell Reference
Parts of the main Calc window
Individual cells
The main section of the screen displays the individual cells in the form of a grid, with eachquotesdbs_dbs2.pdfusesText_2
Chapter 1 Introducing Calc - OpenOffice