RTL UI: Special numbers shown RTL even in cells that are formatted as LTR

[EliCoten]

When using a RTL UI (e.g. Hebrew) even on English spreadsheets the numbers are shown in RTL direction even if the cells are set to be LTR.

It's difficult to explain precisely what the problem is, but it causes weird quirks like for negative numbers, the - appears on the wrong side of the number (in LTR, it's normally before the number e.g. -127 but with RTL UI, even in an LTR cell the number appears as 127-.

The same problem appears in cells formatted to show date time, e.g. D/MM/YYYY hh:nn.

See the attached spreadsheet in LibreOffice when a RTL UI Language in use. I would expect cells A3 and B3 to appear as shown in the screenshot embedded into the sheet. (The screenshot was created by changing the UI language back to English)

ProblemType: Bug
DistroRelease: Ubuntu 13.10
Package: libreoffice-calc 1:4.1.2~rc3-0ubuntu1
ProcVersionSignature: Ubuntu 3.11.0-13.20-generic 3.11.6
Uname: Linux 3.11.0-13-generic i686
ApportVersion: 2.12.5-0ubuntu2.1
Architecture: i386
CheckboxSubmission: ad9a15703e19217cb3448f881e125f6a
CheckboxSystem: abc83e3988b72e7c3a9b3aa684cb92fd
Date: Mon Dec 2 22:56:53 2013
MarkForUpload: True
SourcePackage: libreoffice
UpgradeStatus: Upgraded to saucy on 2013-11-19 (13 days ago)

[Yaron (sh-yaron)]

Hi there, did you report this one in LibreOffice officially as well? this is not the right place for this kind of reports.

[Olivier Tilloy (osomon)]

I can observe the issue described by the original reporter with LibreOffice 6.1.3.2 in Ubuntu 18.10.

I cannot read Hebrew nor am I versed in RTL languages, so not sure what the expectation should be.

@EliCoten, if you still care about that issue, would you mind filing an upstream bug report at https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice&format=guided and sharing the link to that bug here?

Thanks!

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]