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

100

101

Chapter 4: Spreadsheets in Calc

Method Result

Copy the visible cells, for example, with copy and

paste via the clipboard,with the middle mouse button

or drag and drop while pressing the Ctrl key.

Cells were filtered out by way of AutoFilters, default

filters or special filters.

Move the visible cells, for example, by way of cut

and paste via the clipboard or drag and drop without

pressing an additional key.

All cells, including the hidden ones, are

moved.

Cells were hidden manually by way of the Hide

command in the context menu of the row or column

headers, or through an outline.

Copy or move the visible cells.

All cells, including the hidden ones, are

copied or moved.

Referencing a Cell in Another Document

Cells can also be referenced in other spreadsheets:

1. For the following example, the source document is named 'C:\test\test.sxc'; and

it contains a sheet named Sheet1.

2. Open a different or new spreadsheet document.

3. Place the cursor in cell A1 and enter the following formula:

='C:\test\test.sxc'#Sheet 1.A1

4. Alternatively, enter the file name as a URL designation:

='file:///C/test/test.sxc'#Sheet 1.A1. Similarly access a file on the

Internet by using: ='http://ww w.sun.com/test/test.sxc'#Sheet 1.A1.

5. Drag the box in the lower right corner of the active cell to select a range of cells.

OpenOffice.org automatically inserts the corresponding references in the adjacent cells.

As a result, the sheet name is preceded with a "$" sign to designate it as an absolute

reference.

OpenOffice.org User Guide for 2.x 231

1 2 ... 260 261 262 263 264 265 266 267 268 269 270 ... 507 508

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

Relacionado con productos y manuales para Manuales de software OpenOffice.org 2.x