Bug 97616 - Calc conditional formatting: fast scrolling down and up shows borders that shouldn't be there
Summary: Calc conditional formatting: fast scrolling down and up shows borders that sh...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: x86-64 (AMD64) All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2016-02-07 11:24 UTC by Aldo
Modified: 2024-07-24 03:14 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
ods file (17.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-07 11:24 UTC, Aldo
Details
Image of the proper situation (294.98 KB, application/pdf)
2016-02-07 19:14 UTC, Aldo
Details
File ods (15.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-08 09:44 UTC, Aldo
Details
image of the screen (217.94 KB, image/jpeg)
2016-02-08 09:47 UTC, Aldo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Aldo 2016-02-07 11:24:27 UTC
Created attachment 122422 [details]
ods file

If A5 A420 <> 1, applies style 'In Evidenza', with lined cells.

Scrolling down and up, they appear some edges that should not appear.

Sorry for my english.

Can I write Italian?
Comment 1 Aldo 2016-02-07 19:14:13 UTC Comment hidden (obsolete)
Comment 2 Aldo 2016-02-07 19:27:30 UTC Comment hidden (obsolete)
Comment 3 m_a_riosv 2016-02-07 20:58:53 UTC
HI @Aldo, thanks for reporting.

Sorry but the only language here is the English.

The conditional format in your file works fine, for the range specified.

Cells A4 and A421 has there own direct format and has nothing to do with the Conditional Format. Doing a [Ctrl+M] or Menu/Format/Clear direct formatting on this cells. Be care if you make [Ctrl+M] on the whole cells then you clear the CF.

Resolved as notabug, please if you are not agree reopen it.

You can find help in Italian in Ask and in Mailing list:

https://ask.libreoffice.org/it/questions/
Comment 4 Aldo 2016-02-08 09:44:09 UTC
Created attachment 122432 [details]
File ods
Comment 5 Aldo 2016-02-08 09:47:48 UTC
Created attachment 122433 [details]
image of the screen

This is what I see on the screen
Comment 6 Aldo 2016-02-08 09:59:25 UTC
Thanks, but the problem continues


If I delete the conditional formatting, the problem disappears.

On the cells there is no direct formatting with the edge.
Comment 7 Aldo 2016-02-08 10:10:38 UTC
If only the border erase by formatting style used in the conditional formatting, the problem disappears.
Comment 8 Markus Mohrhard 2016-03-26 18:09:41 UTC
Looks like a simple fix.
Comment 9 Xisco Faulí 2017-09-21 08:49:04 UTC Comment hidden (obsolete)
Comment 10 QA Administrators 2018-09-22 02:44:13 UTC Comment hidden (obsolete)
Comment 11 Xavier Van Wijmeersch 2018-09-22 09:02:00 UTC
I did find a lot of exel formatting in the right status bar; styles and formatting cell's
Changing 'cell value is not equal to 1' to 'formula is A1<>1' give no appearing lines

So for me not a bug

Best regards

Version: 6.2.0.0.alpha0+
Build ID: 11a229c0094979b4980d8e3be8a8a7db60d01be7
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: threaded
Comment 12 Timur 2019-01-14 12:55:29 UTC
No repro 4.3. Repro with LO 4.4 and 6.3+. Looks like regression.
Comment 13 Buovjaga 2020-06-05 12:28:36 UTC
Bibisected with Linux 44max repo to https://git.libreoffice.org/core/+/642d64d8fe54b7577fb4184f1ad6e0e8b3f809c4%5E!/
scrolling very slow in calc
Comment 14 Timur 2020-07-23 15:00:59 UTC Comment hidden (obsolete)
Comment 15 Buovjaga 2020-07-23 15:36:38 UTC
(In reply to Timur from comment #14)
> Buovjaga, and reason you didn't CC the author you found by bibisect?

Because it concerns reverting a bunch of commits by Kohei and we don't add Kohei to regressions.
Comment 16 QA Administrators 2022-07-24 03:32:13 UTC Comment hidden (obsolete)
Comment 17 QA Administrators 2024-07-24 03:14:50 UTC
Dear Aldo,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug