[Bug 124192] New: Calculation of power -2^2

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=124192

            Bug ID: 124192
        Issue Type: DEFECT
           Summary: Calculation of power -2^2
           Product: Calc
           Version: 4.0.1
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: ui
          Assignee: issues@openoffice.apache.org
          Reporter: maijmaij@web.de
                CC: issues@openoffice.apache.org

Take an spreadsheet and type -2^2 into an empty cell.
I expect the result to be -4 but OOffice Calc evaluates to 4 instead.

This is especially annoying if more complex expressions like the following give
different results:

=(-2^2+5)

=-(2^2-5)

Both should evaluate to 1 but Calc returns 9 in the first case.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124192] Calculation of power -2^2

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=124192

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |rb.henschel@t-online.de
         Resolution|---                         |DUPLICATE

--- Comment #1 from Regina Henschel <rb...@t-online.de> ---
AOO strictly follows ODF standard. A unary minus has a higher precedence than
the operator ^. If the minus follows directly after the =, it can only be a
unary minus.
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#refTable0

AOO should automatically insert brackets, so it is clear to the user, how it is
interpreted.

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

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

[Bug 124192] Calculation of power -2^2

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=124192

Regina Henschel <rb...@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.