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]
