Bug 160485 - FILESAVE: Some Cells Text missing in EXPORT.png with highresolution.
Summary: FILESAVE: Some Cells Text missing in EXPORT.png with highresolution.
Status: RESOLVED DUPLICATE of bug 137263
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-02 15:08 UTC by Rainer Bielefeld Retired
Modified: 2024-05-15 16:21 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Test Kit (394.02 KB, application/x-zip-compressed)
2024-04-02 15:08 UTC, Rainer Bielefeld Retired
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2024-04-02 15:08:30 UTC
Created attachment 193436 [details]
Test Kit

Steps how to reproduce with Server Installation of Version: 24.8.0.0.alpha0+ (X86_64)
Build ID: 2146e66d8df2b7b6a2dd868e886cae76aaf7f48b
CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE; Theme: Colibre
Calc: threaded – normal Test Profile created from 7.6 and also newly created User Profile

0. Download and unzip TestKit
1. Open SampldDocument.ods
2. Click cell CX3 and with select range  CX3 - A1
3. Release Mouse Button
   » Area keeps highlighted / selected
4. Menu ˋFile → Export → Format = PNG → (Keep Auto-Filename-Extension and
   "Selection" checked → Exportˊ
   » Export Dialog appears
5. ˋRadio button "Modify Dimensions" → in Width add a "0" left from comma → <TAB> for reaching Height fieldˊ
   » Height value also becomes more or less ten times as much, similar to 
     width.
6. ˋKeep resolution at 96 px/inch → Interlaced and Transparency unchecked,
    Compression = 9 → [ok]ˊ
   » PNG will be created
7. Open PNG in IrfanVIEW
   Expected: looks as SampldDocument.png from TestKit, all text contents
   included 😉
   Actual: Text in row 2 is missing as in SampldDocument_HR.png from test kit.
Comment 1 Armondo Lopez 2024-04-03 21:23:28 UTC
I wasn't able to reproduce the same behavior in 

Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

or

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Attempting to reproduce the bug results in a PNG file that is corrupted.
Comment 2 Rainer Bielefeld Retired 2024-04-04 05:14:32 UTC
(In reply to Armondo Lopez from comment #1)
What kind of corruption?
Comment 3 Armondo Lopez 2024-04-10 21:34:42 UTC
The file itself was corrupted, so I was unable to access the PNG file whatsoever.
Comment 4 ady 2024-04-10 23:03:14 UTC
The STR in comment 0 are slightly inaccurate, but anyway...

(In reply to Rainer Bielefeld Retired from comment #0)

> 5. ˋRadio button "Modify Dimensions" → in Width add a "0" left from comma →
> <TAB> for reaching Height fieldˊ
>    » Height value also becomes more or less ten times as much, similar to 
>      width.

The problem is the value for this pair of fields. With a higher value in the "Width" field, the content of the cells is exported "too high", moving it upwards (as opposed to keeping the content of the cells within the cell's limits).

This is probably caused by the "angle" of the content (80 degrees), or by not being horizontal text.

This seems to be the reason for the incorrect export if the cell's content.

NOTE: the problem only happens when Interlaced and Transparency are both _unchecked_.

Now, the following step:

> 6. ˋKeep resolution at 96 px/inch → Interlaced and Transparency unchecked,
>     Compression = 9 → [ok]ˊ
>    » PNG will be created

... is inaccurate. Either you set the Width/Height fields, or the resolution ratio. When you modify both alternative settings, one of them has to be adapted.



>    Actual: Text in row 2 is missing as in SampldDocument_HR.png from test
> kit.

The content of the cells is not missing; it is exported but not within the cell, because of the non-horizontal content of the cells.

If you don't modify the Width/Height fields, you should see the cell's content. If you make the values slightly higher than the original, the cell's content "moves up" in the exported PNG. Make a third export with even higher values... Repeat several exports with higher values each time, and you should see the cell's content "moving" upwards, until it is not seen.

Please let me repeat: the problem only happens when Interlaced and Transparency are both _unchecked_.


I would suggest to modify the Summary field of this report accordingly to my findings.

(In reply to Armondo Lopez from comment #3)
> The file itself was corrupted


If the original value of the Height field is "too big" (e.g. multiply the original value by 100 instead of by 10), then the resulting png is corrupted.
Comment 5 Armondo Lopez 2024-04-11 01:30:25 UTC
Ah. You are correct. I was able to reproduce the same behavior in the versions I listed above. I see what you're saying when it comes to the values of the various fields contributing to the information being missing.
Comment 6 Stéphane Guillou (stragu) 2024-05-15 16:21:18 UTC
This is the same issue as bug 137263: some text does not get scaled with the rest. Bug 137263 is originally about wrapped text, but let's include rotated text in it too.

*** This bug has been marked as a duplicate of bug 137263 ***