As with all the OpenOffice.org programs, Calc works well with data from similar programs such as Microsoft Office and StarOffice. Most of the time, you can load an Excel spreadsheet directly into Calc and work with the spreadsheet as though you had originally created it in Calc. When you load a spreadsheet from another program into Calc, you are using Calc's automatic import feature to bring that data into Calc's workspace. If you want to use Calc data in another program, you must export the spreadsheet data.
Before You Begin
46 Print a Spreadsheet
73 About Advanced Spreadsheet Printing
Although Calc imports virtually all Excel spreadsheets, Calc may have problems importing the following Excel items. If your imported spreadsheets contain any of these items, you may need to adjust the imported spreadsheet manually to eliminate the sections with these items or make a note that the items will not be appearing:
Advanced Office form fields
Non-Calc-supported chart types
Excel's conditional formatting
Esoteric Excel functions and formulas
| || |
Import ” To load data from a non-Calc program into Calc.
Export ” To save data from Calc so another program can use the data.
Import Using Open
To import an Excel or StarOffice 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.
| || |
After importing the spreadsheet, save the spreadsheet with File, Save and select the Calc extension .SXC from the Save as type list box to convert the spreadsheet to Calc's native format. This also preserves the file's original Excel or StarOffice format.
Request the Export
Although Calc's File menu contains an Export command, you should only use this command when you want to export your current spreadsheet data to a PDF file (see 36 Save a Document as a PDF File ).
To export your spreadsheet in a non-Calc format, select File , Save As .
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
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), a StarCalc file 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
extension, or an HTML document with the .html
extension, which you would use if you wanted to display your spreadsheet as a Web page.
| || |
The dBASE file format is useful when you use Calc as a database, as you learn in 74 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
Export as PDF
Calc's File, Export and File, Export as PDF commands do the very same thing. They both convert your spreadsheet to Adobe's PDF format (see 36 Save a Document as a PDF File ) and save the file with the .PDF filename extension. PDF files are useful for eBooks and for offering to Web page visitors as downloads because PDF files are readable on many kinds of computer systems. A primary advantage of PDF files is that they look the same no matter what kind of system you view them on.