Apache OpenOffice (AOO) Bugzilla – Issue 91028
CSV import chops off characters for lines >64k
Last modified: 2015-05-30 20:53:41 UTC
I try to import a tab delimited utf-8 text file (in Ubuntu 8.4), but some lines are strangelly chopped its not the problem of column limit (as the last column is GF) the problem happens at EP3 cell: instead of "Domisi naujausiomis..." it leaves just "Domi" :/ Seams to be the issue with line length, because if I strip it from beggining, it leaves as many characers more at the end (now it chops at 63036-th character) The file: http://popmokslas.projektas.lt/etc/example.txt (is it possible to upload/attach it to the bug?) copying from clipboard also gives similar problems (the chop-places seems to depend on encoding a bit (windows-1257 chops ~20-50 characters later)
In version OOo-dev300-m21_en,when I opened the attachment(example.txt) in Calc,it opened as Writer,instead of Calc.Then I created a new .txt document ,and tried again,it's the same. so I can't reproduce it.
I use Insert -> Sheet from File (not sure about exact naming, as I use in my native language)
Can reproduce it in DEV300_m28_EN on WinXP. To reproduce: Insert -> Sheet from File, to insert the attachment (example.txt) into a calc file. Result: In cell EP3, it leaves "Domis" instead of "Domisi naujausiomis..."
dz0, >>The file: http://popmokslas.projektas.lt/etc/example.txt (is it possible to >>upload/attach it to the bug?) Yes, you can upload an attachment by "create a new attachment" in this page.
confirmed
"Domis" instead of "Domisi naujausiomis" is cut off after the 65535th character of that line. It seems that there is some relation between this and the 64k limit of class String that is used to read from SvStream.
Resolved in LibreOffice 3.6: https://bugs.freedesktop.org/show_bug.cgi?id=48501
And will it be corrected in OOCalc ? 2years and still no corrections the max line length is 65536 characters (64k). DWORD instead of INTEGER... please let me know if any correction are available on OOCalc.