Operation Manual

• Fields – shows how your data will look when it is separated into columns.
– Column type – select a column in the preview window and select the data type to be
applied the imported data.
– Standard – Calc determines the type of data.
– Text – imported data are treated as text.
– US English – numbers formatted in US English are searched for and included
regardless of the system language. A number format is not applied. If there are no US
English entries, the Standard format is applied.
– Hide – the data in the column are not imported.
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 another format.
1) Save your spreadsheet in Calc spreadsheet file format (*.ods).
2) Select File > Save As on the Menu bar to open the Save As dialog (Figure 94).
Figure 94: Save As dialog
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.
120 | Getting Started with LibreOffice 5.0