Description: Quattro Pro opened qpw files have rendering problems, slanted, and overrunning text. Have several Quattro Pro spreadsheet files from 2006, qpw extension. Opened several in the regularly-installed LibreOffice Calc version 7.5.3.2 (x86_64, Windows), and some in the standalone LibreOfficePortable_7.5.3_MultilingualStandard.paf.exe version. Rendering problems with text. Slanted text from column D onwards. Cells not the right width in slanted area. Print rendering shows similar distortions (selecting to print, and actual printing on paper shows it too). FORMATTING PRINTING UI Steps to Reproduce: 1. Open a Quattro Pro qpw file using Calc. 2. Notice how all text beyond column C is actually slanted upwards. 3. Notice how the column widths don't look correct ether. 4. Select to print. 5. See how the print preview has similar slanting. 6. Print onto paper. 7. Acted printed on paper version has similar textual slanting and wrong column widths. Actual Results: Slanted text (slanting upwards from the horizontal) on most text to the right of column C. Slanding is shown during direct sheet editing, and print preview, and printing. Column wides look too small for the parts of the sheet where the text is slanted. Expected Results: A normal looking sheet. Reproducible: Always User Profile Reset: Yes Additional Info: https://gerrit.libreoffice.org/gitweb?p=core.git;a=log;h=9f56dff12ba03b9acd7730a5a481eea045e468f3
Created attachment 187682 [details] Example screen clip showing the problem.
Created attachment 187683 [details] Another example screen clip
Created attachment 187684 [details] Quattro Pro native qpw file which when opened with Calc, shows rendering distortions & column width issues in Calc
Created attachment 187685 [details] Another example Quattro Pro native file showing the problem
Created attachment 187686 [details] Several Quattro Pro files showing the problem when opened with Calc
Confirmed. Let's change product as Quattro Pro is handled by libwps of Document Liberation Project. Arch Linux 64-bit, X11 Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5af44a176d2a738dd7523713202aeee27c5578b6 CPU threads: 8; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 11 August 2023
On pc Debian x86-64 with master sources updated today, I could reproduce this. Laurent: thought you might be interested in this one.
Thank you for these files. They were created with a version of Quattro Pro (for which I didn't have any files), the size of the cell styles is 31 bytes, whereas until now I've only had files with 30 bytes (the oldest) or 36 bytes (the new ones). So I'm going to add some new code to handle them. Notes: - if the new files seem to have a simple version number, 12, 13 ... 19. For the old ones, it's more complicated: I've found another number: 528 oldest files ( 30 bytes ), 233 these files (31 bytes). I'll use the latter number as a basis and add a heuristic to guess the field size when I don't have any information (and when something seems bad). - concerning the weird display, with the problem of reading styles, a 3° rotation was returned; I'll look later at why the rendering is weird for such rotation, maybe a field to be added by libodfgen when it detects a rotation?