> As jonathan wrote I suspect something in the CSV file is being interpreted > as "create a new row." >
I don't see anything that could be causing that. At least, there does not sem to be anything unusual. > I would look at the size of the import file. If it is larger than 64 KB and > your rows aren't very wide that would indicate to me there is non display > data at the end of some of the rows, most likely the last one imported. That > could be verified with a hex editor. > 26 KB. > If there is non display data at the end of the row in the CSV forcing row > imports then I'd look at how the CSV is created. It may be the routine or > program producing the CSV is padding with characters that are forcing Calc > to import "extra" rows. > > I have encountered failed row imports with other programs where fewer rows > would be imported than I knew to be in the source data. Every time I've > encountered such problems the source data, the import file, had unexpected > values in it. Correcting the input file has always led to successful import. > I am attaching a version of the file with classified information removed. It is UTF-8 text, and contains characters outside ASCII (Hebrew letters). I have verified that other Hebrew CVS files do in fact import properly, however. I don't remember if this list accepts attachments or not, so if not, here is the file on my server: http://dotancohen.com/images/examples/contacts-ooo.csv -- Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת ا-ب-ت-ث-ج-ح-خ-د-ذ-ر-ز-س-ش-ص-ض-ط-ظ-ع-غ-ف-ق-ك-ل-م-ن-ه-و-ي А-Б-В-Г-Д-Е-Ё-Ж-З-И-Й-К-Л-М-Н-О-П-Р-С-Т-У-Ф-Х-Ц-Ч-Ш-Щ-Ъ-Ы-Ь-Э-Ю-Я а-б-в-г-д-е-ё-ж-з-и-й-к-л-м-н-о-п-р-с-т-у-ф-х-ц-ч-ш-щ-ъ-ы-ь-э-ю-я ä-ö-ü-ß-Ä-Ö-Ü --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
