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
(initial setup)
 
(Project status)
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category:Marketing]][[Category:Development]]
 
 
{{DISPLAYTITLE:Internship 2010: Add new spreadsheet functions and parameters according to ODFF}}
 
{{DISPLAYTITLE:Internship 2010: Add new spreadsheet functions and parameters according to ODFF}}
 +
 +
__TOC__
 +
 +
== Overview ==
 +
The [[OpenDocument| 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 [[Calc/ODFF_Implementation/Examine_functions| 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.
 +
 +
 +
[[Category:Marketing]]
 +
[[Category:Development]]
 +
[[Category:Calc]]

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