Community Innovation Program/proposals

Proposals

Calc/Chart

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.

Things to look for could include

• Cells that contain numbers stored as text and are used in formulas,
• Number cells that are not used in any formulas,
• Empty cells that are used in single-cell formula references.

The list is not meant to be exhaustive.

• Required skills/knowledge: Java or C++, spreadsheet usage

Contact

dev@sc.openoffice.org

Niklas.Nebel at sun.com

Watch Window

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 be implemented as an add-on component with a modeless dialog containing the list of watched cells as well as the UI to add or remove cells.

• Required skills/knowledge: Java or C++

Contact

dev@sc.openoffice.org

Niklas.Nebel at sun.com

Misc

OXT Extension wizard for templates and XSLT based filter

OXT extensions provide a nice way to bundle a group of templates and share them with other users. Templates are normally created with the office and the idea is to provide a wizard that helps on a higher abstraction level to collect templates and all necessary oxt specific information and build an oxt extension package. The second part is to extend the XSLT filter dialog to export new created XSLT based filters as an oxt extension as well. Currently it is only possible to create a jar file. The new feature should collect some more oxt related info and should create a well formed oxt extension package. The goal is to simplify these tasks and make it as easy as possible to create oxt extension packages that can be easy deployed and can be uploaded in the extensions repository to share them with many other users.

• Required skills/knowledge: Java or C++

Contact

juergen.schmidt at sun.com

ODT/PDF export from OpenOffice.org Wiki

OpenOffice.org documentation is being moved to the OpenOffice.org Wiki. This makes it easier for people to contribute to the content of the documentation, but producing a PDF of ODT of the entire Wiki document or book is not yet possible. The OpenOffice.org Wiki needs a MediaWiki extension developed that will provide a way to convert an aggregation of wiki pages (a "book") to ODT and/or PDF.

• Required skills/knowledge: PHP and XML, familiarity with ODF a plus

Contact

dev@documentation.openoffice.org

ccornell at openoffice.org, juergen.schmidt at sun.com

New Tasks

If you have a task that is challenging enough, and there is an OpenOffice.org Project Member willing to mentor the task, feel free to coordinate with the appropriate project lead. If the appropriate project has been found and it supports the task, add it below and make sure the mentor applies with the web app.

Each entry should contain the task description, required skills, project mailing list for discussion and personal contact. Links to the To-Dos are appreciated provided that the task is well described there ;-)

===Example entry===

This is just an example - the real entry must not start with a space at the beginning
of the line.
A full description of the task should be here; one that will help to see that this task
is important,  and interesting to hack on.  Alternatively it could be an exact link to
the description that is already in To-Dos.

* Required skills/knowledge: Language, technology1, technology2, ...

; Contact
: dev@project.openoffice.org
: The.Mentor at organization com