Hi :) I was wrong. I have been thinking a bit more. By Bodmas the subtraction is the last thing on the list and the multiplication should be done before that. There is an apparent ambiguity here and people with a maths background 'should' expect that and either test it or use brackets, at least that is my excuse.
An equation that results in -2 and then the spreadsheet takes that result and squares it then the result 'should' be (-2)^2 = +4 but the rest of the time -2^2 'should' be -(2^2) Regard from Tom :) ----- Original Message ---- > From: Regina Henschel <[email protected]> > To: [email protected] > Sent: Fri, 10 June, 2011 23:39:01 > Subject: Re: [libreoffice-documentation] Re: Collecting small things in the >Wiki > > Hi Tom, > Tom Davies schrieb: > > Hi :) > > 3^2 does =9 ? > > That's not the problem. But -3^2 result in 9 and that is the problem. > http://openoffice.org/bugzilla/show_bug.cgi?id=26755 > > Kind regards > Regina > > -- Unsubscribe instructions: E-mail to >[email protected] > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/documentation/ > All messages sent to this list will be publicly archived and cannot be deleted > -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/documentation/ All messages sent to this list will be publicly archived and cannot be deleted
