Apache OpenOffice (AOO) Bugzilla – Issue 115531
decimals shown in values
Last modified: 2013-07-10 09:57:08 UTC
In OO 3.3 the calc default number of decimals shown in cells for values seems to be increased to 10 from the previous 2 - a bit too much perhaps. Besides, the behaviour of the buttons that hides decimals one by one seems to be quite strange: place a number with a lot of decimals in a cell (e.g. put function =rand() in cell B4); then select that cell and the empty one above (B3:B4), and press the button to lower the number of decimals shown. In this case it works properly. Now select instead the cell with the number and the empty one below (B4:B5). If you press the same button, now it has no effect. This is actually happening on a larger scale: if the cell with the number is at the low right corner of a selection (with the other selected cells empty) the button does not work; if it is at the upper left corner, it does. I cannot find a logical reason for this. Or there is one? The button to add shown decimals behaves still differently: start again with a cell with rand(); depending on the range you select, it can add the 11th decimal (if the cell with the number is at the bottom right of the selected range) or make the number show only one decimal at the first press, and then increase from there (if the cell with the number is at the upper left corner of the selected range). I suppose this description is not really clear.... sorry. Thanks
B4 =rand() Highlight B3:B4 Delete decimal place -> number in B4 is changing at each press, i.e. 0.5769776925 0.837282350 0.66704216 0.6343279 etc. Rev. 1499347 Win 7