Google Git
Sign in
apache / openoffice-org / bae4ea485ebbd5dfd1014f061bb06a0954836b4b / . / content / specs / calc / index.html
blob: e4e048baafd6785489ae3552526ce9457d162738 [file] [log] [blame]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
<TITLE>OpenOffice.org Calc Specifications</TITLE>
</HEAD>
<BODY LANG="en-US" DIR="LTR">
<H1>OpenOffice.org Calc <A HREF="../index.html">Specifications</A></H1>
<TABLE WIDTH=100% BORDER=0 CELLPADDING=2 CELLSPACING=0 BGCOLOR="#dddddd">
<COL WIDTH=47*>
<COL WIDTH=109*>
<COL WIDTH=41*>
<COL WIDTH=21*>
<COL WIDTH=14*>
<COL WIDTH=23*>
<TR>
<TD COLSPAN=6 WIDTH=100% VALIGN=TOP BGCOLOR="#99ccff">
<H4>Specifications for OpenOffice.org 2.0</H4>
</TD>
</TR>
<TR VALIGN=TOP>
<TH WIDTH=19% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Name</P>
</TH>
<TH WIDTH=43% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Description</P>
</TH>
<TH WIDTH=16% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Author</P>
</TH>
<TH WIDTH=8% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Status</P>
</TH>
<TH WIDTH=6% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Target</P>
</TH>
<TH WIDTH=9% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Date<!-- begin of specifications list --><!-- formula calculation =================================== --></P>
</TH>
</TR>
<TR>
<TD COLSPAN=6 WIDTH=100% VALIGN=TOP BGCOLOR="#eeeeee">
<P>Formula Calculation</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/cac/conditional_array_calculation.sxw">Conditional
Array Calculation</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>IF() and CHOOSE() in array/matrix formulas and specific array
handling.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:er@openoffice.org">Eike Rathke</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2003-12-18</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/HyperLinkFunction.sxw">HYPERLINK()
Function </A>
</P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This will add the HYPERLINK() function.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:jmarmion@openoffice.org">John Marmion</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-04-20</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/bahttext.odt">BAHTTEXT() Function </A>
</P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This will add the BAHTTEXT() function.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:dr@openoffice.org">Daniel Rentz</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0.1</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2005-08-26</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/Thai_t_numberformat_modifier.odt">Thai
't' Numberformat Modifier</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Import/export character 't' in number format codes of Thai
locale to use Thai native numerals in display string.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:er@openoffice.org">Eike Rathke</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0.1</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2005-10-11</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/info-function.odt">INFO() Function </A>
</P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This will add the INFO() function for compatibility reasons.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:dr@openoffice.org">Daniel Rentz</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0.2</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2006-03-14<!-- cell formatting =================================== --></P>
</TD>
</TR>
<TR>
<TD COLSPAN=6 WIDTH=100% VALIGN=TOP BGCOLOR="#eeeeee">
<P>Cell Formatting</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/shrinktofit.sxw">Cell property &quot;Shrink
to fit&quot;</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This will add the &quot;Shrink to fit to cell size&quot; cell
property.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:dr@openoffice.org">Daniel Rentz</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-03-10</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/fillcell.sxw">Cell property &quot;Fill
cell&quot;</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This will add the &quot;Fill cell&quot; cell property.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:dr@openoffice.org">Daniel Rentz</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-05-28</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/diagonalborders.sxw">Cell property
&quot;Diagonal borders&quot;</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This will add diagonal border lines to cell formatting and
styles.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:dr@openoffice.org">Daniel Rentz</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-06-14<!-- page formatting, printing =================================== --></P>
</TD>
</TR>
<TR>
<TD COLSPAN=6 WIDTH=100% VALIGN=TOP BGCOLOR="#eeeeee">
<P>Page Formatting, Printing</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/printsheet.sxw">Sheet Property &quot;Print
Entire Sheet&quot;</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This sheet property will allow to specify whether the sheet is
printed if the document contains user-defined print ranges.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:dr@openoffice.org">Daniel Rentz</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2003-10-15</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/fittopages.sxw">Sheet Property &quot;Fit
Print Ranges to Width/Height&quot;</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This page attribute will allow to specify the width/height of
the printed document.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:dr@openoffice.org">Daniel Rentz</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2003-11-18<!-- spreadsheet general =================================== --></P>
</TD>
</TR>
<TR>
<TD COLSPAN=6 WIDTH=100% VALIGN=TOP BGCOLOR="#eeeeee">
<P>Spreadsheet General</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/number_of_rows.sxw">Increase number of
rows</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Increase number of spreadsheet rows to number of rows in Excel
(65536)</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:er@openoffice.org">Eike Rathke</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-07-26</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/ScenarioProtection.sxw">Scenario
Protection</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This feature will add support for protected scenarios.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:jmarmion@openoffice.org">John Marmion</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2003-11-14</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/enhance_number_recognition.sxw">Enhancement
for Number Recognition</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Many users are confused by inputting data to their spreadsheet
when Number Recognition steps in and re-format their input to
something unexpected.<BR>This new feature will change the alter
Number Recognition behaviour so that it will be easier and more
understandable to use by long-time Calc users, novice users as
well as users migrating from Excel or other spreadsheet
applications.
</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:ft@openoffice.org">Falko Tesch</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-01-15</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/natural_sort_algorithm.sxw">Natural Sort
Option in Sort Dialog</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>A new sort algorithm known as the &quot;natural sort&quot; will
be added to the cell sort options to provide users an option of
sorting string-prefixed numbers in the &quot;natural&quot; way
i.e. A1, A2, A3, ... , A19, A20 instead of the current behavior of
A1, A10, A11, A12, ... ,A19, A2, A20, A3, A4, ... , A8, A9.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:kohei@openoffice.org">Kohei Yoshida</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Draft</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2005-06-21</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/CellRange.sxw">Assign Name to Cell Range</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>The Name Box - alas the Sheet Area Field - in Calc can be used
to define new cell ranges by simply typing a name. The immediate
display of a tool tip tells the user that she is about to create a
new named cell range.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="http://wiki.services.openoffice.org/wiki/User:Mmp">Matthias
M&uuml;ller-Prove</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-05-17</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/select_data_source_dialog.sxw">Reworked
Select Data Source Dialog</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>The Select Data Source Dialog has been reworked to add the
possibility of selecting database files, which are not connected
as a data source. Furthermore the login dialog behavior and some
strings have been changed to improve usability.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:fl@openoffice.org">Frank Loehmann</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-05-11</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="http://specs.openoffice.org/calc/ease-of-use/redlining_comment.sxw">RedLining:
Add comment if rejection could not restore the old state</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>If a recorded change is rejected for an OpenOffice.org Calc
document, a comment for the rejecting action is inserted if
dependencies to other actions indicate that at least one of them
couldn't be properly restored.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:er@openoffice.org">Eike Rathke</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-07-06</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="http://specs.openoffice.org/calc/menus/FormatMenu.sxw">Format
Menu Calc</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>The Format menu in OOo2.0 Calc is no longer context sensitive,
i.e. the set of menu commands is fixed for all objects to be
edited. The structure and terminology is consistent with the
Writer module and matches competitive applications.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="http://wiki.services.openoffice.org/wiki/User:Mmp">Matthias
M&uuml;ller-Prove</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-07-08</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="http://specs.openoffice.org/calc/compatibility/headerfooter.sxw">Header
Footer Dialog </A>
</P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Currently adding headers and footers is more difficult in Calc
than it needs to be. We also need to provide a predefined set of
choices that users can choose from a drop-down list.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:jmarmion@openoffice.org">John Marmion</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-07-08</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/editing_of_non-filtered_selections.sxw">Deletion
and Formatting of non-filtered Selections in Calc</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This will enhance the behaviour of deletion and formatting of
cells that are within a filtered range.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:falko@sun.com">Falko Tesch</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>27.04.2004</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/Paste_special_for_unformatted_text_in_Calc.sxw">New
Paste Special for unformatted text in Calc</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This will enhance the ability of Calc to insert content from
clipboard by using the already existing CVS filter options.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:falko@sun.com">Falko Tesch</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>02.05.2003</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="menus/ContextMenus.odt">Context Menus in Calc</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>The context menu for Calc cells contains commands to manage
notes. Terminology changes make is easier to insert and delete
entire rows and columns.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="http://wiki.services.openoffice.org/wiki/User:Mmp">Matthias
M&uuml;ller-Prove</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Preliminary</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.1</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>1-Sep-2006</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/autosum.odt">Extend AutoSum Capabilities
in Calc</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>OpenOffice.org Calc's capabilities to sum up cell values
automatically are extended. The cell range used for summation is
specified by the user. All values in the marked area are summed up
column- and/or rowwise and the result is inserted automatically as
a sum formula.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:tbe@openoffice.org">Thomas Benisch</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Standard</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.3</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2007-06-22</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="http://specs.openoffice.org/calc/ease-of-use/Insertion_of_Cells.odt">Insertion
of Cells in a Spreadsheet via Drag &amp; Drop</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Often a cell or a plurality of cells has to be moved via drag &amp;
drop to a new columns or row inside the same or new spreadsheet.
The new target cells for the data moved is often not empty, so
that an insertion would be helpful to accomplish the task without
inserting new rows/columns or cells in advance.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:%20frank.loehmann@sun.com">Frank Loehmann</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Standard</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.4</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2007-08-10</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="http://specs.openoffice.org/calc/ease-of-use/Text_to_Columns.odt">Text to Columns</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Comma separated values (CSV) can already be imported from files and the clipboard,
but CSV data inside cells could not be transformed into columns directly.
This spec defines the new feature Text to Columns that uses the already existing Text import
(CSV) dialog and transforms CSV data inside cells to columns.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:%20frank.loehmann@sun.com">Frank Loehmann</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Standard</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.4</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2007-08-10</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/AutoFilter_Behavior.odt">AutoFilter Behavior</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>The AutoFilter function allows to filter data in a spreadsheet by
one criteria per column. This feature allows to run a quick analysis
of data. The current support of multi column filtering shows some
ease of use issues, therefore the AutoFilter list will be overworked
with this specification.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:tbe@openoffice.org">Frank Loehmann</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Standard</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.4</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2007-09-26</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/Enhanced_Formula_Input.odt">Enhanced Formula Input</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Most professional spreadsheet users do use the number pad for
inputting data to save time. So it makes sense to allow to enter a
formula not just by entering a "=" or hitting the Function button in
the Formula tool bar. Therefore "+" and "-" can also be used to
start entering a formula. This improves the usability and the speed
when creating formulas in a spreadsheet. Furthermore this can be
used as a little calculator.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:tbe@openoffice.org">Frank Loehmann</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Standard</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.4</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2007-09-28</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/Enhanced_Data_Input.odt">Enhanced Data Input</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Entering data into a spreadsheet is an important but time
consuming task. So every keyboard input and mouse click which can be
saved makes it faster to accomplish this task. Furthermore it
reduces input errors and makes this task much more comfortable for
the user. Entering data could be done column or row wise. This
specification improves the row wise method. Therefore the Return key
works like a carriage return-line feed on a type writer and allows
to return to the column where the input started, but just a row
below the current row.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:tbe@openoffice.org">Frank Loehmann</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Standard</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.4</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2007-10-09</P>
</TD>
</TR>
<TR>
<TD COLSPAN=6 WIDTH=100% VALIGN=TOP BGCOLOR="#eeeeee">
<P>DataPilot</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/pagefields.sxw">Page Fields in the
DataPilot</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>The DataPilot will be extended to allow the use of page fields.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:nn@openoffice.org">Niklas Nebel</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-03-01</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/fieldoptions.sxw">Field options in the
DataPilot</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>The DataPilot will be extended to allow more settings for each
field.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:nn@openoffice.org">Niklas Nebel</A>, <A HREF="mailto:ftn@openoffice.org">Falko
Tesch</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-05-03</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/grouping.sxw">Grouping in the DataPilot</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>The DataPilot will be extended to allow grouping of items.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:nn@openoffice.org">Niklas Nebel</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-07-06</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/tableoptions.sxw">Table Options in the
DataPilot</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Two new options for DataPilot tables will control the &quot;Filter&quot;
button cell, and the interaction to show or hide details. The
&quot;show details&quot; function will be able to add fields to a
DataPilot table (drill down).</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:nn@openoffice.org">Niklas Nebel</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-07-06</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/importdpcache.odt">Import external
DataPilot tables from XLS files</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Import DataPilot tables from Microsoft Excel files that are
based on external source data such as another spreadsheet file or
a database.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:dr@openoffice.org">Daniel Rentz</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.2</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2006-10-24</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/getpivotdata.odt">GETPIVOTDATA formula
function</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>The GETPIVOTDATA function returns a result value from a
DataPilot table, so it can be used in a cell formula. The value is
addressed using field and item names, so it remains valid if the
layout of the DataPilot table changes.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:nn@openoffice.org">Niklas Nebel</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Preliminary</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.3</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2007-06-06<!-- drawing layer =================================== --></P>
</TD>
</TR>
<TR>
<TD COLSPAN=6 WIDTH=100% VALIGN=TOP BGCOLOR="#eeeeee">
<P>Drawing Layer</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/linkedcontrols.sxw">Form Controls Linked
to Spreadsheet Cells</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This feature will allow to synchronize the contents of form
controls with the contents of spreadsheet cells.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:dr@openoffice.org">Daniel Rentz</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-05-13</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/annotation_formtext.sxw">Formatted Text
in Cell Annotations</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This feature will allow to format text in cell annotations. All
attributes supported by standard text boxes will be available.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:dr@openoffice.org">Daniel Rentz</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-05-24</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/AnnotationPosition.sxw">Cell Note
Positioning </A>
</P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This feature will add support for positioning and resizing of
cell notes.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:jmarmion@openoffice.org">John Marmion</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-03-10</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/AnnotationFormatting.sxw">Formatting of
Cell Note Text Box </A>
</P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>This will add enhanced formatting for the cell note text box
container.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:jmarmion@openoffice.org">John Marmion</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2004-03-12</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/AutoShapeMacroSupport.odt">Macro support
for graphic and autoshapes</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Allows macros to be associated with shapes and images in Calc.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:npower@openoffice.org">Noel Power</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.3</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2007-07-02</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="compatibility/AutoShapeHyperlinkSupport.odt">Hyperlink
support for graphic and autoshapes</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>Allows hyperlinks to be associated with shapes and images in
Calc.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:npower@openoffice.org">Noel Power</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.4</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2007-07-02<!-- filters =================================== --></P>
</TD>
</TR>
<TR>
<TD COLSPAN=6 WIDTH=100% VALIGN=TOP BGCOLOR="#eeeeee">
<P>Filters</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="filters/qpro/qpro6.sxw">Corel Quattro Pro 6.0 Import
Filter</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>An import filter for the Corel Quattro Pro 6.0 file format.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="mailto:shilpas@openoffice.org">Shilpa Sreeramul</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>Final</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0.2</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2005-09-06</P>
</TD>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff">
<P><A HREF="ease-of-use/HTMLNumberImport.odt">HTML Numbers Import
to Calc</A></P>
</TD>
<TD WIDTH=43% BGCOLOR="#ffffff">
<P>A new option in the HTML Compatibility pane allows the proper
import of numbers from HTML pages that are not formatted according
the English locale conventions.</P>
</TD>
<TD WIDTH=16% BGCOLOR="#ffffff">
<P><A HREF="http://wiki.services.openoffice.org/wiki/User:Mmp">Matthias
M&uuml;ller-Prove</A></P>
</TD>
<TD WIDTH=8% BGCOLOR="#ffffff">
<P>draft</P>
</TD>
<TD WIDTH=6% BGCOLOR="#ffffff">
<P>2.0.2</P>
</TD>
<TD WIDTH=9% BGCOLOR="#ffffff">
<P>2005-11-21<!-- OOo 3.0 =================================== --></P>
</TD>
</TR>
<TR>
<TD COLSPAN=6 WIDTH=100% VALIGN=TOP BGCOLOR="#99ccff">
<H4>Specifications for OpenOffice.org 3.0</H4>
</TD>
</TR>
<TR VALIGN=TOP>
<TH WIDTH=19% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Name</P>
</TH>
<TH WIDTH=43% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Description</P>
</TH>
<TH WIDTH=16% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Author</P>
</TH>
<TH WIDTH=8% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Status</P>
</TH>
<TH WIDTH=6% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Target</P>
</TH>
<TH WIDTH=9% BGCOLOR="#dddddd">
<P ALIGN=LEFT>Date</P>
</TH>
</TR>
<TR VALIGN=TOP>
<TD WIDTH=19% BGCOLOR="#ffffff"></TD>
<TD WIDTH=43% BGCOLOR="#ffffff"></TD>
<TD WIDTH=16% BGCOLOR="#ffffff"></TD>
<TD WIDTH=8% BGCOLOR="#ffffff"></TD>
<TD WIDTH=6% BGCOLOR="#ffffff"></TD>
<TD WIDTH=9% BGCOLOR="#ffffff"></TD>
</TR>
</TABLE>
<P>&nbsp;</P>
<HR>
<P>$Date: 2007/10/09 10:16:46 $ $Revision: 1.108 $
</P>
</BODY>
</HTML>