Created attachment 142530 [details] some QPW9 files Hello, as I am adding a filter to convert QPW files in libwps, and I only have some Quattro Pro 9 files (and maybe some Quattro Pro 12 files), I am looking for sample documents created by more recent versions of Quattro Pro: - either to add code to convert them, - or to check that the filter will not try to convert them (if the result is too incomplete). Notes: - the code to convert .qpw9 files can be found in the current source of libwps (if someone want to improve it), so it will probably appear in LibreOffice 6.2, - I attach a zip files which contains some QPW9 files: + some of these files are test files (resaved in QPW9) found on bugzilla, or bz.apache.org, ... ; + passwordtoto.qpw is a small protected file with the password toto, + others are personal test files which makes no sense. If someone can open them in some newest version of Quattro Pro and "save as" them to get new version files, it will be easier to see what changes between each version. - in all cases, knowing the version of QPW which creates a file is "a plus".
Hi oslona, I've done a public call for documents in the dev/qa/project mailing list [1] and in Telegram. [1] http://document-foundation-mail-archive.969070.n3.nabble.com/Libreoffice-qa-Looking-for-Quattro-Pro-qpw-files-td4243343.html
Thank for the public call :-) Note: - I compiled recently an online version of libwps with emscripten: http://libwps.sourceforge.net/convertWPS.html which can be used to test which files are currently converted, what problem/bug exist, ...
Created attachment 143385 [details] files resaved with Quattro pro x9
Created attachment 143661 [details] file Quattro pro x9
Putting to NEW
I don't know if the conversion of SheetColor.qpw is correct; but the other files seem to open correctly in LibreOffice 7.0. Maybe we can close this bug report.
Is this related to the request of this enhancement request? https://wiki.documentfoundation.org/Development/GSoC/Ideas_without_a_mentor#Implement_Quattro_Pro_Import_filter http://web.archive.org/web/20021022012118/http://www.corel.com/partners_developers/ds/CO32SDK/docs/qp7/Qpf2intr.htm
Is this related - https://tika.apache.org/2.9.0/api/org/apache/tika/parser/wordperfect/QuattroProParser.html also, http://web.archive.org/web/20021023090332/http://www.corel.com/partners_developers/ds/CO32SDK/docs/qp7/qpf3recd.htm contains documentation for the Quattro Pro 7 file format, which is different from the .qpw format used in more recent versions of Quattro Pro?
This seems related: - when I tried to add .qpw support, it was to extend the previous quattro pro file filter that converted .wb2, .wb3, ... - I'm not sure, but Quattro Pro 7 seems to create .wb3 files, so there must already exist a filter in liwbps (at least that's the impression I get from looking at the format documentation). It's probably not perfect, but if it is, it would be useful to have files that haven't been converted.
I did get the idea that have to make a new class(file) qpwimport.cxx to handle the parsing for this format? Moreover, I did found this discussion - https://forum.openoffice.org/en/forum/viewtopic.php?p=33845&sid=b23aa0956bbc019ec892a2135aba2a90#p33845
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.
I hope I'm not talking too much nonsense, I'm getting old. If I remember correctly, OpenOffice had a filter for old QuattroPro files at least .wb2 ( which also opened some .wb3 files because the format hadn't evolved much ) and maybe .wq1 and .wq2 files ( not sure) This filter disappeared when the filters written in java were removed. I have since rewritten filters for .wq1-2, .wb1-3 and qpw (at least the first files, the .qpw format may have evolved since then) in libwps... This filter can undoubtedly be improved.
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) ;-)
(In reply to Dennis Roczek from comment #13) > Well you are picking the rare corner cases. Understood. I would like to take this but maybe first I will close my some almost complete PRs first https://gerrit.libreoffice.org/q/owner:varshney.devansh614@gmail.com Moreover, I have also requested to work on the support of the Histogram chart (if I get selected) else the Box and Whisker chart in LO. :) But, if time permit how would I first approach this? By introducing the similar structure of the code as it's already there for the .wb* file formats for the qpw files. Then eventually add the support for the formats which are there in the qpw files. I mean creating the new set of source files for the .qpw filter, such as qpw.cxx, qpwform.cxx, and qpwstyle.cxx, in the same directory sc/source/filter/qpro . First might look like - a. Identifying and validating the .qpw file format. b. Reading the file header and extracting relevant information. c. Parsing the file structure and identifying the different components. TL;DR - how do I approach this?
Check https://github.com/Distrotech/libwps This is the library in question. (Hope i provided the correct reprository. Or did we finally migrathe that to TDF Servers?)
The correct repository is https://sourceforge.net/projects/libwps/ The parsers can be found in - src/lib/QuattroDos* : .wq1-.wq2 - src/lib/Quattro9* : .qpw - src/lib/Quattro* (not followed by 9 or Dos ) : .wb1-.wb3
Thank you. I will try do this and I and currently working on the support of Histogram chart in LO :)