Description: If I try to use percent format for cells, Calc is doing something strange. E.g. I have a value of 18,60 (german format) and try to use percent format for that cell, Calc does display 1860,00 % or 1860 %. I guess not only I would like to see "18,60 %" in that cell, because my used value is 18,6% ... Currency cell format does work very good on the other hand. Steps to Reproduce: 1. Type in any percent value in one cell, like e.g. 15,20 (german format) 2. Mark cell, right click, format cell, choose percentage format 3. Actual Results: It will show as 1520,00 % or 1520 % Expected Results: It should show 15,20 % Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 149440 [details] Screenshot
Percent format is really just a different visual output of the same value. The expected 18,6% corresponds to 0,186, but that's not what you had in the cell. The entered 18,6 value corresponds to 1860%. If you'd like to be able to have the entered 18,6 to be considered percentage in itself, please set cell format to percent first, and enter the value afterwards.
Or in a General formatted cell just enter 18,6% which inputs the desired value and sets a percent format.
Ok thanks. For me these format options have just been visial things, like currency, and was unfortunately not obvious (nor really visable) that in case of percentage format the decimal value will be calculated right away ... But I'm still the opinion that behaviour on changing cell format to percentage is not right, very unfortunate. Why can't it treat an already existing value as correct value directly ... ?