https://bugs.documentfoundation.org/show_bug.cgi?id=118006
--- Comment #11 from Devansh Varshney <[email protected]> --- 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. >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). 2. Implement the necessary parsing and data extraction logic to read and interpret the .qpw format correctly, considering any format-specific features and record types. 3 .Map the imported data accurately to the corresponding cells, formulas, and formatting in LibreOffice Calc, taking into account any differences in the way data is represented between the two formats. 4. Optimize the import process to handle large spreadsheets efficiently, considering memory usage and performance. 5. Thoroughly test the import filter with a wide range of .qpw files, including large and complex spreadsheets, to ensure robustness and reliability. -- You are receiving this mail because: You are the assignee for the bug.
