Bug Hunting Session
Bug 125313 - Interefence with sheet tabs when scrolling horizontal bar
Summary: Interefence with sheet tabs when scrolling horizontal bar
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Sheet-Tabs-Bar
  Show dependency treegraph
 
Reported: 2019-05-15 16:01 UTC by zexcel
Modified: 2019-05-22 15:17 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
multi-spreadsheets workbook user is nervous on pointing horizontal scrolling bar (91.70 KB, image/png)
2019-05-18 12:12 UTC, zexcel
Details
even the MS Windows desktop environment allow adjustment of scrollbar width (99.31 KB, image/png)
2019-05-18 15:02 UTC, V Stuart Foote
Details
20 sheet workbook of random numbers to test with (182.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-05-18 15:31 UTC, V Stuart Foote
Details
Legacy side by side layout of sheet tags and scroll bar (107.02 KB, image/png)
2019-05-19 03:55 UTC, zexcel
Details
distinguish scroll bar zone from the area of sheet tags and cells (81.94 KB, image/png)
2019-05-19 03:58 UTC, zexcel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description zexcel 2019-05-15 16:01:58 UTC
・Miss moving sheet tab happens frequently when horizontally scrolling. 

 I am working on a project with 10+ worksheets. One of them fulls the columns from A to Z.

 Unlike excel, which sets its horizontal scrollbar aside of sheet tabs, calc's one is above the sheets tabs.
Comment 1 V Stuart Foote 2019-05-16 09:43:23 UTC
The GUI for Calc and Draw used to be laid out this way. But because height of scroll bar widgets varies by os/DE, for bug 36772, it was decided to split the scroll bar and the tab bar for the worksheets onto separate rows--decoupling the widget heights for the tabs from the scrollbars.
Comment 2 zexcel 2019-05-18 12:12:29 UTC
Created attachment 151495 [details]
multi-spreadsheets workbook user is nervous on pointing horizontal scrolling bar
Comment 3 zexcel 2019-05-18 12:18:20 UTC
Thank you for giving the historical background.
Yes, a 3 some spreadsheets workbook is the most popular case, as showed in attached file in bug 36772. 

 ・Does it possible keep the current bar height(or area efficiency) and layout back legacy to be compatible with multi-spreadsheets users?
Comment 4 V Stuart Foote 2019-05-18 15:02:33 UTC
Created attachment 151502 [details]
even the MS Windows desktop environment allow adjustment of scrollbar width

(In reply to zexcel from comment #3)
> ...
>  ・Does it possible keep the current bar height(or area efficiency) and
> layout back legacy to be compatible with multi-spreadsheets users?

No. And that is the point. If your os/DE settings are uncomfortable, here your thin width of the scrollbar for target of mouse pointer movement with multisheet workbooks, adjust it.

Even the MS Windows DE support this []1. The attached clip show scrollbar with 20px width on left, and scrollbar with 17px default on right.

Looks like you have your DE set to show ~10px scrollbar--adjust it.

So, agian NAB and => WF as this is reasonable expected user configuration of their DE.

=-ref-=
[1] regedit change to ScrollHeight/ScrollWidth in
HKCU\Control Panel\Desktop\WindowMetrics  (e.g. -15 * 17 = -255 default, -15 * 20 = -300)
Comment 5 V Stuart Foote 2019-05-18 15:07:21 UTC
Lets bounce this off the rest of the UX team. Anyone have a different spin on the WF of what are clearly os/DE settings for user to make?
Comment 6 V Stuart Foote 2019-05-18 15:31:47 UTC
Created attachment 151504 [details]
20 sheet workbook of random numbers to test with
Comment 7 Tomaz Vajngerl 2019-05-18 15:43:54 UTC
There is "TabBarInlineWithScrollbar" in expert configuration, which will bring back the previous behaviour if set to true.
Comment 8 V Stuart Foote 2019-05-18 15:48:00 UTC
Oh, and I had forgotten about the expert configuration option "TabbarInlineWithScrollbar" that joins the tab bar and scroll bar back onto the same line. But I would not enable that with more than a few sheets in a workbook.

Even more weight as NAB and WF...
Comment 9 zexcel 2019-05-19 03:55:56 UTC
Created attachment 151507 [details]
Legacy side by side layout of sheet tags and scroll bar

"TabBarInlineWithScrollbar" configuration works! Thank you.
Comment 10 zexcel 2019-05-19 03:58:34 UTC
Created attachment 151508 [details]
distinguish scroll bar zone from the area of sheet tags and cells

I update the description of hardware/OS. 

① I use Ubuntu18.04LTS's bounded LibreOffice. So regedit does not work.
② The linux version scrollbar width is 10px, away from comfortable zone, visually and for pointing alignment. I do not know how to modify. 

・I agree that change the default layout of Calc might be an over-reaction. Do you think to distinguish scrolling bar background from tags and cells is acceptable?