You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently, numbers and dates are output in the normalized form stored inside the ODS file for internal use by OpenDocument. This form can be different from what the user entered and/or sees in the spreadsheet.
It would be nice if the Converter could be configured to output the original strings instead of the normalized formats.
For example the user may see the following in the spreadsheet in the Dutch (nl_NL) locale; notice that "," is the decimal separator, while "." is the thousands-separator:
1.234,67
However, the normalized form stored in the ODS file could very well be:
1234.66666666667
The latter is what is currently always output by the Converter. The requested enhancement would make it an option to instead output what the user sees.
Note that dates are currently also output in normalized form, while percentages are not.
The text was updated successfully, but these errors were encountered:
Currently, numbers and dates are output in the normalized form stored inside the ODS file for internal use by OpenDocument. This form can be different from what the user entered and/or sees in the spreadsheet.
It would be nice if the Converter could be configured to output the original strings instead of the normalized formats.
For example the user may see the following in the spreadsheet in the Dutch (nl_NL) locale; notice that "," is the decimal separator, while "." is the thousands-separator:
1.234,67
However, the normalized form stored in the ODS file could very well be:
1234.66666666667
The latter is what is currently always output by the Converter. The requested enhancement would make it an option to instead output what the user sees.
Note that dates are currently also output in normalized form, while percentages are not.
The text was updated successfully, but these errors were encountered: