Operation Manual

Figure 95: Confirm File Format dialog
Figure 96: Export Text File dialog for CSV files
Tip
To have Calc save documents by default in a file format other than the default ODF
format, go to Tools > Options > Load/Save > General. In Default file format and
ODF settings > Document type, select Spreadsheet, then in Always save as,
select your preferred file format.
Navigating within spreadsheets
Calc provides many ways to navigate within a spreadsheet from cell to cell and sheet to sheet. You
can generally use the method you prefer.
Cell navigation
When a cell is selected or in focus, the cell borders are emphasized. When a group of cells is
selected, the cell area is colored. The color of the cell border emphasis and the color of a group of
selected cells depends on the operating system being used and how you have set up LibreOffice.
• Using the mouse – place the mouse pointer over the cell and click the left mouse button.
To move the focus to another cell using the mouse, simply move the mouse pointer to the
cell where you want the focus to be and click the left mouse button.
• Using a cell reference – highlight or delete the existing cell reference in the Name Box on
the Formula Bar (Figure 90 on page 114). Type the new cell reference of the cell you want
to move to and press Enter key. Cell references are case insensitive: for example, typing
a3 or A3 will move the focus to cell A3.
Chapter 5 Getting Started with Calc | 119