[libreoffice-users] csv files not displaying properly

OS = Ubuntu 12.04 up to date & LO = 3.5.7.2

I have been downloading and opening bank and credit card activity as csv 
files for some time now with no problems using LO.  Today when I did it 
the results are unusable.

In regards to the bank download, by unusable I mean:

There should be six columns of data and there is, but column C is very 
wide.  Column C should only contain a check or deposit amount.  Starting 
on row 3, column C has parts of other columns and rows in it and has 3 
separate lines in it.

In regards to the credit card download:

In this case it displays the columns correctly, but some rows are 
missing. It should have a heading and 6 rows.  It displays a heading and 
3 rows.  The bottom 3 rows are missing.

In trying to figure this out I:

Looked at the files with a text editor and they look properly formatted.

They open correctly in Gnumeric and Calligra sheets.

In the text import dialog down in the Fields section both display 
correctly.  That is all of the columns display as they should and all 
the rows are present.

I have Character set = Unicode (UTF-8), Language = Default - English 
(USA), Separated by = Comma.

Here is a sanitized sample of the bank file from a text editor.

xxxxxxxxx555,06/30/2013,0.31,0,Added to Account,Accr Earning Pymt
xxxxxxxxx555,06/28/2013,104.82,0,Deposit,ACH Deposit
xxxxxxxxx555,06/27/2013,-1499.50,1130,,Check

I had a copy of this type of file in my trash folder that I processed 
last month with no problems.  When I tried it today I got the same 
results as above.

To my knowledge I have not changed any settings that would cause this. 
The only thing I have done differently is download and read  Andrew 
Pitonyak's excellent book on macro's in Writer format.  While reading it 
I did activate some of his example macros.  I don't see how this could 
cause any problems and mention it only for completeness.

OK, while gathering information for this post I discovered that my 
problems start when a negative number is encountered.  In fact if I 
remove the minus sign from all numbers the file displays correctly.

Does anyone have any idea what is happening and how to fix it?

Thanks,  Jim



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted