We have documents with tables and numbers with formulas in the tables. When the language of the document matches the langage that the JVM considers the default everything works. When we have Aspose words update the formulas in a document that uses formatting for Euro's with the comma and period switched for numeric formatting, Aspose.Words seems to get confused and calculates the formula wrong. If I change the JVM to be in a language that uses periods for the grouping and commas for the dicimal the formulas calculate correctly.
I would like to switch the local per document and not set the JVM default Locale because ths is a multi-user and multi-threaded system. The odds of multiple Locale switched stepping on each other is quite high. With things like NumberFormat I can set the Locale on the object without having to change the JVM default Locale. I can't seem to find anything similar to that with Aspose.Words.