kdatrends.blogg.se - Openoffice spreadsheets

You can preview the layout of the imported data at the bottom of the dialog.

On the Text Import dialog, select the separator options to divide the text in the file into columns.

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.

If the file has another extension (for example.

csv extension, select the file and click Open.

Locate the CSV file that you want to open.

Text is put in quotation marks, numbers are written without quotation marks.

Commas, semicolons, or other characters are used to separate the cells. Each line in a CSV file represents a row in a spreadsheet. The list displays the last 10 files that were opened in any of the OOo components.Ĭomma-separated values (CSV) files are text files that contain the cell contents of a single sheet. This list is located on the File menu, directly below Open. You can also open a spreadsheet that has been recently worked on by using the Recent Documents list. A new spreadsheet, based on the selected template, opens. On the Templates and Documents window, navigate to the appropriate folder and double-click on the required template. Follow the above procedures, but instead of selecting Spreadsheet, select the Templates icon from the Start Center or Templates and Documents from the Menu bar or toolbar. If you already have a spreadsheet open, you can press Control+N to open a new spreadsheet in a new window.Ĭalc documents can also be created from templates. (If a spreadsheet is open, a new spreadsheet document will be created.) Click the button itself to create a new document of the type that is currently open. Click the down-arrow for a choice of which type of document to open (text document, spreadsheet, and so on). If a document is open in any component of OOo (for example, Writer), you can Use the New Document icon on the Standard toolbar. You can create a new, blank spreadsheet from the Start Center (Welcome to ) or from within Calc or any other component of OOo, for example from Writer or Draw.Ĭlick File and then select New > Spreadsheet.