Difference between revisions of "Documentation/OOo3 User Guides/Getting Started/Opening existing spreadsheets"
From Apache OpenOffice Wiki
(New page: {{DISPLAYTITLE:Opening existing spreadsheets}} {{Documentation/GSCalc3TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Getting Started/Starting new spreadsheets |NextPage=D...) |
Clairedwood (Talk | contribs) ((checkpoint save)) |
||
| Line 22: | Line 22: | ||
{{Documentation/Tip| You can also open a spreadsheet that has been recently worked on using the Recent Documents list. This list can be accessed from the '''File''' menu, directly below '''Open'''. The list displays the last 10 files that were opened in any of the OOo components.}} | {{Documentation/Tip| You can also open a spreadsheet that has been recently worked on using the Recent Documents list. This list can be accessed from the '''File''' menu, directly below '''Open'''. The list displays the last 10 files that were opened in any of the OOo components.}} | ||
| + | |||
| + | ==Opening CSV Files== | ||
| + | |||
| + | # Choose File > Open. | ||
| + | # Locate the CSV file that you want to open. | ||
| + | # If the file has a '''*.csv''' extension, select the file and click Open. | ||
| + | # If the file has another extension (for example, *.txt), select the file, select '''Text CSV''' in the File type box (scroll down into the spreadsheet section to find it) and then click '''Open'''. | ||
| + | # On the Text Import dialog (Figure 6), select the Separator options to divide the text in the file into columns. | ||
{{CCBY}} | {{CCBY}} | ||
[[Category:Getting Started (Documentation)]] | [[Category:Getting Started (Documentation)]] | ||
Revision as of 20:39, 13 February 2010
- Parts of the main Calc window
- Starting new spreadsheets
- Opening existing spreadsheets
- Saving spreadsheets
- Navigating within spreadsheets
- Selecting items in a sheet or a spreadsheet
- Working with spreadsheets
- Viewing Calc
- Entering data using the keyboard
- Speeding up data entry
- Editing data
- Formatting data
- Autoformatting cells and sheets
- Formatting spreadsheets using themes
- Hiding and showing data
- Sorting records
- Printing from Calc
An existing spreadsheet can also be opened from any component of OOo.
Click File and then select Open.
From the toolbar
Click the Open button 
on the Standard toolbar.
From the keyboard
Use the key combination Control+O.
Each of these options displays the Open dialog, where you can locate the spreadsheet that you want to open.
Opening CSV Files
- Choose File > Open.
- Locate the CSV file that you want to open.
- If the file has a *.csv extension, select the file and click Open.
- If the file has another extension (for example, *.txt), select the file, select Text CSV in the File type box (scroll down into the spreadsheet section to find it) and then click Open.
- On the Text Import dialog (Figure 6), select the Separator options to divide the text in the file into columns.
| Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |
