Launchpad has imported 3 comments from the remote bug at
https://bugs.documentfoundation.org/show_bug.cgi?id=119961.
If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.
On 2018-09-18T16:55:42+00:00 Miikka-Markus Alhonen wrote:
Description:
Calc seems to assign the alignment of any particular text cell based on the
contents of the cell: if the first character is a LTR character, the cell is
aligned to the left, and if the first character is RTL, the cell is aligned to
the right. This is desirable behavior but it breaks when the first character is
neutral, i.e. a character that behaves as RTL in an RTL context and as LTR in a
LTR context.
See the attached screenshot where cell A1 "abc" is automatically aligned
to the left and cell A2 "ابت" to the right. When I surround these
strings with parentheses, which are bidi-neutral characters, in A3 and
A4, both are aligned to the left. For some reason, even font metrics
break with this assignment, as the last character of the Arabic string
overlaps visually with the closing parenthesis (I filed this as a
separate issue at
https://bugs.documentfoundation.org/show_bug.cgi?id=119960).
In column C, I have copied the contents of column A but changed the
directionality setting of cell C4 manually to RTL through Format Cells >
Text direction. Here the cell is properly aligned to the right and the
closing parenthesis does not overlap with the last character of the
string.
According to the Unicode standard, neutral characters should not affect
directionality, and that’s what I would expect as a user, too. I think
the best solution would be for Calc to skip all neutral characters in
the beginning of the string and just consider the first strong character
for cell alignment. Even better, Calc could use this heuristics to
assign full text directionality for the cell, not just change alignment.
Right now, if you start the cell with an RTL character followed by a LTR
inset and then continue with RTL again, the substrings are ordered as in
a LTR context ("FIRST second THIRD"), not as in true RTL ("THIRD second
FIRST").
This bug was first reported for LO 6.0.3.2 on Launchpad at
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1793126 .
Another user there confirmed the bug on LO 6.0.3.2 and 6.1.1.2.
Steps to Reproduce:
1. In an empty Calc cell with default directionality, write some text in Arabic
enclosed in parentheses.
Actual Results:
The cell is automatically aligned to the left.
Expected Results:
The cell should be aligned to the right, as parentheses are bidi-neutral and
should not affect directionality at all.
Reproducible: Always
User Profile Reset: No
Additional Info:
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1793126/comments/4
On 2018-09-18T16:56:33+00:00 Miikka-Markus Alhonen wrote:
Created attachment 144989
Screenshot of a Calc sheet which shows wrong default alignment
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1793126/comments/5
On 2018-10-12T17:11:19+00:00 Beluga wrote:
Apparently this feature was not yet in 3.3.0, but I can already repro in
3.6.7
Arch Linux 64-bit
LibreOffice 3.3.0
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Arch Linux 64-bit
Version 3.6.7.2 (Build ID: e183d5b)
Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1793126/comments/7
** Changed in: df-libreoffice
Status: Unknown => Confirmed
** Changed in: df-libreoffice
Importance: Unknown => Medium
** Bug watch added: Document Foundation Bugzilla #119960
https://bugs.documentfoundation.org/show_bug.cgi?id=119960
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1793126
Title:
Automatic cell alignment in Calc breaks with bidi-neutral characters
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1793126/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
