https://bugs.documentfoundation.org/show_bug.cgi?id=150855
Bug ID: 150855
Summary: Wrong calculations if used no brackets
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If you make adding from few cells and nusing no brackets you get wrong result.
Steps to Reproduce:
1.Insert value in cell A1 (ex. 2500)
2.Insert Value B1 (ex.2500)
3.Insert value D1 (ex.10000)
4.In cell C1 insert formula: =D1-A1+B1
Actual Results:
10000
Expected Results:
5000
Reproducible: Always
User Profile Reset: Yes
Additional Info:
If you put in brackets =D1-(A1+B1) result is correct.
Version: 7.3.6.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.6~rc2-0ubuntu0.20.04.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
