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

[Patrick Durusau <patrick@durusau.net>]

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
patrick@durusau.net
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)