Internship 2010: Add new spreadsheet functions and parameters according to ODFF

From Wiki
Revision as of 14:45, 20 May 2011 by Admin (talk | contribs) (1 версия)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search


Overview

The OASIS OpenDocument Format (ODF) specification part 2, OpenFormula aka ODFF, standardizes on recalulcated formula expression as used by Calc and introduces new functions and parameters that need to be implemented.

Project plan

  • Align and enhance the already existing overview and comparison of differences between implemented spreadsheet functions and the current ODFF draft.
  • Determine the most important functions to be implemented.
  • Implement functions in
    • compiler
    • interpreter
    • function wizard resources

Documentation

  • Code documentation.
  • Function and parameter descriptions in the Formula Wizard.
  • Provide input for the online help / documentation team.

Project status

  • The project is accepted for the OpenOffice.org summer internship program 2010
  • Evaluation and comparison is done.
  • AVERAGEIF and XOR are done.
  • AVERAGEIFS, COUNTIFS and SUMIFS are implemented.
  • IFERROR and IFNA functions are ongoing.