In my application, I’m exporting Workbooks as PDFs in either English or German. This means that date formats and decimal separators are different per language. It seems like the work environment’s language is set as the default language. Unfortunately, I cannot seem to change it at all.
My understanding is that using the following code would change every “1.234.567,89” into “1,234,567.89” and every “Dezember” into “December”:
WorkbookSettings settings = workbook.getSettings(); settings.setLanguageCode(CountryCode.USA); settings.setLocale(Locale.US); settings.setRegion(CountryCode.USA);
But the exported PDF stays completely German. I’d rather not change the entire work environment’s language if I can help it.
I’m using Aspose.Cells 19.9.