Bug 167685 - Use the scroll bar for showing the 'used' range, and the arrows to expand the sheet
Summary: Use the scroll bar for showing the 'used' range, and the arrows to expand the...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
26.2.0.0 alpha0+ master
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsUXEval
Depends on:
Blocks:
 
Reported: 2025-07-27 10:37 UTC by Telesto
Modified: 2025-07-31 18:26 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Screencast Excel (404.55 KB, image/gif)
2025-07-27 10:38 UTC, Telesto
Details
Screencast LibreOffice (305.08 KB, image/gif)
2025-07-27 10:38 UTC, Telesto
Details
Screencast 365 Online (2.53 MB, image/gif)
2025-07-31 18:26 UTC, Telesto
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2025-07-27 10:37:51 UTC
Description:
Horizontal scrollbar: use the bar for showing the 'used' range, and the arrows to expand the sheet

Steps to Reproduce:
1. Open Calc
2. Press and hold left mouse click on horizontal scrollbar and drag it to the right. The maximum you can scroll right depends on the size of the window. In screencast AG
3. Release: scrollbar jumps to the middle again


Actual Results:
Scrollbar goes to the middle (which hard to asses the position with use range

Expected Results:
Use the end arrows to 'increase' the number of visible columns, similar to Excel (2003). This give far more control of the scroll experience, IMHO


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7f4868348c14b305fcd75744e1e3544d0d3a5d61
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded
Comment 1 Telesto 2025-07-27 10:38:17 UTC
Created attachment 202018 [details]
Screencast Excel
Comment 2 Telesto 2025-07-27 10:38:40 UTC
Created attachment 202019 [details]
Screencast LibreOffice
Comment 3 V Stuart Foote 2025-07-27 13:09:41 UTC
Not a fan. Happy with current modal scroll bar and the column movements of the L and R arrows on the bar.  Resize of the "thumb" linked to exposed viewport of the sheet is comfortable to use.

-1 => WF
Comment 4 Heiko Tietze 2025-07-31 07:32:58 UTC
Interesting issue. The thumb width usually indicates the total canvas size and is larger if you can scroll only a few pixels. And scrolling to the end goes to the very end of the canvas. In case of dynamic content, typically for infinite large pages, this behavior breaks the end position rather loads further content.

While I personally hate this overloaded misuse of scrollbars and think it's not necessary for Calc, the situation is worse in Excel where scrolling via thumb to the end never reaches the very end. You need to click the small thumb in order to go further (or use the keyboard).

The situation is the same for horizontal and vertical sccrollbars, adjusting the summary.
Comment 5 Telesto 2025-07-31 18:26:17 UTC
Created attachment 202101 [details]
Screencast 365 Online

Thumbs behaves differently in 365 compared to 2003

Couple of observations
* The thumbs scrolls back on hitting the bottom during drag (so you can keep dragging down a couple of times)
* Thumbs minimum size is larger (so even at row 1000.000)
* A single scroll wheel tick is 5 rows in Excel, 3 in Calc, bit faster is rather nice (although: there is bug 40917, increasing it might cause more problems at this point)