https://bugs.documentfoundation.org/show_bug.cgi?id=157201
Bug ID: 157201
Summary: The libreoffice calc cell return value is not normal.
Product: LibreOffice
Version: 7.6.0.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
windows ltsc 21H2 X64
libreoffice portable V7.6
calc
format cells
number normal
language default-chinese(simplified)
In the cell enter "= (69.15-62.15)*1000" Return value is 7000.00000000001
In cell A1 enter "= 69.15-62.15" return value of 7, in cell B1 enter "= A1 *
1000" return value of 7000.00000000001
In the cell enter "=(77.15-69.15)*1000" Return value is 8000
In cell A1 enter "=(77.15-69.15)" return value of 8, in cell B1 enter "= A1 *
1000" return value of 8000
Why is this value returned? Is it a bug?
Please fix it. Thanks.
Steps to Reproduce:
In the cell enter "= (69.15-62.15)*1000" Return value is 7000.00000000001
In cell A1 enter "= 69.15-62.15" return value of 7, in cell B1 enter "= A1 *
1000" return value of 7000.00000000001
In the cell enter "=(77.15-69.15)*1000" Return value is 8000
In cell A1 enter "=(77.15-69.15)" return value of 8, in cell B1 enter "= A1 *
1000" return value of 8000
Actual Results:
In the cell enter "= (69.15-62.15)*1000" Return value is 7000
In cell A1 enter "= 69.15-62.15" return value of 7, in cell B1 enter "= A1 *
1000" return value of 7000
Expected Results:
In the cell enter "= (69.15-62.15)*1000" Return value is 7000.00000000001
In cell A1 enter "= 69.15-62.15" return value of 7, in cell B1 enter "= A1 *
1000" return value of 7000
Reproducible: Always
User Profile Reset: Yes
Additional Info:
No relevant information
--
You are receiving this mail because:
You are the assignee for the bug.
