Issue 91028 - CSV import chops off characters for lines >64k
Summary: CSV import chops off characters for lines >64k
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.4.1 RC2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-25 01:26 UTC by dz0
Modified: 2015-05-30 20:53 UTC (History)
6 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dz0 2008-06-25 01:26:12 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)
Comment 1 chl207 2008-07-07 03:35:19 UTC 
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.
Comment 2 dz0 2008-07-07 14:37:49 UTC 
I use 
Insert -> Sheet from File 
(not sure about exact naming, as I use in my native language)
Comment 3 amy2008 2008-08-15 03:38:35 UTC 
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..."
Comment 4 amy2008 2008-08-15 03:48:48 UTC 
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.
Comment 5 redflagzhulihua 2008-08-20 09:43:32 UTC 
confirmed
Comment 6 ooo 2008-09-15 14:38:07 UTC 
"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.
Comment 7 vulcain 2013-01-28 09:43:46 UTC 
Resolved in LibreOffice 3.6:
https://bugs.freedesktop.org/show_bug.cgi?id=48501
Comment 8 JBO 2015-05-30 20:53:41 UTC 
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.