Bug 140599

Summary:	EDITING Row and column highlight cleared when selection moves over a filtered row
Product:	LibreOffice	Reporter:	NISZ LibreOffice Team <libreoffice>
Component:	Calc	Assignee:	Tünde Tóth <tundeth>
Status:	VERIFIED FIXED
Severity:	normal	CC:	nemeth, tundeth
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:	target:7.2.0
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	103512, 109139
Attachments:	Example file from Calc The example file after selecting two visible cells. The example file after extending the selection to a hidden cell.

Description NISZ LibreOffice Team 2021-02-22 13:52:49 UTC

Created attachment 169963 [details]
Example file from Calc

Selection of cells stops highlighting the row and column headers when some rows hidden with autofilter get selected.

Steps to reproduce:
    1. Open attached file, it has a few values and one of them is hidden with an autofilter
    2. Click in A2 and press Shift+Down to highlight A3 as well
    3. Notice the row headers and column header is highlighted with blue background and white text
    4. Press Shift+Down again to highlight A4 too, which is hidden by autofilter

Actual results:
The row and column headers lose their highlighting.

Expected results:
Row and column headers are still highlighted.

LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 385808a2dff7300ec0120fdd5e8acfad8f86e50d
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-GB
Calc: CL

Also happens in: 7.0, 6.0, 5.0, 4.0, 3.5.

Comment 1 NISZ LibreOffice Team 2021-02-22 13:53:15 UTC

Created attachment 169964 [details]
The example file after selecting two visible cells.

Comment 2 NISZ LibreOffice Team 2021-02-22 13:53:35 UTC

Created attachment 169965 [details]
The example file after extending the selection to a hidden cell.

Comment 3 Commit Notification 2021-02-24 09:52:52 UTC

Tünde Tóth committed a patch related to this issue.
It has been pushed to "master":

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

tdf#140599 calc UI: fix row and column highlight

It will be available in 7.2.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 NISZ LibreOffice Team 2021-03-10 07:03:41 UTC

Verified in:

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 72841008bf422dfd8553240b3a78f0474d03523c
CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: hu-HU
Calc: threaded Jumbo