Bug 156655 - Long text in merged cells not painted
Summary: Long text in merged cells not painted
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Tibor Nagy
URL:
Whiteboard: target:24.8.0 target:24.2.3
Keywords:
Depends on:
Blocks: Calc-Merge-Split
  Show dependency treegraph
 
Reported: 2023-08-07 13:19 UTC by Gabor Kelemen (allotropia)
Modified: 2024-04-09 13:21 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Problematic document (24.42 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-08-07 13:19 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2023-08-07 13:19:19 UTC
Created attachment 188830 [details]
Problematic document

Attached document contains some formatted cells, with A21:A23 merged and containing a long word. The row 21 is hidden, and this causes the long text not appearing on screen/print preview/PDF export.

1. Open attached file
-> Notice there is a seemingly empty cell in A22:A23 - but if you click in it, the input bar shows it has text "Loremipsum", 90 degrees rotated. A bit of clicking inside the cells can make this appear, but only until you click out again.
Showing the row 21 fixes this behavior.

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 34387332173782498acd4998c7c665d04ebc3c7d
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: threaded

With or without Skia, and also under Linux with GTK3 and gen backends as well.
Happens in older versions as well way back to 3.3 - setting as inherited.
Maybe related to bug 150335 but not exactly the same behavior.
Comment 1 Telesto 2023-08-07 20:43:13 UTC
Confirm
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: b3053b63c65372627c5fb4df6b4ddcd5e12e16f7
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded
Comment 2 m_a_riosv 2023-08-09 03:07:21 UTC
I'm sure what we must expect when the first cell of a merged range is hidden.
Comment 3 Commit Notification 2024-03-14 00:09:36 UTC
Tibor Nagy committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/d5f25d9c0026ec06a0b46e1560e26adba2725290

tdf#156655 sc: fix disappear text in merged cell

It will be available in 24.8.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 4 Commit Notification 2024-04-07 19:39:19 UTC
Tibor Nagy committed a patch related to this issue.
It has been pushed to "libreoffice-24-2":

https://git.libreoffice.org/core/commit/09a055c7457b005e1d7c733dc951dd8469c75411

tdf#156655 sc: fix disappear text in merged cell

It will be available in 24.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 5 Gabor Kelemen (allotropia) 2024-04-09 13:21:19 UTC
Verified in:

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 432c866072aa62cf90168d569dc56cbc7269bcda
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: default