Issue 86337 - Make double-clicking on percentage formatted cell function the same as single-click
Summary: Make double-clicking on percentage formatted cell function the same as single...
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.4 RC1
Hardware: All All
: P4 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Blocks: 84292
  Show dependency tree
Reported: 2008-02-22 02:05 UTC by redflagzhulihua
Modified: 2013-02-07 22:42 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description redflagzhulihua 2008-02-22 02:05:01 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
Comment 1 jjmckenzie 2008-02-22 03:58:42 UTC
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
Comment 2 jjmckenzie 2008-02-22 04:01:19 UTC
Confirmed that this is how the percent functions in 2.3.

Closing Invalid.
James McKenzie
Comment 3 jjmckenzie 2008-02-22 04:06:24 UTC
Closing issue. 

This is how the percentage data type functions in Calc and how it functions in
Excel (a Microsoft (TM) product.)

James McKenzie
Comment 4 redflagzhulihua 2008-02-22 06:26:06 UTC
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.
Comment 5 jjmckenzie 2008-02-22 09:54:30 UTC
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.
Comment 6 jjmckenzie 2008-02-22 10:03:24 UTC

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
Comment 7 oc 2008-07-15 10:43:25 UTC
reassigning features and enhancements to user which
will be the default owner for those tasks (was introduced some time ago)