Apache OpenOffice (AOO) Bugzilla – Issue 72747
No Locale casting methods in API
Last modified: 2014-02-14 10:48:20 UTC
While there are methods in the OOo API to set the file properties are no methods in the API to assist in casting numerical data to the correct locale format. For example if you make an application to import data into a spreadsheet it is not possible using the OOo API programmatically to set the entire spreadsheet to a different locale. (There are interfaces XLocale and XLocalizable present in the API which do nothing.) So if I have English US formatted numerical data and want to present the data in different locale formats i.e. Hungarian, English UK, I have to either manually intervene each time to set the locale on the spreadsheet or use the standard Java API to format numbers and dates. This is very messy, time consuming and error prone.
TM->requirements: please have a look, thanks !