Basically the problem boils down to not having text delimiter in pairs (http://www.openoffice.org/issues/show_bug.cgi?id=31441). I have the file with me and found offending line, if anyone needs the file.
That other spreadsheet app handles this scenario by treating everything between unmatched delimiter and next record separator as single string. We are trying to search for matching text delimiter ignoring record separators, so our behavior argurably can be improved. Should I file RFE for that? Does it have any chance of being implemented? WBR, K. Palagin. -----Original Message----- From: Stepan Bechynsky [mailto:[EMAIL PROTECTED] Sent: Sunday, April 22, 2007 3:26 PM To: dev@sc.openoffice.org Subject: [sc-dev] Question about OpenOffice.org Calc: CSV import enhancements Hi, I have tried to import CSV file to Calc. CSV file has 16408 lines. Calc imported just 13268 lines. I cut file to 13000 lines and Calc imported just 11011 lines. Is it known bug? I am using OOo 2.2 on Windows Vista Ultimate. I can send you CSV for testing. Regards, Stepan Bechynsky Developer Evangelist Microsoft --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]