Bug 160780 - Scrolling in edit mode with row/col highlighting hides cell content
Summary: Scrolling in edit mode with row/col highlighting hides cell content
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.0.3 release
Hardware: All All
: medium normal
Assignee: Printf Debugging
URL:
Whiteboard: target:24.8.0
Keywords:
Depends on:
Blocks:
 
Reported: 2024-04-22 11:35 UTC by Heiko Tietze
Modified: 2024-05-02 07:32 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Heiko Tietze 2024-04-22 11:35:41 UTC
* Enable Tools > Options > Calc > View > Column/Row highlighting
* Go into edit mode, enter a few characters, and scroll up or down 
=> cell content is not visible anymore. Happens only for 

Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 32; OS: Linux 6.8; UI render: default; VCL: kf6 (cairo+xcb)
Locale: de-DE (en_US.UTF-8); UI: en-US
24.2.2-2
Calc: threaded

as well as for master but not gtk3. Neither when "Col/Row highlighting" is off.
Comment 1 ady 2024-04-22 18:08:18 UTC
It happens on Windows too with a recent LO 24.8 alpha.

After scrolling (down and up back again to the original on-focus cell), the content of the cell is not displayed while we are still in edit mode. To be clear, any (mouse) scrolling action generates this visual problem, as long as the scroll is performed using the mouse (wheel); moving by keyboard (arrows) does not seem to generate the same visual effect (e.g. when building formulas).

FWIW, the content of the cell can be briefly seen during the scrolling action, but it is not displayed on-cell once we stop scrolling. This is just a minor detail that has no useful effect on usage, but perhaps it helps in identifying the source of the problem.

The content of the formula bar window box is always displayed correctly at every moment.

After scrolling, we can continue typing-in/editing the cell; the on-cell content is correctly seen again in such case.

The situation could be relevant when building formulas, when you type a function and then, in order to select a cell/range as argument, you might need to navigate to some other area of the spreadsheet, or when selecting a cell/range located on another spreadsheet. While this could be annoying for many users, it is not as critical as it may sound, since the window box in the formula bar still shows the content of the cell that is being edited.

While still in cell's edit mode, when we change to another spreadsheet (to select a cell/range as argument of a function) and we go back to the original spreadsheet, the visual problem on-cell also occurs.

So the problem is not just when scrolling (by mouse) but also when we change to another spreadsheet and back to the original (e.g. when building a formula).
Comment 2 Printf Debugging 2024-04-23 12:13:16 UTC
ColumnRowHighlighting borrows most of the logic from selection. Selection shows the  same behaviour.
a) select a rectangular area of cells on the sheet (ColRowHighlighting can be on or off (doesn't matter))
b)start typing something. Then scroll the sheet. ==> SelectionHighlight also cover the edit cell's contents.
Comment 3 Commit Notification 2024-05-02 07:32:46 UTC
Printf Debugging committed a patch related to this issue.
It has been pushed to "master":

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

tdf#160780 Overlays should not cover EditView.

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.