Spreadsheet Project
Project Lead: Developer mailing list.
This is the home page for the Apache OpenOffice spreadsheet application, named Calc. A product description (including screenshot) can be found here. Note that the Chart module has its own page.
User Information
If you're looking for user information about Calc, try these links:
Submit an Issue
If you found a bug or want to suggest an enhancement, find the information about submitting issues in the QA project.
Develop Extensions
In addition to general extension development, Calc supports the use of Add-In components to extend the set of functions that can be used in cell formulas. Add-Ins can easily be created using the Add-In Wizard of the NetBeans integration. Besides that, some articles are available:
Simple Calc Add-in in the Wiki
CompleteAddIn in the Wiki
An older article “How to add-in”
Development Documentation
The OpenOffice.org wiki has a category "Calc".
Specifications for some spreadsheet features
Excel file format documentation (in progress), available as odt or pdf, and Compound Document file format documentation, also as odt or pdf
See also the “Documents & files” link to the left of this page.
Current Development
To see what the Calc team at Sun is doing, look for the weekly update entries in the GullFOSS blog.
Currently, the major topics of Calc development are:
Performance
Current Calc activities within the performance project are listed on the performance wiki page.
Excel 2007 import filter
The import filter for Excel 2007 files is continually improved. For details about the filter implementation, see its wiki page.
ODF formula specification
Within the OASIS OpenDocument Formula Subcommittee, a specification for spreadsheet formulas is being created. Necessary changes are being implemented.
Integration of R into Calc
A Summer of Code project has integrated the R environment with Calc, see the page in the wiki. The Summer of Code project is completed, but the integration will continue to be improved.
Usability improvements
There's a separate wiki page about our usability activities.
Solver
Calc has a built-in dialog to control different solver components, and a linear solver component included in the installation set. A non-linear component is available as a preliminary version.
To-Do List
These are some areas where help would be useful. Well thought-out patches are welcome, but please file your Joint Copyright Assignment (JCA) first, see How to submit code to OpenOffice.org.
Possible extensions
Statistical data analysis tools (ANOVA etc.), see issue 4921.
Leonard Mada has posted some code for ANOVA to the sc-dev mailing list.
Component to check spreadsheet documents for potential errors
Write an extension that checks a spreadsheet document for potential errors in formulas, presents a list of the findings to the user, and allows to correct them. Note that the conversion of text to numbers is already handled by the CT2N extension.
Other features
A Watch Window to watch certain cells
A Watch Window is a separate, small window that remains "on top" and enables users to monitor a selected set of cells, see issue 28386. This could possibly also be done as an extension.
CSV import enhancements
Most of the changes that were originally planned for the import of csv (text) files have already been done. Some open points are issues 60110, 37668, 19369, 24076 and 3687.
Add new spreadsheet functions and parameters according to ODFF
The OpenDocument Format Formula specification (ODFF aka OpenFormula) defines several new spreadsheet functions and new optional parameters to already existing functions that have to be implemented.
See also the list of suggestions for the Community Innovation Program.
IssueZilla queries
Spreadsheet issues with keyword “easy2dev”
These are issues that someone new to the project might want to look at. They generally don't require very deep insight into the inner workings of Calc.
Spreadsheet issues with keyword “needhelp”
These are issues where help is needed.
Features & Enhancements with target "Later"
This is a long list, sorted by priority and votes. Some of these may currently be blocked by other issues.