Behavior of Editing Decimals

WebOffice 10.9 SP1 allows you to edit decimals. However several formats of decimals (different separator) will be used in different regions, WebOffice 10.9 SP1 pursues the following approach. Please consider this approach to avoid troubles with your data storage/usage.

 

The LOCALE settings will NOT be considered!

The minus sign can be at the beginning or at the end.

Apostrophes or blanks will only be used as thousand separator and so they are insignificant.

If more than on special character (dot or comma) are used, the last character will be used as decimal separator and the character before will be used as thousand separator.

If only one special character (dot or comma) is used, but several times, it will be used as thousand separator.

If only one special character (dot or comma) is used, it will be used as decimal separator.

 

As example the following formatted user input will be used correctly as "-1234.5":

"-1234.5 -1234,5 1234.5- 1234,5- -1,234.5 -1 234.5 -1'234.5 -1`234.5 -1´234.5 -1.234,5 -1 234,5 -1'234,5 -1`234,5 -1´234,5 -1234.5e-3 -0.12345e1"

 

icon_comment

If a special character (dot or comma) is used as thousand separator, but the number doesn't contain any decimals, the thousand separator will be used wrongly as decimal separator.