Date not being translated in Nepali while viewing it through the data entry form

User Support Form Building
, ,
12

OK, i found out the issue here. If you simply view the year that is in Nepali font (Unicode) in D14 you will see it being displayed in Nepali font (inside the sheet) but if you view the same thing in the status bar boxed in red you will still see the same thing in English (shown in the image below).

Image 101

So in this case, if you upload your xlsform in the server, you will still see an English date (like you seeing currently).

So the fix for this is as follows:

  • Open the choices tab of your xlsform.
  • Select all the cells that you wish to view it in Nepali font.
  • Then press right click.
  • Press Format Cells.
  • A Format Cells dialogue box appears. There, under the Number select Text.
  • Now copy the Unicode dates (year) to where ever required.

Doing so, you should be able to see the year being typed in Nepali in D14 (inside the sheet as well as in the status bar as boxed in red):

Image 102

Now if you upload your xlsform to the server, you should be able to see the year in Nepali as shown in the image below:

Image 103
Image 103666×682 12.4 KB

As a reference, you could use the following xlsform (where i have changed the first one for you):

nep date.xlsx (15.3 KB)

1 Like