Opening Text CSV in Calc
Sun, 23 Oct 2011 - 11:26 PM
I am having trouble opening a file saved in Text CSV in Calc. When I attempt to open it, all the numbers come out jumbled, some are incorrect and not in correct columns. In the attached example the mutual funds number of shares should be in the thousands but they show only as single digits. The market values are incorrect.
| Attachment | Size |
|---|---|
| Open Office Spreadsheet.jpg | 242.75 KB |
Fri, 28 Oct 2011 - 6:47 PM
#2
Choose the correct boxes to tick in the Separator Options
When you open a CSV file, you get a dialogue box before the file opens. A sample of what the file will look like appears at the bottom of the dialogue. In the case of this file, untick the Comma as it is part of the numbers, not a separator as in most Comma Separated Values (CSV) files. Probably the separator here is the Tab, so try ticking that, but you can experiment.
Fedora 17 LibreOffice 3.5.7OpenSUSE 12.3 LibreOffice 4.0.2