Issue 106106 - Number Format: 'Add Decimal Point' to ranges with unpredictable result
Summary: Number Format: 'Add Decimal Point' to ranges with unpredictable result
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-10-20 19:17 UTC by skelem
Modified: 2014-03-15 16:39 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

test file exhibiting the bug, complete with explanatory text (8.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-10-20 19:18 UTC, skelem
no flags Details
New Sample (22.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-03-15 16:37 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description skelem 2009-10-20 19:17:17 UTC
Selecting a column containing numbers, then clicking the "Number Format: Add
Decimal Point" reduces the number of fraction digits instead of increasing them.

Open a new spreadsheet. Type the number 3.14159265358979 into a cell.
The number appears as 3.14.
Click on Format/Cells. The format is "General, 1 leading zero, 0 decimal places."

* This is odd already. Even though the format says "0 decimal places", two
digits are displayed.

Select the column containing that cell.
Click the button with the tooltext "Number Format: Add Decimal Point".
The number is now displayed as 3.1 instead of 3.142.
Comment 1 skelem 2009-10-20 19:18:18 UTC
Created attachment 65481 [details]
test file exhibiting the bug, complete with explanatory text
Comment 2 Edwin Sharp 2013-11-17 14:05:17 UTC
Confirmed with

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Comment 3 Rainer Bielefeld 2014-03-08 11:24:39 UTC
Version has been changed wrongly, so back!

May be we have a user error here, not a bug?

(a) In sample <<document 2009-10-20 21:18 CEST, skelem>> format of cell B4
    is "Standard", what means limit number of shown decimals to setting in
    menu 'Tools -> Options -> Calc -> Calculate - Decimal places', what is "2"
    for reporter's sample document. 
    So no problem here!
(b) Reporter also misunderstands "Add Decimal Place" icon (at least most of it).
    Function of that icon is not "Show 1 more decimal place of 20 existing 
    ones", but "enforce 1 additional minimum decimal. 
    In reporter's sample document you can simply test that with typing "1" 
    into B5. After Enter result should be shown as "1", because Format 
    "Number - Standard" does not enforce decimal places. 
(b1) With selected column 4 clicking Icon "Add Decimal Place" will change
     viewing of  "1" to  "1.0", what is correct
(b2) But it's indeed difficult to understand why for B4 such a click reduces
     number of shown decimals. It's completely correct due to format code
     "0.0" created for affected cells, but that might be a little unintuitive.
(b21) Help for "Number Format: Add Decimal Place" is really poor: "Adds
      one decimal place to the numbers in the selected cells.", That's at least

All this is not limited to Linux, I see the same with WIN.

After some thinking I will submit an enhancement request for Help and decide later whether behavior of this function acn be improved to make it more intuitive.

But I cna't see a bug here, so Not_An_Issue.
Comment 4 Rainer Bielefeld 2014-03-15 16:37:22 UTC
Created attachment 82869 [details]
New Sample

Great, well founded, consistent theory in Comment 3, unfortunately horrible nonsense. 

(a) The base formatting to what a decimal will be added is not easy to find.
(a1) If you select complete rows or columns it seems to be the formatting
     of the cell closest to the heading of row or column
(a2) If you select Column / Row ranges the relevant formatting seems to be 
     in cell closest to highest column / Row number
(a3) If you select adjacent cells of a row formatting of most right cell seems
     to be relevant
(a4) if you select adjacent cells formatting of most right bottom cell seems
     to be relevant 
(a5) if you select NOT adjacent cells formatting of most bottom cell seems
     to be relevant 

But that all without any liability to be correct and complete.

Help definitively needs some comments concerning usage of increase/decrease number of decimals for cell ranges
Comment 5 Rainer Bielefeld 2014-03-15 16:39:09 UTC
See comment above, reopened due to results with New Sample <<2014-03-15 17:37 CET, Rainer Bielefeld >>
Comment 6 Rainer Bielefeld 2014-03-15 16:39:42 UTC
CONFIRMED due to results with New Sample 
<<2014-03-15 17:37 CET, Rainer Bielefeld >>