Start Calc and enable grid. That is in menu View > Grid and Helplines > Display Grid. To make the grid better visible you might set Resolution to 5mm and Subdivision to 5. That is in Tools > Options > Calc > Grid. Now set right-to-left writing direction in page properties and set "Right-To-Left" in menu Sheet. Error: The grid is no longer displayed. Go to menu View and make sure, that the option "Display Grid" is still enabled.
Reproduced with 6.4.6 under Windows 10: Version: 6.4.6.2 (x64) Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115 CPU threads: 2; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; Locale: zh-CN (zh_CN); UI-Language: en-US Calc: threaded For people not familiar with RTL: in non-CTL locale/UI one needs to first enable RTL in Tools > Options > Language Settings > Languages > Complex text layout, to have menu Sheet > Right-To-Left active.
A patch is available for this bug. https://gerrit.libreoffice.org/c/core/+/108989
Regina Henschel committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/7635a475130a0e9e3b0dded853348659d07a00d7 tdf#137083 consider negative width in DrawPageViewGrid 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.
This patch has no unit test. I was not able to write a test, and nobody on the dev-list had an idea, see https://lists.freedesktop.org/archives/libreoffice/2021-January/086612.html Therefore I set this to fixed without having a unit test.
Regina Henschel committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/6bb252e26ce1aeb3949c64ec6f0bef502a6a459d tdf#137083 consider negative width in DrawPageViewGrid It will be available in 7.1.0.2. 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.