Apache OpenOffice (AOO) Bugzilla – Issue 86337
Make double-clicking on percentage formatted cell function the same as single-click
Last modified: 2013-02-07 22:42:39 UTC
1. Create a Calc document and format some cell into percentage format; 2. Active a percentage formatted cell with one click and input a number; 3. Active another percentage formatted cell with DOUBLE CLICK and input a number. You can see the result is not the same, the latter one is 100 times of our expectation.
This is 'as designed' functionality. If you click into the cell you are entering a percent value. If you DOUBLE CLICK you are entering a 'raw number', that is 12.85 which when converted to percentage is 1285%. I will confirm this is how 2.3 and 2.3.1 function as well. James McKenzie
Confirmed that this is how the percent functions in 2.3. Closing Invalid. James McKenzie
Closing issue. This is how the percentage data type functions in Calc and how it functions in Excel (a Microsoft (TM) product.) James McKenzie
Hi, James, I just tested in Excel. We get the same result with this 2 different ways. So I think maybe we should reopen this issue for the sake of interoperability.
Reopening as an enhancement request that the percentage type cell have the same function when clicking into and doubleclicking on a cell, that is all data will be input as percentages.
summary: In the Calc program, if you format a cell as percent and then double-click on the cell the input function is changed to accept raw number input. This is then translated into a percent value by multiplying by 100. This is confusing to users and is not the same as other spreadsheet products. This should function the same as a single-click and accept input as a pre-computed percentage. This is technically not a bug as the cell type is functioning as designed, but the design is incorrect for expected functioning by new users. James McKenzie
reassigning features and enhancements to user requirements@openoffice.org which will be the default owner for those tasks (was introduced some time ago)