Here are all features and enhancements, which were integrated in 2.3. All the listed issues are announced in the release notes for the developer snapshots since SRC680m200. With build SRC680m221 all features and enhancements should be integrated. This is the first build after Feature Freeze. At the end of this page you will find links to all issues from type feature and enhancement. If one of those issues isn't listed here, a feature announcement is missing or was missing before the release notes for the developer snapshots were created.

Component : API

77185 : A possibility to represent a sequence as a seekable input stream is required.

Description : While using OOo API there is often a need to represent data from a sequence as a stream. For this reason the service "com.sun.star.io.SequenceInputStream" is introduced. Please see the idl specification for details

Component : Chart

Description : Allow users to associate source-ranges of spreadsheet data to single chart-objects in different roles, like the x-values of a data-series in a scatter chart. Especially different data series with different x-values are commonly used in competitor's applications.

Description : The twelve default colors used for creating new charts have changed to a set of new colors. The colors are the winner (proposal #2) of a voting where twelve different proposals have been made, to vote for. The colors have been changed in the Registry schema file Chart.xcs.

Description : With the “Insert Title” dialog for charts, a user can decide which title objects in a chart are shown, and what content they have. There is a main title, a sub title and axis-titles for some axes.

Description : Segments of 3D pies or donuts now can be pulled out to stress single data points. The new chart types '3D exploded pie' and 'exploded donut' are offered in the new chart type dialog and wizard

Description : The chart creation procedure has been simplified to take less steps. The chart is positioned automatically and serves as live preview. A new wizard offers to select the chart type as first user action. The type can be selected on a single page. There is no need to switch between pages or scroll around anymore. The chart type dialog has been replaced thus it now equals the new first wizard page.

Description : Logarithmic scales have been enhanced. The user is free to choose manual minimum and maximum values as well as a user defined major interval. Thus for example audio engineers now can display their log charts from typical 20 to 20000 Hz.

Description : Logarithmic scales have been enhanced. The user is free to choose manual minimum and maximum values as well as a user defined major interval. Thus for example audio engineers now can display their log charts from typical 20 to 20000 Hz.

Description : Donut charts now are written to xml according to the ODF specification. Wrong files from former versions are converted during loading. As former versions are buggy they will not be able to import the new correct files correctly. So switch to the corrected version completely when you use this chart type.

Description : Percent charts with user defined scales now are written to xml correctly. Wrong files from former versions are converted during loading. As former versions are buggy they will not be able to import the new correct files correctly. So switch to the corrected version completely when you use this kind of charts.

Description : For Charts that display their own data there is a dialog for editing the data. The Chart Data dialog is capable to modify, add and delete data that is used in data series and for categories. It is also possible to add and remove entire data series. All parts of a data series' data can be changed with this dialog. Charts with own data are typically those in a presentation. Although they can also appear in a spreadsheet, there, they usually use data coming from sheets

Description : With the new right-angled axes option the user can easily ensure that the axes in a 3D chart are exactly vertical or horizontal. This simplified display looks comfortable and allows for more accurate reading. New charts are now created per default with this option. Some further defaults were adjusted also to fit the new look.

75202 : New Chart Default Colors are not contained in the Office color palette

Description : The standard color palette (standard.soc) contains 12 new colors with the new defaults for charts. The entries are named "Chart %N" in locale en-US, where %N is replaced by 1 to 12. The colors in RGB values are:

Description : With the new right-angled axes option the user can easily ensure that the axes in a 3D chart are exactly vertical or horizontal. This simplified display looks comfortable and allows for more accurate reading. New charts are now created per default with this option. Some further defaults were adjusted also to fit the new look.

78442 : Show formula and r^2 value of regression curve in status bar and quick help

Description : When a regression curve in a chart is selected, the status bar now shows the formula and the square of correlation coefficient R in the status bar. The same string is also used for quick help, but only in the extended version (see Tools/Options/%PRODUCTNAME/General for switching that on)

Component : dba - Database

Description : With the integration of CWS fwkdbdesign01, database forms and reports will not share their UI configuration with text documents anymore. That is, you can have separate toolbar/menu/keyboard configurations for all three modules: forms, reports, normal text documents. Additionally, window states are also handled separately, that is, if you open a database form with a certain window size, and a certain set of opened toolbars, then those settings will not be shared with text documents anymore, but be valid for all database forms only. The same holds for database reports, of course.

Description : With the integration of CWS dba23ui, the entries in Base's task pane (the upper pane with items such as "Create a new table..." etc.) have accelerator shortcuts, i.e. can be accessed by pressing the Alt key (or whatever is the platform dependent accelerator key) plus the respective shortcut. The shortcuts are determined dynamically at runtime, and do not interfere with the accelerators for main menu and the left hand side category pane.

73084 : Base, slash "/" in report name causes error message when trying to do anythign with the report..

Description : With the integration of CWS dba23a, database objects (queries, forms, reports) cannot contain slashes / in their name anymore. This character never reliably worked when used, and since it's used in another meaning already - separating hierarchies when you, for instance, put forms or reports into folders -, they have been completely forbidden. Every attempt to create or rename an object, giving it a name with a slash, will now be rejected with an error message. If Base reads a document which already contains such broken names, then the slashes will silently be converted to underscores _ - which implies the objects will then work, again.

Description : 1 Extensions can now contain an identifier element in their description.xml, giving the extension a unique identifier. This removes the current restriction that no two extensions can have the same filename. ...

Description : The new function "Preview Document in Web Browser" provides an easy way to display the current document as a html export in the system web browser. Especially Writer/Web users benefit from this feature as they can now preview their document changes much easier. The feature will be available in the following application modules: Writer, Writer/Web, Writer/Global, Calc, Draw, Impress. For more information please look at the available specification.

Description : Similar to the export of single Basic modules as *.bas file in the OOo Basic IDE it's now also possible to export single Dialogs in the Dialog Editor (as *.xdl files). Until now it has only been possible to export a complete (dialog) library. If a Dialog Library is localized also properties files are exported that contain all string resources used by the exported dialog. These files are named like this: $DialogName_$LanguageCode.properties e.g. Dialog1_en_US.properties. This correponds with the extended functionality of the com.sun.star.awt.DialogProvider service. For details see #i75778.

Description : According to ISO 4217 MA amendment #138 there will be a new currency in Venezuela, effective from 2008-01-01 ID: VEF Symbol: BsF Decimals: 2 Name: bolívar fuerte; Added as a secondary currency to the Spanish_Venezuela (es_VE) locale data.

Description : According to ISO 4217 MA amendments #138 and #139 there will be a new currency in Ghana, effective from 2007-07-01 ID: GHS Symbol: ₵ Decimals: 2 Name: Ghana Cedi; Added this as the default currency to the *_Ghana (ak_GH, ee_GH, en_GH, ha_GH) locales.

Component : Presentation

Description : Since introducing the new presentation engine which supported more than one effect per shape, editing of the path object for motion path effects was no longer possible. This feature, including the feature to add motion path effects with a user drawn path is now possible again. Please see chapter 1.13 of the specification for further details...

Component : QA

Description : the implementation for typekeys and mouseup, mousedown and mousemove has changed to be able to return to the old implementation (temporarily) a nre command has ben established; UsePostEvents Bool ; default is to use the new method so "UsePostEvents false" would return to the old behaviour

Description : + Integer HTTPSend <Host>, <PATH>, <Port>[, <Filename>]; + HTTPSetProxy <Host>, <Port>; HTTPSend uses a GET request to retreive the requested page. Returncode is the HTTP result (200 if OK) Optionally the result can be saved in a file HTTPSetProxy sets a proxy if required

Description : <int> WaitSlot [ <int> nTimeoutInMSec ]; new constants to campare to WSTimeout, WSFinished; the command will return after nTimeoutInMSec or when the slot is finished. The returnvalue will be WSTimeout if the slot is not finished yet. It will be WSFinished if it is finished. The command refers to the last via testtool directly called slot. It does not recognize slots called via UI.

Component : sc - Spreadsheet

Description : The default values for the following print options in Calc have been changed: - Print only selected sheets (property AllSheets) - Suppress output of empty pages (property EmptyPages); By default those options are now enabled. In addition, if the 'Print only selected sheets' option is enabled, the Calc page preview prints only the displayed sheet. Furthermore a warning box with the message 'There is nothing to print. The selected print range or sheet is empty.' is shown, if nothing is printed, e.g. if the document, selected sheet or print range is empty.

Description : Calc now supports inline matrix/array constants in formulas. An inline array is surrounded by curly braces '{' and '}'. Elements can be each a number (including negatives), a logical constant (TRUE, FALSE) or a literal string. Non-constant expressions are not allowed. Arrays can be entered with one or more rows, and one or more columns. All rows must consist of the same number of elements, all columns must consist of the same number of elements, so that a two-dimensional array has no sparse elements. The column separator (separating elements in one row) is the ';' semicolon, the row separator is a '|' pipe symbol. They were chosen because the upcoming ODF formula specification uses these separators. Contrary to Excel, the separators are not UI-version and/or locale dependent. Arrays can not be nested. Import/export from/to Excel are implemented.

Description : Ctrl-Plus is now "Insert Cells". Ctrl-Minus is now "Delete Cells". Both work like the menu entries: If whole columns or rows are selected, they are inserted/deleted, otherwise the dialog is shown.

Description : 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. The field/item names can be passed as a variable-sized parameter list, or as a single string (compatibility syntax). The new function is also imported and exported to XLS files.

Description : Introduced a new error code 532 to distinguish division by zero errors from the more general illegal floating-point operation with error code 503. A more user-friendly #DIV/0! instead of Err:532 is displayed. The illegal floating-point operation now displays #NUM! instead of Err:503. This should be reflected in the online help under "error codes;list of". The list of functions resulting in #DIV/0! includes, but may not be limited to: ...

51564 : ux-ctest: Summation does not work from UI; changes exsisting value

Description : 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.

Description : The description of the slot .uno:SetInputMode has been changed from "Set Input Mode" to "Toggle Edit Mode". This slot is used to enter/leave the cell edit mode in spreadsheets using the F2 key. Please see the issue for details.

Description : Ctrl + ~ (Ctrl + `) now toggles formula view i.e. the cells display the (formula) result or the formula that the cells contain. This applies to all the cells in the table. The shortcut key can also be configured through the customize option. Ctrl + ~ is available for English keyboard layouts only. For non-English Keyboard layouts, the shortcut key has to be configured to a different key combination.

Description : In a spreadsheet, drawing objects (lines, rectanges etc) and pictures may contain a link to a macro. This macro will be executed when the object is clicked with the mouse. UI: The context menu of these objects has been extended by a new entry "Assign Macro..." that opens the macro selection dialog. If a macro has been assigned to an object, the mouse pointer will change to a "hand" if it is over the object. API: Shapes will support the optional interface com.sun.star.document.XEventsSupplier. Its function getEvents() returns a name container with one element, named "OnClick" and containing a sequence of com.sun.star.beans.PropertyValue objects. The sequence is empty if no macro link is present, otherwise contains the property "EventType" with value "Script", and the property "Script" with macro name as value. Loading/saving from/to ODF works, also import from BIFF8 Excel files (no export yet).

Description : The ASC function converts full-width to half-width ASCII and katakana characters. The JIS function converts half-width to full-width ASCII and katakana characters. Both functions are needed for interoperability with Japanese localized Microsoft Excel versions. For details please see the specification URL.

Description : The Excel export filter now handles the cotangent functions COT, ACOT, COTH, and ACOTH which are not contained in Microsoft Excel. The filter replaces the functions by the related tangent functions: ...

Description : The toolbar "Form Objects" has been removed from Calc. It was a remaint from the times before the Big Toolbar Renewal, did exist in Calc only, and contained only items which nowadays are to be found in the "Form Design" toolbar.

Description : Furthermore a warning box with the message 'There is nothing to print. The selected print range or sheet is empty.' is shown, if nothing is printed, e.g. if the document, selected sheet or print range is empty

75202 : New Chart Default Colors are not contained in the Office color palette

Description : The standard color palette (standard.soc) contains 12 new colors with the new defaults for charts. The entries are named "Chart %N" in locale en-US, where %N is replaced by 1 to 12. The colors in RGB values are: ...

Component : Word Processing

55007 : Update charts in writer should be automatic, or at least more accessible

Description : The checkbox in the dialog "Tools/Options/Star Office Writer/General" named "Charts" is now indented the same level as the "Fields" box. Also enabling/disabling the "Field" box does not have an effect on the "Chart" box anymore. Thus toggling of automatic updates for charts is now fully a flag on it's own. If that flag is set and changes to a table cell (with a chart attached) are made the chart will be updated a moment after the cursor leaves the current cell. And this is right after the formula fields in a table got updated. Thus chart will get the correct value for every field. Previously the chart was only updated if cells/rows/columns got deleted/inserted or if a cell changed that was used in a formula field of another cell. Now all changes to a cells content will trigger the automatic update for the chart object if the cursor leaves the cell.

Description : With this CWS the Writer is capable of guessng the language of unknown text. The functionality is implemented in the context menu of misspelled words. The language of the word is still guessed by the old algorithm (using the spell checker) and the one for the paragraph is now obtained with the language guessing algorithm. If only one of them does not return a result it is set to the same language as the other one.

Description : With OOo 2.2, a first draft of a Smart Tag API has been introduced. That API only provided some basic Smart Tag functionality which had to be enhanced in many regards. With cws smarttags3, the Smart Tag API has been enhanced and some additional UI has been introduced. Please see the specification for a detailed overview about this feature.

Description : With the integration of CWS fwkdbdesign01, XML form documents will not share their UI configuration with text documents anymore. That is, you can have separate toolbar/menu/keyboard configurations for text documents and XML form documents. Additionally, window states are also handled separately, that is, if you open an XML form document with a certain window size, and a certain set of opened toolbars, then those settings will not be shared with text documents anymore, but be valid for all XML form documents only.

Description : The ODF 1.1 allows the export of soft page breaks. A soft page break is a page break that has been inserted by a page oriented processor like Writer at a position where the document itself does not include a page break (e.g. paragraph attribute page break before/after). The soft page break information is for the purposes of consistent page breaks and for proper conversion to digital talking book formats.