6) In OOo 3.3, two new options are available when importing CSV files that
contain data separated by specific characters.
These options determine whether quoted data will always be imported as text,
and whether Calc will automatically detect all number formats, including
special number formats such as dates, time, and scientific notation. The
detection depends on the language settings.
7) Click OK to open the file.
Caution
If you do not select Text CSV (*csv;*txt;*xls) as the file type when
opening the file, the document opens in Writer, not Calc.
Saving spreadsheets
Spreadsheets can be saved in three ways.
• Press Control+S.
• Choose File > Save (or Save All or Save As).
• Click the Save button on the main toolbar.
If the spreadsheet has not been saved previously, then each of these actions will open
the Save As dialog. There you can specify the spreadsheet name and the location in
which to save it.
Note
If the spreadsheet has been previously saved, then saving it using the
Save (or Save All) command will overwrite an existing copy. However,
you can save the spreadsheet in a different location or with a different
name by selecting File > Save As.
Saving a document automatically
You can choose to have Calc save your spreadsheet automatically at regular intervals.
Automatic saving, like manual saving, overwrites the last saved state of the file. To
set up automatic file saving:
1) Choose Tools > Options > Load/Save > General.
2) Click on Save AutoRecovery information every and set the time interval.
The default value is 15 minutes. Enter the value you want by typing it or by
pressing the up or down arrow keys.
Saving as a Microsoft Excel document
If you need to exchange files with users of Microsoft Excel, they may not know how to
open and save *.ods files. Only Microsoft Excel 2007 with Service Pack 2 (SP2) can do
this. Users of Microsoft Excel 2007, 2003, XP, and 2000 can also download and install
a free OpenDocument Format (ODF) plugin from Sun Microsystems, available from
Softpedia, http://www.softpedia.com/get/Office-tools/Other-Office-Tools/Sun-ODF-
Plugin-for-Microsoft-Office.shtml.
22 OpenOffice.org 3.3 Calc Guide
Comentarios a estos manuales