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

From
Patrick Durusau <>
Date
2008-04-17T22:21:29+00:00
ID
Thread
Re: [office] Excel 2007 != Ecma spec YEARFRAC. Not even slightly.What should we do?
Warren,

Warren Turkal wrote:
<snip>
>>  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

-- 
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)