Bug 159684 - EDITING: Erroneous interpretation of math formula in LibreOffice Calc, eg. -1^2 evaluates to "1" instead of "-1"
Summary: EDITING: Erroneous interpretation of math formula in LibreOffice Calc, eg. -1...
Status: RESOLVED DUPLICATE of bug 37271
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.4.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-02-11 22:35 UTC by wzarebs
Modified: 2024-02-12 01:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description wzarebs 2024-02-11 22:35:48 UTC
Description:
Enter a string
                                   =-1^2
into any LibreOffice Calc cell. Then the formula is evaluated to "1",
however, the correct value should be -1.
In my opinion, -1^2 should be evaluated to -(1^2), but not to (-1)^2

Steps to Reproduce:
1. Enter a formula "=-1^2" in any LibreOffice Calc cell.
2. Press Enter.
3. Formula evaluates to "1" (i.e. it is understood as "(-1)^2").
4. The result should be -(1^2)=-1, not 1. 

Actual Results:
1

Expected Results:
-1


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.4.1 (x86) / LibreOffice Community
Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: pl-PL
Calc: threaded
Comment 1 Regina Henschel 2024-02-12 00:34:14 UTC
Please notice the discussion in bug 114929 about how we can help users with such formula.

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