Bug 160654 - drawing of cell borders severely broken (appearing/disappering) as one scrolls through columns
Summary: drawing of cell borders severely broken (appearing/disappering) as one scroll...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Freeze
  Show dependency treegraph
 
Reported: 2024-04-13 16:03 UTC by Christoph Anton Mitterer
Modified: 2024-09-26 02:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example A (86.68 KB, image/jpeg)
2024-04-13 16:03 UTC, Christoph Anton Mitterer
Details
Example A (with border dialogue) (148.35 KB, image/jpeg)
2024-04-13 16:04 UTC, Christoph Anton Mitterer
Details
Example B 0 (leftmost) (139.92 KB, image/jpeg)
2024-04-13 16:04 UTC, Christoph Anton Mitterer
Details
Example B 1 (136.00 KB, image/jpeg)
2024-04-13 16:05 UTC, Christoph Anton Mitterer
Details
Example B 2 (137.44 KB, image/jpeg)
2024-04-13 16:05 UTC, Christoph Anton Mitterer
Details
Example B 3 (139.81 KB, image/jpeg)
2024-04-13 16:05 UTC, Christoph Anton Mitterer
Details
Example B 4 (139.61 KB, image/jpeg)
2024-04-13 16:06 UTC, Christoph Anton Mitterer
Details
Example B 5 (rightmost) (132.58 KB, image/jpeg)
2024-04-13 16:06 UTC, Christoph Anton Mitterer
Details
Test File (24.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-04-14 21:24 UTC, Christoph Anton Mitterer
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Christoph Anton Mitterer 2024-04-13 16:03:47 UTC
Created attachment 193657 [details]
Example A

Hey.

Since a few releases (unfortunately I forgot when it started, but it must have been something like one or two bigger releases *before* you've started with the new versioning schema (24.xxx), I see some major rendering problems with cell borders in calc.

It's rather hard do describe, so I'm going to attach a series of screenshots which should show quite well what's happening.
The screenshots are ordered, they're all from the very same document and no editing is done to that while I was doing the screenshots. I only scroll (using the scroll bars) from left to right.

It's from an actual document of mine, with most text removed however for privacy reasons.
I do use frozen columns/rows (the first column, and the few first rows, but it seems even disabling that doesn't change anything).

I did of course verify whether the the frames are correctly set, and also made the screenshot of that for one example (when doing Ctrl-1).

There are screenshots from two different sheets (marked with a and b).


Thanks,
Chris.
Comment 1 Christoph Anton Mitterer 2024-04-13 16:04:27 UTC
Created attachment 193658 [details]
Example A (with border dialogue)
Comment 2 Christoph Anton Mitterer 2024-04-13 16:04:54 UTC
Created attachment 193659 [details]
Example B 0 (leftmost)
Comment 3 Christoph Anton Mitterer 2024-04-13 16:05:11 UTC
Created attachment 193660 [details]
Example B 1
Comment 4 Christoph Anton Mitterer 2024-04-13 16:05:42 UTC
Created attachment 193661 [details]
Example B 2
Comment 5 Christoph Anton Mitterer 2024-04-13 16:05:56 UTC
Created attachment 193662 [details]
Example B 3
Comment 6 Christoph Anton Mitterer 2024-04-13 16:06:08 UTC
Created attachment 193663 [details]
Example B 4
Comment 7 Christoph Anton Mitterer 2024-04-13 16:06:28 UTC
Created attachment 193664 [details]
Example B 5 (rightmost)
Comment 8 m_a_riosv 2024-04-13 20:46:49 UTC
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Comment 9 Armondo Lopez 2024-04-14 20:31:03 UTC
Thank you for reporting the bug. 

Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. 

(Note that the attachment will be public, remove any sensitive information before attaching it. 

See <https://wiki.documentfoundation.org/QA/FAQ#sanitize> for further detail.)
Comment 10 Christoph Anton Mitterer 2024-04-14 21:24:19 UTC
Created attachment 193675 [details]
Test File
Comment 11 Christoph Anton Mitterer 2024-04-14 21:25:01 UTC
Added the testfile (with content, conditional formattings and the likes removed - but the problem still occurs).
Comment 12 Christoph Anton Mitterer 2024-04-14 21:28:10 UTC
btw: The wiki you referred to missed IMO at least one place where private information could still be contained:

Conditional Formattings

These may easily contain strings or so...
Comment 13 m_a_riosv 2024-04-14 21:47:16 UTC
Seems the issue is in relation with Menu/View/Free, disabling it looks it works properly.

Reproducible
Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
and
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d76f1877f699c91f5e4a020641c6d65064bfb997
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 14 Christoph Anton Mitterer 2024-04-14 22:38:05 UTC
> Seems the issue is in relation with Menu/View/Free,
> disabling it looks it works properly.

As said in the original report, I'm afraid it also happens with Freezing disabled.

That only seems to fix the rendering of that one "cell" on the first sheet.

Please have a look at the 2nd sheet ("Data") and there scroll right up to at least that purple area... for me, with and without freezing, lines vanish and re-appear.
Comment 15 m_a_riosv 2024-04-14 22:48:11 UTC
Ok, merged cells also get the issue. Unmerging them shows the borders.
Comment 16 ady 2024-05-31 22:14:50 UTC
IINM, this is no longer reproduced in recent LO 24.8 alpha.

In that case, finding which commit solved the visual problem and then back-porting it to LO 24.2 might be desired.
Comment 17 Christoph Anton Mitterer 2024-05-31 22:19:07 UTC
24.8.0~alpha1 currently waiting in Debian's NEW queue... I may verify this once it has passed (too lazy for building it manually O:-) ).

From my side, a backport wouldn't be needed.
Comment 18 Christoph Anton Mitterer 2024-09-25 11:30:46 UTC
AFAICS, this has already been fixed in Version: 24.2.6.2  (or maybe Debian just cherry picked the fix).

It also still works in 24.8.2.1.

Thanks for fixing!