https://bugs.documentfoundation.org/show_bug.cgi?id=106210
Bug ID: 106210
Summary: =EFFECT(0,4) returns error
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
> SYNTAX: EFFECT( _Number_ rate ; _Integer_ payments )
>
> CONSTRAINTS: rate >= 0; =EFFECT(0,4) returns error, so constraints
> should be rate > 0 (without =) ? The same in excel :
> https://support.office.com/en-US/article/EFFECT-function-910D4E4C-79E2-4009-95E6-507E04F11BC4
> If nominal_rate ≤ 0 or if npery < 1, EFFECT returns the #NUM! error
> value.
EFFECT is an ODFF1.2 function, the code currently does not apply the
ODFF-constraints correctly. There is no reason why
argument rate may not be 0.
Actual Results:
.
Expected Results:
.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:51.0) Gecko/20100101 Firefox/51.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
