Mailing-List: contact dev-help@openoffice.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openoffice.apache.org
Date: Mon, 12 Oct 2015 20:58:39 +0100
From: Rory O'Farrell <ofarrwrk@iol.ie>
To: dev@openoffice.apache.org
Subject: Re: [API] Priority Problem with AND and OR
Message-Id: <20151012205839.9d2633db5e9e69a64c1468cf@iol.ie>
In-Reply-To: <6f82f188c9370f89340fb07b5978701a@xaox.net>
References: <561C0C9D.1090300@gmx.net>
	<6f82f188c9370f89340fb07b5978701a@xaox.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Mon, 12 Oct 2015 15:45:16 -0400
Andrew Pitonyak <andrew@pitonyak.org> wrote:

> Yes, I note this travesty in OOME. There is also a difference in the=20
> way that it handles exponentiation. Standard rules indicate that 2^3^4=20
> is evaluated as 2^(3^4) rather than (2^3)^4, wihch is what OOo does.

This problem came up recently several times on the en-Forum; we advised tha=
t it is best to use the brackets to define order of calculation (particular=
ly as so many Calc users are mathematically inexperienced).  It would never=
theless be good to have the matter correct in some revision.

Rory O'Farrell=20
> On 12.10.2015 15:40, Mathias R=F6llig wrote:
> > Hello!
> >
> > I stumbled into a priority problem with the boolean operators AND and
> > OR. I cannot find any documentation for this.
> >
> > First mathematical examples.
> >
> > With
> > MsgBox( 3 * 2 ^ 2 )
> > you will see, that ^ has a higher priority than *.
> > (2 ^ 2) =3D 4
> > 4 * 3 =3D 12
> > With
> > MsgBox( (3 * 2) ^ 2 )
> > you will get the right result 6 ^ 2 =3D 36.
> >
> > With
> > MsgBox( 3 + 4 * 3 )
> > you will see, that * has a higher priority than +.
> > (4 * 3) =3D 12
> > 3 * 12 =3D 36
> > With
> > MsgBox( (3 + 4) * 3 )
> > you will get the right result 7 * 3 =3D 21.
> >
> > Now looking at the same logic with logical operators.
> >
> > Dim bResult As Boolean
> > bResult =3D TRUE Or FALSE And TRUE
> > MsgBox( bResult )
> > bResult =3D TRUE Or TRUE And FALSE
> > MsgBox( bResult )
> >
> > What do you expect?
> > For logical operations AND is equivalent to * and OR is equivalent to=20
> > +.
> > AND should have a higher priority than OR, so I would expect in both
> > cases (because TRUE Or (<anything>) =3D TRUE):
> > bResult =3D TRUE
> > But you will get
> > TRUE Or FALSE And TRUE =3D (TRUE Or FALSE) And TRUE =3D TRUE
> > TRUE Or TRUE And FALSE =3D (TRUE Or TRUE) And FALSE =3D FALSE
> >
> > Is there any explanation that AND and OR have (and should have) the
> > same priority?
> >
> > Regards, Mathias
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> > For additional commands, e-mail: dev-help@openoffice.apache.org
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>=20
>=20


--=20
Rory O'Farrell <ofarrwrk@iol.ie>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org