Skip to content

start:

OpenOffice.org 2.3.0rc3 (build OOG680_m5) - Release Notes


These notes contains changes between SRC680_m200 and  SRC680_m225 and OOG680_m1 and OOG680_m5.
This release will install as OpenOffice.org.
Sources can be received from cvs by tag OOG680_m5.
 
Until now, almost every jar from program/classes had been on the OOo
Java class path, which had both performance and name clash implications.  That has been changed by completely emptying the class path, making sure that OOo explicitly locates all the jars it calls, and that each jar finds any jars it depends on.  However, that causes extension code that relies on certain jars being available on the Java class path to fail now.  See <http://www.openoffice.org/servlets/ReadMsg?list=interface-announce&msgNo=1012> for further details.

What's new ?

Feature title TaskId Spec. title Spec. abstract Dev. owner Spec. link Component
separated UI/configuration for database forms and database reports i45663   feature-info:
With the integration of CWS fwkdbdesign01 (http://eis.services.openoffice.org/EIS2/servlet/cws.ShowCWS?Path=SRC680%2Ffwkdbdesign01), 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. 		frank.schoenheit@sun.com
dba
keyboard shortcuts for database record navigation i74918   feature-info:
With the integration of CWS fwkdbdesign01 (http://eis.services.openoffice.org/EIS2/servlet/cws.ShowCWS?Path=SRC680%2Ffwkdbdesign01), you have a number of new keyboard shortcuts available in database forms. In particular, those are: Modifier 1 + Modifier 2 + Home: First Record Modifier 1 + Modifier 2 + Cursor-Left: Previous Record Modifier 1 + Modifier 2 + Cursor-Right: Next Record Modifier 1 + Modifier 2 + End : Last Record As usual, the meaning of "Modifier" depends on your platform/hardware, for an ordinary PC keyboard, it's "Ctrl" resp. "Alt". 		frank.schoenheit@sun.com
dba
Show filter options dialog before file dialog in case of pdf-export. i13154 PDF Export This document is about enhancements to OOo1.1's PDF export feature. For Ooo2.0 the features most requested by our users should be implemented; namely: improved graphics output, links, document outline, document notes, tagged PDF, presentation effects, form controls and document encryption. Mikhail.Voitenko@sun.com speclink framework
Selection of stylist filter now persistent i4854   feature-info:
Now the selection of a stylist filter is persistent. One selection for every application. 		hans-peter.burow@sun.com
framework
The title for the broken signature dialog has been changed. i69640 Electronic Signatures and EncryptionGraphical User Interface (GUI)
Mikhail.Voitenko@sun.com speclink framework
Extension Identifiers, unopkg, pkgchk i69910 Extension Identifiers Extensions can now contain an element in their , giving the extension a unique identifier. This removes the current restriction that no two extensions can have the same file name. Stephan Bergmann (SB) speclink framework
Export COT, ACOT, COTH, and ACOTH to MS Excel files i72768   feature-info:
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: Cotangent: COT(x) is replaced with (1/TAN(x)) Arccotangent: ACOT(x) is replaced with (PI/2-ATAN(x)) where PI/2 is given as numerical constant Hyperbolic cotangent: COTH(x) is replaced with (1/TANH(x)) Hyperbolic arccotangent: ACOTH(x) is replaced with ATANH(1/(x)) with "x" being any simple or complex expression. Note the additional parentheses which are needed to preserve correct operator precedence, for example: COT(1)^2 is correctly replaced by (1/TAN(1))^2 instead of the wrong 1/TAN(1)^2. 		daniel.rentz@sun.com
sc
Centered document view i1761   feature-info:
From mmp's short spec as issue comment: If the horizontal scrollbar has nothing to do then the pages will be centered in the window. Otherwise we keep the behavior from previous OOo versions (ZoomIn bahaviour will not be changed.) The center of the pages is defined by the half width of the widest page of the document (pages can also be in landscape orientation, right?). Then all pages are aligned to the left border of the widest page. 		oliver.specht@sun.com
word processing
separated UI/configuration for XML Form Documents i75146   feature-info:
With the integration of CWS fwkdbdesign01 (http://eis.services.openoffice.org/EIS2/servlet/cws.ShowCWS?Path=SRC680%2Ffwkdbdesign01), 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. 		frank.schoenheit@sun.com
word processing
Locale data for Hausa_Ghana (ha_GH) available i72206   feature-info:
Locale data for Hausa_Ghana (ha_GH) was added. The locale is now available as a default document language and selectable for number formats. 		eike.rathke@sun.com
L10N
Locale data for Ewe_Ghana (ee_GH) available. i72207   feature-info:
Locale data for Ewe_Ghana (ee_GH) was added. The locale is now available as a default document language and selectable for number formats. 		eike.rathke@sun.com
L10N
Locale data for Frisian_Netherlands (fy_NL) available. i72919   feature-info:
Locale data for Frisian_Netherlands (fy_NL) was added. The locale is now available as a default document language and selectable for number formats. 		eike.rathke@sun.com
L10N
Tagalog_Philippines (tl_PH) added to language list box. i73406   feature-info:
The Tagalog_Philippines (tl_PH) locale is now selectable for character attribution. 		eike.rathke@sun.com
L10N
Jewish calendar dates for en_US locale. i74008   feature-info:
Jewish calendar dates are available in en_US locale data, selectable from the number formatter's date formats with the prefix modifier [~jewish] 		eike.rathke@sun.com
L10N
Locale data for Uzbek_Uzbekistan (uz_UZ) available. i75857   feature-info:
Locale data for Uzbek_Uzbekistan (uz_UZ) Latin script was added. The locale is now available as a default document language and selectable for number formats. 		eike.rathke@sun.com
L10N
Uzbek (Cyrillic) removed from language list box. i75857   feature-info:
The already existing "Uzbek (Cyrillic)" language list box entry was removed because there is no support of Uzbek in Cyrillic script and the value could not be stored. 		eike.rathke@sun.com
L10N
Locale data for Occitan_France (oc_FR) available. i76044   feature-info:
Locale data for Occitan_France (oc_FR) was added. The locale is now available as a default document language and selectable for number formats. 		eike.rathke@sun.com
L10N
Locale data for Lingala_Congo (ln_CD) available. i76153   feature-info:
Locale data for Lingala_Congo [Democratic Republic] (ln_CD) was added. The locale is now available as a default document language and selectable for number formats. 		eike.rathke@sun.com
L10N
Locale data for Sango _ Central African Republic (sg_CF) available. i76345   feature-info:
Locale data for Sango _ Central African Republic (sg_CF) was added. The locale is now available as a default document language and selectable for number formats. 		eike.rathke@sun.com
L10N
Locale data for English_Ghana (en_GH) available. i76346   feature-info:
Locale data for English_Ghana (en_GH) was added. The locale is now available as a default document language and selectable for number formats. 		eike.rathke@sun.com
L10N
Locale data for Ganda_Uganda (lg_UG) available. i76348   feature-info:
Locale data for Ganda_Uganda (lg_UG) was added. The locale is now available as a default document language and selectable for number formats. 		eike.rathke@sun.com
L10N
Locale data for Armenian_Armenia (hy_AM) available. i78003   feature-info:
Locale data for Armenian_Armenia (hy_AM) was added. The locale is now available as a default document language and selectable for number formats. 		eike.rathke@sun.com
L10N
Currency Bolivar Fuerte, VEF, for Spanish_Venezuela (es_VE) locale. i78586   feature-info:
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. 		eike.rathke@sun.com
L10N
Default currency Ghana Cedi, GHS, for *_Ghana (ak_GH, ee_GH, en_GH, ha_GH) locales. i78587   feature-info:
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. 		eike.rathke@sun.com
L10N
com.sun.star.io.SequenceInputStream service i77185   feature-info:
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. 		Mikhail.Voitenko@sun.com
api
Insert/Title Dialog Layout Changed i13443
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. bjoern.milcke@sun.com speclink chart
offer to switch to a Simple 3d look in charts i14202
The 3D settings for charts are presented in one new dialog “3D View”. It offers settings for perspective, appearance, and illumination. The user can also choose “right-angled axes” to easily ensure vertical and horizontal axes. ingrid.halama@sun.com speclink chart
exploded 3D pies and donuts i20321 Chart Wizard Charts can be created with a new Chart Wizard. Matthias Müller-Prove /MMP speclink chart
more easy creation of charts / new wizard i20344 Chart Wizard Charts can be created with a new Chart Wizard. Matthias Müller-Prove /MMP speclink chart
enhanced logarithmic scales i26869
This specification describes the scaling behavior of charts as well as the settings for the visible interval marks and the grid lines inside the chart. ingrid.halama@sun.com speclink chart
Strings for Undo in Charts i27351 Chart Undo Undo actions are represented to the user with strings. ingrid.halama@sun.com speclink chart
enhanced logarithmic scales i27694
This specification describes the scaling behavior of charts as well as the settings for the visible interval marks and the grid lines inside the chart. ingrid.halama@sun.com speclink chart
Automatic axis scaling i30426 Automatic Axis Scaling This document describes how axes are scaled automatically in the new chart module. The goal of automatic axis scaling is to visualize all data points best possible in the available plot area. daniel.rentz@sun.com speclink chart
Flexible Source-Range Selection i3997
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. bjoern.milcke@sun.com speclink chart
enhanced selection handling i58161 Chart Selection Handling This document describes how the selection via mouse works in the new chart module. The goal of the mouse handling is to be predictable and easy. ingrid.halama@sun.com speclink chart
Export donut charts according to spec i58457   feature-info:
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. 		ingrid.halama@sun.com
chart
Export manual scales for percent charts correctly i59288   feature-info:
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. 		ingrid.halama@sun.com
chart
Menu for Charts i60358 Chart Menu Structure By activating a chart (select and double click it) the main menu structure offers commands to edit the type, style and appearance of the chart. Terminology is simplified and the menus are easier to access because the items are grouped in meaningful sections. ingrid.halama@sun.com speclink chart
Chart Data Editor improved i64824

bjoern.milcke@sun.com speclink chart
Right-angled axes for 3D Charts i67754
The 3D settings for charts are presented in one new dialog “3D View”. It offers settings for perspective, appearance, and illumination. The user can also choose “right-angled axes” to easily ensure vertical and horizontal axes. ingrid.halama@sun.com speclink chart
New Default Colors for Charts i7019

bjoern.milcke@sun.com speclink chart
Chart-Specific Toolbars i70287
When editing a chart the user interface provides some chart-specific functions in toolbars. bjoern.milcke@sun.com speclink chart
Terms for Chart Elements i74907 Chart Object Names This document specifies the names of the different chart objects. ingrid.halama@sun.com speclink chart
Terms for Chart Elements i74909 Chart Object Names This document specifies the names of the different chart objects. ingrid.halama@sun.com speclink chart
simplified 3D dialog for charts i75176
The 3D settings for charts are presented in one new dialog “3D View”. It offers settings for perspective, appearance, and illumination. The user can also choose “right-angled axes” to easily ensure vertical and horizontal axes. ingrid.halama@sun.com speclink chart
Right-angled axes for 3D Charts i76430
The 3D settings for charts are presented in one new dialog “3D View”. It offers settings for perspective, appearance, and illumination. The user can also choose “right-angled axes” to easily ensure vertical and horizontal axes. ingrid.halama@sun.com speclink chart
Show formula and R^2 for regression curves in Status Bar and Extended Tip Help i78442 Chart Object Names This document specifies the names of the different chart objects. bjoern.milcke@sun.com speclink chart
keyboard shortcuts for task pane entries i72799   feature-info:
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. 		frank.schoenheit@sun.com
dba
/ in database object names not allowed anymore i73084   feature-info:
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. 		frank.schoenheit@sun.com
dba
New Report Designer i76758
At the moment OpenOffice.org Base supports only very limited report functionality. This document describes the user interface to design a report by hand. This allows the user to design a report with any level of complexity e.g. grouped records, sorting of records, different alignment of text fields, and calculations. Marc Neumann (msc) speclink dba
HTML export for draw and presentation documents now supports png i23353 HTML Export Documents the HTML Export functionality including the HTML Wizard in OOo Draw & Impress. Christian Lippka (cl) speclink drawing
Alternative text for non-text image map i68099 Image Map Dialog This specification documents the image map dialog feature. Christian Lippka (cl) speclink drawing
Alternative text for layers in drawings i68100 Layer Dialog This specification documents the layer dialog that lets the user insert or make changes to layers in the OpenOffice.org Draw application. Christian Lippka (cl) speclink drawing
Alternative text for layers in drawings (now with issue number) i68100 Layer Dialog This specification documents the layer dialog that lets the user insert or make changes to layers in the OpenOffice.org Draw application. Christian Lippka (cl) speclink drawing
Preview Document in Web Browser i74477 Preview Document in Web Browser Make the current document previewed by browser as web page, in order to see the effect of display before release. dded a new menu item in the File menu which named 'Preview in Web Browser'. This menu item can make the current document browsed in web page. text, picture and media that can be edit in the document are all can be browsed successful. Liu Tao speclink framework
Extension can integrate options pages in the options dialog i75869 Options Dialog for Extensions An extension may require to be configured before it can be used reasonably or in order to adapt it to personal preferences. For example, a spell checker extension could be configured to use different sets of grammar rules, a clock extension could be configured to show twelve or twenty four hours, etc. Configuring the extension should be as easy as possible for the user. That is, a dialog should be used rather then some obscure configuration files which need to be edited. And, of course, this dialog should be easily accessible, that is, it needs to be found intuitively.Future extensions shall be able to integrate own options pages into the options dialog. An options page is similar to a dialog but is lacking the title bar and border so that it can be shown in a parent window, which is the option dialog. The options dialog can also be started from the Extension Manager, in which case it shows only the options pages of the selected extension. Joachim Lingner (JL) speclink framework
New option: Load printer settings with the document i76855 Load Printer Settings with the Document Option OOo stores and restores printer settings with a document by default. In an enterprise environment with always available printers (i.e. around the world) this could result in printing a document on the other side of the world. Therefore a new option is added to suppress loading document printer settings on loading a document. Frank Loehmann (FL) speclink framework
Single dialog export in dialog editor i77640 Export Single Dialog from Library Currently dialogs are always embedded into a basic library. Especially for OOo extensions it would be helpful to have access to single dialogs. Therefore the dialog IDE gets a possibility to export the current dialog via a new button in the tool bar. Frank Loehmann (FL) speclink framework
Link to extensions.services.openoffice.org in Extension Manager i78209 Link to extensions.services.openoffice.org
Joachim Lingner (JL) speclink framework
Editing of path animations is possible again i41800 Custom Animation User Interface The user interface for custom animation now also supports adding user drawn motion path effects and the feature to edit the path of existing motion path effects. Christian Lippka speclink presentation
testtool: new commands to request webpages i22679   feature-info:
+ Integer HTTPSend , , [, ] + HTTPSetProxy , 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 		gregor.hartmann@sun.com
qa
testtool: new implementation for typekeys and mouse* i45199   feature-info:
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 		gregor.hartmann@sun.com
qa
testtool: new methods to access EditBrowseBox i52436   feature-info:
IMPORTANT to use EditBrowsBox the command SetControlType is not needed anymore same for ValueSets new methods to access EditBrowseBox Text GetSelText returns the text of the selected field Int GetColumnCount Int GetRowCount Bool IsEditing TRUE if the field is in edit mode Select nRow, nColumn go to given field 		gregor.hartmann@sun.com
qa
testtool: config tabpage for Crashreport configuration i63641   feature-info:
there is a new config tabpage inside the testtool to configure the Crashreporter section of the testtoolrc/.ini 		gregor.hartmann@sun.com
qa
testtool: New option in options dialog to set OOo program path i63642   feature-info:
On the "misc" tabpage there is a new option to set the following part of the testtool.ini/rc called "OOo Program Dir" [OOoProgramDir] Current= so now there are 2 ways to set it from within the testtool: this one and the generic one via the "generic" tabpage 		gregor.hartmann@sun.com
qa
testtool: method to get state of menu entry if expandable i68654   feature-info:
+ BOOL MenuHasSubMenu nItemId 		gregor.hartmann@sun.com
qa
testtool: add new methods for ORoadmap e.g. in wizards i72795   feature-info:
This contol is used in wizards on the left side of the dialog to show the steps of the wizard new methods are: nNr GetItemCount String GetItemText nIndex Select nIndex nNr GetSelIndex String GetSelText Bool IsItemEnabled nIndex 		gregor.hartmann@sun.com
qa
testtool: new method to get slot execution status i76851   feature-info:
WaitSlot [ 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. 		gregor.hartmann@sun.com
qa
Default print options in Calc i25278   feature-info:
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. 		thomas.benisch@sun.com
sc
Support of inline matrix/array constants in formulas i32342   feature-info:
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. Examples: ={1;2;3} An array with one row consisting of the three numbers 1, 2 and 3. ={1;2;3|4;5;6} An array with two rows and three values in each row. ={0;1;2|FALSE;TRUE;"two"} A mixed data array. =SIN({1;2;3}) Entered as a matrix formula delivers the result of three SIN calculations with the arguments 1, 2 respectively three. ={1;2|4;5;6} Invalid array, the first row misses an element. This results in Err:512 "Formula overflow". ={1;2+3} Invalid array, the second element is not a constant. This results in Err:512 "Formula overflow". ={1;2;{3;4;5}} Invalid array, nested arrays are not allowed. This results in Err:533 "Nested arrays are not supported". This is a new error condition relevant for translation. 		eike.rathke@sun.com
sc
Keyboard shortcut "Ctrl-1" is now "Format Cells" i35738   feature-info:
The shortcut "Ctrl-1" in Calc was changed from from "single line spacing" (in drawing objects only) to "cell format dialog". 		niklas.nebel@sun.com
sc
Keyboard shortcuts Ctrl-Plus and Ctrl-Minus for Insert/Delete Cells i38108   feature-info:
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. 		niklas.nebel@sun.com
sc
GETPIVOTDATA formula function i45843   feature-info:
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. 		niklas.nebel@sun.com
sc
Division by zero #DIV/0! error displayed for certain functions, #NUM! displayed for illegal floating-point operation errors i47644   feature-info:
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: division operator / if the denominator is 0 VARP with less than 1 argument, e.g. only empty cells in a range STDEVP with less than 1 argument VAR with less than 2 arguments STDEV with less than 2 arguments AVERAGE of nothing AVERAGEA of nothing KURT of nothing ZTEST of only 1 point SUBTOTAL with functions average, stdev, stdevp, var, varp as above LOGNORMDIST with stdev=0 STANDARDIZE with stdev=0 NORMDIST with stdev=0 The #DIV/0! error is also exported to MS-Excel so that a recalculation doesn't flip from #NUM! to #DIV/0! anymore. 		eike.rathke@sun.com
sc
Division by zero #DIV/0! error displayed for certain functions, #NUM! displayed for illegal floating-point operation errors i47724   feature-info:
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: division operator / if the denominator is 0 VARP with less than 1 argument, e.g. only empty cells in a range STDEVP with less than 1 argument VAR with less than 2 arguments STDEV with less than 2 arguments AVERAGE of nothing AVERAGEA of nothing KURT of nothing ZTEST of only 1 point SUBTOTAL with functions average, stdev, stdevp, var, varp as above LOGNORMDIST with stdev=0 STANDARDIZE with stdev=0 NORMDIST with stdev=0 The #DIV/0! error is also exported to MS-Excel so that a recalculation doesn't flip from #NUM! to #DIV/0! anymore. 		eike.rathke@sun.com
sc
Cell context menu entry changed i47732   feature-info:
The cell context menu entry "~Default" has been changed to "~Default Formatting". Now, the entry is equal to the corresponding context menu entry in a Writer document (see http://www.openoffice.org/issues/ show_bug.cgi?id=39939). 		daniel.rentz@sun.com
sc
Renamed checkbox in Paste Special dialog i50436   feature-info:
In Calc's Edit -> Paste Special dialog, the checkbox "~Strings" has been renamed to "Te~xt". 		daniel.rentz@sun.com
sc
Checkbox in Delete Contents dialog renamed i50439   feature-info:
In Calc's Edit -> Delete Contents dialog, the checkbox "~Strings" has been renamed to "~Text". 		daniel.rentz@sun.com
sc
Extend AutoSum Capabilities in Calc i51564 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@sun.com speclink sc
Renamed "Set Input Mode" to "Toggle Edit Mode" i53756   feature-info:
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. 		daniel.rentz@sun.com
sc
Shortcut for Format->Cells menu entry changed i55972   feature-info:
The shortcut for the menu entry "Cells" in the "Format" menu has been changed from "~Cells" to "Ce~lls" to prevent clash with the globally defined entry "~Change Case". 		daniel.rentz@sun.com
sc
Ctrl + ~ (Ctrl + `) toggles formula view i56202   feature-info:
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. 		muthusuba@openoffice.org
sc
Dynamic ranges as formula results in validation lists i56566   feature-info:
Calc now supports dynamic ranges as formula results in validation lists, menu Data.Validity, pick "Cell range". Previously, only directly entered range references such as A1:A5 or defined names that simply (recursively) evaluated to a range were supported. Now also a formula that evaluates to a range or an array can be entered, such as INDIRECT(A1) if A1 contains a string that evaluates to a range, such as B2:C3. Defined names are deeply evaluated now and don't need to be defined to a simple range, a formula returning a range or an array here is fine as well. This makes it possible to define a name to a complex formula that calculates a rectangular area and enter that defined name in the validation dialog. The restriction that a range has to be exactly one column or one row was removed. If a two-dimensional area is given, the elements in the selection list are listed row-wise if not sorted. If the range or formula calculation results in an error, that error is displayed as the only value of the selection list box. The hint displayed below the Source edit field was adapted to "A valid source can only consist of a contiguous selection of rows and columns, or a formula that results in an area or array." 		eike.rathke@sun.com
sc
Drawing objects support Basic macro calls i59082 Support Macros for graphic and autoshapes in Calc To improve MS Excel interoperability, support for associating Noel Power (NP) speclink sc
JIS and ASC Spreadsheet Functions i70213

er@openoffice.org speclink sc
"Form Objects" toolbar removed i71900   feature-info:
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. 		frank.schoenheit@sun.com
sc
Toolbars "Insert" and "Insert Object" merged i73123
This specification covers the Toolbar content changes for OpenOffice.org 2.0 Frank Schönheit speclink sc
Changed menu entry Data->Outline i77653   feature-info:
The menu entry "~Outline" (Data menu) has been changed to "~Group and Outline". 		daniel.rentz@sun.com
sc
Default print options in Calc i78488   feature-info:
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. 		thomas.benisch@sun.com
sc
Intro and about bitmap location changed, configure script extended i66426   feature-info:
To better support the creation of adapted OpenOffice.org installation sets we now support the following options with the configure script. intro-bitmaps [ --with-intro-bitmaps Prefer the specified intro bitmaps over the the default one. Can be more than one (separated by commas), the order means priority of fallback if the first does not exist (in the installed tree). Usage: --with-intro-bitmaps=/path/my_ooo_intro.bmp ],,) about-bitmaps [ --with-about-bitmaps Similarly to --with-intro-bitmaps, this allows specification of bitmaps for the About box. Usage: --with-about-bitmaps=/path/my_ooo_about.bmp ],,) vendor, [ --with-vendor Set vendor of the build. Usage: --with-vendor="John the Builder" ],,) The location of the intro and about bitmaps have changed in the following way: - "svx/res/oooabout.bmp" - "svx/res/ooointro.bmp" - "svx/res/brabout.bmp" - "svx/res/brintro.bmp" - "svx/res/soffice.bmp" - "svx/res/ofaabout.bmp" + "default_images/introabout/about.bmp" + "default_images/introabout/intro.bmp" + "ooo_custom_images/broffice/about.bmp" + "ooo_custom_images/broffice/intro.bmp" + "custom_images/so/introabout/about.bmp" + "custom_images/so/introabout/intro.bmp" 		carsten.driesner@sun.com
tools
Selectable FixedTexts i64785   feature-info:
Now the values of File - Properties... - General (Type. Location, Size...) are selectable and can be copied into the clipboard. 		hans-peter.burow@sun.com
ui
Changed shortcut for "Object" in the Edit menu i72608   feature-info:
The shortcut of the menu entry "Object" in the Edit menus of the applications (Writer, Calc, Impress, Draw) has been changed from O to J, to prevent clash with "Delete C~ontents". 		daniel.rentz@sun.com
ui
Standard Color Palette Extended by new Chart Default Colors i75202
With the Tools/Options/Charts/Default Colors dialog a set of default colors can be defined. These default colors are applied to the data series of newly created charts, as well as data series added to existing charts. bjoern.milcke@sun.com speclink ui
Automatic update for charts in Writer i55007   feature-info:
Hi, As with CWS chart2mst3: 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. Regards, Thomas 		thomas.lange@sun.com
word processing
Language Guessing i73173 Automatic Language Guessing Component The following component allows to determine the langue of a (selected) text. This feature works without using wordbooks, so the language could be determined without having a special wordbook installed for that language. This feature was developed during a Google summer of code. Frank Loehmann (FL) speclink word processing
Ctrl-click to execute hyperlinks i75130 Smart Tags A smart tag scans the text of a document thru an API (i.e. for stock symbols like “SUNW”) and could offer functionality for such a recognized text via a context menu. Smart tags can be provided by extensions. This first version will support Writer text documents only and is only visible in the product if at least one Smart Tag has been installed. Frank Loehmann speclink word processing
New Smart Tag API and UI i75130 Smart Tags A smart tag scans the text of a document thru an API (i.e. for stock symbols like “SUNW”) and could offer functionality for such a recognized text via a context menu. Smart tags can be provided by extensions. This first version will support Writer text documents only and is only visible in the product if at least one Smart Tag has been installed. Frank Loehmann speclink word processing
'Old' mail merge dialog now supports output to single file i76853 Rework Simple Mail Merge Print Dialog The simple mail merge dialog is often used to print already present mail merge documents. The new mail merge wizard seems to be overloaded for those existing mail merge documents. The feature to save the mail merge in a single document is not implemented yet for this old dialog. This specification defines how this feature gets integrated into this dialog. Frank Loehmann (FL) speclink word processing
Soft page break i78650
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). Andreas Martens speclink word processing
Shortcut for "Repeat" i41586   feature-info:
We added a new shortcut for "Repeat": . 		hans-peter.burow@sun.com
framework
New writer compatibility option i45491   feature-info:
There is a new compatibility option on Tools - Options - Writer - Compatibility: "Do not justify alignment in lines ending with manual line break" 		hans-peter.burow@sun.com
framework
Password of a document is asked untill the correct one is entered or the dialog is cancelled. i75966   feature-info:
While opening an encrypted document the password should be asked again if an incorrect one was entered, otherwise an information loss is possible. Please see the related task for details. 		Mikhail.Voitenko@sun.com
framework
Menu and toolbar merging support for extensions i78020 New feature for Add-ons to merge into OpenOffice.org menu bar and toolbars

speclink framework
Default Macro Security Level changed i79170 Electronic Signatures and EncryptionGraphical User Interface (GUI)
malte.timmermann@sun.com speclink framework
First word in a Calc cell will no longer be capitalized by auto-correction i78661   feature-info:
As requested in the issue the auto capitalization of the first word in the first paragraph of a cell will no longer happen in spread sheets. This behavior is independent(!) of the respective setting for auto-correction. Developer notes: To allow for this the EditEngine has two new functions - IsFirstWordCapitalization and - SetFirstWordCapitalization Calling SetFirstWordCapitalization( FALSE ) will override the auto-correction setting and result in the described behavior. The default is TRUE. 		thomas.lange@sun.com
sc
Customize Keyboard tabpage i75754   feature-info:
There are some improvements of the Customize-Keyboard-TabPage. Now the Category-, Function- and Keys-Box are wider and the Load-, Save- and Reset-Button have new positions. The width of the tab of the Shortcut-Keys-Box is calculate dynamically. 		hans-peter.burow@sun.com
ui
Compatibility option "Expand word space..." added i45491 Compatibility Options Allow configuration of behavior when a line break is inserted Frank Loehmann (FL) speclink word processing
New export filter: MediaWiki i48409 MediaWiki Export Filter This document describes the usage of the Openoffice.org MediaWiki export filter and its formatting features. This adds the feature to export Writer and Writer/Web documents to a text file in Wikitext syntax. mathias.bauer@sun.com speclink word processing
Spell checking one letter words i78734   feature-info:
As requested in the issue one letter words will now also be spell checked. Regards, Thomas 		thomas.lange@sun.com
word processing 


Integrated
Child
Workspaces



List of integrated child workspaces:





  
    

      dba23f
      
      
OOo 2.3
fixing

      		
      OOG680m5
    

    

      mav24
      
      
The fix
for the Windows system file-picker implementation.

      		
      OOG680m5
    

    

      sdkapifix
      
      
hotfix
for the SDK

      		
      OOG680m5
    

  








  
    

      i18n37_OOG680
      
      
i18n
bug fixes

      		
      OOG680m4
    

    

      impress130
      
      
OOo
2.3 show stopper bug fix.

      		
      OOG680m4
    

    

      l10nfix22
      
      
this
cws fix one l10n issue

      		
      OOG680m4
    

    

      l10nfix23
      
      
this
cws fixes in pt tools/options/online update string

      		
      OOG680m4
    

    

      tl46_OOG680
      
      
Fixes
for OOo 2.3

      		
      OOG680m4
    

  








  
    

      ab41
      
      
cws to fix showstopper i80952

Applies patch that removes delete operations.
Only risk could be to get a memory leak, but
I could detect none at the first glance.

      		
      OOG680m3
    

    

      atkbridge7
      
      
Last
minute accessibility fixes.

      		
      OOG680m3
    

    

      bfbasic
      
      
revive Basic in documents in the old binary format
(http://www.openoffice.org/issues/show_bug.cgi?id=80769)

      		
      OOG680m3
    

    

      binfilterregression
      
      
Simple
bugfix for a regression in the sdd-Importfilter

      		
      OOG680m3
    

    

      c05helpfix2
      
      

      

      		
      OOG680m3
    

    

      cloph08_OOG680
      
      
fix permissions in slackware desktop-integration package
fix description in debian desktop-integration package

      		
      OOG680m3
    

    

      dba23e_OOG680
      
      
Fix
for SYSTEM_HSQLDB define in OpenOffice.org build

      		
      OOG680m3
    

    

      dicooo18_OOG680
      
      
Fix for DicOOo problem with Linguistic.xcu which may result in complete or partial loss
of linguistic functionality and some user settings.

      		
      OOG680m3
    

    

      extquote
      
      
Really
fix shared extension support on Solaris.

      		
      OOG680m3
    

    

      fmsrcres
      
      
fix
issue 80555

      		
      OOG680m3
    

    

      hr45
      
      
Fixes
a crash during smoketest in impress and draw on LP64 platforms.

      		
      OOG680m3
    

    

      hypfix
      
      
cws
for i80480 - hyperlink attributes might get lost.

      		
      OOG680m3
    

    

      i18n36
      
      
i18n
bug fixes.

      		
      OOG680m3
    

    

      impress127
      
      
OOo
2.3 show stopper

      		
      OOG680m3
    

    

      impress128
      
      
showstopper
fixes for impress

      		
      OOG680m3
    

    

      impress129
      
      
OOo2.3
showstoppers

      		
      OOG680m3
    

    

      localisation22
      
      

      

      		
      OOG680m3
    

    

      mh230
      
      
update
of THIRDPARTLICENSEREADME.html files

      		
      OOG680m3
    

    

      os101
      
      
Fix
of issue 79225

      		
      OOG680m3
    

    

      os102
      
      
Fix
of i76699 - centered view after loading of own documents

      		
      OOG680m3
    

    

      rpt23fix05
      
      
Replace
wrong license header with LGPL one. Fix minor build issue for
--with-lang=ALL. 

      		
      OOG680m3
    

    

      rpt23fix06
      
      
Reportdesign
fixes

      		
      OOG680m3
    

    

      shellfix06
      
      
Remove
bash'ism from senddoc.sh

      		
      OOG680m3
    

    

      swqbf107
      
      
fix
for issue i80724

      		
      OOG680m3
    

    

      swqbf108
      
      
cws
for i80767

      		
      OOG680m3
    

    

      thbpp8c
      
      
Showstopper
fixes for 2.3

      		
      OOG680m3
    

    

      thbpp8d
      
      
Showstopper
fixes for 2.3

      		
      OOG680m3
    

    

      tl42_OOG680
      
      

      

      		
      OOG680m3
    

    

      tl43_OOG680
      
      

      

      		
      OOG680m3
    

    

      updchk07b
      
      
Last
minutes bugfix for download component.

      		
      OOG680m3
    

    

      xmlmemory
      
      
fix
memory allocator divergence problem caused by calling xmlMemSetup in
unoxml

      		
      OOG680m3
    

    

      ab40
      
      

      

      		
      OOG680m2
    

    

      basepoolfix
      
      
Fix
for i80669

      		
      OOG680m2
    

    

      chart12_OOG680
      
      
chart
regressions

      		
      OOG680m2
    

    

      dbaantversion_OOG680
      
      
make
configure check whether ant is >= 1.6.0

      		
      OOG680m2
    

    

      dr57_OOG680
      
      
OOo
2.3 showstopper #i80499#

      		
      OOG680m2
    

    

      hro23
      
      
Showstopper 2.3

Add dummy stubs for missing imports on Win9x/ME

      		
      OOG680m2
    

    

      i18n34_OOG680
      
      
i18n
bug fix

      		
      OOG680m2
    

    

      impress125_OOG680
      
      
2.3
showstopper

      		
      OOG680m2
    

    

      impress126_OOG680
      
      
showstopper
fix for 2.3 release

      		
      OOG680m2
    

    

      jl72_OOG680
      
      
showstopper

      		
      OOG680m2
    

    

      localisation21_OOG680
      
      
l10n
cws for OOo 2.3

      		
      OOG680m2
    

    

      native107
      
      
rpm
dependencies for extensions

      		
      OOG680m2
    

    

      qssyncterm_OOG680
      
      

      

      		
      OOG680m2
    

    

      rpt23fix04
      
      
License
text for the sun report builder

      		
      OOG680m2
    

    

      smoketest17_OOG680
      
      
Solution
for Debian Systems

      		
      OOG680m2
    

    

      swqbf106
      
      
fixes
for issues i80691 and i80720

      		
      OOG680m2
    

    

      fixudkversion_OOG680
      
      
fix
UDK Version

      		
      OOG680m1
    

    

      fwk73_OOG680
      
      
Framework
showstopper for OpenOffice.og 2.3

      		
      OOG680m1
    

    

      jl68_OOG680
      
      
OOo
2.3 fixes

      		
      OOG680m1
    

    

      jl71_OOG680
      
      

      

      		
      OOG680m1
    

    

      rpt23fix03_OOG680
      
      

      

      		
      OOG680m1
    

    

      swqbf104_OOG680
      
      
fix
for regression i80314

      		
      OOG680m1
    

    

      thbpp8b_OOG680
      
      
Last-minute
fixes for 2.3

      		
      OOG680m1
    

  


54 records with 192 tasks.

View
as OpenDocument(Calc)







  
    

      ab34
      
      
OOo
2.3 fixes

      		
      SRC680m225
    

    

      aquavcl02
      
      
Second
child workspace for Mac OS X native related issues. 

      		
      SRC680m225
    

    

      aw052
      
      
BugFixing
CWS

      		
      SRC680m225
    

    

      brofficenologo
      
      
broffice
with nologo intro

      		
      SRC680m225
    

    

      chart10
      
      
regression
performance problem in calc with charts

      		
      SRC680m225
    

    

      cloph07
      
      
fix the fake-db rpm for the user-installation script, and maybe
some minor (configure) fixes related to the Mac port

      		
      SRC680m225
    

    

      cmcfixes35
      
      

      

      		
      SRC680m225
    

    

      cmcfixes37
      
      
Fix
missing toolbar descriptions in customize dialog

      		
      SRC680m225
    

    

      dictionariesfor23v01
      
      
More dictionaries and language related stuff for 2.3.

- Afrikaans hyphenation
- South African English autocorrect file
- Slovenian spellchecker
- Brazilian Portuguese spellchecker

      		
      SRC680m225
    

    

      dr56
      
      
Calc
fixes for 2.3

      		
      SRC680m225
    

    

      fsfixes07
      
      
fix a silly where the embedded objects in flat odf must have old invalid
mimetype in order not to be ignored on import.

      		
      SRC680m225
    

    

      fwk69
      
      
Bugfixes
for OOo 2.3.

      		
      SRC680m225
    

    

      fwk70
      
      
Fixes
for OpenOffice.org 2.3

      		
      SRC680m225
    

    

      fwk71
      
      
Showstopper
for 2.3

      		
      SRC680m225
    

    

      hcicons
      
      

      

      		
      SRC680m225
    

    

      hropatches
      
      
Community
patches for OOo 2.3

      		
      SRC680m225
    

    

      impress123
      
      
fixes
for impress/draw

      		
      SRC680m225
    

    

      jscoo23showstopper
      
      
showstopper
issue that causes a crash

      		
      SRC680m225
    

    

      kendy18
      
      
Trivial
fixes, mostly build-related.

      		
      SRC680m225
    

    

      oasisrng03
      
      

      

      		
      SRC680m225
    

    

      pj83
      
      
Collection
of random fixes. Cleanup of goodies. Mac OS X X11 redraw issue. 

      		
      SRC680m225
    

    

      rpt23fix01
      
      
2.3
fixes for the new report designer

      		
      SRC680m225
    

    

      rpt23fix02
      
      
Ongoing
issue fixing for the report builder

      		
      SRC680m225
    

    

      swa11y01
      
      
Implementation
of a11y issues for Writer and Chart

      		
      SRC680m225
    

    

      swqbf103