https://bugs.documentfoundation.org/show_bug.cgi?id=172117
Bug ID: 172117
Summary: There is no difference in two Calc functions
Product: LibreOffice
Version: 24.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I tried:
=REDONDEAR.MENOS(-5.89)
=TRUNCAR(-5.89)
Both are the same -5, in "=REDONDEAR.MENOS(-5.89)" It must be -6
Steps to Reproduce:
1.put in any cell: =REDONDEAR.MENOS(-5.89)
2.put in any cell: =TRUNCAR(-5.89)
Actual Results:
=REDONDEAR.MENOS(-5.89): -5
=TRUNCAR(-5.89): -5
Expected Results:
=REDONDEAR.MENOS(-5.89): -6
=TRUNCAR(-5.89): -5
Reproducible: Always
User Profile Reset: No
Additional Info:
REDONDEAR.MENOS(): always goes down to the lower integer.
TRUNCAR(): cut decimals.
--
You are receiving this mail because:
You are the assignee for the bug.
