Sams Teach Yourself StarOffice® 5 for Linux in 24 Hours |
![]() |
|||||||||||||||||||||
Hour 5: Importing and Exporting StarOffice Documents |
![]() |
|||||||||||||||||||||
|
If you need to share StarOffice spreadsheets with a colleague that uses another spreadsheet program, the other program is not likely to read StarOffice files. None of the other popular spreadsheets--Lotus 1-2-3, Quattro Pro, Microsoft Works--support importing StarOffice spreadsheet files.
Instead, you'll need to export your StarOffice spreadsheet files in a format that can be read by the other spreadsheet program.
StarOffice provides the following useful spreadsheet export filters from the Save As dialog box:
Excel 4.0, 5.0, 95, and 97
HTML
dBase (a database format)
Text
To save a StarOffice spreadsheet in another format, follow these steps:
1. Choose Save As from the File menu. The Save As dialog box opens.
2. Select a format from the File type drop-down list.
Tip - As described in the previous sections, the best option for exporting a file for use in another word processor is Excel. (Use the latest version of Excel that the target computer has installed.) If you use any of the other formats listed previously, some formatting or formula information will be lost during the conversion. |
3. Enter a different name for the document.
4. Select the directory in which the new file is to be saved (remember that you can't save the file directly to a floppy diskette unless you have it mounted in your Linux system).
5. Choose OK to save the document.
After you've saved a StarCalc spreadsheet in a format such as Excel, you can use that spreadsheet in any program that can import that format. Because of the popularity of Excel, any program released after the release of Excel 5 probably has this capability.
In fact, most spreadsheet programs determine the file format automatically, based on the file extension or content, and apply the correct conversion to the Excel format. For example, if you open an Excel 5 spreadsheet in Lotus 1-2-3 version 3.1 for Windows, the file imports automatically and appears on your screen.
Caution - In some cases, a spreadsheet program can't determine the format of a file. In such a case, you normally choose the format from a dialog box that lists the available filters. |
Sams Teach Yourself StarOffice® 5 for Linux in 24 Hours |
![]() |
|||||||||||||||||||||
Hour 5: Importing and Exporting StarOffice Documents |
![]() |
|||||||||||||||||||||
|
© Copyright Macmillan USA. All rights reserved.