Operation Manual

– Number Format: Provides a way to quickly change the format of numbers including
decimals, currency, dates, or numeric text. Numerical and label field controls for Forms
are also available.
Each of these panels has a More Options button, which opens a dialog that gives a
greater number of options. These dialogs lock the document for editing until they are
closed.
• Styles and Formatting: This deck contains a single panel, which is the same as that
opened by selecting the Styles and Formatting button (F11) from the Text Formatting
toolbar.
• Gallery: This deck contain a single panel, which is the same as that opened by selecting
Gallery from the Standard toolbar or Tools > Gallery from the Menu bar.
• Navigator: This deck contains a single panel, which is essentially the same as the
Navigator window opened by clicking the Navigator button on the Standard toolbar or
selecting View > Navigator (F5) from the Menu bar. Only the Contents button is absent in
the Sidebar’s Navigator panel.
• Functions: This deck contains a single panel, which is the same as the window opened by
selecting Insert > Function List from the Menu bar.
To the right side of the title bar of each open deck is a Close button (X), which closes the deck to
leave only the Tab bar open. Clicking on any Tab button reopens the deck.
The Sidebar can be hidden, or revealed if already hidden, by clicking on the edge Hide/Show
button. You can adjust the deck width by dragging on the left edge of the sidebar.
Opening a CSV file
Comma-separated-values (CSV) files are spreadsheet files in a text format where cell contents are
separated by a character, for example a comma or semi-colon. Each line in a CSV text file
represents a row in a spreadsheet. Text is entered between quotation marks; numbers are entered
without quotation marks.
To open a CSV file in Calc:
1) Choose File > Open on the Menu bar and locate the CSV file that you want to open.
2) Select the file and click Open. By default, a CSV file has the extension .csv. However,
some CSV files may have a .txt extension.
3) The Text Import dialog (Figure 93) opens allowing you to select the various options
available when importing a CSV file into a Calc spreadsheet.
4) Click OK to open and import the file.
The various options for importing CSV files into a Calc spreadsheet are as follows:
• Import
– Character Set – specifies the character set to be used in the imported file.
– Language – determines how the number strings are imported.
If Language is set to Default for CSV import, Calc will use the globally set language. If
Language is set to a specific language, that language will be used when importing
numbers.
– From Row – specifies the row where you want to start the import. The rows are visible
in the preview window at the bottom of the dialog.
118 | Getting Started with LibreOffice 5.0