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

2013-05-27 Thread Torokhov Sergey
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. Enter in cell the expression: =-1^2 The result will

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.

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 torokhov-...@yandex.ru 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?

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 Andre Fischer
On 27.05.2013 13:33, Norbert Thiebaud wrote: On Mon, May 27, 2013 at 4:20 AM, Torokhov Sergey torokhov-...@yandex.ru 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?

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

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

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 pesce...@apache.org 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.

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 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.

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

2013-05-27 Thread Torokhov Sergey
27.05.2013, 16:16, Regina Henschel rb.hensc...@t-online.de: 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

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

2013-05-27 Thread Dennis E. Hamilton
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 Pescetti pesce...@apache.org

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

2013-05-27 Thread Rob Weir
that at WONTFIX. Regards, -Rob -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 Pescetti pesce

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 expressions