support for rtl(right to left) cell styling

[emf-developer]

The writer is missing support for rtl cell styling and rtl direction for spreadsheets;

[adrilo]

Would you like to make a PR?

[adrilo]

Here's the excerpt of the XLSX spec:

An integer value indicating whether the reading order (bidirectionality) of the cell is left- to-right, right-to-left, or context dependent.
0 - Context Dependent - reading order is determined by scanning the text for the first non-whitespace character: if it is a strong right-to-left character, the reading order is right-to-left; otherwise, the reading order left-to-right.
1 - Left-to-Right- reading order is left-to-right in the cell, as in English.
2 - Right-to-Left - reading order is right-to-left in the cell, as in Hebrew.

According to this, the reading order is automatically detected by default. @emad22552 can you tell me in which cases you'd need to explicitly set it to RTL?

[emf-developer]

@adrilo it is good to set each cell direction but i need to set the whole sheet to be RTL, something like excel -> page layout -> sheet Right-to-Left.

[seddighi78]

is it possible to set the layout to right to left?

[kazux]

having the same issue here any solution yet ?

[mhyeganeh]

+1

[SabraHashemi]

did you found solution to this this?

[TAGHREEDAA]

hello, any updates regarding this issue? or any idea how to make a workaround solution to make the excel sheet RTL?