[Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

Regina Henschel  changed:

   What|Removed |Added

 CC||wzar...@ch.pw.edu.pl

--- Comment #24 from Regina Henschel  ---
*** Bug 159684 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

b.  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=13
   ||6268

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

Aron Budea  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||4929

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

--- Comment #23 from Regina Henschel  ---
(In reply to Michael Meeks from comment #22)
> I'd suggest that whomever
> is interested in this - file a new enhancement bug that concisely describes
> the confusion caused here (which is clearly real), and how to work around it
> by auto-inserting brackets

The enhancement request for inserting brackets is in bug 114929.
A request to improve the help texts is in bug 114930.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

--- Comment #22 from Michael Meeks  ---
It seems to be a common problem so should have the feature enhancement to add
the ( ) in automatically (I guess) at least filed. Implementing that, of
course, requires some coding action - which would need to be done by someone.
This bug has got too cluttered for this. I'd suggest that whomever is
interested in this - file a new enhancement bug that concisely describes the
confusion caused here (which is clearly real), and how to work around it by
auto-inserting brackets - Long bug reports are a real problem for developers to
read and get interested. Then we can close this bug as a duplicate of that one.

Thanks =)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

--- Comment #21 from Karel Hruska  ---
(In reply to Timur from comment #20)
> Tor set this as Notabug (I don't know whether he is still active) and Björn
> supported it.
> But due to a number of duplicates, I personally don't agree with "do
> nothing" approach. 
> This should be reconsidered, maybe on ESC.

I agree that this is something that should be discussed in a wider group,
especially with mathematicians. Thanks for support.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

Timur  changed:

   What|Removed |Added

 CC||michael.me...@collabora.com

--- Comment #20 from Timur  ---
Tor set this as Notabug (I don't know whether he is still active) and Björn
supported it.
But due to a number of duplicates, I personally don't agree with "do nothing"
approach. 
This should be reconsidered, maybe on ESC.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

--- Comment #19 from Karel Hruska  ---
"Status:RESOLVED NOTABUG (edit)"

This is a joke? I've spent two hours of my working time finding out, why
expression

z = -i_M^2/(3*u) + u + i_DELTA^2/8

does not work, while finding, that required syntax is

z = -(i_M^2)/(3*u) + u + i_DELTA^2/8

which is NOT mathematically correct, and it is NOT considered a bug?

I thought, that LibreOffice is better than MS Office, but apparently it is
not...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

Aron Budea  changed:

   What|Removed |Added

 CC||push...@email.cz

--- Comment #18 from Aron Budea  ---
*** Bug 114922 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

Julien Nabet  changed:

   What|Removed |Added

 CC||jlbounho...@gmail.com

--- Comment #17 from Julien Nabet  ---
*** Bug 98248 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

Eike Rathke  changed:

   What|Removed |Added

Version|3.3.2 release   |Inherited From OOo

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

Julien Nabet  changed:

   What|Removed |Added

 CC||force...@gmail.com

--- Comment #16 from Julien Nabet  ---
*** Bug 94580 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

GerardF  changed:

   What|Removed |Added

 CC||esc...@gmail.com

--- Comment #14 from GerardF  ---
*** Bug 94568 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

--- Comment #15 from Adrian Maire  ---
So as Microsoft developers has made a mistake 20 years ago, LibreOffice also
copied this mistake without even checking. And now, to maintain
retro-compatibility, we are going to have this wrong behaviour until the end of
the time?.

Today, I lost 2h until I discovered why the hell my function with around 30
parameters was wrong to discover that Libre-office was wrong. 

I asked a Mathematician community to be sure before and I end-up against these
comments.

Possible solution:
Change the behaviour to the correct, and add parentheses while opening old
files from before the update so they still work.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

--- Comment #13 from donots...@fastmail.fm ---
Not being an Excel user I hadn't realised that Excel also deviates from
mathematical convention, but I agree that compatibility should be maintained as
far as possible.

My question is, would a gnumeric-like solution of background-bracketing -x^y to
(-x)^y would at least give users a clue that the result may not be what they
intended, if they understand the maths behind what they are perhaps trying to
achieve.

Would such an approach break anything?

I have difficulty in accepting that an inaccurate result in a spreadsheet from
a formula observing conventions of operator precedence should not be considered
potentially a major problem.  Also, in maths, for something so fundamental,
surely this "convention" is a standard in all but name?  Other approaches
(postfix etc) might be considered somewhat non-mainstream and I think are
likely to be used by those who are mindful of such issues and know what to
check for and against (eg. scientists, mathematicians) rather than, say, a
doctor or pharmacist calculating a dosage and expecting the spreadsheet to work
like maths does...

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 37271] -A1^2 is interpreted as (-A1)^2 instead of -(A1^2), violating the order of operations as defined in mathematics

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=37271

Julien Nabet  changed:

   What|Removed |Added

 CC||donots...@fastmail.fm

--- Comment #12 from Julien Nabet  ---
*** Bug 93983 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs