Bug 157201 - The libreoffice calc cell return value is not normal.
Summary: The libreoffice calc cell return value is not normal.
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.0.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-12 07:59 UTC by neil
Modified: 2023-09-12 08:08 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description neil 2023-09-12 07:59:01 UTC 
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