Description: Merged cells that go beyond the current view, have their borders disappear while they are not fully shown in some circumstances. It seems to affect printed documents as well, manifested when the merged cell goes beyond the page. Steps to Reproduce: 1. New Calc document 2. Merge enough cells from the B column such that they exceed screen height. It's not needed to start at the top. For example, if the spreadsheet is currently showing 30 rows, merge from B20 to A35 or so. 3. Apply full border to the merged cell. 4. Select another cell so the border is clearly on view. 5. Even if the border is not shown, scroll down so the full merged cells gets on view. Actual Results: The border is not shown when the merged cell goes beyond view through the bottom side. The border is shown when the merged cell is fully on view or it goes beyond through the top side. Expected Results: The border should be always shown. Reproducible: Always User Profile Reset: Yes Additional Info: This affects printing as well. I tested it horizontally and it happens as well: if the merged cell goes beyond view through the right side, its borders are not shown. Not seen in 7.6 Seen in 24.2 and 24.8-alpha.
Forgot my version information: Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: da48488a73ddd66ea24cf16bbc4f7b9c08e9bea1 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded OpenCL is not used. Hardware acceleration is disabled. Tried with a new profile.
Repro with recent 24.8 alpha on Windows too, with or without Skia.
Repro with: Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: 420(Build:3) CPU threads: 16; OS: Linux 6.7; UI render: default; VCL: gtk3 Locale: es-MX (en_US.UTF-8); UI: en-US 24.2.0-1 Calc: threaded
To be clear, this doesn't happen in 7.6.3.2. > regression.
Created attachment 192718 [details] Reproducible on Windows 11, Lib 24.2
I believe I bibisected it to this commit: https://cgit.freedesktop.org/libreoffice/core/commit/?id=e27d4cc31e04be4c47b5085dfa2363ee45457e8a (Hopefully I did this correct. Only my 2nd bibisect ever.) I tested in on Windows + followed the video attachment 192718 [details]'s instructions exactly. Could not reproduce in the 7.6 branch, but could in the 24.2 branch. - - - - - - - author Noel Grandin <noel.grandin@collabora.co.uk> 2023-06-19 12:23:55 +0200 committer Noel Grandin <noel.grandin@collabora.co.uk> 2023-06-19 18:26:03 +0200 commit e27d4cc31e04be4c47b5085dfa2363ee45457e8a (patch) tree 75aebab2bd9a0c2d0f152fb545757af0513f5aec parent 281bdb5a979f0516fe7a9cd35585fd3daf4021b1 (diff) tdf#150534 reduce the memory consumption of cells when calculating borders - if there are a lot hidden columns, we end up allocating a lot of cells. Since most of the cells have the same settings, use a SfxItemPool to consolidate them. Change-Id: If2dd77b3eabc5d37eb8804953f8c89ffa04f2400 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/153258 Tested-by: Jenkins Reviewed-by: Noel Grandin <noel.grandin@collabora.co.uk>
(In reply to Tex2002ans from comment #6) > I believe I bibisected it to this commit: > > https://cgit.freedesktop.org/libreoffice/core/commit/ > ?id=e27d4cc31e04be4c47b5085dfa2363ee45457e8a > > Could not reproduce in the 7.6 branch, but could in the 24.2 branch. Let's CC' Noel then.
I think the wrong Metabug was accidentally used: - 102998 = Mail Merge vs.: - 108320 = Calc cells merging and splitting bugs I fixed it. :)
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6f8a73a379d97829080367b21d54f9b5fab781c9 tdf#161019 tdf#159846 spreadsheet border rendering 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.
Noel Grandin committed a patch related to this issue. It has been pushed to "libreoffice-24-2": https://git.libreoffice.org/core/commit/ab69de0e0aa0c9e48355c9db36c8aa9b93f235d4 tdf#161019 tdf#159846 spreadsheet border rendering It will be available in 24.2.4. 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.
*** Bug 160693 has been marked as a duplicate of this bug. ***