atom feed16 messages in org.oasis-open.lists.officeRe: [office] Proposed TC Meeting Agen...
FromSent OnAttachments
robe...@us.ibm.comJan 16, 2006 8:22 am 
Bruce D'ArcusJan 16, 2006 8:53 am 
David A. WheelerJan 16, 2006 10:23 am 
Mary McRaeJan 16, 2006 10:28 am 
robe...@us.ibm.comJan 16, 2006 11:49 am 
Lars OppermannJan 17, 2006 1:50 am 
Michael Brauer - Sun Germany - ham02 - HamburgJan 17, 2006 4:52 am 
Bruce D'ArcusJan 17, 2006 6:15 am 
Florian ReuterJan 17, 2006 8:05 am 
Bruce D'ArcusJan 17, 2006 8:58 am 
Mary McRaeJan 17, 2006 5:58 pm 
Michael Brauer - Sun Germany - ham02 - HamburgJan 18, 2006 2:53 am 
Michael Brauer - Sun Germany - ham02 - HamburgJan 18, 2006 9:03 am 
Bruce D'ArcusJan 18, 2006 9:56 am 
Michael BrauerJan 19, 2006 12:10 am 
robe...@us.ibm.comJan 19, 2006 11:59 am 
Subject:Re: [office] Proposed TC Meeting Agenda Items
From:David A. Wheeler (dwhe@dwheeler.com)
Date:Jan 16, 2006 10:23:20 am
List:org.oasis-open.lists.office

On Jan 16, 2006, at 11:22 AM, robe@us.ibm.com wrote:

1) Proposal to create additional Subcommittees ... c) Subcommittee formed to develop and propose further support for Metadata and Spreadsheet Formulas. d) ODF 1.1 draft released with enhanced metadata, spreadsheet formulas, and whatever other new features the TC may propose e) Compliance Subcommittee formed to propose ways to define compliance and recommend and perhaps develop a means to verify compliance of ODF-supporting applications

If you don't mind, I'd like to wait to discuss formulas and how to handle them (including subcommittees, etc.) until AFTER the upcoming Monday meeting. Technically, I'm only an "observer" until after next meeting, yet I'm ESPECIALLY interested in ensuring that spreadsheet formulas are well-defined. I'd prefer to legitimately be part of that discussion :-).

If it's any consolation, formulas aren't standing still anyway. As you know, I'm leading a group ("OpenFormula") that is creating an early draft spec for spreadsheet formulas for OpenDocument. We plan to submit it to a standards body, and I've been having several emails with OASIS management about that very subject. We've made a lot of progress, I think.

Speaking of compliance tests, in the OpenFormula work, we've combined two problems into a solution. Our problems were: (1) How can you define functions well enough to really know what they mean, and (2) how do you get a compliance test? The answer, for us, has been to embed compliance tests into the specification itself. I don't think this would work in the general case, but for spreadsheet formulas, giving specific required answers as part of each definition is turning out to be VERY useful. Instead of dancing over the head of the pin of some terms, the test cases eliminate a VAST number of misunderstandings. They also let us examine what current applications do, quickly.