Re: [office-formula] Missing Excel Functions

["David A. Wheeler" <dwheeler@dwheeler.com>]

> Same for SUMIFS, that exists on my To-Do list for editing the draft. In
> which group should we place them? I think Large would be appropriate.

Agree.  Go ahead and put it in "Large".

> > > CELL - I found the note in the spec about platform independence.  Some of the values returned by the function are not platform specific.  Does it make sense to add it to the Large group with a note about some of the argument values?
> > 
> > It might; what do you have in mind?
> 
> CELL is problematic in itself. The definition of the "filename" info
> type is most controversial, as one would expect it is defined to return
> the file name, but that is not what Excel and OOo return. For legacy
> reasons (once upon a time each sheet was a separate file) Excel includes
> the sheet name, as does OOo. However, Excel does not do the IRI
> notation. I currently don't see a real solution for this.

Perhaps we can define CELL for some values, and note that others are
platform-specific.  I suspect, but do not know, that this is more of a debugging
function than a function used extensively for interoperability.
True? False?

--- David A. Wheeler