Issue 14365 - RTL Chart: Bi-directional writing in charts
Summary: RTL Chart: Bi-directional writing in charts
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@graphics
Keywords: Arabic, ms_interoperability, usability
: 39526 (view as issue list)
Depends on:
Blocks: 79434 91970
  Show dependency tree
Reported: 2003-05-12 14:49 UTC by mehlng
Modified: 2013-02-24 21:19 UTC (History)
8 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

A misbidirectional Chart (99.86 KB, image/jpeg)
2003-10-27 18:22 UTC, mehlng
no flags Details
Test document containing 3 charts with "LTR", "RTL", "Use super" (35.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-10-31 13:50 UTC, daniel.rentz
no flags Details
corrected example document (30.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-11-10 17:39 UTC, IngridvdM
no flags Details
TCS for Bi-directional writing mode for charts (52.95 KB, text/html)
2008-11-21 11:26 UTC, kla
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mehlng 2003-05-12 14:49:31 UTC
When creating a chart, the textboxes inside (say, the title and the legend) are
automatically L2R, and I found no way to change its directionality nor its
identation (IE idented to left or to right).

I rated it P4 as this rarely matters.
Comment 1 Dieter.Loeschky 2003-06-05 11:35:06 UTC
DL->BM: Would you please takeover?
Comment 2 bjoern.milcke 2003-06-05 11:55:44 UTC
BM_>FT: Please provide a specification for that feature.
Comment 3 mehlng 2003-08-15 10:43:08 UTC
*** Issue 15969 has been marked as a duplicate of this issue. ***
Comment 4 falko.tesch 2003-08-15 11:16:02 UTC
Question is, do we allow RTL for all other text within Charts? If so
the same must go for legend box content. If not we can postpone this
for features of the new Chart engine.
Basically at the end we must supply the same formatting issues to any
text in Chart as we do in Writer text (given a unified text engine).
Anyway I re-ategerted this to OO.o later since it is no requirement
within the OO.o 2.0 PCD.
Comment 5 bjoern.milcke 2003-09-02 15:12:27 UTC
I think I need some more information on this. As I just checked, your
cursor travels from right to left, if you entered arabic text in a
Writer. The same happens when you edit chart titles. I didn't find any
other options in Writer for changing text to RTL mode. (I checked in
an OOo 1.1 RC1) So, ...

1. What possibilities does the Writer have for changing to RTL mode?
And do we need those for the chart?
2. Do we need a mirrored legend, where the symbols are shown on the
right side of the text?

I can't answer 1., because I don't know how this feature is
implemented in Writer, and I can't answer 2., because I am no Arab and
I never had the chance to see an arabic chart.
Comment 6 bjoern.milcke 2003-09-02 15:26:29 UTC
Questions for you.
Comment 7 falko.tesch 2003-10-27 10:50:46 UTC
FT->Mehling: Please write a full featured list of requirement thart
are needed for a RTL Chart.
Comment 8 mehlng 2003-10-27 18:18:04 UTC
I want: 
1) cells which denotes chart's name and are marked R2L will be written as RTL (and 
not as in the picture I'll attach) 
2)ditto for Chart's subject, it should be possible to define it as R2L 
3)ditto for row's names. 
That's all simple but important. 
Comment 9 mehlng 2003-10-27 18:22:19 UTC
Created attachment 10692 [details]
A misbidirectional Chart
Comment 10 sforbes 2003-12-03 13:59:55 UTC
dina: FWI
Comment 11 bjoern.milcke 2007-04-19 13:12:32 UTC
So, it looks like we would need a setting to switch between "Left to Right" and
"Right to Left" for titles, axis labels, the legend (single legend entries) and
data series/points (for data labels).

For titles, we have an alignment tab-page in the object properties that could be
extended. For the other objects we would have to find a suitable place.

The setting that can be set in such a control would then be applied to the
drawing-layer shapes, which use the edit-engine for rendering, so we would get
the correct direction.

Retrieving the current setting from the cell is a bit more difficult, as the
data transfer interface (new chart) currently only allows passing the content as
string or number, and the number format. Maybe we could live without this
automatism in the first step of implementation.
Comment 12 bjoern.milcke 2007-09-27 13:25:43 UTC
->mehlng: About passing only strings from Calc to Chart: I think there is a
unicode character that changes the writing mode. Would it be feasible to use
this character to pass the cell content's writing modes correctly to the chart?
Comment 13 bjoern.milcke 2007-10-04 08:59:54 UTC
Taking Issue back.

About the Unicode character for writing mode: obviously this should only be used
if there is no other way to determine the writing mode.
Comment 14 bjoern.milcke 2008-05-28 08:24:36 UTC
adapted summary to be consistent with i78477
Comment 15 IngridvdM 2008-07-03 11:49:24 UTC
change owner
Comment 16 Joost Andrae 2008-07-09 11:14:22 UTC
retarget to 3.1
Comment 17 stephan_schaefer 2008-07-16 12:31:05 UTC
CCed: ssa
Comment 18 IngridvdM 2008-07-22 11:58:23 UTC
added keywords
Comment 19 IngridvdM 2008-10-27 10:23:42 UTC
*** Issue 39526 has been marked as a duplicate of this issue. ***
Comment 20 IngridvdM 2008-10-27 10:25:18 UTC
@dr, please take over. Thanks!
Comment 21 daniel.rentz 2008-10-31 13:50:36 UTC
Created attachment 57613 [details]
Test document containing 3 charts with "LTR", "RTL", "Use super"
Comment 22 daniel.rentz 2008-10-31 14:42:24 UTC
Added a "text direction" listbox containing "Left-to-right", "Right-to-left",
"Use superordinate settings" to the following places:

** Main/sub/axis titles **: Object Properties -> Alignment -> below rotation
control. Renamed "Text direction" fixedline above to "Text orientation"
according to cell format dialog in Calc.

** Legend **: Object Properties -> Position -> below position radio group.

** Data series/point labels **: Object Properties -> Data Labels -> below
placement listbox.

** Axis labels **: Object Properties -> Label -> below rotation control. Renamed
"Rotate text" fixedline above to "Text orientation" according to cell format
dialog in Calc.

** Regression curve equation **: Object Properties -> (new tabpage) Alignment ->
nothing but the text direction listbox.

The listbox is not visible if support for CTL is disabled (Tools -> Options ->
Language settings -> Languages).
For regression curve equation, the entire new tabpage "Alignment" is not visible
if support for CTL is disabled.
For data series/points, the listbox is disabled, if data labels are switched off
(all checkboxes unchecked).
Comment 23 IngridvdM 2008-11-04 18:25:06 UTC
@dr, thanks a lot :-) ! I'll take over for the rest during your vacation.
Created issue 95843 for the necessary changes in the documentation.
Created issue 95844 for the necessary changes in the automatic testing scripts.
Comment 24 IngridvdM 2008-11-10 17:35:50 UTC
Fixed in CWS rtlchart01.
The new setting is now also loaded correctly and 'Superordinate' setting is
When 'Use superordinate object settings' is set chart elements use the writing
direction that is set in the parent document (see Format->Page... Page).
Comment 25 IngridvdM 2008-11-10 17:39:21 UTC
Created attachment 57844 [details]
corrected example document
Comment 26 IngridvdM 2008-11-10 17:43:41 UTC
@KLA, please verify in CWS rtlchart01.
In case you find some issues that can be solved after feature freeze please
submit separate issues. Thanks a lot! Ingrid.
Comment 27 kla 2008-11-21 11:26:51 UTC
Created attachment 58185 [details]
TCS for Bi-directional writing mode for charts
Comment 28 kla 2008-11-21 11:50:38 UTC
Integration of bi-directional writing mode for chart looks like as in the spec
decribed and works fine. Issue verified
Comment 29 kla 2008-12-19 11:39:36 UTC
Checked by using TCS in current master -> closed