https://bugs.documentfoundation.org/show_bug.cgi?id=100562
Bug ID: 100562
Summary: DB() function, period and lifetime parameter
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: r...@post.cz
ODF specification: 6.12.13 DB
Summary: Compute the depreciation allowance of an asset.
Syntax: DB( Number cost ; Number salvage ; Integer lifeTime ; Number period [ ;
Number month = 12 ] )
Returns: Currency
Constraints: cost > 0, salvage >= 0, lifetime >0; period > 0; 0 < month < 13
=DB(25000;1000;0;1;6)
=DB(25000;1000;36;0;6)
=DB(25000;1000;36;-1;6)
period parameter specified as "period > 0". Lifetime as "lifetime> 0". These
formulas should throws error.
Checked in excel and excel return error.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs