Microsoft open xml converter has stopped working

#Microsoft open xml converter has stopped working how to#

OOo seems to define a default style for the date-time column like this:Д¬ode: Select all Expand view Collapse view Not shure if it helps acknak, but I did a quick test with various number formats and a set of styles for date, time, date-time, scientific numbers, percent values and booleans. Let's see, if we can do the trick with your data assuming locale 'en-US' or any other locale for that purpose. It could be done on any server, running any operating system and the most simple, generic XML-tools. This would not even require to have any office application installed (thanks to the free file format ODF). Working with international ISO dates and dot-decimals it could be very easy to convert your XML (or any other) to perfectly valid spreadsheets or text document tables. It would be easier for any conversion tool if it could assume one single dot per number and avoid commas alltogether.

Most countries use comma as decimal separator (Pi is written as 3,14159 in German) whereas a comma in dot-countries is used as thousands-separator for better readability.

#Microsoft open xml converter has stopped working how to#

What does 'Jul' and 'AM' mean to a dumb software? Even non-US citizens know what it is, but how to tell a machine? Even in my mother tongue (German) Jul stands commonly for the month 'July', however the full name is 'Juli' and short month 'Dec' would be 'Dez' ('Dezember').