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


Help: OASIS Mailing Lists Help | MarkMail Help

office message

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

Subject: Re: [office] Excel 2007 != Ecma spec YEARFRAC. Not even slightly.What should we do?


Warren Turkal wrote:
>>  It doesn't address the problem that different people may want
>>  basis==0 to mean different things.  The only solution I see for that is to
>>  attach some parameter to the sheet (as I noted earlier), which can affect the
>>  mapping of the basis value to the algorithm used.
> Yuck!....Why can't we just rely on the import filters in apps just map
> to the correct bases on import. We certainly shouldn't standardize
> magic variables that affect seemingly unrelated formula calculations.
> As long as we document it clearly, there's no reason that app
> developers cannot handle the conversion.
I think David was referring to the problem of knowing what was meant by 
basis==0. Import filters won't help unless which import filter to apply 
is signaled in some fashion. In which case, why use an import filter at 
all? Simply apply the appropriate rule. Yes?

Hope you are having a great day!


Patrick Durusau
Chair, V1 - US TAG to JTC 1/SC 34
Convener, JTC 1/SC 34/WG 3 (Topic Maps)
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)

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