Bug 119960 - EDITING: Font metrics mixed up for RTL insets in a LTR context in Calc
Summary: EDITING: Font metrics mixed up for RTL insets in a LTR context in Calc
Status: RESOLVED DUPLICATE of bug 103492
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: RTL-CTL
  Show dependency treegraph
Reported: 2018-09-18 16:45 UTC by vaaydayaasra
Modified: 2022-09-11 22:33 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Screenshot of an Arabic RTL inset in the middle of LTR text (92.35 KB, image/png)
2018-09-18 16:47 UTC, vaaydayaasra
Screenshot on LO (96.92 KB, image/png)
2019-10-16 08:58 UTC, vaaydayaasra
Screenshot on (72.04 KB, image/png)
2022-03-01 18:21 UTC, vaaydayaasra

Note You need to log in before you can comment on or make changes to this bug.
Description vaaydayaasra 2018-09-18 16:45:56 UTC
In the attached screenshot, I’ve written an English sentence with an Arabic word in the middle on the first row of a Calc sheet. On the second row, I’ve written the same Arabic word (العربية) by itself. The second row looks as it should but on the first row, some of the characters overlap. The same problem occurs if I surround the isolated Arabic word with parentheses, in which case the cell is automatically aligned to the left. I’m using the default font settings, which in my environment are Liberation Sans for Latin text and DejaVu Sans for Arabic. The problem only occurs in Calc, not Writer. 

This problem was first reported for LO on Launchpad at https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1793127 . Another user there confirmed the bug for LO and

Steps to Reproduce:
1. In a LTR Calc cell, write some text in English, then Arabic and then English.

Actual Results:
Some of the letters of the Arabic text overlap.

Expected Results:
Arabic should look the same as in an RTL context.

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 vaaydayaasra 2018-09-18 16:47:07 UTC
Created attachment 144988 [details]
Screenshot of an Arabic RTL inset in the middle of LTR text
Comment 2 Buovjaga 2018-10-12 17:40:38 UTC
Did some testing and looks like it appeared with the HarfBuzz implementation in 5.3.
Comment 3 Lior Kaplan 2018-10-12 20:45:01 UTC
Can you also reproduce with 6.1.x or master ?
Comment 4 Buovjaga 2018-10-13 06:21:03 UTC
(In reply to Lior Kaplan from comment #3)
> Can you also reproduce with 6.1.x or master ?

Original report was for 6.1.1. I confirm with master

Arch Linux 64-bit
Build ID: b752a93acff31c824bcec4233a8dd9bee014ca7d
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; 
Locale: fi-FI (fi_FI.UTF-8); Calc: threaded
Built on 12 October 2018
Comment 5 QA Administrators 2019-10-14 02:27:39 UTC Comment hidden (obsolete)
Comment 6 vaaydayaasra 2019-10-16 08:56:04 UTC
I tested this again with LO installed on Ubuntu as a snap. Now font metrics are still mixed up in the main view while I am typing and permanently on the formula line. When I finish typing and press Enter, the main display shows the characters correctly. So part of the problem is fixed, part is remaining.

Build ID: libreoffice-
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Comment 7 vaaydayaasra 2019-10-16 08:58:42 UTC
Created attachment 155033 [details]
Screenshot on LO

The first line in the main view looks correct; the second line, which I'm still typing at the moment of this screenshot, is incorrect. The formula line is incorrect, too.
Comment 8 QA Administrators 2021-10-16 03:51:47 UTC Comment hidden (obsolete)
Comment 9 vaaydayaasra 2022-03-01 18:20:34 UTC
Tested again on LibreOffice on Windows 10. Now the formula line looks good but all LTR cells in the main view have font metrics mixed up, whether I'm currently typing them or not. For some reason, cells starting with a RTL character that Calc automatically aligns to the right behave as they should, although they're still not truly RTL, as the order of mixed LTR/RTL elements is wrong. See the attached screenshot.

Version: (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: CL
Comment 10 vaaydayaasra 2022-03-01 18:21:28 UTC
Created attachment 178599 [details]
Screenshot on
Comment 11 ⁨خالد حسني⁩ 2022-09-11 20:00:47 UTC

*** This bug has been marked as a duplicate of bug 103492 ***