Specifications for OpenOffice.org 2.0

Formula Calculation

Conditional Array Calculation

IF() and CHOOSE() in array/matrix formulas and specific array handling.

Eike Rathke

Final

2.0

2003-12-18

HYPERLINK() Function

This will add the HYPERLINK() function.

John Marmion

Final

2.0

2004-04-20

BAHTTEXT() Function

This will add the BAHTTEXT() function.

Daniel Rentz

Final

2.0.1

2005-08-26

Thai 't' Numberformat Modifier

Import/export character 't' in number format codes of Thai locale to use Thai native numerals in display string.

Eike Rathke

Final

2.0.1

2005-10-11

INFO() Function

This will add the INFO() function for compatibility reasons.

Daniel Rentz

Final

2.0.2

2006-03-14

Cell Formatting

Cell property "Shrink to fit"

This will add the "Shrink to fit to cell size" cell property.

Daniel Rentz

Final

2.0

2004-03-10

Cell property "Fill cell"

This will add the "Fill cell" cell property.

Daniel Rentz

Final

2.0

2004-05-28

Cell property "Diagonal borders"

This will add diagonal border lines to cell formatting and styles.

Daniel Rentz

Final

2.0

2004-06-14

Page Formatting, Printing

Sheet Property "Print Entire Sheet"

This sheet property will allow to specify whether the sheet is printed if the document contains user-defined print ranges.

Daniel Rentz

Final

2.0

2003-10-15

Sheet Property "Fit Print Ranges to Width/Height"

This page attribute will allow to specify the width/height of the printed document.

Daniel Rentz

Final

2.0

2003-11-18

Spreadsheet General

Increase number of rows

Increase number of spreadsheet rows to number of rows in Excel (65536)

Eike Rathke

Final

2.0

2004-07-26

Scenario Protection

This feature will add support for protected scenarios.

John Marmion

Final

2.0

2003-11-14

Enhancement for Number Recognition

Many users are confused by inputting data to their spreadsheet when Number Recognition steps in and re-format their input to something unexpected.
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.

Falko Tesch

Final

2.0

2004-01-15

Natural Sort Option in Sort Dialog

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.

Kohei Yoshida

Draft

2.0

2005-06-21

Assign Name to Cell Range

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.

Matthias Müller-Prove

final

2.0

2004-05-17

Reworked Select Data Source Dialog

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.

Frank Loehmann

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.

Eike Rathke

Final

2.0

2004-07-06

Format Menu Calc

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.

Matthias Müller-Prove

Final

2.0

2004-07-08

Header Footer Dialog

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.

John Marmion

Final

2.0

2004-07-08

Deletion and Formatting of non-filtered Selections in Calc

This will enhance the behaviour of deletion and formatting of cells that are within a filtered range.

Falko Tesch

Final

2.0

27.04.2004

New Paste Special for unformatted text in Calc

This will enhance the ability of Calc to insert content from clipboard by using the already existing CVS filter options.

Falko Tesch

Final

2.0

02.05.2003

Context Menus in Calc

The context menu for Calc cells contains commands to manage notes. Terminology changes make is easier to insert and delete entire rows and columns.

Matthias Müller-Prove

Preliminary

2.1

1-Sep-2006

Extend AutoSum Capabilities in Calc

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.

Thomas Benisch

Standard

2.3

2007-06-22

Insertion of Cells in a Spreadsheet via Drag & Drop

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.

Frank Loehmann

Standard

2.4

2007-08-10

Text to Columns

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.

Frank Loehmann

Standard

2.4

2007-08-10

AutoFilter Behavior

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.

Frank Loehmann

Standard

2.4

2007-09-26

Enhanced Formula Input

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.

Frank Loehmann

Standard

2.4

2007-09-28

Enhanced Data Input

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.

Frank Loehmann

Standard

2.4

2007-10-09

DataPilot

Page Fields in the DataPilot

The DataPilot will be extended to allow the use of page fields.

Niklas Nebel

Final

2.0

2004-03-01

Field options in the DataPilot

The DataPilot will be extended to allow more settings for each field.

Niklas Nebel, Falko Tesch

Final

2.0

2004-05-03

Grouping in the DataPilot

The DataPilot will be extended to allow grouping of items.

Niklas Nebel

Final

2.0

2004-07-06

Table Options in the DataPilot

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).

Niklas Nebel

Final

2.0

2004-07-06

Import external DataPilot tables from XLS files

Import DataPilot tables from Microsoft Excel files that are based on external source data such as another spreadsheet file or a database.

Daniel Rentz

Final

2.2

2006-10-24

GETPIVOTDATA formula function

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.

Niklas Nebel

Preliminary

2.3

2007-06-06

Drawing Layer

Form Controls Linked to Spreadsheet Cells

This feature will allow to synchronize the contents of form controls with the contents of spreadsheet cells.

Daniel Rentz

Final

2.0

2004-05-13

Formatted Text in Cell Annotations

This feature will allow to format text in cell annotations. All attributes supported by standard text boxes will be available.

Daniel Rentz

Final

2.0

2004-05-24

Cell Note Positioning

This feature will add support for positioning and resizing of cell notes.

John Marmion

Final

2.0

2004-03-10

Formatting of Cell Note Text Box

This will add enhanced formatting for the cell note text box container.

John Marmion

Final

2.0

2004-03-12

Macro support for graphic and autoshapes

Allows macros to be associated with shapes and images in Calc.

Noel Power

Final

2.3

2007-07-02

Hyperlink support for graphic and autoshapes

Allows hyperlinks to be associated with shapes and images in Calc.

Noel Power

Final

2.4

2007-07-02

Filters

Corel Quattro Pro 6.0 Import Filter

An import filter for the Corel Quattro Pro 6.0 file format.

Shilpa Sreeramul

Final

2.0.2

2005-09-06

HTML Numbers Import to Calc

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.

Matthias Müller-Prove

draft

2.0.2

2005-11-21

Specifications for OpenOffice.org 3.0