Apache OpenOffice (AOO) Bugzilla – Issue 65731
Decimal separator formatting incorrectly carried over to Object Properties Scale tab
Last modified: 2013-02-24 21:19:15 UTC
If, under the Numbers tab in the Format Cells dialogue, a group of cells is set to a certain language, their formatting will be carried over onto any chart on which data from this group of cells is used. However, when I open the Object Properties dialogue for the axis which uses the same group of cells, the formatting is carried over to the Scale tab. For example, if I had set the cells' language to English but had my system set to operate in Finnish, all numbers on the Scale tab would have the period as a decimal separator. However, as my system is set to use the comma as a decimal separator, I would get "Invalid number" error messages when trying to save the changes. It is neither possible to save the changes using the period (error message) or the comma (program automatically removes all digits after comma) as a decimal separator. This error only seems to occur when the Source format box is ticked under the Numbers tab.
If you use "Source Format", the language of the format of the cells is also used in the scale tab-page. So, if you have cells with "English" as language, you have to enter dots as decimal separators. This is the same behaviour as when changing the corresponding values in the cells. I don't see this as a bug. When entering "," then this leads to an error message or interpretation as 0, which is ok. When entering "." you should get the correct number. Decimal places shouldn't disappear. On the scale tab the number of decimal places is one larger than the one in the original format (i.e. even if you have no decimal places for the numbers, you should get at least one in the scale tab). ->woom76: Please try to be more specific. I can't see (reproduce) a bug yet.
Created attachment 36964 [details] Issue test case
I have attached an issue case that should demonstrate this problem. On my system, the issue can be reproduced by double-clicking on the y axis and going to the Scale tab (while "Source format" is ticked under Numbers). Trying to switch between tabs should cause a number of "Invalid number" errors, which may prevent switching to another tab. Reproducibility may depend on which system locale, ie. decimal separator, is set.
Hi, i also can't see any issue. The source format in en the decimal separator for with is dot. You try to use a comma as decimal separator; that will be not work. So i close this issue as invalid.
closed