Here are the current (and previous) formula work areas for OpenFormula; see About_OpenFormula for more information about the project.

Current Assignments

EVERYONE: By Wednesday, please let Wheeler know which section(s) you'd like to take on for the next week.

Due each Wednesday 7PM EST - what you've done so far in your section.

Previous assignments:

Next to assign: byte position.

The following people are accepting OpenDocument Fellowship funding: Carrera, Guelzow, Mecir, Nikolaus, Wheeler.

Old_assignments lists the old assignments.

Work Process

In our current work process, we have a single draft document; people "own" various sections for a week. We then send the improved sections to Wheeler (dwheeler at dwheeler, dot com), who merges them and posts the updated version. This way, there's no need to worry about merge conflicts.

"Documents" has the current draft - PLEASE start work from the most recent version available to you.

For the moment, just download the latest merged posting, edit it, and send back the whole document. Wheeler will then cut and paste the relevant sections, make changes to make the whole document "fit together", and then send out the new version. There's no point in turning on change tracking right now, because we already know who edits each section, and it would reveal that many changes are being made (well, we knew that). This process will probably change once all the undefined functions are defined.

If during work you have questions or concerns, please post to the mailing list, office-formula, at Public posting is preferred, that way everyone can help at once.

Instructions for Defining Functions

When defining a function, you must follow the "Common Template for Functions and Operators" (section 6.1). This template requires that you include test cases; for more information about test cases, see Test Cases (section 2.3) and the Test Case Data Set (2.4). You can have more test case data added, just coordinate that with the chair. The Types chapter (4) tells you about the pseudotypes and automatic conversions. This isn't hard; use existing function definitions as examples.

Use many different sources for information, not just one source. You may directly copy material from the Lotus 1-2-3 v9.8 help documentation; otherwise, you must not copy due to copyright issues.'s Research Data page points to data sources, be sure to use many of them.

The test cases are especially important. Formulas need to produce the right answer, and test cases greatly increases the likelihood of this.

Hints (especially about test cases):

The goal is a spec that all applications can implement, and current documents can transition to. In a few cases we have functions unique to a particular application, to ease transition from that application's native format into the common format.

Who's done what?

Since Aug. 23, volunteers not in a spreadsheet-implementing company have done these:

Plus the work done by those at various companies. See the end of the document for a complete list of contributors.

Sources of Information and Tools

Here are some external locations that may help you:

Formulas is the main page of the Formula SC.

Formula_Work (last edited 2009-08-12 18:04:26 by localhost)