Hi Liang,, On Tue, Feb 21, 2006 at 09:09:41 -0800, Liang, Xiaodong wrote:
> I tried the following calculation: > = - A2^2 > > I think the result in the cell should be a negative number if A2 is > not a zero. However, the result is actually a positive one. This because also other spreadsheet applications handle it that way. The unary negation binds to the leftmost subexpression, so read your formula as =(-A2)^2 If you want it the way you're used from a calculator, use =-(A2^2) instead. > Please see the attached spreadsheet. Please no attachments on mailing lists. Eike P.S.: As you're not subscribed to the mailing list you were posting to, you will miss replies that are directed to the list only. When answering, please reply only to the list (Reply-To header is set), not to my personal account. Thanks. -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
