Hi, James, I tested inputing numbers in a percentage formated cell, with the 2 ways we talked about.
In MS office 2003, no matter we click or double click the cell and input numbers in it, it will show me the same result. Best regards, Zhu Lihua 发件人： James McKenzie 发送时间： 2008-02-25 11:09:05 收件人： [email protected] 抄送： 主题： Re: [qa-dev] percentage format in calc seems doesn't work well. zhulihua wrote: > [Reply moved to bottom per RFC 1855] > > 发件人： James McKenzie > 发送时间： 2008-02-22 22:12:34 > 收件人： [email protected] > 抄送： > 主题： Re: [qa-dev] percentage format in calc seems doesn't work well. > > 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 > Hi, James, I tested in MS Office 2003. Best regards, Zhu Lihua I would like to know what you tested as your reply is ambiguous. James McKenzie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
