Bug 93352 - RTL: Horizontal scrolling for right-to-left Sheet moves in opposite direction (macOS and Linux)
Summary: RTL: Horizontal scrolling for right-to-left Sheet moves in opposite direction...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
: 93559 94010 153207 154720 155693 (view as bug list)
Depends on:
Blocks: Scrollbars RTL-UI
  Show dependency treegraph
 
Reported: 2015-08-11 11:10 UTC by Mansour
Modified: 2023-09-25 12:44 UTC (History)
15 users (show)

See Also:
Crash report or crash signature:


Attachments
Wrong H. Scrollbar Alignment for Right-To-Left Sheets (119.38 KB, image/jpeg)
2015-08-13 11:48 UTC, Mansour
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mansour 2015-08-11 11:10:38 UTC
After changing a Sheet's format to Right-To-Left, the horizontal scrolling of the window gets broken. The sheet moves left when you scroll right and vice versa. The horizontal scrollbar also does not replace itself accordingly. It stays at left of screen, while it should be to the right. This makes it impossible to grasp it with the mouse and slide it as one would expect.

Steps to reproduce:
1) Open a new Sheet.
2) Choose: Format -> Sheet -> Right-To-Left
3) Scroll the sheet left or right using the laptop's touchpad or a mouse's scroll-wheel. Notice how the sheet slides in the opposite direction!
4) Try to grasp the horizontal scrollbar at the button of window. See how that's impossible!

I tested this using Mac OS X 10.10.4.

Thank you.
Comment 1 Alex Thurgood 2015-08-13 10:10:00 UTC
(In reply to Mansour from comment #0)


> 
> Steps to reproduce:
> 1) Open a new Sheet.
> 2) Choose: Format -> Sheet -> Right-To-Left

I see this menu entry, but it is greyed out, thus inactive.
How does one change the settings so that this entry is available ?

OSX 10.10.4
Version: 5.0.0.5
Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b
Locale : fr-FR (fr.UTF-8)
Comment 2 Maxim Monastirsky 2015-08-13 10:25:18 UTC
(In reply to Alex Thurgood from comment #1)
> How does one change the settings so that this entry is available ?
Tools->Options...->Language Settings->Languages. You need to enable there "Complex text layout (CTL)".
Comment 3 Mansour 2015-08-13 11:48:12 UTC
Created attachment 117888 [details]
Wrong H. Scrollbar Alignment for Right-To-Left Sheets
Comment 4 Alex Thurgood 2015-08-13 14:13:54 UTC
Confirming on

Version: 5.0.0.5
Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b
Locale : fr-FR (fr.UTF-8)

OSX 10.10.4

Wow, frustrating, like trying to play whack-a-mole ;-)
Comment 5 Adolfo Jayme Barrientos 2015-08-21 22:01:49 UTC
*** Bug 93559 has been marked as a duplicate of this bug. ***
Comment 6 Yousuf Philips (jay) (retired) 2015-08-23 02:30:05 UTC
Setting to NEW as alex, me, and duplicate bug confirmed it.

This is a regression as it works in 3.3, but wasnt able to test it in 3.4 or 3.5.
Comment 7 Lior Kaplan 2015-09-23 16:00:36 UTC
I couldn't reproduce this with LibO 5.0.1 on Debian 64bit (both Debian's packages and LibO official build). Can anyone reproduce this on Linux/Windows? or this is a Mac OS X issue only ? (which the bug should reflect)
Comment 8 Yousuf Philips (jay) (retired) 2015-09-25 10:27:52 UTC
Tested in 3.5.7 and it works fine and it is still broken in master.

Version: 5.1.0.0.alpha1+
Build ID: 1e67e94f1a308ca60d4934e9fe9d5c048225ebe8
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-09-21_07:28:58
Locale: en-US (en_US.UTF-8)
Comment 9 Robinson Tryon (qubit) 2015-12-14 05:32:31 UTC Comment hidden (noise)
Comment 10 QA Administrators 2017-01-03 19:48:47 UTC Comment hidden (noise)
Comment 11 Shimon Shore 2017-03-05 16:06:12 UTC
*** Bug 94010 has been marked as a duplicate of this bug. ***
Comment 12 Anass Ahmed 2017-08-01 06:23:14 UTC
Still happening in LibreOffice 5.3.4 GTK3 Backend. Also tried VCL_BACKEND=gtk,kde4, and gen, and it's happening with all of them.

I'm using Fedora 26 with GNOME Shell 3.24 and a touchpad.
Comment 13 Anass Ahmed 2017-08-01 06:24:00 UTC
I mean SAL_USE_VCLPLUGIN not VCL_BACKEND.
Comment 14 Omer Zak 2017-11-09 08:21:22 UTC
I tested in:

Version: 6.0.0.0.alpha1+
Build ID: 6070dec9ca9a15587a2aece81f9ae1ab5ac0f8c4
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.utf8); Calc: group
(Build from 2017-Nov-05 00:00)

OS: Debian 64bit Stretch (Debian 9.2, with some backported packages)


Works for me.
In this version, reproduction instructions are different:

  Sheet > Right-To-Left (add checkmark)

(P.S.: a capitalization style note - in the above menu you have "Right-To-Left" but in Insert > Formatting Mark > Right-to-left mark, i.e. there is different capitalization.)
Comment 15 Hossein Shojaeifar 2020-11-15 09:05:28 UTC
Still affecting me.

version: 6.4.6.2
OS: Zorin OS 15.3
Comment 16 niyumard 2020-11-25 12:46:04 UTC
(In reply to Hossein Shojaeifar from comment #15)
> Still affecting me.
> 
> version: 6.4.6.2
> OS: Zorin OS 15.3

I'm using version 7.0.3.1 and this happens for me too.
Comment 17 Aron Budea 2021-11-15 03:00:53 UTC
I'm not seeing the wrongly positioned scrollbar, but I'm seeing different scrolldirection: I checked using Shift-<mouse scrollwheel> in an RTL sheet, if rolling the wheel upwards scrolled left, I considered it good, if it scrolled right, I considered it bad. Bibisected to the following range using repo bibisect-43all, with 'gen' VCL plugin (SAL_USE_VCLPLUGIN=gen ./soffice).

https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=b0da54bec69f4931af0adbc15d230d3f4eea7b08..bec62421a45da89d2812bdff30fbbab73291cf91

The following commit, fixing bug 44657 seems suspicious.

https://cgit.freedesktop.org/libreoffice/core/commit/?id=bfa21ce5fa08f2c634ccb6162914be55aef9f3c2
author		Jan Holesovsky <kendy@suse.cz>	2012-10-19 01:21:22 +0200
committer	Jan Holesovsky <kendy@suse.cz>	2012-10-19 14:51:23 +0200

fdo#44657 Remove hack that "simulates" a mirrored horizontal scrollbar.
Comment 18 Andreas Heinisch 2023-01-26 08:07:11 UTC
I cannot repro the error in:
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 2f141c05a7205db660e79673ad2676e19d50583d
CPU threads: 16; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL threaded

Version: 6.4.0.3 (x64)
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 16; OS: Windows 10.0 Build 19044; UI render: GL; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: CL

Version: 5.4.7.2 (x64)
Build-ID: c838ef25c16710f8838b1faec480ebba495259d0
CPU-Threads: 16; BS: Windows 6.19; UI-Render: GL; 
Gebietsschema: de-DE (de_DE); Calc: CL

I set the sheet RTL and the scrolling and the positioning of the scroolbar seems correct to me.
Comment 19 Stéphane Guillou (stragu) 2023-03-06 09:21:12 UTC
*** Bug 153207 has been marked as a duplicate of this bug. ***
Comment 20 Stéphane Guillou (stragu) 2023-03-06 09:28:14 UTC
We've seen this on macOS and Linux, but not Windows (I just checked again on Windows 10). See also confirmations in duplicate bug 153207.

Changing summary and metas to more appropriate ones.

Still reproducible with a recent master build:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: feda414f8b70f50a9f6745d2ce8828316d4711cd
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded
Comment 21 Kurosh Tavassoli 2023-04-09 04:08:04 UTC
*** Bug 154720 has been marked as a duplicate of this bug. ***
Comment 22 ady 2023-06-05 19:21:08 UTC
*** Bug 155693 has been marked as a duplicate of this bug. ***