Thanks for the clarification. I added code to our program to set the Region to “Germany” when loading the file or when creating a blank workbook.
One final question: what do you do for “Region = CountryCode.Default”? Do you pick the OS language, or do you always use english?
You are welcome and good to know that by setting the Region to Germany works for the purpose.
CountryCode.Default instructs Aspose.Cells to use the environment’s (OS or thread culture) regional settings.
OK, so setting the region myself is not needed in most cases as we target only the german market, it is only relevant if the report is generated on a server that does not have german regional settings (which I did see very rarely).
You are right. Apparently, you do not need to explicitly set the Region if you are using German locale.