[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

*Subject*: **[OASIS Issue Tracker] Updated: (OFFICE-1067) Public Comment: ODFF:FV function**

*From*:**OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>***To*: office@lists.oasis-open.org*Date*: Wed, 6 Jan 2010 15:09:15 -0500 (EST)

[ http://tools.oasis-open.org/issues/browse/OFFICE-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eike Rathke updated OFFICE-1067: -------------------------------- Proposal: Change Syntax from FV( Number Rate ; Number Nper ; Number Payment [ ; Number Pv = 0 [ ; Number PayType = 0 ] ] ) to FV( Number Rate ; Number Nper ; Number Payment [ ; [ Number Pv = 0 ] [ ; Number PayType = 0 ] ] ) Add second and third Syntax FV( Number Rate ; Number Nper ; [ Number Payment = 0 ] ; Number Pv [ ; Number PayType = 0 ] ) FV( Number Rate ; Number Nper ; [ Number Payment = 0 ] ; [ Number Pv = 0 ] ; Number PayType ) The same for PV, PMT and NPER with parameter names exchanged accordingly. was: Change Syntax from FV( Number Rate ; Number Nper ; Number Payment [ ; Number Pv = 0 [ ; Number PayType = 0 ] ] ) to FV( Number Rate ; Number Nper ; Number Payment [ ; [ Number Pv = 0 ] [ ; Number PayType = 0 ] ] ) Add second and third Syntax FV( Number Rate ; Number Nper ; [ Number Payment = 0 ] ; Number Pv [ ; Number PayType = 0 ] ) FV( Number Rate ; Number Nper ; [ Number Payment = 0 ] ; [ Number Pv = 0 ] ; Number PayType ) The same for PV, PMT, NPER and RATE with parameter names exchanged accordingly. Note that RATE has an additional optional parameter Guess. Description: Copied from office-comment list Original author: "David King" <openoffice@drking.plus.com> Original date: 13 Aug 2008 21:58:25 -0000 Original URL: http://lists.oasis-open.org/archives/office-comment/200808/msg00037.html * PMT can be omitted (default = 0) in Calc and Excel, if Pv is given. * [] optional parameter brackets are wrong - Pv can be omitted while PayType is present. [ed:] Calc, Gnumeric and Excel also allow both, Payment and Pv, to be optional if PayType is given, but not if PayType is not given. Implementations did not document this behavior. The same optional parameter constellation is true for PV (with Payment and Fv), but an omittable Payment isn't even documented. The same optional parameter constellation is true for PMT (with Pv and Fv), but an omittable Pv isn't even documented. The same optional parameter constellation is true for NPER (with Pv and Fv), but an omittable Pv isn't even documented. was: Copied from office-comment list Original author: "David King" <openoffice@drking.plus.com> Original date: 13 Aug 2008 21:58:25 -0000 Original URL: http://lists.oasis-open.org/archives/office-comment/200808/msg00037.html * PMT can be omitted (default = 0) in Calc and Excel, if Pv is given. * [] optional parameter brackets are wrong - Pv can be omitted while PayType is present. [ed:] Calc, Gnumeric and Excel also allow both, Payment and Pv, to be optional if PayType is given, but not if PayType is not given. Implementations did not document this behavior. The same optional parameter constellation is true for PV (with Payment and Fv), but an omittable Payment isn't even documented. The same optional parameter constellation is true for PMT (with Pv and Fv), but an omittable Pv isn't even documented. The same optional parameter constellation is true for NPER (with Pv and Fv), but an omittable Pv isn't even documented. The same optional parameter constellation is true for RATE (with Pv and Fv), but an omittable Pv isn't even documented. RATE is handled in OFFICE-1072. > Public Comment: ODFF: FV function > --------------------------------- > > Key: OFFICE-1067 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-1067 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: Bug > Components: OpenFormula > Affects Versions: ODF 1.2 > Reporter: Robert Weir > Assignee: Eike Rathke > Fix For: ODF 1.2 > > > Copied from office-comment list > Original author: "David King" <openoffice@drking.plus.com> > Original date: 13 Aug 2008 21:58:25 -0000 > Original URL: http://lists.oasis-open.org/archives/office-comment/200808/msg00037.html > * PMT can be omitted (default = 0) in Calc and Excel, if Pv is given. > * [] optional parameter brackets are wrong - Pv can be omitted while PayType is present. > [ed:] > Calc, Gnumeric and Excel also allow both, Payment and Pv, to be optional if PayType is given, but not if PayType is not given. Implementations did not document this behavior. > The same optional parameter constellation is true for PV (with Payment and Fv), but an omittable Payment isn't even documented. > The same optional parameter constellation is true for PMT (with Pv and Fv), but an omittable Pv isn't even documented. > The same optional parameter constellation is true for NPER (with Pv and Fv), but an omittable Pv isn't even documented. -- 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