Issue 117225 - Import large HTML table, data gets truncated
Summary: Import large HTML table, data gets truncated
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.3
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: saroja
Depends on:
Reported: 2011-03-04 21:12 UTC by wotschie
Modified: 2013-10-06 09:39 UTC (History)
4 users (show)

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

20000 rows as HTML table (1.57 MB, application/
2011-03-04 21:12 UTC, wotschie
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description wotschie 2011-03-04 21:12:45 UTC
Created attachment 76010 [details]
20000 rows as HTML table

By importing a document (a HTML file named as .XLS or .HTML) with lots (more than 15000) of rows, OpenOffice Calc truncates data without showing any error or warning.

The issue can be reproduced by importing attached file into calc. On my machine it imports just 13635 of the 20000 rows.
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:16:16 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 2 Dan 2013-02-01 01:31:51 UTC
AOO341m1(Build:9593) - Rev. 1372282
Windows 7 / 32-bit

I was able to reproduce this issue. I tried importing the attached file in calc and found the same issue, only 13635 rows of the 20000 were imported. 

Out of curiosity, I also tried this by creating a .htm file in excel with one column of 20000 rows. This opened in OpenOffice Calc and showed all 20000 rows.

Could this be a problem due to the amount of data?
Comment 3 Edwin Sharp 2013-10-06 09:39:50 UTC
As given in description. Opens OK in Excel 2007.

Rev. 1525015 Win 7