poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 54523] .xlsx files more then 80000 rows can not open in excel (got "Excel found unreadable content" error)
Date Mon, 18 Mar 2013 10:33:00 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=54523

--- Comment #5 from Piotr Przybylski <piotrprz@gmail.com> ---
windows 7
java version "1.6.0_31"
Java(TM) SE Runtime Environment (build 1.6.0_31-b05)
Java HotSpot(TM) 64-Bit Server VM (build 20.6-b01, mixed mode)

windows 7
java version "1.7.0_17"
Java(TM) SE Runtime Environment (build 1.7.0_17-b02)
Java HotSpot(TM) Client VM (build 23.7-b01, mixed mode, sharing)

XLSX file with 81000 rows has 203 234 945 bytes, when extracted with 7-zip
xl/worksheets/sheet1.xml has 4 305 778 271 bytes (slightly more than 4 GB) and
looks to be cut at this point.

XLSX file with 80000 rows has 200 729 481 bytes, when extracted with 7-zip
xl/worksheets/sheet1.xml has 4 252 483 271 bytes (almost 4 GB) and looks ok.

4 GB seems to be some magic size after which sheet1.xml gets broken (cut).

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message