| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> |
| <HTML> |
| <head> |
| <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252"> |
| <TITLE>Spreadsheet Project</TITLE> |
| <META NAME="GENERATOR" CONTENT="StarOffice 9 (Win32)"> |
| <META NAME="AUTHOR" CONTENT="Niklas Nebel"> |
| <META NAME="CREATED" CONTENT="20061208;17510400"> |
| <META NAME="CHANGED" CONTENT="20090330;16354400"> |
| <STYLE TYPE="text/css"> |
| <!-- |
| @page { size: 21.01cm 29.69cm } |
| --> |
| </STYLE> |
| </head> |
| <body LANG="en-US" DIR="LTR"> |
| <H1>Spreadsheet Project</H1> |
| <P><strong>Project Lead:</strong> <A HREF="mailto:dev@openoffice.apache.org">Developer mailing list</A>.</P> |
| <P>This is the home page for the Apache OpenOffice spreadsheet |
| application, named Calc. A product description (including screenshot) |
| can be found <A HREF="https://www.openoffice.org/product/calc.html">here</A>. |
| Note that the Chart module has <A HREF="https://graphics.openoffice.org/chart/chart.html">its |
| own page</A>.</P> |
| <H2>User Information</H2> |
| <P>If you're looking for user information about Calc, try these |
| links:</P> |
| <UL> |
| <LI><P><A HREF="http://wiki.services.openoffice.org/wiki/FAQ:Calc">FAQ: |
| Calc in the Wiki</A></P> |
| <LI><P><A HREF="http://user-faq.openoffice.org/new-faq/Calc/">User |
| FAQ: Calc</A></P> |
| <LI><P><A HREF="http://documentation.openoffice.org/faqs/spreadsheet/index.html">Calc |
| FAQs</A></P> |
| <LI><P><A HREF="http://documentation.openoffice.org/HOW_TO/index.html">HOW |
| TO (scroll down for Calc)</A></P> |
| <LI><P><A HREF="http://documentation.openoffice.org/manuals/index.html">User |
| Guides (all modules)</A></P> |
| <LI><P><A HREF="http://documentation.openoffice.org/tutorials/index.html">Tutorials |
| (all modules)</A></P> |
| </UL> |
| <H2>Submit an Issue</H2> |
| <P>If you found a bug or want to suggest an enhancement, find the |
| information about submitting issues <A HREF="http://qa.openoffice.org/issue_handling/project_issues.html">in |
| the QA project</A>.</P> |
| <H2>Develop Extensions</H2> |
| <P>In addition to general <A HREF="http://wiki.services.openoffice.org/wiki/Extensions_development">extension |
| development</A>, Calc supports the use of <A HREF="http://wiki.services.openoffice.org/wiki/Add-In">Add-In</A> |
| components to extend the set of functions that can be used in cell |
| formulas. Add-Ins can easily be created using the <A HREF="http://wiki.services.openoffice.org/wiki/OpenOffice_Calc_Add-In_Project_Type">Add-In |
| Wizard</A> of the <A HREF="http://wiki.services.openoffice.org/wiki/OpenOffice_NetBeans_Integration">NetBeans |
| integration</A>. Besides that, some articles are available:</P> |
| <UL> |
| <LI><P><A HREF="http://wiki.services.openoffice.org/wiki/Simple_Calc_Add-in">Simple |
| Calc Add-in</A> in the Wiki</P> |
| <LI><P><A HREF="http://wiki.services.openoffice.org/wiki/CompleteAddIn">CompleteAddIn</A> |
| in the Wiki</P> |
| <LI><P>An older article <A HREF="http://sc.openoffice.org/addin_howto.html">“How |
| to add-in”</A></P> |
| </UL> |
| <H2>Development Documentation</H2> |
| <UL> |
| <LI><P>The <A HREF="http://wiki.services.openoffice.org/wiki/Main_Page">OpenOffice.org |
| wiki</A> has a <A HREF="http://wiki.services.openoffice.org/wiki/Category:Calc">category |
| "Calc"</A>.</P> |
| <LI><P><A HREF="http://specs.openoffice.org/calc/index.html">Specifications</A> |
| for some spreadsheet features</P> |
| <LI><P><A HREF="testdocs/index.html">Import/export filter test |
| documents</A></P> |
| <LI><P>Excel file format documentation (in progress), available as |
| <A HREF="http://sc.openoffice.org/excelfileformat.odt">odt</A> or |
| <A HREF="http://sc.openoffice.org/excelfileformat.pdf">pdf</A>, and |
| Compound Document file format documentation, also as <A HREF="http://sc.openoffice.org/compdocfileformat.odt">odt</A> |
| or <A HREF="http://sc.openoffice.org/compdocfileformat.pdf">pdf</A></P> |
| <LI><P>See also the “Documents & files” link to the |
| left of this page.</P> |
| </UL> |
| <H2>Current Development</H2> |
| <P>To see what the Calc team at Sun is doing, look for the weekly |
| update entries in the <A HREF="http://blogs.sun.com/GullFOSS/">GullFOSS |
| blog</A>.</P> |
| <P>Currently, the major topics of Calc development are:</P> |
| <UL> |
| <LI><P>Performance</P> |
| <P>Current Calc activities within the <A HREF="http://performance.openoffice.org/">performance |
| project</A> are listed on the <A HREF="http://wiki.services.openoffice.org/wiki/Performance">performance |
| wiki page</A>.</P> |
| <LI><P>Excel 2007 import filter</P> |
| <P>The import filter for Excel 2007 files is continually improved. |
| For details about the filter implementation, see <A HREF="http://wiki.services.openoffice.org/wiki/SpreadsheetML">its |
| wiki page</A>.</P> |
| <LI><P>ODF formula specification</P> |
| <P>Within the OASIS OpenDocument <A HREF="http://www.oasis-open.org/committees/tc_home.php?wg_abbrev=office-formula">Formula |
| Subcommittee</A>, a specification for spreadsheet formulas is being |
| created. Necessary changes are being implemented.</P> |
| <LI><P>Integration of R into Calc</P> |
| <P>A Summer of Code project has integrated the R environment with |
| Calc, see <A HREF="http://wiki.services.openoffice.org/wiki/R_and_Calc">the |
| page in the wiki</A>. The Summer of Code project is completed, but |
| the integration will continue to be improved.</P> |
| <LI><P>Usability improvements</P> |
| <P>There's a separate <A HREF="http://wiki.services.openoffice.org/wiki/Calc_Usability_Activities">wiki |
| page</A> about our usability activities.</P> |
| <LI><P>Solver</P> |
| <P>Calc has a <A HREF="http://blogs.sun.com/GullFOSS/entry/spreadsheet_solver_infrastructure">built-in |
| dialog</A> to control different solver components, and a linear |
| solver component included in the installation set. A non-linear |
| component is available as a <A HREF="http://blogs.sun.com/GullFOSS/entry/solver_for_nonlinear_programming">preliminary |
| version</A>.</P> |
| </UL> |
| <H2>To-Do List</H2> |
| <P>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 <A HREF="http://contributing.openoffice.org/programming.html#jca">How |
| to submit code to OpenOffice.org</A>.</P> |
| <H3>Possible extensions</H3> |
| <UL> |
| <LI><P>Statistical data analysis tools (ANOVA etc.), see <A HREF="http://www.openoffice.org/issues/show_bug.cgi?id=4921">issue |
| 4921</A>.</P> |
| <P>Leonard Mada has posted <A HREF="http://sc.openoffice.org/servlets/ReadMsg?list=dev&msgNo=1936">some |
| code</A> for ANOVA to the sc-dev mailing list.</P> |
| <LI><P>Component to check spreadsheet documents for potential errors</P> |
| <P>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 <A HREF="http://extensions.openoffice.org/project/CT2N">CT2N |
| extension</A>.</P> |
| </UL> |
| <H3>Other features</H3> |
| <UL> |
| <LI><P>A Watch Window to watch certain cells</P> |
| <P>A Watch Window is a separate, small window that remains "on |
| top" and enables users to monitor a selected set of cells, see |
| <A HREF="http://www.openoffice.org/issues/show_bug.cgi?id=28386">issue |
| 28386</A>. This could possibly also be done as an extension.</P> |
| <LI><P>CSV import enhancements</P> |
| <P>Most of the changes that were originally planned for the import |
| of csv (text) files have already been done. Some open points are |
| issues <A HREF="http://qa.openoffice.org/issues/show_bug.cgi?id=60110">60110</A>, |
| <A HREF="http://qa.openoffice.org/issues/show_bug.cgi?id=37668">37668</A>, |
| <A HREF="http://qa.openoffice.org/issues/show_bug.cgi?id=19369">19369</A>, |
| <A HREF="http://qa.openoffice.org/issues/show_bug.cgi?id=24076">24076</A> |
| and <A HREF="http://qa.openoffice.org/issues/show_bug.cgi?id=3687">3687</A>.</P> |
| <LI><P>Add new spreadsheet functions and parameters according to |
| ODFF</P> |
| <P>The <A HREF="http://www.oasis-open.org/committees/documents.php?wg_abbrev=office">OpenDocument |
| Format Formula specification</A> (ODFF aka OpenFormula) defines |
| several new spreadsheet functions and new optional parameters to |
| already existing functions that have to be implemented.</P> |
| <LI><P>See also the <A HREF="http://wiki.services.openoffice.org/wiki/Community_Innovation_Program/proposals">list |
| of suggestions</A> for the Community Innovation Program.</P> |
| </UL> |
| <H3>IssueZilla queries</H3> |
| <UL> |
| <LI><P><A HREF="http://www.openoffice.org/issues/buglist.cgi?Submit+query=Submit+query&component=Spreadsheet&issue_status=NEW&issue_status=STARTED&issue_status=REOPENED&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&short_desc=&short_desc_type=substring&long_desc=&long_desc_type=substring&issue_file_loc=&issue_file_loc_type=substring&status_whiteboard=&status_whiteboard_type=substring&keywords=easy2dev&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&cmdtype=doit&newqueryname=&order=Reuse+same+sort+as+last+time">Spreadsheet |
| issues with keyword “easy2dev”</A></P> |
| <P>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.</P> |
| <LI><P><A HREF="http://www.openoffice.org/issues/buglist.cgi?Submit+query=Submit+query&component=Spreadsheet&issue_status=NEW&issue_status=STARTED&issue_status=REOPENED&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&short_desc=&short_desc_type=substring&long_desc=&long_desc_type=substring&issue_file_loc=&issue_file_loc_type=substring&status_whiteboard=&status_whiteboard_type=substring&keywords=needhelp&keywords_type=anytokens&field0-0-0=noop&type0-0-0=noop&value0-0-0=&cmdtype=doit&newqueryname=&order=Reuse+same+sort+as+last+time">Spreadsheet |
| issues with keyword “needhelp”</A></P> |
| <P>These are issues where help is needed.</P> |
| <LI><P><A HREF="http://qa.openoffice.org/issues/buglist.cgi?issue_type=ENHANCEMENT&issue_type=FEATURE&issue_type=TASK&component=Spreadsheet&issue_status=NEW&issue_status=STARTED&issue_status=REOPENED&target_milestone=OOo+Later&order=issues.target_milestone,%20issues.priority,%20issues.votes%20desc,%20issues.issue_id">Features |
| & Enhancements with target "Later"</A></P> |
| <P>This is a long list, sorted by priority and votes. Some of these |
| may currently be blocked by other issues.</P> |
| </UL> |
| </body> |
| </HTML> |