spout icon indicating copy to clipboard operation
spout copied to clipboard

support for rtl(right to left) cell styling

Open emf-developer opened this issue 4 years ago • 8 comments

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

emf-developer avatar Oct 08 '19 07:10 emf-developer

Would you like to make a PR?

adrilo avatar Oct 08 '19 11:10 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?

adrilo avatar Oct 27 '19 18:10 adrilo

@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.

emf-developer avatar Dec 15 '19 09:12 emf-developer

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

seddighi78 avatar Mar 17 '20 10:03 seddighi78

having the same issue here any solution yet ?

kazux avatar May 10 '20 01:05 kazux

+1

mhyeganeh avatar Sep 06 '20 21:09 mhyeganeh

did you found solution to this this?

SabraHashemi avatar Jul 14 '21 06:07 SabraHashemi

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

TAGHREEDAA avatar Jul 28 '21 07:07 TAGHREEDAA