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
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 ***