André Schnabel wrote: > Hi James, > > >> No, this is how the percentage data type functions: >> >> 1. If you click into the cell, you are entering percentages, i.e. 12.85 >> will be 12.85%. >> 2. If you DOUBLE CLICK into the cell, you are entering raw numbers, i.e. >> 12.85 will be 1285%. >> >> Thus this functions as designs and I have closed the issue as Invalid. >> >> > Ok - if you think, you are the only one who knows what user expect .... > > I don't know what a user expects from Calc, I do know what happens when you double click on a percentage cell in that other product. > For a user (as me) it is a bug, if I get different results whe I enter > the same number in a slightly different way. > Andre:
I agree that this is not expected behaviour and should be annotated as either an enhancement or this should be in the help. This is, however, the way that a percentage cell functions in that other spreadsheet product. > But maybe this is the known trap "the deeper you are involved in the > project the more you claim to know what is right or wrong". > > Not a trap, but a little knowledge is a dangerous thing. My suggestion is that we document how this works now and if we want to change it, put in an enhancement request. People migrating from that other product expect this type of action for a cell. And Yes, I was surprised that Calc worked this way as well, but I have access to that other product and that is how it functions. James --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
