[OASIS Issue Tracker] Updated: (OFFICE-2164) Add EASTERSUNDAYfunction

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

     [ 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