[OASIS Issue Tracker] (OFFICE-3920) VDB startPeriod and endPeriod

[ https://issues.oasis-open.org/browse/OFFICE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=72291#comment-72291 ] 

Patrick Durusau commented on OFFICE-3920:
-----------------------------------------

Waiting on feedback from Office team.

> VDB startPeriod and endPeriod
> -----------------------------
>
>                 Key: OFFICE-3920
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3920
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula, Part 2 (Formulas)
>            Reporter: Patrick Durusau
>            Priority: Major
>             Fix For: ODF 1.3
>
>
> 6.12.50 VDB
> says
> "VDB allows for the use of an initialPeriod option to calculate
> depreciation for the period the asset is placed in service. VDB uses the
> fractional part of startPeriod and endPeriod to determine the
> initialPeriod option. If both startPeriod and endPeriod have fractional
> parts, then VDB uses the fractional part of startPeriod."
> I think this is wrong, it seems to say that only the fractional part of
> startPeriod is used if both, startPeriod and endPeriod, have fractional
> parts given. Instead, both fractional parts should be considered. The
> last sentence "If both ..." should be omitted from that paragraph.
> In LibreOffice Calc the calculation was corrected, see
> https://bugs.documentfoundation.org/show_bug.cgi?id=101204
> including a test case document.



--
This message was sent by Atlassian JIRA
(v7.7.2#77003)