[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] (OFFICE-3879) In function floor, mode<>0 rounds toward zero, not away from zero
[ https://issues.oasis-open.org/browse/OFFICE-3879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Michael Stahl updated OFFICE-3879: ---------------------------------- Component/s: Part 2 (Formulas) > In function floor, mode<>0 rounds toward zero, not away from zero > ------------------------------------------------------------------ > > Key: OFFICE-3879 > URL: https://issues.oasis-open.org/browse/OFFICE-3879 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Bug > Components: OpenFormula, Part 2 (Formulas) > Affects Versions: ODF 1.2 > Reporter: Regina Henschel > Priority: Major > Fix For: ODF 1.3 > > > This issue has been reported in https://lists.oasis-open.org/archives/office-comment/201502/msg00000.html > Example floor(6.4;2;1) results in 6 in LibreOffice and OpenOffice. Following the description in "6.17.3 FLOOR" it would result in 8. > A mode-value<>zero is used to get a function which is compatible to Excel's function "floor", which rounds toward zero. Therefore Gnumeric exports it's Excel compatible function "floor" to floor(number; significance;1) when exporting to ODF. > I guess, that it is a forgotten adaption, when copying the description of "ceiling" and adapt it to "floor". Therefore I suggest to fix it in the errata. > The suggestion of the reporter to find a better wording in general, can be handled in an issue for ODF 1.3. -- This message was sent by Atlassian JIRA (v7.7.2#77003)
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]