Opening Text CSV in Calc

2 replies [Last post]
ahdunno's picture
Last seen: 27 weeks 1 day ago
Title: ★★
Joined: 23 Oct 2011
Posts: 16
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.
Open Office Spreadsheet.jpg242.75 KB

Last seen: 2 years 38 weeks ago
Title: ★★★★★
Joined: 25 Oct 2011
Posts: 941
we would need to see what the
we would need to see what the actual cvs looks like (i.e. could you attach that) to make any sense of this along with what you are expecting to see
Linux Mint 15 LibreOffice : OpenSUSE 12.3 LibreOffice 4.0.3
Last seen: 4 years 38 weeks ago
Joined: 28 Oct 2011
Posts: 1
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.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.