Hi,
this really works as designed and in the same way like another well
known spreadsheet application. If you single click on a cell which is
preformatted as percent and type a number (e.g. 12.85) you will see that
the percent sign is already added to your input. So you really enter
12.85%. But if you doubleclick the cell you won't get the percentsign
added automatically, so your input of 12.85 will be correctly formatted
to 1285.00%.
Best regards,
Oliver
zhulihua wrote:
Hi, everyone, :-)
If we format some cells to percentage, then we input numbers in them. we found
if we click cell and input a number, e.g. 12.85, It will show me 12.85%. But if
we double click the cell, then input 12.85, after enter key is pressed, it will
show me 1285%.
I tried to find a answer in the "Enhance Number Recognition", but there is only
"input an alien format number input into a formated cell" is talked about.
Does this work as designed? In my mind this will get users confused. If this is
a bug, I'll file a issue in issuetracker.
Thanks!
Best regards,
zhulihua
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
