Bug 164683 - "Whole sheet Export" does not export text that overflows from columns
Summary: "Whole sheet Export" does not export text that overflows from columns
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: PDF-Export
  Show dependency treegraph
 
Reported: 2025-01-13 09:47 UTC by Saburo
Modified: 2025-01-13 18:12 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Saburo 2025-01-13 09:47:59 UTC
Description:
If a1:b1 is merged, or if the text simply goes beyond cell A1, it will not be exported.

Steps to Reproduce:
1.Enter "AA" in cell A1 and set the font size to 80pt.
2.Merge cells A1 and B1.
3.File - Export as PDF , Check "Whole sheet export" and export.

Actual Results:
A and part of A were output.

Expected Results:
AA is output.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c9ae567c791bcffdc3fff9e3fb11b46275a13d2b
CPU threads: 12; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded

This was posted on ask.
https://ask.libreoffice.org/t/calc-pdf-pdf/116431https://ask.libreoffice.org/t/calc-pdf-pdf/116431
Comment 1 TANAKA Hidemune 2025-01-13 12:25:12 UTC
It has been reproduced.

Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 24; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Calc: threaded
Comment 2 Shinji Enoki 2025-01-13 12:30:59 UTC
Reproduced in

Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP
Calc: threaded


However, it was not reproduced when there was data in two cells.

The original discussion of this issue is as follows:
https://ask.libreoffice.org/t/calc-pdf-pdf/116431/
Comment 3 Shinji Enoki 2025-01-13 12:39:02 UTC
Is it the intention to export only the area of ​​cells that contain data? I think it is an option to export multiple sheets.
Comment 4 Shinji Enoki 2025-01-13 12:44:44 UTC
Once the problem occurs, it will reoccur even if it export with "Export entire sheet" unchecked. However, the problem does not reoccur if it export again.
Comment 5 TANAKA Hidemune 2025-01-13 12:51:41 UTC
Although it says "export the entire sheet," 
it also looks like it's "exporting the entire workbook," 
and I suspect this is a feature that was added by mistake during implementation.
Comment 6 Shinji Enoki 2025-01-13 12:53:03 UTC
(In reply to Shinji Enoki from comment #4)
> Once the problem occurs, it will reoccur even if it export with "Export
> entire sheet" unchecked. However, the problem does not reoccur if it export
> again.


Sorry, I was mistaken about this comment; it is reflected correctly if I turn off the option.
Comment 7 Shinji Enoki 2025-01-13 14:14:28 UTC
(In reply to Shinji Enoki from comment #3)
> Is it the intention to export only the area of ​​cells that contain data? I
> think it is an option to export multiple sheets.

I read the help and it seems to be an option to force various things to be displayed. And according to the help, it seems that displaying only cells with data is the intended effect.

This is a pretty special option, and it seems dangerous to turn it on in general. But it's very hard to understand that from the UI label.