How to Fix Google Sheets RTL?

Question

I am trying to use the Kharosthi script in Google Sheets, which is Right-to-Left. In Google Sheets, the script shows up properly while in cell-edit mode, but once it is confirmed it goes back to Left-to-Right.

Selected
Deselected

Answer 1

go to File > Spreadsheet settings and change locale to RTL language

---

last option would be to use formula or script to reverse the string

function REVERSE(string) {
  if (typeof string != 'string') {
    return null;
  }
  return string.split('').reverse().join('');
}

---

=REVERSE(A1)

---

or without script:

=JOIN(, INDEX(MID(A2, LEN(A2)-ROW(INDIRECT("1:"&LEN(A2)))+1, 1)))