RE: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Dennis E. Hamilton
Yes, NOT A BUG is definitely preferable to INVALID. - Dennis -Original Message- From: Rob Weir [mailto:robw...@apache.org] Sent: Monday, May 27, 2013 02:56 PM To: dev@openoffice.apache.org; Dennis Hamilton Subject: Re: Question about: OpenOffice Calc. "=-1^2" like e

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Rob Weir
g is to rename "INVALID" so it is less offensive? Maybe NOT-A-BUG or something like that? But still preserve the distinction between that at WONTFIX. Regards, -Rob > -Original Message- > From: Rory O'Farrell [mailto:ofarr...@iol.ie] > Sent: Monday, May 27, 2013 05:

RE: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Dennis E. Hamilton
quired to be that way). -Original Message- From: Rory O'Farrell [mailto:ofarr...@iol.ie] Sent: Monday, May 27, 2013 05:21 AM To: dev@openoffice.apache.org Subject: Re: Question about: OpenOffice Calc. "=-1^2" like expressions On Mon, 27 May 2013 14:08:15 +0200 Andrea

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Torokhov Sergey
27.05.2013, 16:16, "Regina Henschel" : > > My personal favorite is the way Gnumeric does it. It puts brackets > around -1 when you enter the formula, so that there is no doubt about > the meaning. > > Kind regards > Regina > It looks currently like best solution without misunderstanding from vi

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Andre Fischer
On 27.05.2013 14:08, Andrea Pescetti wrote: Andre Fischer wrote: In any case, this is a problem with no good solution. Indeed. Before this becomes another 0 ^ 0... there is an issue for this, it dates back to 2004 and it is marked invalid. That's it. https://issues.apache.org/ooo/show_bug.c

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Torokhov Sergey
Thanks to all for explanations - To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Rory O'Farrell
On Mon, 27 May 2013 14:08:15 +0200 Andrea Pescetti wrote: > Andre Fischer wrote: > > In any case, this is a problem with no good solution. > > Indeed. Before this becomes another 0 ^ 0... there is an issue for this, > it dates back to 2004 and it is marked invalid. That's it. > > https://issue

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Regina Henschel
Hi, please see the (long) discussions in https://issues.apache.org/ooo/show_bug.cgi?id=24271 and https://issues.apache.org/ooo/show_bug.cgi?id=26755 and its duplicates. Torokhov Sergey schrieb: There is a some strange behaviour in "OpenOffice Calc" (and in Microsoft Office too). Did it was m

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Andrea Pescetti
Andre Fischer wrote: In any case, this is a problem with no good solution. Indeed. Before this becomes another 0 ^ 0... there is an issue for this, it dates back to 2004 and it is marked invalid. That's it. https://issues.apache.org/ooo/show_bug.cgi?id=24271 If someone has strong feelings h

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Andre Fischer
On 27.05.2013 13:33, Norbert Thiebaud wrote: On Mon, May 27, 2013 at 4:20 AM, Torokhov Sergey wrote: There is a some strange behaviour in "OpenOffice Calc" (and in Microsoft Office too). Did it was made in OpenOIffice for compability with MSO? http://en.wikipedia.org/wiki/Order_of_operations#

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Oliver-Rainer Wittmann
Hi, On 27.05.2013 11:20, Torokhov Sergey wrote: There is a some strange behaviour in "OpenOffice Calc" (and in Microsoft Office too). Did it was made in OpenOIffice for compability with MSO? This seems to concern all combinations of even degrees and "minus" sign in the begining of formula 1.

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Norbert Thiebaud
On Mon, May 27, 2013 at 4:20 AM, Torokhov Sergey wrote: > There is a some strange behaviour in "OpenOffice Calc" (and in Microsoft > Office too). Did it was made in OpenOIffice for compability with MSO? http://en.wikipedia.org/wiki/Order_of_operations#Exceptions_to_the_standard The behavior or

Re: Question about: OpenOffice Calc. "=-1^2" like expressions

2013-05-27 Thread Herbert Dürr
On 2013/05/27 11:20 AM, Torokhov Sergey wrote: There is a some strange behaviour in "OpenOffice Calc" (and in Microsoft Office too). Did it was made in OpenOIffice for compability with MSO? This seems to concern all combinations of even degrees and "minus" sign in the begining of formula 1.