Search code examples
google-apps-scriptgoogle-sheetsgoogle-sheets-formularight-to-left

How to Fix Google Sheets RTL?

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

Solution

  • 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)))