Bug 147271

Summary: gtktiledviewer from the LibreOfficeKit renders mirrored content for an RTL spreadsheet
Product: LibreOffice Reporter: Hossein <hossein>
Component: LibreOfficeAssignee: Dennis Francis <dennisfrancis.in>
Status: ASSIGNED ---    
Severity: normal CC: aron.budea, hossein
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 43808    
Attachments: Example Calc file with an rtl sheet
Bad rendering

Description Hossein 2022-02-07 22:17:00 UTC 
Description:
When opening a Calc document with a right-to-left (rtl) sheet, the text is wrongly displayed as mirrored. The wrong mirroring is done both for English (ltr) and Arabic/Persian (rtl) text.

Steps to Reproduce:
1. Open a Calc file with an rtl sheet. You can invoke this from the core folder after building LibrOffice:

./bin/run gtktiledviewer --lo-path=instdir/program rtl.ods

Actual Results:
All the texts are displayed as mirrored.

Expected Results:
The text should be shown as normal readable text, and not mirrored.


Reproducible: Always


User Profile Reset: No



Additional Info:
The same effect can be created by sending UNO command "SheetRightToLeft" from the UI in a Calc file with rtl sheets.
Comment 1 Hossein 2022-02-07 22:19:11 UTC 
Created attachment 178128 [details]
Example Calc file with an rtl sheet
Comment 2 Hossein 2022-02-10 21:48:09 UTC 
Created attachment 178203 [details]
Bad rendering
Comment 3 Aron Budea 2022-02-11 16:08:15 UTC 
Confirmed using gtktiledviewer in LO Version: 7.4.0.0.alpha0+ (80d00b3eec3a7811c0139afe0ea749cc319ce7b9) / Ubuntu.

It seems to me gtktiledviewer should mirror the whole sheet (including the row/column headers), which it doesn't do currently.
Comment 4 Eyal Rozenberg 2023-12-04 20:56:47 UTC 
Is this under the right product? LibreOffice itself doesn't seem to exhibit this behavior. Perhaps it's the right product but should be in a different category, e.g. sdk?