Oliver Craemer - Sun Germany - Hamburg wrote:
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
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
Oliver:
Since I have MSDN access to the latest version of that well known
spreadsheet, I will confirm this action. If it is not so, we need to
change the way that percentage cells function in Calc. If the
functionality is as you state, then we need to document it in the help
files and any other documentation. The issue submitted by zhulihua will
remain open in either situation.
James Mckenzie
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
