OpenOffice.org Calc Specifications
Specifications for OpenOffice.org 2.0 |
|||||
|
Name |
Description |
Author |
Status |
Target |
Date |
|---|---|---|---|---|---|
|
Formula Calculation |
|||||
|
IF() and CHOOSE() in array/matrix formulas and specific array handling. |
Final |
2.0 |
2003-12-18 |
||
|
This will add the HYPERLINK() function. |
Final |
2.0 |
2004-04-20 |
||
|
This will add the BAHTTEXT() function. |
Final |
2.0.1 |
2005-08-26 |
||
|
Import/export character 't' in number format codes of Thai locale to use Thai native numerals in display string. |
Final |
2.0.1 |
2005-10-11 |
||
|
This will add the INFO() function for compatibility reasons. |
Final |
2.0.2 |
2006-03-14 |
||
|
Cell Formatting |
|||||
|
This will add the "Shrink to fit to cell size" cell property. |
Final |
2.0 |
2004-03-10 |
||
|
This will add the "Fill cell" cell property. |
Final |
2.0 |
2004-05-28 |
||
|
This will add diagonal border lines to cell formatting and styles. |
Final |
2.0 |
2004-06-14 |
||
|
Page Formatting, Printing |
|||||
|
This sheet property will allow to specify whether the sheet is printed if the document contains user-defined print ranges. |
Final |
2.0 |
2003-10-15 |
||
|
This page attribute will allow to specify the width/height of the printed document. |
Final |
2.0 |
2003-11-18 |
||
|
Spreadsheet General |
|||||
|
Increase number of spreadsheet rows to number of rows in Excel (65536) |
Final |
2.0 |
2004-07-26 |
||
|
This feature will add support for protected scenarios. |
Final |
2.0 |
2003-11-14 |
||
|
Many users are confused by inputting data to their spreadsheet
when Number Recognition steps in and re-format their input to
something unexpected. |
Final |
2.0 |
2004-01-15 |
||
|
A new sort algorithm known as the "natural sort" will be added to the cell sort options to provide users an option of sorting string-prefixed numbers in the "natural" 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. |
Draft |
2.0 |
2005-06-21 |
||
|
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. |
final |
2.0 |
2004-05-17 |
||
|
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. |
Final |
2.0 |
2004-05-11 |
||
|
RedLining: Add comment if rejection could not restore the old state |
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. |
Final |
2.0 |
2004-07-06 |
|
|
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. |
Final |
2.0 |
2004-07-08 |
||
|
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. |
Final |
2.0 |
2004-07-08 |
||
|
This will enhance the behaviour of deletion and formatting of cells that are within a filtered range. |
Final |
2.0 |
27.04.2004 |
||
|
This will enhance the ability of Calc to insert content from clipboard by using the already existing CVS filter options. |
Final |
2.0 |
02.05.2003 |
||
|
The context menu for Calc cells contains commands to manage notes. Terminology changes make is easier to insert and delete entire rows and columns. |
Preliminary |
2.1 |
1-Sep-2006 |
||
|
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. |
Standard |
2.3 |
2007-06-22 |
||
|
Often a cell or a plurality of cells has to be moved via drag & 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. |
Standard |
2.4 |
2007-08-10 |
||
|
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. |
Standard |
2.4 |
2007-08-10 |
||
|
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. |
Standard |
2.4 |
2007-09-26 |
||
|
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. |
Standard |
2.4 |
2007-09-28 |
||
|
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. |
Standard |
2.4 |
2007-10-09 |
||
|
DataPilot |
|||||
|
The DataPilot will be extended to allow the use of page fields. |
Final |
2.0 |
2004-03-01 |
||
|
The DataPilot will be extended to allow more settings for each field. |
Final |
2.0 |
2004-05-03 |
||
|
The DataPilot will be extended to allow grouping of items. |
Final |
2.0 |
2004-07-06 |
||
|
Two new options for DataPilot tables will control the "Filter" button cell, and the interaction to show or hide details. The "show details" function will be able to add fields to a DataPilot table (drill down). |
Final |
2.0 |
2004-07-06 |
||
|
Import DataPilot tables from Microsoft Excel files that are based on external source data such as another spreadsheet file or a database. |
Final |
2.2 |
2006-10-24 |
||
|
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. |
Preliminary |
2.3 |
2007-06-06 |
||
|
Drawing Layer |
|||||
|
This feature will allow to synchronize the contents of form controls with the contents of spreadsheet cells. |
Final |
2.0 |
2004-05-13 |
||
|
This feature will allow to format text in cell annotations. All attributes supported by standard text boxes will be available. |
Final |
2.0 |
2004-05-24 |
||
|
This feature will add support for positioning and resizing of cell notes. |
Final |
2.0 |
2004-03-10 |
||
|
This will add enhanced formatting for the cell note text box container. |
Final |
2.0 |
2004-03-12 |
||
|
Allows macros to be associated with shapes and images in Calc. |
Final |
2.3 |
2007-07-02 |
||
|
Allows hyperlinks to be associated with shapes and images in Calc. |
Final |
2.4 |
2007-07-02 |
||
|
Filters |
|||||
|
An import filter for the Corel Quattro Pro 6.0 file format. |
Final |
2.0.2 |
2005-09-06 |
||
|
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. |
draft |
2.0.2 |
2005-11-21 |
||
Specifications for OpenOffice.org 3.0 |
|||||
|
Name |
Description |
Author |
Status |
Target |
Date |
$Date: 2007/10/09 10:16:46 $ $Revision: 1.108 $
