OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources] نسخه متنی

1.

Import Using Open

To import an Excel or other non-OpenDocument format spreadsheet into Calc, simply use

File, Open to request the file. Browse the files from the

Open dialog box until you find the spreadsheet you want to import and then click

OK to import the file into Calc. Almost always, assuming the spreadsheet doesn't contain some advanced or esoteric feature, such as those listed in this task's introduction, the spreadsheet imports perfectly, and you can continue editing and printing it as though you had created the sheet originally in Calc.

36 Save a Document as a PDF File ).

To export your spreadsheet in a non-OpenDocument format, select

File, Save As .

3.

Select the Export Type

The

Save As dialog box opens, and you select the type of file you want Calc to convert your spreadsheet to in the

Save as type list box.

You can export the file to a Data Interchange Format with the .dif extension, a dBASE file with the .dbf extension, one of several versions of Excel (most commonly, the .xls extension is used for Excel spreadsheets), one of several pre-version 8 versions of StarCalc (with the .sdc extension), a SYLK file with the .slk extension, a text-based comma-separated values file (known as a

CSV file) with the .csv or .txt extension, or a218 document with the l extension, which you would use if you wanted to display your spreadsheet as a Web page.75 About Calc Databases .

When you click

Save , Calc converts the spreadsheet to the format you selected and saves the file under the name you typed in the

File name field. A warning dialog box may open if there is any danger of losing content or formatting in the selected format.

4.

Export as

PDF

Calc's

File, Export as

PDF command converts your spreadsheet to Adobe's PDF format (see

36 Save a Document as a PDF File ) and saves the file with the .PDF filename extension. After you save the file, an

Options dialog box opens where you can set options such as choosing a range within the document print, or raising or lowering the quality of JPEG images contained in the document. You can customize your new PDF document or accept the defaults and click

OK .

You can also use the

Export Directly As

PDF button on the

Standard toolbar instead of the menu command to save a spreadsheet as a PDF document, but you will not be able to choose additional options for saving the file if you go this route.

5.

Export as Web Page

Calc's

File, Export command offers two choices: You can export to PDF format (as described in step 4) or you can export to XHTML format. The default file format in the

Export dialog box is PDF, so use the

File format list arrow to change to the XHTML format.