Issue 115531

Summary: decimals shown in values
Product: Calc Reporter: scagni <silvandy>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 3.3 RC2   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description scagni 2010-11-11 11:55:47 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
Comment 1 Edwin Sharp 2013-07-10 09:57:08 UTC
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