[Libreoffice-bugs] [Bug 41580] calc dropping enties from .cvs file when importing

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=41580

Russ Fineman <upscope at nwi.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |upscope at nwi.net

--- Comment #3 from Russ Fineman <upscope at nwi.net> 2011-10-20 12:01:41 PDT ---
(In reply to comment #1)
> Hi Russ,
> 
> Thanks for the report.
> 
> Recently there was a discussion about the same on the users list.
> See subject " Calc row limits error " around 12-10-2011.
> 
> (Cannot acces the archives right now - no idea why, but should be here:
> listarchives.libreoffice.org/global/users/
> www.mail-archive.com/users at global.libreoffice.org/
>  - maybe to slow connection )
> 
> 
> Suggestions are for possible errors in formatting.
> e.g.
> A missing quote for instance as in:
> > http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=43731 
> 
> But then it is something that Calc refuses and koffice / gnumeric don't .
> So in any case interesting to examine.
> 
> Could you pls have a look at that possibility?
> thanks,
> Cor

Hi Cor: Sorry was so long getting back. Was out of town. I did the following:
 1. Deleted all previous .cvs files. 
 2. From Sea Monkey I exported my Personal address book as a .cvs 
 3. Opened in Kspread
 4. Say missing contacts were there. 
 5. saved a a .csv from kspread
 6. Inported this version to Libreoffice Calc
 7. Missing contacts are there.
 8. Then inported into Kmail. Contacts came in but some of them had a comma in
the zipcode field between the 98,837  should read 98837. This does not appear
to be problem, it appears that field is formatted wrong in Kspread. When I
imported it I got all the contacts, including ones kmail does'nt. 

will check on link you provided and post again,

Thanks for your help.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.