Apache OpenOffice (AOO) Bugzilla – Issue 106106
Number Format: 'Add Decimal Point' to ranges with unpredictable result
Last modified: 2014-03-15 16:39:42 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.
Created attachment 65481 [details] test file exhibiting the bug, complete with explanatory text
Confirmed with AOO410m1(Build:9750) - Rev. 1539999 2013-11-09_04:08:11 - Rev. 1540252 Debian
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 imprecise. 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.
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
See comment above, reopened due to results with New Sample <<2014-03-15 17:37 CET, Rainer Bielefeld >>
CONFIRMED due to results with New Sample <<2014-03-15 17:37 CET, Rainer Bielefeld >>