Bug 94580 - incorrect calculation for negative roots
Summary: incorrect calculation for negative roots
Status: RESOLVED DUPLICATE of bug 37271
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86 (IA32) Linux (All)
: medium critical
Assignee: Not Assigned
Depends on:
Reported: 2015-09-28 16:39 UTC by forcepam
Modified: 2020-08-31 12:05 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description forcepam 2015-09-28 16:39:50 UTC

the following math expression "-3^-2" is given a positive solution in Calc while the solution is negative.

Comment 1 GerardF 2015-09-28 16:56:10 UTC
-3^-2 is calculated by Calc as (-3)^-2.
Write -(3^-2) if you want the negation of the formula.

Seems to be a duplicate of https://bugs.documentfoundation.org/show_bug.cgi?id=37271
Comment 2 Julien Nabet 2015-09-28 19:11:14 UTC
I agree that -3^-2 should be treated like -(3^-2) not like (-3)^-2
Some argue about compatibility but I strongly disagree, a mistake is a mistake. I prefer not being compatible or at least detect such cases and propose to add parenthesis. The (or should I say "my") problem is, it's not majority opinion at least for LO Devs.

Anyway, it's indeed a duplicate of tdf#37271. I'm really sorry to say it won't be fixed as you and I would expect :-(

*** This bug has been marked as a duplicate of bug 37271 ***