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

100

101

Figure 274: Linked areas in target spreadsheet

How to find the required data range or table

The examples above show that the import filter gave names to the data ranges

(tables) in the sample web page starting from HTML_1. It also created two additional

range names (not visible in the illustration):

HTML_all – designates the entire document

HTML_tables – designates all HTML tables in the document

If the data tables in the source HTML document have been given names (using the ID

attribute on the TABLE tag), or the external spreadsheet includes named ranges,

those names appear in the list along with the ranges Calc has sequentially numbered.

If the data range or table you want is not named, how can you tell which one to

select?

Go to the source document, which you opened in Calc. In the Navigator, double-click

on a range name: that range is highlighted on the sheet (see Figure 276).

If the Formula Bar is visible, the range name is also displayed in the Name box at the

left-hand end (see Figure 275).

Figure 275: Using the Name box to find a data range name

Chapter 10 Linking Calc Data 273

1 2 ... 268 269 270 271 272 273 274 275 276 277 278 ... 433 434

Komentáře k této Příručce

Žádné komentáře

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

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3