[libreoffice-users] Re: csv files not displaying properly

On 07/21/2013 01:29 PM, Jay Lozier wrote:
> 1. On Sun, 21 Jul 2013 13:56:21 -0400, Jim Byrnes
> <jf_byrnes@comcast.net> wrote:
>
> > 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
>
> Jim,
>
> Using your sample data I had no problems with the csv file with the
> following settings
>
> 1. Character set = Unicode (UTF-8), Language = Default - English  (USA),
> Separated by = Comma, Detect Special Numbers checked
>
> 2. Character set = Unicode (UTF-8), Language = Default - English  (USA),
> Separated by = Comma, Detect Special Numbers unchecked
>
> 3. Character set = Unicode (UTF-7), Language = Default - English  (USA),
> Separated by = Comma, Detect Special Numbers checked
>
> In all cases the data imported correctly and the amounts behaved as
> expected; formatting and sum() worked as expected.
>
> Using LO 4.0.0 from openSUSE 12.3 repository.

Jay,

It was working for me also. Mine is from the Unbuntu repository and I 
don't think there have been any updates to it , but I will check. I'm 
hoping someone recognizes the problem or knows of some setting I may 
have inadvertently changed to cause the problem.

Just out of curiosity did you happen to add a couple of lines after the 
last one that had the negative number in it?  All of my problems seem to 
start after a negative number.  Silly me, I was just giving people a 
look at the file format, it never dawned on me that could be used to 
test with.  I should have included some more lines.

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