Apache OpenOffice (AOO) Bugzilla – Issue 123340
Feature Request: Increase limits (maximum number of rows and cells) /Unable to import large text-tab delimited document
Last modified: 2013-10-21 15:28:34 UTC
I am unable to import a large text-tab delimited document with the following specifications: --------------- Rows: 60,249 Columns: 18 Cells: 1,020,126 Maximum characters per cell: 268 -------------- The rows are imported but cropped at 60,226 rows (-23 from the actual document). And if I try LibreOffice fork of OpenOffice I also get the error "The data could not be loaded completely because the maximum number of characters per cell was exceeded." and nothing imports at all. At least OpenOffice is able to open the document, but not completely. Feature Request: As I see it the Microsoft Excel specs are much higher than OpenOffice currently, even the older 2010 version. Work should be done to allow OpenOffice to work with Big(er) Data and large documents. https://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx
Can you please share the text document?
(In reply to Edwin Sharp from comment #1) > Can you please share the text document? As the data contains inventory information I am not able to share the exact document. I have been able to re-create a similar document with Lorem Ipsum however; which is downloadable here: http://www.fileconvoy.com/dfl.php?id=gb8fb948b65603142999385510b7c2a36510c78e6a This document gets input/output errors in Libre Office and locks up the latest OpenOffice, but works perfectly in Microsoft Excel. Also it doesn't matter whether it is text-tab delimited/xls/etc.
Thank you. File opens OK in Excel 2007. Calc Rev. 1525015 not responding. Win 7
The document from comment 2 takes ages to open because it got some very long texts in some cells, 7208 characters. A xslx-file with one 7208 character long text cell takes half a minute on my machine, now multiply with several thousand fields. (maybe file new performance bug for this) ------------ please provide a new sample with shorter text in cells to avoid the performance bug. My Excel 2003 caps the lines at 65536 while your file has 70000 lines. I reduced the text to 268 characters like stated in comment 1 and saved as Excel 2007 xlsx -> AOO 4.0.1 and 3.4.1 open the new file just fine, all 65536 lines.
(In reply to Prosper Uniger from comment #4) > The document from comment 2 takes ages to open because it got some very long > texts in some cells, > 7208 characters. > > A xslx-file with one 7208 character long text cell takes half a minute on my > machine, now multiply with several thousand fields. > (maybe file new performance bug for this) > > ------------ > > please provide a new sample with shorter text in cells to avoid the > performance bug. > > My Excel 2003 caps the lines at 65536 while your file has 70000 lines. > I reduced the text to 268 characters like stated in comment 1 and saved as > Excel 2007 xlsx > -> AOO 4.0.1 and 3.4.1 open the new file just fine, all 65536 lines. Seems to be an issue with cells like you said. I've opened the new bug here per your advice: https://issues.apache.org/ooo/show_bug.cgi?id=123511 However if one were using only OpenOffice it would be difficult to trim the lines down before importing. And even if this were automatic it might loose valuable description data.