I was tempted to open a bug against this some years back, but, this is
the type of change that I can't help but wonder if it is more dangerous
to affect existing code, or to use rules by new users who are unaware
that ^ does not follow expected rules, and neither does AND and OR. Same
is true for bitwise operations.
On 12.10.2015 15:58, Rory O'Farrell wrote:
On Mon, 12 Oct 2015 15:45:16 -0400
Andrew Pitonyak <and...@pitonyak.org> wrote:
Yes, I note this travesty in OOME. There is also a difference in the
way that it handles exponentiation. Standard rules indicate that
2^3^4
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 that it is best to use the brackets to define order of
calculation (particularly as so many Calc users are mathematically
inexperienced). It would nevertheless be good to have the matter
correct in some revision.
Rory O'Farrell
On 12.10.2015 15:40, Mathias Röllig 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) = 4
> 4 * 3 = 12
> With
> MsgBox( (3 * 2) ^ 2 )
> you will get the right result 6 ^ 2 = 36.
>
> With
> MsgBox( 3 + 4 * 3 )
> you will see, that * has a higher priority than +.
> (4 * 3) = 12
> 3 * 12 = 36
> With
> MsgBox( (3 + 4) * 3 )
> you will get the right result 7 * 3 = 21.
>
> Now looking at the same logic with logical operators.
>
> Dim bResult As Boolean
> bResult = TRUE Or FALSE And TRUE
> MsgBox( bResult )
> bResult = TRUE Or TRUE And FALSE
> MsgBox( bResult )
>
> What do you expect?
> For logical operations AND is equivalent to * and OR is equivalent
to
> +.
> AND should have a higher priority than OR, so I would expect in
both
> cases (because TRUE Or (<anything>) = TRUE):
> bResult = TRUE
> But you will get
> TRUE Or FALSE And TRUE = (TRUE Or FALSE) And TRUE = TRUE
> TRUE Or TRUE And FALSE = (TRUE Or TRUE) And FALSE = FALSE
>
> Is there any explanation that AND and OR have (and should have)
the
> same priority?
>
> Regards, Mathias
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: dev-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
