Difference between revisions of "OpenOffice.org Internship/Projects/2010/Add new spreadsheet functions and parameters according to ODFF"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Project status)
(Project status)
Line 22: Line 22:
 
* The project is accepted for the OpenOffice.org summer internship program 2010
 
* The project is accepted for the OpenOffice.org summer internship program 2010
 
* Evaluation and comparison is done.
 
* Evaluation and comparison is done.
* Implementing AVERAGEIF, AVERAGEIFS, COUNTIFS and SUMIFS functions is ongoing.
+
* AVERAGEIF and XOR are done.
 +
* Implementing AVERAGEIFS, COUNTIFS and SUMIFS functions is ongoing.
  
  

Revision as of 16:46, 30 August 2010


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.
  • Implementing AVERAGEIFS, COUNTIFS and SUMIFS functions is ongoing.
Personal tools