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

100

101

Chapter 4: Spreadsheets in Calc

If a new sheet, independent from the source areas, should not be created , but retaining links

to the source areas or consolidating areas in which the order of rows or columns varies is

preferred,, click the More button in the Consolidate dialogue.

1. Select Link to Source Data to insert only the formulae that generate the results in the

target area, rather than the actual results. With linked data, any values modified in the

source area are automatically updated in the target area. The corresponding cell references

in the target area are inserted in consecutive rows, which are automatically ordered and

then hidden from view. Only the final result, based on the selected calculation rule, is

displayed.

2. Under Consolidate by do the following:

a) Select either Row Labels or Column Headers if the cells of the source area are to be

consolidated according to a matching row label or column header rather than to the

identical position of the cell in the area.

To consolidate by row or column headers, the text must be contained in the selected

source areas, or included in the selection with the mouse.

The data from the consolidation and target areas is saved when the document is saved.

Opening a document later, in which consolidation has been defined, this data will again be

available.

Note: The text in the headers or labels must be identical, so that rows or columns can be accurately matched. If the

row or column label does not match any that exist in the target area, it will be appended as a new row or column.

OpenOffice.org User Guide for 2.x 254

1 2 ... 283 284 285 286 287 288 289 290 291 292 293 ... 507 508

Comentarios a estos manuales

Sin comentarios

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

Comentarios a estos manuales

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