[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: [OASIS Issue Tracker] Updated: (OFFICE-2164) Add EASTERSUNDAYfunction
[ http://tools.oasis-open.org/issues/browse/OFFICE-2164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eike Rathke updated OFFICE-2164: -------------------------------- Proposal: Move EASTERSUNDAY from the Huge group to the Large group. Define as: Syntax: EASTERSUNDAY( Number Year ) Description: Returns the date of Easter Sunday in the year passed as Year. Return: Date Constraints: Year >= 1583 Semantics: The Easter Sunday date is calculated according to the algorithms of Butcher or Oudin for years >= 1583 in the Gregorian calendar. References: http://www.smart.net/~mmontes/butcher.html http://www.tondering.dk/claus/cal/node3.html#SECTION003137000000000000000 (Calendar FAQ, Easter algorithms for Julian and Gregorian calendar) "Explanatory Supplement to the Astronomical Almanac", P. Kenneth Seidelmann, editor. was: Move EASTERSUNDAY from the Huge group to the Large group. Define as: Syntax: EASTERSUNDAY( Number Year ) Description: Returns the date of Easter Sunday in the year passed as Year. Return: Date Semantics: The Easter Sunday date is calculated according to the algorithms of Butcher (Nature 1876) or Oudin (Explanatory Supplement to the Astronomical Almanac) Description: OpenOffice.org Calc knows the EASTERSUNDAY function, this is a proposal to include that with OpenFormula. (was: OpenOffice.org Calc knows the EASTERSUNDAY function, this is a proposal to include that with OpenFormula / ODF 1.2) Added to the proposal to use Gregorian calendar, valid for years >= 1583, and added online references. @Andreas: I don't think Gnumeric's behavior with the optional parameter defaulting to the _next_ Easter Sunday is practical. Easter Sunday is also used to calculate other Christian holidays like Pentecost Sunday (Easter Sunday +49 days). Changing the year of these events depending on whether the formula is calculated before or after Easter may cause confusion. > Add EASTERSUNDAY function > ------------------------- > > Key: OFFICE-2164 > URL: http://tools.oasis-open.org/issues/browse/OFFICE-2164 > Project: OASIS Open Document Format for Office Applications (OpenDocument) TC > Issue Type: New Feature > Components: OpenFormula > Reporter: Eike Rathke > Assignee: Eike Rathke > Fix For: ODF 1.2 > > > OpenOffice.org Calc knows the EASTERSUNDAY function, this is a proposal to include that with OpenFormula. -- 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]