https://bugs.documentfoundation.org/show_bug.cgi?id=154797
Bug ID: 154797
Summary: ROUNDUP and ROUNDDOWN Function may not match when
Count Section is zero or omitted.
Product: LibreOffice
Version: 7.5.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
ROUNDUP and ROUNDDOWN Function may not match when Count Section is zero or
omitted.
Steps to Reproduce:
1. Open New Calc
2. Input
=ROUNDDOWN(100000000000.9 ; 0)
or
=ROUNDUP(100000000000.1 ; 0)
Actual Results:
3.
=ROUNDDOWN(100000000000.9 ; 0) -> 100000000001
=ROUNDUP(100000000000.1 ; 0) -> 100000000000
Expected Results:
3.
=ROUNDDOWN(100000000000.9 ; 0) -> 100000000000
=ROUNDUP(100000000000.1 ; 0) -> 100000000001
Reproducible: Always
User Profile Reset: No
Additional Info:
The following is a comparison between the case of zero and omitted.
=ROUNDDOWN(100000000000.9 ; 0) -> 100000000001
=ROUNDDOWN(100000000000.9) -> 100000000000
=ROUNDUP(100000000000.1 ; 0) -> 100000000000
=ROUNDUP(100000000000.1) -> 100000000001
---
Reference help
https://help.libreoffice.org/7.5/en-US/text/scalc/01/04060106.html
ROUNDUP
If Count is omitted or zero, the function rounds up to an integer.
---
Even if there is a problem with accuracy, it must be the same value in this
case.
It looks correct if the Count Section is omitted.
---
Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: Skia/Raster; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: fc6806c4be8585ce0d35a6b581bf8b3dbf858500
CPU threads: 4; OS: Windows 10.0 Build 10240; UI render: default; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
