OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 263)

Figure 260: Checking ledger

Inserting sheets from a different spreadsheet

On the Insert Sheet dialog, you can also add a sheet from a different spreadsheet file

(for example, another Calc or Excel spreadsheet), by choosing the From file option.

Click Browse and select the file; a list of the available sheets appears in the box.

Select the sheet to import. If, after you select the file, no sheets appear you probably

selected an invalid file type (not a spreadsheet, for example).

Tip

For a shortcut to inserting a sheet from another file, choose Insert >

Sheet from file from the menu bar. The Insert Sheet dialog opens with

the From file option preselected, and then the Insert dialog opens on top

of it.

The above method adds a sheet from another file as an embedded object – it is

contained within the document and is independent of the original sheet. If you prefer,

select the Link option to insert the external sheet as a link instead as a copy. This is

one of several ways to include “live” data from another spreadsheet. (See also

“Linking to external data” on page 270.) The links can be updated manually to show

the current contents of the external file; or, depending on the options you have

selected in Tools > Options > OpenOffice.org Calc > General > Updating,

whenever the file is opened.

If the sheet is contained in an already open spreadsheet you can use the Move/Copy

command in the other spreadsheet to copy (or move) a sheet to another document.

Referencing other sheets in the spreadsheet

On the Summary sheet we display the balance from each of the other sheets. If you

copy the example in Figure 260 onto each account, the current balance will be in cell

F3 of each sheet.

There are two ways to enter cell references in other sheets: by entering the formula

directly using the keyboard or by using the mouse. We will look at the mouse method

first.

Creating the reference with the mouse

On the Summary sheet, set up a place for all five account balances, so we know

where to put the cell reference. Figure 261 shows a summary sheet with a blank

Chapter 10 Linking Calc Data 263

1 2 ... 258 259 260 261 262 263 264 265 266 267 268 ... 433 434

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 263