OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

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

Subject: Re: [office-formula] OFFICE-2164: EASTERSUNDAY

Hi Robert,

On Monday, 2009-10-26 12:13:46 -0400, Robert Weir wrote:

> I'm looking at this from a "linguistic and cultural adaptability" 
> perspective, which is an ISO/IEC requirement.  There are two dates where 
> Easter is celebrated, if you consider as well the Eastern Orthodox 
> observance.  And then there are all the other holidays which have movable 
> dates in various religions and cultures which base such dates on a lunar 
> calendar.
> I wonder whether the approach is to have a function called HOLIDAY(String 
> name, Number year), which you could call as:
> HOLIDAY("Easter", 2009)

No, especially from a "linguistic and cultural adaptability" view string
parameters that could and should but cannot be translated are a no-no.

Existing implementations of CELL() and INFO() made that error in the
past and are causing pain if another implementation or even just another
localization of the otherwise same implementation attempts to read such


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature

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