Skip to content

You are not logged in. Register orLog In

start:

Spreadsheet Project

Project Lead: Niklas Nebel, Co-Lead: Eike Rathke (for questions, please use the mailing lists).

This is the home page for the OpenOffice.org 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:

Development Documentation

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