[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-1102) Public Comment: ODFF:INTRATE function
[ http://tools.oasis-open.org/issues/browse/OFFICE-1102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eike Rathke updated OFFICE-1102: -------------------------------- Proposal: A few corrections: Replace "Basis: [optional] indicates how the year is to be treated; see section 3.11.6" with "Basis: [optional] indicates the day count basis to use; see section 3.11.6" Replace "Constraints: If settlement date or maturity date is not valid, INTRATE returns an error." with Constraints: Settlement < Maturity From Semantics remove "If the Settlement date is equal to or after the maturity date, an Error is returned." And add the formula: The return value for this function is: ( (Redemption- Investment)/Investment ) / YEARFRAC(Settlement; Maturity; Basis) was: A few corrections: Replace "Basis: [optional] indicates how the year is to be treated; see section 3.11.6" with "Basis: [optional] indicates the day count basis to use; see section 3.11.6" Replace "Constraints: If settlement date or maturity date is not valid, INTRATE returns an error." with Constraints: Settlement < Maturity And add the formula: The return value for this function is: ( (Redemption- Investment)/Investment ) / YEARFRAC(Settlement; Maturity; Basis) > Public Comment: ODFF: INTRATE function > -------------------------------------- > > Key: OFFICE-1102 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-1102 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Bug > Components: OpenFormula > Reporter: Robert Weir > Assignee: Robert Weir > Priority: Blocker > Fix For: ODF 1.2 Part 2 CD 3 > > > Copied from office-comment list > Original author: "David King" <openoffice@drking.plus.com> > Original date: 5 Sep 2008 17:35:41 -0000 > Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00007.html -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]