Issue 110486 - Calc/Writer: data loss on import table from .html file
Summary: Calc/Writer: data loss on import table from .html file
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO320m14
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-03-30 10:09 UTC by bormant
Modified: 2013-01-29 21:39 UTC (History)
2 users (show)

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


Attachments
test file (82.74 KB, application/x-compressed)
2010-03-30 10:10 UTC, bormant
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bormant 2010-03-30 10:09:41 UTC
Experiment 1:
1) start OOo
2) File - Open - test.html, HTML Document (OpenOffice.org Calc)
3) document opens in calc (be patient), 
4) navigate to F column, press Ctrl+Down arrow

As for me, column F breaks at row 10923, column A breaks at row 10924 (error).
Columns B and C are complete.

Experiment 2:
1) start OOo
2) File - Open - test.html, All files
3) document opens in writer/web (be patient),
3) navigate to F:10667 in table

As for me, table breaks in column F at row 10667, other data follow the table 
(error).
Comment 1 bormant 2010-03-30 10:10:53 UTC
Created attachment 68632 [details]
test file
Comment 2 bormant 2010-03-30 10:28:20 UTC
Experiment 3:
1) open test.html in browser
2) select and copy whole table
3) open Calc
4) paste (Ctrl+V)

As for me, column F breaks at row 10923, column A breaks at row 10924 (error).
Columns B and C are complete.

If Paste special (Ctrl+Shift+V) - Unformatted text on step 4 -- complete table 
goes in document (without formatting, of course).
Comment 3 helenrussian 2010-03-30 11:32:21 UTC
I confirm experiments 1 and 2 with OOo 3.2 on Linux as described.

In experiment 3 my browser hangs. :(
Comment 4 gquigs 2010-05-21 07:01:55 UTC
Another example file available on launchpad bug:
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/480130

In this file it cuts off at 6555. This bug appears in Ubuntu's OOo, Go-oo on
Windows and OpenOffice 3.2.1rc.  

Tested all files with both Excel and Firefox, nothing is wrong with the html in
this bug report or launchpads.
Comment 5 gquigs 2010-05-21 07:40:19 UTC
You can create a new document that exhibits this behavior by using Excel:
File up columns 1-4 with data down to row 18,000. Can just be 1-17,999.
Save it as a Web Page from excel.

Open in OpenOffice.  Scroll down to the end, you will notice that instead of
being a table with multiple columns, there is only one column at the bottom
(it's cut off, but the data looks like it has been merged into it. 

Bug still exists in DEV300m77 on Windows.
Comment 6 Olaf Felka 2010-05-21 07:50:19 UTC
This should be better reviewed by the Spreadsheet folks.