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)
 
(One intermediate revision by the same user not shown)
Line 23: Line 23:
 
* Evaluation and comparison is done.
 
* Evaluation and comparison is done.
 
* AVERAGEIF and XOR are done.
 
* AVERAGEIF and XOR are done.
* Implementing AVERAGEIFS, COUNTIFS and SUMIFS functions is ongoing.
+
* AVERAGEIFS, COUNTIFS and SUMIFS are implemented.
 +
* IFERROR and IFNA functions are ongoing.
  
  

Latest revision as of 15:02, 12 November 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.
  • AVERAGEIFS, COUNTIFS and SUMIFS are implemented.
  • IFERROR and IFNA functions are ongoing.
Personal tools