OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 216)

Calc spreadsheet

The simplest and most often used case is analyzing a list in a Calc spreadsheet. The

list might be updated regularly or the data might be imported from a different

application.

For example, a huge list can be copied from a different application and pasted into

Calc. The behavior of Calc while inserting the data depends on the format of the data.

If the data is in a common spreadsheet format, it is copied directly into Calc.

However, if the data is in plain text, the Text Import dialog appears; see Figure 188 in

this chapter and Chapter 1 (Introducing Calc) for more more information.

Calc can import data from a huge number of foreign data formats, for example from

other spreadsheets (Excel, Lotus 1, 2, 3), from databases (like dBase), and from

simple text files including CSV formats.

The drawback of copying or importing foreign data is that it will not update

automatically if there are changes in the source file. With a Calc file you were

previously limited to 65,535 rows but this has been expanded to one million rows.

Registered data source

A registered data source in OpenOffice.org is a connection to data held in a database

outside Calc. This means that the data to be analyzed will not be saved in Calc; Calc

always uses the data from the original source. Calc is able to use many different data

sources and also databases that are created and maintained with OpenOffice.org

Base. See Chapter 10 (Linking Calc Data) for more information.

External data (OLAP)

No implementation exists at the moment so this option is not available.

The DataPilot dialog

The function of the DataPilot is managed in two places: first in the DataPilot dialog

and second through manipulations of the result in the spreadsheet. This section

describes the dialog in detail.

Basic layout

In the DataPilot (Figure 198) are four white areas that show the layout of the result.

Beside these white areas are buttons with the names of the fields in your data source.

To choose a layout, drag and drop the field buttons into the white areas.

The Data Fields area in the middle must contain at least one field. Advanced users

can use more than one field here. For the data field an aggregate function is used.

For example, if you move the sales field into the Data Fields area, it appears there as

Sum – sales.

216 OpenOffice.org 3.3 Calc Guide

1 2 ... 211 212 213 214 215 216 217 218 219 220 221 ... 433 434

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 216