[Libreoffice-ux-advise] [Bug 157036] LibreOffice 7.6 portable version can not achieve the following function insert->field (date, sheet name, document_title)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Sep 10 03:24:19 UTC 2023


https://bugs.documentfoundation.org/show_bug.cgi?id=157036

neil <recluset2 at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #10 from neil <recluset2 at gmail.com> ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list