Why no Persian Numerals in LibreOffice Calc Options?

English
,
#1

Hi everyone,

I’m trying to make all numbers in a LibreOffice Calc sheet display as Persian numerals. I went to Tools → Options → Languages and Locales → Complex Text Layout → General Options → Numerals, but there’s no option for Persian. The menu only shows Arabic, Eastern Arabic, System, and Context.

None of these work the way I want for Persian numbers. Does anyone know why Persian numerals aren’t included in the list? I’m referring to the Persian numeral system with the LCID 429, as mentioned on this LibreOffice help page.

Would appreciate any help or insights!

Thanks!

#2

Have you set the language in Locale? See rtl - How to set LibreOffice to use Persian / Arabic-Indic / Hindi page numbers? - Ask Ubuntu

1 Like
#3

Changing the locale fixed it, but I’m not sure if it’s a permanent solution. If I send the file to someone with a different locale, how will the numerals appear on their system? Is there a way to make this permanent? Also, when I open the ODS file in Excel, all the numerals show up in English.

#4
  1. Open a new spreadsheet
  2. Get the stylist window [Ctrl+F11]
  3. Right-click>Edit cell style “Default”
  4. On the “Numbers” tab, set the locale to “Persian”, NOT “Default - Persian”.
  5. File>Template>Save… under some name.
  6. File>Templates>Manage… right-click your template saved in step 5 and choose “Default template”.

From now on, every new spreadsheet has a Persian locale explicitly set.
Add more customizations via: File>Template>Edit…

1 Like
#5

I think there’s a misunderstanding. I want to ensure the numerals in my ODS file always appear in Persian, even on systems with different locales. Like if I send the file to someone who doesn’t know how to change these settings, they would still see the numerals in Persian. Is there any way?

#6

Change the number format locale of cell style “Standard”, and if you want the same for every new document, save a blank spreadsheet with this modification as your default template.

#7

Not sure what you mean exactly, but I tried this, and it still opens with English numerals in Excel.

#8

I described the full procedure step by step.

Either you did something wrong, or Excel has an import problem. Compatibility with Open Document Format (ODF) is not in the interest of Microsoft Corp.

The attached document looks the same everywhere with adequate Open Document software. All the cells use Persian numerals except for the cells explicitly marked as English or German.
ask115983.ods (14.8 KB)

#9

If you want it to display for everybody, regardless of locale, exactly as you see it then you must print it or export to pdf. You could try Hybrid PDF
.
Sometimes dates and decimal separators appear to the recipient as they expect to see them, maybe the same applies to numbers?
.
If the recipient has Persian as default in the operating system and then installed LibreOffice then they should see Persian numerals, the same might apply to Excel.

#10

It might depend on the version of Excel. My Excel 365 imports Persian correctly. It imports it as custom number format [$-fa-IR,300]JJJJ.MM.TT for the date and #.##0" "[$﷼-fa-IR];[Red]"-"#.##0" "[$﷼-fa-IR] for the currrency, when I open file ask115983.ods

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.