Bug 119960

Summary: EDITING: Font metrics mixed up for RTL insets in a LTR context in Calc
Product: LibreOffice Reporter: vaaydayaasra
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: eyalroz1, ilmari.lauhakangas, khaled
Priority: medium    
Version: 5.3.0.3 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
See Also: https://launchpad.net/bugs/1793127
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 43808    
Attachments: Screenshot of an Arabic RTL inset in the middle of LTR text
Screenshot on LO 6.3.2.2
Screenshot on 7.3.0.3

Description vaaydayaasra 2018-09-18 16:45:56 UTC 
Description:
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 6.0.3.2 on Launchpad at https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1793127 . Another user there confirmed the bug for LO 6.0.3.2 and 6.1.1.2.

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
Version: 6.2.0.0.alpha0+
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 6.3.2.2 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.

Version: 6.3.2.2
Build ID: libreoffice-6.3.2.2-snap1
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 6.3.2.2

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 7.3.0.3 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: 7.3.0.3 (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 7.3.0.3
Comment 11 ⁨خالد حسني⁩ 2022-09-11 20:00:47 UTC 

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