OpenOffice.org 2.x Guía de usuario descargar pdf (Pagina 255)

Chapter 4: Spreadsheets in Calc

When there is insufficient space to display the sheet tabs on the lower window border,

increase it by moving the separator bar between the tab bar and the horizontal scrolling bar

with the mouse button. Keep the mouse button pressed and drag to the right. Remember this

shares the available space between the sheet tabs and horizontal scroll bar.

Working With Multiple Sheets

Each sheet of a spreadsheet is completely independent of the other sheets in a spreadsheet

document. However the same data can be incorporated into several sheets. For example, the

same data should be inserted at the same location in the first three sheets. To do so, select all

three sheets together and enter the data in only one of the sheets.

Selecting several sheets together, is simply a matter of clicking the sheet tabs of the sheets in

question while pressing the Ctrl key. All selected sheets will now have white sheet tabs,

instead of the gray sheet tabs of the unselected sheets. To undo the selection of a sheet, click

its sheet tab again whilst pressing the Ctrl key. Clicking the sheet tab of the current sheet

while pressing the Shift key, ensures that only this one is selected.

Calc includes the name of the sheet in the reference when assigning sheet references. Thus,

instead of referring to $A$1, Calc refers to $Sheet 1.$A$1 which makes multi-sheet

referencing easy and straight forward as shown in the examples below:.

• To address the first cell from both Sheet1 and Sheet2 in a single reference, for

example, summarize, the 3D formula will read =SUM(Sheet 1.A1:Sheet2.A1). The

sum function has one addend here, namely, the range from Sheet 1.A1 to Sheet

2.A1. In this range there are two cells (as long as no more cells are included between

Sheet 1 and Sheet 2). The simple formula (not a 3D formula) would only list two

addends: =SUM(Sheet 1.A1;Sheet2.A1).

• To include any subsequently inserted sheets found between Sheet 1 and Sheet 2, the

formula would then be =SUM(Sheet 1.A1:Sheet2.B2).

The full address of a cell also contains the complete path and file name of the spreadsheet

document. So, in its full form, the reference to cell A1 in Sheet1 of the document

name.sxc could be ='file:///home/username/name.sxc'#$sheet 1.A1

under *UNIX where /home is a mounted filesystem and username specifies the directory

where the file is stored. Under Windows®, the specification is similar and could be

='file:///c:/name.sxc'#$sheet 1.A1 where the drive is “C:”.

Note: the single quotes surrounding the file name, and the # character that describes the location within the file, in

accordance with URL convention.

Printing Spreadsheets

C licking the Print File Directly icon in the Standard toolbar sends all the sheets in the document to the

printer. However, if there's a print range selected, then only selection is printed. To set the print range, select the

cells to be printed, then use the Format > Print Ranges > Define command. There is further information on this

topic in the OpenOffice.org Help.

OpenOffice.org User Guide for 2.x 221

1 2 ... 250 251 252 253 254 255 256 257 258 259 260 ... 507 508

Sin comentarios

OpenOffice.org 2.x Guía de usuario Pagina 255