[OASIS Issue Tracker] (OFFICE-2164) Add EASTERSUNDAY function

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

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

Andreas Guelzow edited comment on OFFICE-2164 at 3/6/22 7:41 PM:
-----------------------------------------------------------------

Alternate 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 if given, otherwise returns the date of the next Easter Sunday on or after TODAY().

Return: Date

Constraints: 1582 <= Year <= 9956

Semantics: Given a value for Year, the Easter Sunday date is calculated according to the following algorithm given an integer {{Year}} in the range from 1582 to 9956:

Â
{code:java}
int month;
int day;
int century, n, k, i, j, l;
century = Year/100;
n = Year - 19 * (Year / 19);
k = (century - 17) / 25;
i = century - century / 4 - (century - k) / 3 + 19 * n + 15;
i %= 30;
i = i - (i / 28) * (1 - (i / 28) * (29 / (i+1)) * ((21 - n) / 11 ));
j = Year + Year / 4 + i + 2 - century + century / 4;
j %= 7;
l = i - j;
month = 3 + (l + 40) / 44;
day = l + 28 - 31 * (month / 4);
{code}
Â

The resulting date is: Date =Â{{Year-month-day}}.

Note that all calculations in the above code are integer calculations and operations are written using C notation.

If Year is not given, the above calculation is performed for the current and the next year and the smaller of the two dates is returned that is not before TODAY().


was (Author: aguelzow):
Alternate 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 if given, otherwise returns the date of the next Easter Sunday on or after TODAY().

Return: Date

Constraints: 1582 <= Year <= 9956

Semantics: Given a value for Year, the Easter Sunday date is calculated according to the following algorithm given an integer {{Year}} in the range from 1582 to 9956:

Â
{code:java}
int month;
int day;
int century, n, k, i, j, l;
century = year/100;
n = Year - 19 * (Year / 19);
k = (century - 17) / 25;
i = century - century / 4 - (century - k) / 3 + 19 * n + 15;
i %= 30;
i = i - (i / 28) * (1 - (i / 28) * (29 / (i+1)) * ((21 - n) / 11 ));
j = Year + Year / 4 + i + 2 - century + century / 4;
j %= 7;
l = i - j;
month = 3 + (l + 40) / 44;
day = l + 28 - 31 * (month / 4);
{code}
Â

The resulting date is: Date =Â{{Year-month-day}}.

Note that all calculations in the above code are integer calculations and operations are written using C notation.

If Year is not given, the above calculation is performed for the current and the next year and the smaller of the two dates is returned that is not before TODAY().

> Add EASTERSUNDAY function
> -------------------------
>
>                 Key: OFFICE-2164
>                 URL: https://issues.oasis-open.org/browse/OFFICE-2164
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: New Feature
>          Components: OpenFormula, Part 2 (Formulas)
>            Reporter: Eike Rathke
>            Assignee: Patrick Durusau
>            Priority: Minor
>             Fix For: ODF 1.4
>
>
> OpenOffice.org Calc knows the EASTERSUNDAY function, this is a proposal to include that with OpenFormula.



--
This message was sent by Atlassian Jira
(v8.3.3#803004)