Operation Manual

Saving spreadsheets
To save a spreadsheet, see Chapter 1 Introducing LibreOffice for more details on how to save files
manually or automatically. Calc can also save spreadsheets in a range of formats and also export
spreadsheets to PDF, HTML and XHTML file formats, see the Calc Guide Chapter 6 Printing,
Exporting, and E-mailing for more information.
Saving in other spreadsheet formats
If you need to exchange files with users who are unable to receive spreadsheet files in Open
Document Format (ODF) (*.ods), which Calc uses as default format, you can save a spreadsheet
in an another format.
1) Save your spreadsheet in Calc spreadsheet file format (*.ods).
2) Select File > Save As on the main menu bar to open the Save As dialog (Figure 94).
3) In File name, if you wish, enter a new file name for the spreadsheet.
4) In File type drop-down menu, select the type of spreadsheet format you want to use.
5) If Automatic file name extension is selected, the correct file extension for the
spreadsheet format you have selected will be added to the file name.
6) Click Save.
7) Each time you click Save, the Confirm File Format dialog opens (Figure 95). Click Use
[xxx] Format to continue saving in your selected spreadsheet format or click Use ODF
Format to save the spreadsheet in Calc ODS format.
8) If you select Text CSV format (*.csv) for your spreadsheet, the Export Text File dialog
(Figure 96) opens allowing you to select the character set, field delimiter, text delimiter and
so on to be used for your CSV file.
Figure 94: Save As dialog
118 | Getting Started with LibreOffice 4.0