https://bugs.documentfoundation.org/show_bug.cgi?id=118006
--- Comment #13 from Dennis Roczek <[email protected]> --- Well you are picking the rare corner cases. (In reply to Devansh Varshney from comment #11) > The limitations and challenges in importing large Quattro Pro (.qpw) files > into other spreadsheet applications like Excel and OpenOffice.org (now > Apache OpenOffice and LibreOffice). > > 1. Quattro Pro's .qpw format supports larger spreadsheet sizes compared to > pre-2007 Excel format: > > a. .qpw format: 18,276 columns x 1,000,000 rows > b. Pre-2007 Excel format: 256 columns x 65,536 rows > > 2. Even with the newer Excel 2007 format (16,384 columns x 1,000,000 rows), > it still falls short of accommodating the maximum sizes supported by Quattro > Pro. > > 3. OpenOffice.org (and its successors) have been using the old Excel file > format limitations, which poses challenges when importing large Quattro Pro > sheets. OpenOffice does still have these limitations (or better saying not support the full 2007+ OOXML row limit), LibreOffice did increase for 7.4 the support for the number of lines (1.048.576 lines x 16.384 columns). Even somebody used that many lines, I believe we finally added some warning that LibreOffice is not able to pick every line/columns from the file. > From OOo BZ - > > https://bz.apache.org/ooo/show_bug.cgi?id=30215 (Support 1048576 rows) > https://bz.apache.org/ooo/show_bug.cgi?id=5460 (Corel Quattro Pro import > filter/file open) > > > > Some points for me - > > 1. We have to ensure that the import filter can handle the maximum > spreadsheet sizes supported by the .qpw format (18,276 columns x 1,000,000 > rows). Don't. I believe it is still a rare corner case and should be used at the end as file format stuff is much more important (better import nearly everything with as much as possible features than import all lines without any features) ;-) -- You are receiving this mail because: You are the assignee for the bug.
