Difference between revisions of "New Features 2.4"
From Apache OpenOffice Wiki
(→Full list) |
(fix list of regressions) |
||
| (28 intermediate revisions by 4 users not shown) | |||
| Line 9: | Line 9: | ||
Full list is available below. | Full list is available below. | ||
| − | + | General | |
| + | * Connect to WebDAV servers via HTTPS | ||
| + | * Custom icons for toolbars are imported | ||
| + | * Control password-storing with a master password | ||
| + | * Warning if document is from a newer ODF | ||
| + | * PDF documents: [http://www.oooninja.com/2008/02/create-relative-links-in-pdfs.html relative links], [http://www.oooninja.com/2008/02/convert-document-references-pdf-targets.html document references], [http://www.oooninja.com/2008/01/generating-pdfa-for-long-term-archiving.html PDF/A-1] (ISO 19005-1) supported, and cross-document link behavior options | ||
| + | * Mac OS X (Aqua Development version): Quicktime support for movies and sound / use the built in spell checker | ||
| + | * Print dialog improvements in usability | ||
| + | * Edit boxes: warning at limit of characters | ||
| + | * DejaVu font is now default instead of BitStream Vera | ||
| + | |||
| + | Localisation | ||
| + | * Entries for 10 languages added | ||
| − | + | Base / DBA | |
| + | * Improved rendering of numeric(n) data from JDBC and Oracle | ||
| + | * Easier choice of table name in "Copy table" | ||
| + | * Editing of views in HSQLDB | ||
| + | * Query designer for all properties which allow SQL command | ||
| + | * Query designer in SQL view | ||
| + | * Relation design accessible for MySQL databases | ||
| + | * Setting to check for required fields on forms | ||
| + | * Support for Access 2007 (.accdb files) | ||
| − | + | Calc | |
| + | * [http://www.oooninja.com/2008/01/text-columns-calc-convert-openoffice.html Convert text to columns]: with this feature CSV data inside cells can be transformed into columns directly | ||
| + | * Columns and rows in spreadsheet can be [http://www.oooninja.com/2008/03/drag-drop-move-copy-link-cells-calc.html moved with drag and drop] | ||
| + | * Enter key returns to the column where the input started, one row below | ||
| + | * Formula input: "+" and "-" can also be used to start | ||
| + | * Individual zoom level per sheet | ||
| + | * AutoFilter: choices clearer grouped and based on result of filtering in other columns | ||
| + | * DataPilot: Manual Sorting / Double-click in DataPilot cell provides calculation data of that cell | ||
| + | * Performance improvement with functions VLOOKUP and MATCH | ||
| + | * Print dialog for Calc easier to use | ||
| + | * PageUp and PageDown keys work in print preview | ||
| + | * Sheet names in cell-hyperlinks: renamed properly | ||
| − | + | Chart | |
| + | * [http://www.oooninja.com/2007/12/display-equations-for-regression-lines.html Regression curves: show equations and R² value] | ||
| + | * [http://www.oooninja.com/2008/02/reverse-axis-chart-bar-graph.html Reverse axes] possible | ||
| + | * [http://www.oooninja.com/2008/01/show-bars-side-by-side-double-column.html Bars on different axes displayed next to each other] | ||
| + | * Data labels: [http://www.oooninja.com/2008/03/data-label-options-calc-chart.html Number format] | ||
| + | * Data point label: display both value and percentage | ||
| + | * Data label: display each part in a separate line | ||
| + | * Data labels: more flexible placement of labels | ||
| + | * [http://blogs.sun.com/GullFOSS/entry/new_chart_features_in_openoffice Labels on pie segments: avoiding overlapping] | ||
| + | * Data point label: can be removed with delete key | ||
| − | + | Draw | |
| + | * Navigation (tab) order of page objects | ||
| + | * PDF export: [http://www.oooninja.com/2008/02/export-page-names-as-pdf-bookmarks.html page names as bookmark] | ||
| + | * Reduce complexity: no longer necessary display options removed | ||
| − | + | Impress | |
| + | * Navigation (tab) order of page objects | ||
| + | * Thrilling [http://www.oooninja.com/2008/02/eye-candy-3d-opengl-transitions-impress.html 3D effects in slide transitions] | ||
| + | * Export slide names as PDF bookmarks | ||
| + | * Easier to insert background picture | ||
| − | + | Writer | |
| + | * [http://www.oooninja.com/2007/12/block-selection-mode-new-feature.html Selecting rectangular region of text] | ||
| + | * Find and Replace: [http://www.oooninja.com/2007/12/backreferences-in-replacements-new.html backward references] in regular expressions | ||
| + | * Spell checking: [http://www.oooninja.com/2008/02/set-select-language-spell-check-switch.html easier selecting of the language] | ||
| + | * Insert&Insert Object toolbar redesign - Writer | ||
| + | * Printing of hidden text can be turned on | ||
| + | * Printing text place holders can be turned off | ||
| + | * Shortcuts added for paragraph style Heading 4, Heading 5 and Textbody | ||
| + | * Ctrl-click behaviour for hyperlinks can be changed | ||
| + | * [http://blogs.sun.com/GullFOSS/entry/custom_properties_and_fields Custom document properties: Text fields and UI support] | ||
| − | + | Extensions/ programmability / API | |
| − | + | * Extensible Help System for extensions | |
| − | + | * Extensions can have a separate display name | |
| − | + | * [http://blogs.sun.com/GullFOSS/entry/improvements_for_updating_extensions_in Extensions: support of web based update] | |
| − | + | * Extensions: additional information about the publisher and release notes | |
| − | + | * Extensions: check for updates | |
| − | + | * Dialogs can have a wallpaper set | |
| − | + | * Transparent background for controls | |
| − | + | * Remote control presentations via API | |
| − | + | * API: get selected table(s) or query(s) in the main Base window | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
== Blogs & Screen Shots == | == Blogs & Screen Shots == | ||
=== Blogs === | === Blogs === | ||
| + | |||
| + | <!-- These are blogs which refer to OpenOffice.org in general? How about we move some of these into more specific places. For example, the localization article can be moved into the localization section. Ditto for new chart features. Some of others, such as the RedFlag, I suggest stay. --> | ||
* [http://blogs.sun.com/GullFOSS/entry/ooo_2_4_localisation "OOo 2.4 localisation"] | * [http://blogs.sun.com/GullFOSS/entry/ooo_2_4_localisation "OOo 2.4 localisation"] | ||
| Line 53: | Line 100: | ||
* [http://blogs.sun.com/GullFOSS/entry/openoffice_org_2_4_features "OpenOffice.org 2.4 features implemented in cooperation with the RedFlag 2000 framework team"] | * [http://blogs.sun.com/GullFOSS/entry/openoffice_org_2_4_features "OpenOffice.org 2.4 features implemented in cooperation with the RedFlag 2000 framework team"] | ||
* [http://blogs.sun.com/GullFOSS/entry/last_feature_release_on_openoffice "Last Feature Release on OpenOffice.org 2.x"] | * [http://blogs.sun.com/GullFOSS/entry/last_feature_release_on_openoffice "Last Feature Release on OpenOffice.org 2.x"] | ||
| + | * [http://www.oooninja.com/2008/03/new-features-openofficeorg-240.html New Features in OpenOffice.org 2.4] | ||
=== Screen Shots === | === Screen Shots === | ||
| − | |||
| − | |||
<gallery> | <gallery> | ||
| Line 85: | Line 131: | ||
|- | |- | ||
| − | | | + | | ... |
| − | | | + | | ... |
| − | | | + | | ... |
|} | |} | ||
<br> | <br> | ||
| − | See list of [http://qa.openoffice.org/issues/buglist.cgi? | + | See list of [http://qa.openoffice.org/issues/buglist.cgi?Submit+query=Submit+query&version=OOH680m1&version=OOH680m2&version=OOH680m3&version=OOH680m4&version=OOH680m5&version=OOH680m6&version=OOH680m7&version=OOH680m8&version=OOH680m9&version=OOo+2.4+RC1&version=OOo+2.4+RC2&version=OOo+2.4+RC3&version=OOo+2.4+RC4&version=OOo+2.4+RC5&version=OOo+2.4+RC6&version=OOo+2.4.0&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfieldfrom=&chfieldto=&chfieldvalue=&short_desc=&short_desc_type=allwords&long_desc=&long_desc_type=allwords&issue_file_loc=&issue_file_loc_type=fulltext&status_whiteboard=&status_whiteboard_type=fulltext&keywords=regression&keywords_type=anytokens regressions found in OpenOffice.org version 2.4.0]. |
== Full list == | == Full list == | ||
| Line 103: | Line 149: | ||
! Specs/Issue | ! Specs/Issue | ||
| − | |||
| − | |||
| − | |||
| − | |||
|- | |- | ||
| Connect WebDAV servers via HTTPS | | Connect WebDAV servers via HTTPS | ||
| − | | OOo is now able to connect WebDAV servers via HTTPS | + | | OOo is now able to connect WebDAV servers via HTTPS. |
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=31053 31053 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=31053 31053] [http://specs.openoffice.org/appwide/fileIO/WebDAV_over_HTTPS.odt Spec] |
|- | |- | ||
| − | | Custom icons for toolbars | + | | Custom icons for toolbars imported |
| Icons can be imported for toolbars (Tools>Customize>Toolbars...>Modify>Change icon). Now those are stored persistently into a user-icon list. Icons for import shall be in PNG format and shall have a size of 16x16 or 26 by 26 pixel. The dialog has new buttons for Import and Delete. | | Icons can be imported for toolbars (Tools>Customize>Toolbars...>Modify>Change icon). Now those are stored persistently into a user-icon list. Icons for import shall be in PNG format and shall have a size of 16x16 or 26 by 26 pixel. The dialog has new buttons for Import and Delete. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=73357 73357 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=73357 73357] [http://specs.openoffice.org/ui_in_general/toolbars/openoffice_org_toolbar_spec.odt Spec] |
|- | |- | ||
| ODF in the names of the file types | | ODF in the names of the file types | ||
| − | | The 'ODF' abbreviation replaces the 'OpenDocument' description of file types | + | | The 'ODF' abbreviation replaces the 'OpenDocument' description of file types. |
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=80206 80206 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=80206 80206] [http://specs.openoffice.org/appwide/fileIO/FileFormatNames.sxw Spec] |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| Master password/ password configuration | | Master password/ password configuration | ||
| The security tab in the Tools>Options dialog contains now possibility to control password-storing ( the passwords for specific URL-sites could be stored there ). By default the storing is not allowed. | | The security tab in the Tools>Options dialog contains now possibility to control password-storing ( the passwords for specific URL-sites could be stored there ). By default the storing is not allowed. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=82892 82892 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=82892 82892] [http://specs.openoffice.org/appwide/security/Electronic_Signatures_and_Security.sxw Spec] |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| Warning if document is from a newer ODF version | | Warning if document is from a newer ODF version | ||
| If a file is opened, that is written in a newer ODF version, than supported by the installed OpenOffice.org (i.e. ODF 1.2 versus ODF 1.1) a new dialog is shown. This dialog informs about online update to a newer version of OOo. | | If a file is opened, that is written in a newer ODF version, than supported by the installed OpenOffice.org (i.e. ODF 1.2 versus ODF 1.1) a new dialog is shown. This dialog informs about online update to a newer version of OOo. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=83653 83653 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=83653 83653] [http://specs.openoffice.org/appwide/onlineupdate/ODF_Online_Update_Trigger.odt Spec] |
|- | |- | ||
| Relative links can be created in PDF documents | | Relative links can be created in PDF documents | ||
| When exporting to PDF, links in those documents can be made relative on request. Thus for example, some related PDF-documents can link to each other. The PDF Options dialog has a new tab page: Links. | | When exporting to PDF, links in those documents can be made relative on request. Thus for example, some related PDF-documents can link to each other. The PDF Options dialog has a new tab page: Links. | ||
| [http://www.oooninja.com/2008/02/create-relative-links-in-pdfs.html Article] | | [http://www.oooninja.com/2008/02/create-relative-links-in-pdfs.html Article] | ||
| − | [http://www.openoffice.org/issues/show_bug.cgi?id=56629 56629 | + | [http://www.openoffice.org/issues/show_bug.cgi?id=56629 56629] |
|- | |- | ||
| Document references can be converted in PDF targets | | Document references can be converted in PDF targets | ||
| Line 163: | Line 182: | ||
| When exporting a document to PDF, the PDF Options dialog offers export to PDF/A-1a. PDF/A-1a is ISO 19005-1:2005 International Standard. | | When exporting a document to PDF, the PDF Options dialog offers export to PDF/A-1a. PDF/A-1a is ISO 19005-1:2005 International Standard. | ||
| [http://www.oooninja.com/2008/01/generating-pdfa-for-long-term-archiving.html Article] | | [http://www.oooninja.com/2008/01/generating-pdfa-for-long-term-archiving.html Article] | ||
| − | [http://www.openoffice.org/issues/show_bug.cgi?id=59651 59651 | + | [http://www.openoffice.org/issues/show_bug.cgi?id=59651 59651] [http://www.openoffice.org/issues/show_bug.cgi?id=59651#desc22 Spec] |
|- | |- | ||
| − | | Quicktime support for movies and sound | + | | Mac OS X: Quicktime support for movies and sound |
| The Mac OS X native used Quicktime player is now supported by OpenOffice.org. | | The Mac OS X native used Quicktime player is now supported by OpenOffice.org. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=82234 82234 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=82234 82234] [http://specs.openoffice.org/Mac_Port/System_Integration/macosx_quicktime.odt Spec] |
|- | |- | ||
| − | | | + | | Mac OS X: use the built in spell checker |
| Mac OS X has a built in spell checking facility in many languages. Thus the user can maintain a single word list across all applications. Now these spellcheck services are integrated into the existing OpenOffice.org user interface. | | Mac OS X has a built in spell checking facility in many languages. Thus the user can maintain a single word list across all applications. Now these spellcheck services are integrated into the existing OpenOffice.org user interface. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=77592 77592 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=77592 77592] [http://specs.openoffice.org/appwide/linguistic/macosx_spellchecker.odt Spec.] |
|- | |- | ||
| − | | Print dialog | + | | Print dialog: cursor on field 'number of copies' |
| The print dialog in all OOo modules (Ctrl-P or File>Print) now starts with the focus on the 'number of copies' the user would like to print. This often saves tabbing or clicking. | | The print dialog in all OOo modules (Ctrl-P or File>Print) now starts with the focus on the 'number of copies' the user would like to print. This often saves tabbing or clicking. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=9521 9521] [http:// | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=9521 9521] |
| + | |- | ||
| + | | Print dialog: 'Sort' option default | ||
| + | | In the Print dialog the 'Sort' option is defaulted to on. This makes it easier to print multiple copies of a document. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=82071 82071] | ||
| + | [http://specs.openoffice.org/appwide/printing/Print_Dialog.odt Spec] | ||
|- | |- | ||
| − | | Warning when limit of | + | | Warning when limit of characters reached for edit boxes |
| If an edit box (such as text box or combo box and others) reaches the limit of characters, a message box warns that the text is truncated. (The limit of characters can either be set for the control, or be the maximum count (65535) of characters possible in such controls.) | | If an edit box (such as text box or combo box and others) reaches the limit of characters, a message box warns that the text is truncated. (The limit of characters can either be set for the control, or be the maximum count (65535) of characters possible in such controls.) | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=73360 73360] [http:// | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=73360 73360] |
| + | |- | ||
| + | | AutoCaption format localisable | ||
| + | | Now the AutoCaption format (figures, tables) is localisable. In some languages, the number has to be placed before the word "figure", for example. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=61007 61007] | ||
|- | |- | ||
| DejaVu font is now default in stead of BitStream Vera | | DejaVu font is now default in stead of BitStream Vera | ||
| Line 198: | Line 226: | ||
| Serbia and Montenegro | | Serbia and Montenegro | ||
| Disentangled the Serbia and Montenegro locales | | Disentangled the Serbia and Montenegro locales | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=71789 71789 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=71789 71789] |
|- | |- | ||
| Add locales of available dictionaries to language list box | | Add locales of available dictionaries to language list box | ||
| New language list box entries available for font attribution: "Nyanja" [= ny-MW], "Kashubian" [= csb-PL], "Spanish (Cuba)" [= es-CU], "Tetun" [= tet-ID] | | New language list box entries available for font attribution: "Nyanja" [= ny-MW], "Kashubian" [= csb-PL], "Spanish (Cuba)" [= es-CU], "Tetun" [= tet-ID] | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=76233 76233 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=76233 76233] |
|- | |- | ||
| Venezuela (es_VE): currency | | Venezuela (es_VE): currency | ||
| − | | From 2008-01-01 the Bolivar Fuerte, VEF, | + | | From 2008-01-01 the Bolivar Fuerte, VEF, is the new currency for Venezuela. In OpenOffice.org 2.4 it will be the default currency for the es-VE locale. |
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=78601 78601 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=78601 78601] |
|- | |- | ||
| Farsi/Persian: numbering support | | Farsi/Persian: numbering support | ||
| Added support of Farsi/Persian native numbering and alphabetic outline numbering, the latter appearing in Writer under Format -> Bullets and Numbering -> Options -> Numbering list box. It is not available in the preset numbering types or outlines yet. Native numbering is available through the number formatter for format codes using the [NatNum1] modifier. | | Added support of Farsi/Persian native numbering and alphabetic outline numbering, the latter appearing in Writer under Format -> Bullets and Numbering -> Options -> Numbering list box. It is not available in the preset numbering types or outlines yet. Native numbering is available through the number formatter for format codes using the [NatNum1] modifier. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=79797 79797 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=79797 79797] |
|- | |- | ||
| Bolivia, Quechua: added to language list box | | Bolivia, Quechua: added to language list box | ||
| New language list box entries available for character attribution: "Quechua (Bolivia, North)" [= qul-BO], "Quechua (Bolivia, South)" [= quh-BO] | | New language list box entries available for character attribution: "Quechua (Bolivia, North)" [= qul-BO], "Quechua (Bolivia, South)" [= quh-BO] | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=80114 80114 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=80114 80114] |
|- | |- | ||
| Low German (nds-DE): added to language list box. | | Low German (nds-DE): added to language list box. | ||
| New language list box entry available for character attribution: "Low German" [= nds-DE] | | New language list box entry available for character attribution: "Low German" [= nds-DE] | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=80432 80432 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=80432 80432] |
|- | |- | ||
| Hiligaynon (hil_PH): added to language list box | | Hiligaynon (hil_PH): added to language list box | ||
| Added a new language list box entry and locale data for Hiligaynon_Philippines (hil_PH), available for character attribution, number formats and as default document language. | | Added a new language list box entry and locale data for Hiligaynon_Philippines (hil_PH), available for character attribution, number formats and as default document language. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=82723 82723 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=82723 82723] |
|- | |- | ||
| Sámi languages: added to language list box | | Sámi languages: added to language list box | ||
| Various Sami entries added to the language list box. These are available for character attribution and spell-checking: ... | | Various Sami entries added to the language list box. These are available for character attribution and spell-checking: ... | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=82927 82927] | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=82927 82927] ] |
|- | |- | ||
| Somali (so_SO): added to language list box | | Somali (so_SO): added to language list box | ||
| Added a new language list box entry and locale data for Somali_Somalia (so_SO), available for character attribution, number formats and as default document language. | | Added a new language list box entry and locale data for Somali_Somalia (so_SO), available for character attribution, number formats and as default document language. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=83369 83369 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=83369 83369] |
|} | |} | ||
| Line 245: | Line 273: | ||
| Improved rendering of numeric(n) data from jdbc/oracle | | Improved rendering of numeric(n) data from jdbc/oracle | ||
| The Advanced Settings dialog now has a property to disable the currency return value from the ResultSetMetaData. Thus numeric data can be rendered as number, in stead of (always) as currency. | | The Advanced Settings dialog now has a property to disable the currency return value from the ResultSetMetaData. Thus numeric data can be rendered as number, in stead of (always) as currency. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=11746 11746] | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=11746 11746] |
| + | [http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw Spec] | ||
|- | |- | ||
| Easier choice of table name in "Copy table" | | Easier choice of table name in "Copy table" | ||
| Now when you paste table-like data to OOo Base, with a table object selected, this table's existing name, along with the option "Append data", is pre-selected in the "Copy Table" wizard. | | Now when you paste table-like data to OOo Base, with a table object selected, this table's existing name, along with the option "Append data", is pre-selected in the "Copy Table" wizard. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=18907 18907 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=18907 18907] |
|- | |- | ||
| − | | | + | | Editing of views in HSQLDB |
| From OOo 2.4.0 it is possibe to edit a view's design (underlying statement) in embedded HSQL databases. | | From OOo 2.4.0 it is possibe to edit a view's design (underlying statement) in embedded HSQL databases. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=49183 49183 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=49183 49183] |
|- | |- | ||
| Query designer for all properties which allow SQL command | | Query designer for all properties which allow SQL command | ||
| From the property browser it is possible to invoke the query designer not only for the "Content" property of a database form (if it's content type is "SQL command"), but also for the list content of a list box control (or grid column), if its list content type is "SQL". The SQL command which you design in the query designer will, when saving it, be set as the respective property at the list box. | | From the property browser it is possible to invoke the query designer not only for the "Content" property of a database form (if it's content type is "SQL command"), but also for the list content of a list box control (or grid column), if its list content type is "SQL". The SQL command which you design in the query designer will, when saving it, be set as the respective property at the list box. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=66624 66624 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=66624 66624] |
|- | |- | ||
| Query designer in SQL view | | Query designer in SQL view | ||
| From within the property browser for a database form, you can open the query designer, to graphically design the SQL command underlying the form. ... | | From within the property browser for a database form, you can open the query designer, to graphically design the SQL command underlying the form. ... | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=77492 77492 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=77492 77492] |
|- | |- | ||
| Relation design for MySQL databases | | Relation design for MySQL databases | ||
| The relation design is now accessible for MySQL databases as well | | The relation design is now accessible for MySQL databases as well | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=68858 68858 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=68858 68858] |
|- | |- | ||
| API: get selected table(s) or query(s) in the main Base window | | API: get selected table(s) or query(s) in the main Base window | ||
| The ability is added (by supporting of com.sun.star.view.XSelectionSupplier interface) to find which table(s) or query(s) are currently selected in the main Base window. | | The ability is added (by supporting of com.sun.star.view.XSelectionSupplier interface) to find which table(s) or query(s) are currently selected in the main Base window. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=69740 69740 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=69740 69740] |
|- | |- | ||
| Setting to check for required fields on forms | | Setting to check for required fields on forms | ||
| Now for databases, there exists a per-database setting which controls whether forms check for required fields when entering data. | | Now for databases, there exists a per-database setting which controls whether forms check for required fields when entering data. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=80930 80930 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=80930 80930] |
|- | |- | ||
| Support for Access 2007 (accdb) | | Support for Access 2007 (accdb) | ||
| The new file format for MS Access 2007 (accdb files) is now also supported by the OpenOffice.org Base. When creating a new database, one can now select "MS Access 2007" as type to connect to. | | The new file format for MS Access 2007 (accdb files) is now also supported by the OpenOffice.org Base. When creating a new database, one can now select "MS Access 2007" as type to connect to. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=81043 81043] | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=81043 81043] |
| + | [http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw Spec] | ||
|} | |} | ||
| Line 295: | Line 325: | ||
Start this feature with the menu Data>Text to Columns. | Start this feature with the menu Data>Text to Columns. | ||
| [http://www.oooninja.com/2008/01/text-columns-calc-convert-openoffice.html Article] | | [http://www.oooninja.com/2008/01/text-columns-calc-convert-openoffice.html Article] | ||
| − | [http://www.openoffice.org/issues/show_bug.cgi?id=4040 4040] | + | [http://www.openoffice.org/issues/show_bug.cgi?id=4040 4040] |
| + | [http://specs.openoffice.org/calc/ease-of-use/Text_to_Columns.odt Spec] | ||
|- | |- | ||
| − | | | + | | Cells in spreadsheet can be moved, copied, or linked |
| Select one or more columns or rows, or a range of cells, and hold down Alt while moving the selection with the mouse. When the mouse button is released, other cells/columns/rows are moved left or down, to insert the selection. Before this feature, target cells always were overwritten. | | Select one or more columns or rows, or a range of cells, and hold down Alt while moving the selection with the mouse. When the mouse button is released, other cells/columns/rows are moved left or down, to insert the selection. Before this feature, target cells always were overwritten. | ||
| − | | [http://www. | + | | [http://www.oooninja.com/2008/03/drag-drop-move-copy-link-cells-calc.html<span title="Instructions and video on the three new drag-and-drop modes in OpenOffice.org Calc">Article</span>] |
| + | [http://www.openoffice.org/issues/show_bug.cgi?id=7180 7180] | ||
| + | [http://specs.openoffice.org/calc/ease-of-use/Insertion_of_Cells.odt Spec] | ||
|- | |- | ||
| Enter key returns to the column where the input started, one row below | | Enter key returns to the column where the input started, one row below | ||
| Entering data row wise is made easier. The Enter 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. | | Entering data row wise is made easier. The Enter 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. | ||
| − | | [http://www. | + | | [http://www.veoh.com/videos/v6305084fsMfEQrn Video] |
| + | [http://www.openoffice.org/issues/show_bug.cgi?id=15546 15546] | ||
| + | [http://specs.openoffice.org/calc/ease-of-use/Enhanced_Data_Input.odt Spec] | ||
|- | |- | ||
| Formula input: "+" and "-" can also be used to start | | Formula input: "+" and "-" can also be used to start | ||
| 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. | | 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. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=20496 20496] | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=20496 20496] |
| + | [http://specs.openoffice.org/calc/ease-of-use/Enhanced_Formula_Input.odt Spec] | ||
|- | |- | ||
| Individual zoom level per sheet | | Individual zoom level per sheet | ||
| Each sheet in a spreadsheet document can now have its own zoom level. | | Each sheet in a spreadsheet document can now have its own zoom level. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=24372 24372] | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=24372 24372] |
| + | [http://specs.openoffice.org/calc/dialogs/Options_Dialog.odt Spec] | ||
|- | |- | ||
| AutoFilter: choices clearer grouped and based on result of filtering in other columns | | AutoFilter: choices clearer grouped and based on result of filtering in other columns | ||
| 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. Two things are new: there is a clearer grouping of static filter choices. And if in one column a filter is set, the filters in the other columns only show the options that are available in the visible rows. | | 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. Two things are new: there is a clearer grouping of static filter choices. And if in one column a filter is set, the filters in the other columns only show the options that are available in the visible rows. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=27745 27745] | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=27745 27745] |
| + | [http://specs.openoffice.org/calc/ease-of-use/AutoFilter_Behavior.odt Spec] | ||
|- | |- | ||
| DataPilot: Manual Sorting | | DataPilot: Manual Sorting | ||
| It's now possible to rearrange items in a DataPilot field via Drag&Drop or Copy&Paste. The default sorting for new tables is "Ascending", it is changed to "Manual" when items are moved. | | It's now possible to rearrange items in a DataPilot field via Drag&Drop or Copy&Paste. The default sorting for new tables is "Ascending", it is changed to "Manual" when items are moved. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=32307 32307] | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=32307 32307] |
| + | [http://specs.openoffice.org/calc/ease-of-use/Manual_Sorting_in_Data_Pilot.odt Spec] | ||
|- | |- | ||
| Double-click in Datapilot cell provides calculation data of that cell | | Double-click in Datapilot cell provides calculation data of that cell | ||
| When a cell within the data field is double-clicked, it inserts a new sheet containing a subset of rows from the original data source that constitutes the result data displayed in that cell. For instance, when the data field function is selected to be SUM, then the number that is shown in the data field cell must be identical to the sum of all the data field values in the constituent rows displayed in the inserted sheet. | | When a cell within the data field is double-clicked, it inserts a new sheet containing a subset of rows from the original data source that constitutes the result data displayed in that cell. For instance, when the data field function is selected to be SUM, then the number that is shown in the data field cell must be identical to the sum of all the data field values in the constituent rows displayed in the inserted sheet. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=57030 57030] | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=57030 57030] |
| + | [http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_drill-down_on_data_field Spec] | ||
|- | |- | ||
| Performance improvement with functions VLOOKUP and MATCH | | Performance improvement with functions VLOOKUP and MATCH | ||
| Spreadsheet functions VLOOKUP and MATCH results are used by OpenOffice.org to make these functions in the same row perform faster. | | Spreadsheet functions VLOOKUP and MATCH results are used by OpenOffice.org to make these functions in the same row perform faster. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=81336 81336] | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=81336 81336] |
| + | [http://wiki.services.openoffice.org/wiki/Calc/To-Dos/Performance/VLOOKUP Spec] | ||
|- | |- | ||
| Print dialog for Calc easier to use | | Print dialog for Calc easier to use | ||
| The Print dialog in Calc makes it easier to choose what part of the spreadsheet has to be printed. The option 'print only selected sheets' is now on that dialog. | | The Print dialog in Calc makes it easier to choose what part of the spreadsheet has to be printed. The option 'print only selected sheets' is now on that dialog. | ||
Furthermore the 'Sort' option is defaulted to on. This makes it easier to print multiple copies of a document. | Furthermore the 'Sort' option is defaulted to on. This makes it easier to print multiple copies of a document. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=82071 82071] [http:// | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=82071 82071] |
| + | [http://specs.openoffice.org/appwide/printing/Print_Dialog.odt Spec] | ||
| + | |- | ||
| + | | Print preview: PageUp and PageDown keys work | ||
| + | | From 2.4.0 PgUp/PgDn scroll continuously through the print preview. Ctrl + PgUp/PgDn scroll to top of next/previous page. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=7269 7269] | ||
| + | |- | ||
| + | | Sheet names in cell-hyperlinks: renamed properly | ||
| + | | Now sheet names in cell-hyperlinks are renamed properly. This also corrects the import from Excel with cell references to other sheets. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=81154 81154] | ||
|} | |} | ||
<br> | <br> | ||
| + | |||
=== Chart === | === Chart === | ||
| Line 344: | Line 395: | ||
|- | |- | ||
| − | | | + | | Regression curves: show equations and R² value |
| The equation of trend lines and the R² value now can be displayed in the chart. | | The equation of trend lines and the R² value now can be displayed in the chart. | ||
| [http://www.oooninja.com/2007/12/display-equations-for-regression-lines.html Article] | | [http://www.oooninja.com/2007/12/display-equations-for-regression-lines.html Article] | ||
[http://www.openoffice.org/issues/show_bug.cgi?id=7998 7998] | [http://www.openoffice.org/issues/show_bug.cgi?id=7998 7998] | ||
| − | |||
[http://specs.openoffice.org/chart/DisplayTrendLineEquations.odt Spec] | [http://specs.openoffice.org/chart/DisplayTrendLineEquations.odt Spec] | ||
| − | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4 Screen Shots] | + | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4#Display_bars_on_different_axes_next_to_each_other Screen Shots] |
|- | |- | ||
| Reverse axes | | Reverse axes | ||
| It is possible now to change the direction of axes. Thus the user can choose where the lower values and where the higher values are displayed at an axis. | | It is possible now to change the direction of axes. Thus the user can choose where the lower values and where the higher values are displayed at an axis. | ||
| [http://www.oooninja.com/2008/02/reverse-axis-chart-bar-graph.html Article] | | [http://www.oooninja.com/2008/02/reverse-axis-chart-bar-graph.html Article] | ||
| − | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4 Screen Shots] | + | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4#Reverse_axes Screen Shots] |
[http://www.openoffice.org/issues/show_bug.cgi?id=24614 24614] | [http://www.openoffice.org/issues/show_bug.cgi?id=24614 24614] | ||
| − | |||
[http://specs.openoffice.org/chart/Chart_Scales_and_Intervals.odt Spec] | [http://specs.openoffice.org/chart/Chart_Scales_and_Intervals.odt Spec] | ||
|- | |- | ||
| − | | | + | | Different axes: bars displayed next to each other |
| − | | In bar charts with two y axes it is now also possible to display all the bars next to each thus they don't hide each other anymore. | + | | In bar charts with two y axes it is now also possible to display all the bars next to each other, thus they don't hide each other anymore. |
| [http://www.oooninja.com/2008/01/show-bars-side-by-side-double-column.html Article] | | [http://www.oooninja.com/2008/01/show-bars-side-by-side-double-column.html Article] | ||
| − | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4 Screen Shots] | + | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4#Display_bars_on_different_axes_next_to_each_other Screen Shots] |
[http://www.openoffice.org/issues/show_bug.cgi?id=26795 26795] | [http://www.openoffice.org/issues/show_bug.cgi?id=26795 26795] | ||
| − | |||
[http://specs.openoffice.org/chart/BarChartOptions.odt Spec] | [http://specs.openoffice.org/chart/BarChartOptions.odt Spec] | ||
|- | |- | ||
| − | | Number format | + | | Data labels: Number format |
| For data labels in charts it is now possible to choose a number format for the display of values and percentage values. Thus the precision of the displayed values can be changed for example. | | For data labels in charts it is now possible to choose a number format for the display of values and percentage values. Thus the precision of the displayed values can be changed for example. | ||
| − | | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4 Screen Shots] | + | | [http://www.oooninja.com/2008/03/data-label-options-calc-chart.html Article] |
| + | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4#Number_format_for_data_labels Screen Shots] | ||
[http://www.openoffice.org/issues/show_bug.cgi?id=37792 37792] | [http://www.openoffice.org/issues/show_bug.cgi?id=37792 37792] | ||
| − | |||
[http://specs.openoffice.org/chart/ChartDataLabels.odt Spec] | [http://specs.openoffice.org/chart/ChartDataLabels.odt Spec] | ||
|- | |- | ||
| − | | | + | | Data point label: display both value and percentage |
| For data labels in charts it is now possible to display the value and the percentage value at the same time. | | For data labels in charts it is now possible to display the value and the percentage value at the same time. | ||
| − | | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4 Screen Shots] | + | | [http://www.oooninja.com/2008/03/data-label-options-calc-chart.html Article] |
| + | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4#Display_both_in_the_data_point_label:_value_and_percentage Screen Shots] | ||
[http://www.openoffice.org/issues/show_bug.cgi?id=43489 43489] | [http://www.openoffice.org/issues/show_bug.cgi?id=43489 43489] | ||
| − | |||
[http://specs.openoffice.org/chart/ChartDataLabels.odt Spec] | [http://specs.openoffice.org/chart/ChartDataLabels.odt Spec] | ||
|- | |- | ||
| − | | | + | | Data label: display each part in a separate line |
| The different parts of a data label now can be displayed in separate lines. | | The different parts of a data label now can be displayed in separate lines. | ||
| − | | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4 Screen Shots] | + | | [http://www.oooninja.com/2008/03/data-label-options-calc-chart.html Article] |
| + | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4#Allow_to_display_each_part_of_a_data_label_in_a_separate_line Screen Shots] | ||
[http://www.openoffice.org/issues/show_bug.cgi?id=82051 82051] | [http://www.openoffice.org/issues/show_bug.cgi?id=82051 82051] | ||
| − | |||
[http://specs.openoffice.org/chart/ChartDataLabels.odt Spec] | [http://specs.openoffice.org/chart/ChartDataLabels.odt Spec] | ||
|- | |- | ||
| − | | | + | | Data labels: more flexible placement of labels |
| It is now possible to manipulate the placement of the data point labels relative to the data point. For example for symbol charts the labels can be placed above, below, left, right or centered on the symbol. | | It is now possible to manipulate the placement of the data point labels relative to the data point. For example for symbol charts the labels can be placed above, below, left, right or centered on the symbol. | ||
| − | | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4 Screen Shots] | + | | [http://www.oooninja.com/2008/03/data-label-options-calc-chart.html Article] |
| + | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4#More_flexible_placement_of_labels_on_data_points Screen Shots] | ||
[http://www.openoffice.org/issues/show_bug.cgi?id=63857 63857] | [http://www.openoffice.org/issues/show_bug.cgi?id=63857 63857] | ||
| − | |||
[http://specs.openoffice.org/chart/ChartDataLabels.odt Spec] | [http://specs.openoffice.org/chart/ChartDataLabels.odt Spec] | ||
|- | |- | ||
| − | | | + | | Labels on pie segments: avoiding overlapping |
| There is an automatism now which tries to avoid the overlapping of data point labels on pie charts. | | There is an automatism now which tries to avoid the overlapping of data point labels on pie charts. | ||
| − | | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4 Screen Shots] | + | | [http://www.oooninja.com/2008/03/data-label-options-calc-chart.html Article] |
| + | [http://wiki.services.openoffice.org/wiki/Chart2/Features2.4#Display_bars_on_different_axes_next_to_each_other Screen Shots] | ||
[http://www.openoffice.org/issues/show_bug.cgi?id=4039 4039] | [http://www.openoffice.org/issues/show_bug.cgi?id=4039 4039] | ||
| − | |||
[http://specs.openoffice.org/chart/ChartDataLabels.odt Spec] | [http://specs.openoffice.org/chart/ChartDataLabels.odt Spec] | ||
|- | |- | ||
| − | | | + | | Data point labels can be removed |
| − | | It is now possible to remove selected data point labels with pressing the delete key. | + | | It is now possible to remove selected data point labels with pressing the delete key or using the mouse. |
| − | | [http:// | + | | [http://www.oooninja.com/2008/03/data-label-options-calc-chart.html Article] |
[http://www.openoffice.org/issues/show_bug.cgi?id=83344 83344] | [http://www.openoffice.org/issues/show_bug.cgi?id=83344 83344] | ||
| − | |||
|} | |} | ||
| Line 421: | Line 468: | ||
|- | |- | ||
| − | | | + | | Navigation (tab) order of page objects |
| − | | | + | | When a shape is selected, the Tab-key brings the focus to the next object. Now the navigation (tab) order of the shapes can be set with drag and drop in the Navigator. Before, the tab order always was dependent on the paint order. |
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=68097 68097] | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=68097 68097] |
| + | [http://specs.openoffice.org/draw/NavOrder.odt Spec] | ||
|- | |- | ||
| − | | Reduce complexity: | + | | PDF exported: page names as bookmark |
| − | | | + | | When exporting to PDF, you can now able choose to make bookmarks of the names of the pages in a draw document. |
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=80528 80528] | + | | [http://www.oooninja.com/2008/02/export-page-names-as-pdf-bookmarks.html Article] |
| + | [http://www.openoffice.org/issues/show_bug.cgi?id=40318 40318] | ||
| + | |- | ||
| + | | Reduce complexity: no longer necessary display options removed | ||
| + | | Some no longer necessary display options are removed. These options were needed in very early office versions, but already were switched off in the configuration for some time. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=80528 80528] | ||
| + | [http://www.openoffice.org/nonav/issues/showattachment.cgi/49524/ReCo.odt Spec] | ||
|} | |} | ||
| Line 439: | Line 493: | ||
! Specs/Issue | ! Specs/Issue | ||
|- | |- | ||
| − | | | + | | Navigation (tab) order of page objects |
| − | | Transition is an animation where one page is visible in the beginning and another in the end. It is used during presentation slideshow to switch pages. OpenOffice.org 2.4 makes it possible to use an extension to show these 3D transitions, and when OpenOffice.org 2.4 is released, this extension will be available. | + | | When a shape is selected, the Tab-key brings the focus to the next object. Now the navigation (tab) order of the shapes can be set with drag and drop in the Navigator. Before, the tab order always was dependent on the paint order. |
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=68097 68097] | ||
| + | [http://specs.openoffice.org/draw/NavOrder.odt Spec] | ||
| + | |- | ||
| + | | Slide transitions: thrilling 3D effects | ||
| + | | Transition is an animation where one page is visible in the beginning and another in the end. It is used during presentation slideshow to switch pages. OpenOffice.org 2.4 makes it possible to use an extension (using OpenGL) to show these 3D transitions, and when OpenOffice.org 2.4 is released, this extension will be available. | ||
| [http://www.oooninja.com/2008/02/eye-candy-3d-opengl-transitions-impress.html Article] | | [http://www.oooninja.com/2008/02/eye-candy-3d-opengl-transitions-impress.html Article] | ||
[http://qa.openoffice.org/issues/show_bug.cgi?id=82460 82460] | [http://qa.openoffice.org/issues/show_bug.cgi?id=82460 82460] | ||
|- | |- | ||
| − | | | + | | PDF exported: slide names as bookmark |
| − | | The PDF export filter is able | + | | The PDF export filter is now able make bookmarks of the names of the slides in a presentation |
| [http://www.oooninja.com/2008/02/export-page-names-as-pdf-bookmarks.html Article] | | [http://www.oooninja.com/2008/02/export-page-names-as-pdf-bookmarks.html Article] | ||
[http://www.openoffice.org/issues/show_bug.cgi?id=40318 40318] | [http://www.openoffice.org/issues/show_bug.cgi?id=40318 40318] | ||
| − | |||
|- | |- | ||
| − | | insert | + | | Background picture: easier to insert |
| − | | | + | | Now choosing a picture file and set it as the background of a slide is in the context menu of a slide. This is much easier that how this had to be done previously. |
| [http://www.openoffice.org/issues/show_bug.cgi?id=82911 82911] | | [http://www.openoffice.org/issues/show_bug.cgi?id=82911 82911] | ||
| − | |||
[http://specs.openoffice.org/impress/sd.insertbackground.odt Spec] | [http://specs.openoffice.org/impress/sd.insertbackground.odt Spec] | ||
|} | |} | ||
| Line 467: | Line 524: | ||
|- | |- | ||
| − | | Selecting rectangular region of text | + | | Selecting rectangular region of text |
| The selection mode "block selection" allows the selection of text inside a rectangular region. Start this by holding down Alt while dragging, or start mode "block selection" with the control on the status bar. | | The selection mode "block selection" allows the selection of text inside a rectangular region. Start this by holding down Alt while dragging, or start mode "block selection" with the control on the status bar. | ||
| [http://www.oooninja.com/2007/12/block-selection-mode-new-feature.html Article] | | [http://www.oooninja.com/2007/12/block-selection-mode-new-feature.html Article] | ||
| − | [http://www.openoffice.org/issues/show_bug.cgi?id=1596 1596 | + | [http://www.openoffice.org/issues/show_bug.cgi?id=1596 1596] [http://specs.openoffice.org/writer/selection_enhancement/Block_Selection_of_Text Spec] |
|- | |- | ||
| − | | Find & Replace | + | | Find & Replace: backward references in regular expressions |
| Find & Replace now can substitute regular expression subexpression in replace. "$n" references the nth subexpression of the found string, n >= 0, n<=9. With "$0" the whole found string can be referenced. | | Find & Replace now can substitute regular expression subexpression in replace. "$n" references the nth subexpression of the found string, n >= 0, n<=9. With "$0" the whole found string can be referenced. | ||
| [http://www.oooninja.com/2007/12/backreferences-in-replacements-new.html Article] | | [http://www.oooninja.com/2007/12/backreferences-in-replacements-new.html Article] | ||
| − | [http://www.openoffice.org/issues/show_bug.cgi?id=15666 15666] | + | [http://www.openoffice.org/issues/show_bug.cgi?id=15666 15666] |
| + | [http://specs.openoffice.org/appwide/find_and_replace/Regular_Expressions.odt Spec] | ||
|- | |- | ||
| − | | | + | | Spell checking: easier selecting of the language |
| A new control in the status bar of Writer is introduced to show the language at the current cursor position/selection. Furthermore the entire document language can be changed. | | A new control in the status bar of Writer is introduced to show the language at the current cursor position/selection. Furthermore the entire document language can be changed. | ||
The same possibilities are now found in the menu Tools>Language. | The same possibilities are now found in the menu Tools>Language. | ||
| − | | [http://www.oooninja.com/2008/02/set-select-language-spell-check-switch.html Article] [http://qa.openoffice.org/issues/show_bug.cgi?id=1034 1034] [http://www.openoffice.org/issues/show_bug.cgi?id=77208 77208 | + | | [http://www.oooninja.com/2008/02/set-select-language-spell-check-switch.html Article] [http://qa.openoffice.org/issues/show_bug.cgi?id=1034 1034] [http://www.openoffice.org/issues/show_bug.cgi?id=77208 77208] [http://specs.openoffice.org/appwide/linguistic/Set_Language_Attribute_for_Text.odt Spec.] |
|- | |- | ||
| Insert&Insert Object toolbar redesign - Writer | | Insert&Insert Object toolbar redesign - Writer | ||
| Toolbars for Insert&Insert Object have been changed. Choices no longer needed, are removed. | | Toolbars for Insert&Insert Object have been changed. Choices no longer needed, are removed. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=73117 73117 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=73117 73117] [http://specs.openoffice.org/appwide/toolbars/Toolbar_content_spec.odt Spec] |
|- | |- | ||
| − | | Printing of hidden text can be turned on | + | | Printing of hidden text can be turned on |
| Printing of hidden text (hidden paragraph field, hidden text field, hidden characters) is now possible. It is controlled via settings in Tools>Options>Writer>Print. | | Printing of hidden text (hidden paragraph field, hidden text field, hidden characters) is now possible. It is controlled via settings in Tools>Options>Writer>Print. | ||
Or just for print command via File>Print>Options. | Or just for print command via File>Print>Options. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=81434 81434 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=81434 81434] [http://specs.openoffice.org/writer/printing/Print_Hidden_Text.odt Spec] |
|- | |- | ||
| − | | Printing text | + | | Printing text place holders can be turned off |
| It is no longer that text placeholders are always printed out. It can controlled via settings in Tools>Options>Writer>Print. | | It is no longer that text placeholders are always printed out. It can controlled via settings in Tools>Options>Writer>Print. | ||
Or just for print command via File>Print>Options. | Or just for print command via File>Print>Options. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=81434 81434 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=81434 81434] [http://specs.openoffice.org/writer/printing/Print_Hidden_Text.odt Spec] |
|- | |- | ||
| Shortcuts added for paragraph style Heading 4, Heading 5 and Textbody | | Shortcuts added for paragraph style Heading 4, Heading 5 and Textbody | ||
| The following shortcuts to apply paragraph styles have been added: ctrl+4 => Heading 4; ctrl+5 => Heading 5 (current shortcut for 1 1/2 will be dropped); ctrl+0 => Textbody; ctrl+shift+0 -> Default | | The following shortcuts to apply paragraph styles have been added: ctrl+4 => Heading 4; ctrl+5 => Heading 5 (current shortcut for 1 1/2 will be dropped); ctrl+0 => Textbody; ctrl+shift+0 -> Default | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=81514 81514 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=81514 81514] [http://specs.openoffice.org/appwide/keyboard/assign_keyboard_shortcuts_to_styles.sxw Spec] |
|- | |- | ||
| − | | Ctrl-click | + | | Ctrl-click behaviour for hyperlinks can be changed |
| By default, hyperlinks in Writer are activated by holding down the Control key while clicking. | | By default, hyperlinks in Writer are activated by holding down the Control key while clicking. | ||
| − | This can be turned off via Tools>Options>OpenOffice.org>Security ...>Options, Security options, | + | This can be turned off via Tools>Options>OpenOffice.org>Security ...>Options, Security options, "Ctrl-click required to follow hyperlinks". |
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=83402 83402 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=83402 83402] [http://specs.openoffice.org/appwide/security/Electronic_Signatures_and_Security.sxw Spec] |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- | |- | ||
| − | | | + | | Custom document properties: Text fields and UI support |
| − | | | + | | In OOo 2.4.0 user interface support and text fields are added for custom document properties. Since OOo 2.0.3 the Word document variables (custom document properties) were imported. Further enhancements expected. |
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id= | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=5091 5091] [http://blogs.sun.com/GullFOSS/entry/custom_properties_and_fields blog] |
|} | |} | ||
| Line 531: | Line 578: | ||
! Specs/Issue | ! Specs/Issue | ||
| + | |- | ||
| + | | Extensible Help System for extensions | ||
| + | | Now help content inside extensions is supported. Extension help content is provided together with the OpenOffice.org installed help content. It's also possible to extend the help index. The implementation supports extended tool tips and accessing extension help content by pressing F1 in UNO dialogs and menus. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=20164 20164] [http://specs.openoffice.org/appwide/help/ExtensibleHelp.odt Spec] | ||
| + | |- | ||
| + | | Extensions can have a separate display name | ||
| + | | An extension may have a display name, shown in the Tools>Extensions Manager dialog. It can be localized. If no display name is provided then the file name of Extension will be displayed. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=81326 81326] [http://specs.openoffice.org/appwide/packagemanager/packagemanager_gui_spec.sxw Spec] | ||
| + | |-http://wiki.services.openoffice.org/mwiki/index.php?title=New_Features_2.4&action=edit§ion=14 | ||
| + | |- | ||
| + | | Extensions: support of web based update | ||
| + | | The Extension Manager online update feature now also supports web-based updates. The Update Extensions dialog shows available updates which one can only obtain through a particular website and which the Extension Manager cannot automatically download. When the user installs the updates, web browser will be started which navigate to the websites where the user can manually download the update. | ||
| + | | [http://blogs.sun.com/GullFOSS/entry/improvements_for_updating_extensions_in Article] | ||
| + | [http://www.openoffice.org/issues/show_bug.cgi?id=82775 82775] [http://specs.openoffice.org/appwide/packagemanager/online_update_for_extensions.odt Spec] | ||
| + | |- | ||
| + | | Extensions: additional information about the publisher and release notes | ||
| + | | It is now possible to see additional information for an available update of an extension in the Update Extensions dialog (Extension Manager dialog -> button Updates). This is first the name of the publisher and second a link to the release notes. Also the publisher name is a link. Clicking on these links will open an browser and navigate to the respective web sites. | ||
| + | | [http://blogs.sun.com/GullFOSS/entry/improvements_for_updating_extensions_in Article] | ||
| + | [http://www.openoffice.org/issues/show_bug.cgi?id=81502 81502] [http://specs.openoffice.org/appwide/packagemanager/online_update_for_extensions.odt Spec] | ||
| + | |- | ||
| + | | Extensions: check for updates | ||
| + | | When the office is configured to check for office updates automatically, the office will look for updates for the installed extensions, too. When any updates are found, the user will be notified via the menu bar about these updates. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=82851 82851] [http://specs.openoffice.org/appwide/onlineupdate/Online_Update_Notification_of_Extensions.odt Spec] | ||
| + | |- | ||
| + | | Dialogs can have a wallpaper set | ||
| + | | A new property for dialogs and tab pages is added, for an image URL which is used to display as a background image. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=83238 83238] [http://wiki.services.openoffice.org/wiki/Framework/Specification/Background_Bitmap_For_Dialogs_And_Tabs Spec] | ||
| + | |- | ||
| + | | Transparent background for controls | ||
| + | | A transparent for background of controls, e.g. for Labels, is now a property that can be set over the toollkit. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=83237 83237] | ||
| + | |- | ||
| + | | Remote control presentations via API | ||
| + | | API added for remote control of presentations, e.g. to advance to next slide and go back to previous slide, from an other application. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=15900 15900] | ||
| + | |- | ||
| + | | API: get selected table(s) or query(s) in the main Base window | ||
| + | | The ability is added (by supporting of com.sun.star.view.XSelectionSupplier interface) to find which table(s) or query(s) are currently selected in the main Base window. | ||
| + | | [http://www.openoffice.org/issues/show_bug.cgi?id=69740 69740] | ||
|- | |- | ||
| stoc library merge | | stoc library merge | ||
| Those various small UNO component libraries from stoc that are relevant at OOo startup (implreg.uno.so, nestedreg.uno.so, regtypeprov.uno.so, security.uno.so, servicemgr.uno.so, shlibloader.uno.so, simplereg.uno.so, typeconverter.uno.so, typemgr.uno.so, uriproc.uno.so) have been merged into two new larger bootstrap.uno.so (for those components that are used during binary UNO bootstrap and need UNO type information in a format independent of types.rdb) and stocservices.uno.so (for the rest). Client code should not be affected by this change. | | Those various small UNO component libraries from stoc that are relevant at OOo startup (implreg.uno.so, nestedreg.uno.so, regtypeprov.uno.so, security.uno.so, servicemgr.uno.so, shlibloader.uno.so, simplereg.uno.so, typeconverter.uno.so, typemgr.uno.so, uriproc.uno.so) have been merged into two new larger bootstrap.uno.so (for those components that are used during binary UNO bootstrap and need UNO type information in a format independent of types.rdb) and stocservices.uno.so (for the rest). Client code should not be affected by this change. | ||
| − | | [http://www.openoffice.org/issues/show_bug.cgi?id=77885 77885 | + | | [http://www.openoffice.org/issues/show_bug.cgi?id=77885 77885] |
|} | |} | ||
Latest revision as of 19:00, 30 April 2008
Category:Draft marketing ideas and materials
Draft marketing documents index
New Features in OpenOffice.org 2.4
Note - this list is based on the full list in Feature_Freeze_Testing_2.4 Full list is available below.
General
- Connect to WebDAV servers via HTTPS
- Custom icons for toolbars are imported
- Control password-storing with a master password
- Warning if document is from a newer ODF
- PDF documents: relative links, document references, PDF/A-1 (ISO 19005-1) supported, and cross-document link behavior options
- Mac OS X (Aqua Development version): Quicktime support for movies and sound / use the built in spell checker
- Print dialog improvements in usability
- Edit boxes: warning at limit of characters
- DejaVu font is now default instead of BitStream Vera
Localisation
- Entries for 10 languages added
Base / DBA
- Improved rendering of numeric(n) data from JDBC and Oracle
- Easier choice of table name in "Copy table"
- Editing of views in HSQLDB
- Query designer for all properties which allow SQL command
- Query designer in SQL view
- Relation design accessible for MySQL databases
- Setting to check for required fields on forms
- Support for Access 2007 (.accdb files)
Calc
- Convert text to columns: with this feature CSV data inside cells can be transformed into columns directly
- Columns and rows in spreadsheet can be moved with drag and drop
- Enter key returns to the column where the input started, one row below
- Formula input: "+" and "-" can also be used to start
- Individual zoom level per sheet
- AutoFilter: choices clearer grouped and based on result of filtering in other columns
- DataPilot: Manual Sorting / Double-click in DataPilot cell provides calculation data of that cell
- Performance improvement with functions VLOOKUP and MATCH
- Print dialog for Calc easier to use
- PageUp and PageDown keys work in print preview
- Sheet names in cell-hyperlinks: renamed properly
Chart
- Regression curves: show equations and R² value
- Reverse axes possible
- Bars on different axes displayed next to each other
- Data labels: Number format
- Data point label: display both value and percentage
- Data label: display each part in a separate line
- Data labels: more flexible placement of labels
- Labels on pie segments: avoiding overlapping
- Data point label: can be removed with delete key
Draw
- Navigation (tab) order of page objects
- PDF export: page names as bookmark
- Reduce complexity: no longer necessary display options removed
Impress
- Navigation (tab) order of page objects
- Thrilling 3D effects in slide transitions
- Export slide names as PDF bookmarks
- Easier to insert background picture
Writer
- Selecting rectangular region of text
- Find and Replace: backward references in regular expressions
- Spell checking: easier selecting of the language
- Insert&Insert Object toolbar redesign - Writer
- Printing of hidden text can be turned on
- Printing text place holders can be turned off
- Shortcuts added for paragraph style Heading 4, Heading 5 and Textbody
- Ctrl-click behaviour for hyperlinks can be changed
- Custom document properties: Text fields and UI support
Extensions/ programmability / API
- Extensible Help System for extensions
- Extensions can have a separate display name
- Extensions: support of web based update
- Extensions: additional information about the publisher and release notes
- Extensions: check for updates
- Dialogs can have a wallpaper set
- Transparent background for controls
- Remote control presentations via API
- API: get selected table(s) or query(s) in the main Base window
Blogs & Screen Shots
Blogs
- "OOo 2.4 localisation"
- "New Chart features in OpenOffice.org 2.4"
- "OpenOffice.org 2.4 features implemented in cooperation with the RedFlag 2000 framework team"
- "Last Feature Release on OpenOffice.org 2.x"
- New Features in OpenOffice.org 2.4
Screen Shots
Print Hidden Text
Language Selector
PDF/A Export
Chart: Equations for regression curves
Chart: Reverse axes
Chart: Display bars on different axes next to each other
Chart: Number format for data labels
Chart: Display both in the data point label: value and percentage
Chart: Allow to display each part of a data label in a separate line
Chart: More flexible placement of labels on data points
Chart: Automatic positions for labels on pie segments
Persistent Icon List
Enhanced tooltip for "Print Directly" toolbar button
Release notes
Known issues
| Function | Description | Issue |
|---|---|---|
| ... | ... | ... |
See list of regressions found in OpenOffice.org version 2.4.0.
Full list
General
| Feature | Description | Specs/Issue |
|---|---|---|
| Connect WebDAV servers via HTTPS | OOo is now able to connect WebDAV servers via HTTPS. | 31053 Spec |
| Custom icons for toolbars imported | Icons can be imported for toolbars (Tools>Customize>Toolbars...>Modify>Change icon). Now those are stored persistently into a user-icon list. Icons for import shall be in PNG format and shall have a size of 16x16 or 26 by 26 pixel. The dialog has new buttons for Import and Delete. | 73357 Spec |
| ODF in the names of the file types | The 'ODF' abbreviation replaces the 'OpenDocument' description of file types. | 80206 Spec |
| Master password/ password configuration | The security tab in the Tools>Options dialog contains now possibility to control password-storing ( the passwords for specific URL-sites could be stored there ). By default the storing is not allowed. | 82892 Spec |
| Warning if document is from a newer ODF version | If a file is opened, that is written in a newer ODF version, than supported by the installed OpenOffice.org (i.e. ODF 1.2 versus ODF 1.1) a new dialog is shown. This dialog informs about online update to a newer version of OOo. | 83653 Spec |
| Relative links can be created in PDF documents | When exporting to PDF, links in those documents can be made relative on request. Thus for example, some related PDF-documents can link to each other. The PDF Options dialog has a new tab page: Links. | Article |
| Document references can be converted in PDF targets | When exporting a PDF, this option changes ODF-extensions (such as .odt, .ods, and .odp) to .pdf. Of course this is useful with the feature of the relative links, and it can be found at the same place: File>Export to PDF ..>Links | Article |
| PDF/A (ISO 19005-1) supported | When exporting a document to PDF, the PDF Options dialog offers export to PDF/A-1a. PDF/A-1a is ISO 19005-1:2005 International Standard. | Article |
| Mac OS X: Quicktime support for movies and sound | The Mac OS X native used Quicktime player is now supported by OpenOffice.org. | 82234 Spec |
| Mac OS X: use the built in spell checker | Mac OS X has a built in spell checking facility in many languages. Thus the user can maintain a single word list across all applications. Now these spellcheck services are integrated into the existing OpenOffice.org user interface. | 77592 Spec. |
| Print dialog: cursor on field 'number of copies' | The print dialog in all OOo modules (Ctrl-P or File>Print) now starts with the focus on the 'number of copies' the user would like to print. This often saves tabbing or clicking. | 9521 |
| Print dialog: 'Sort' option default | In the Print dialog the 'Sort' option is defaulted to on. This makes it easier to print multiple copies of a document. | 82071 |
| Warning when limit of characters reached for edit boxes | If an edit box (such as text box or combo box and others) reaches the limit of characters, a message box warns that the text is truncated. (The limit of characters can either be set for the control, or be the maximum count (65535) of characters possible in such controls.) | 73360 |
| AutoCaption format localisable | Now the AutoCaption format (figures, tables) is localisable. In some languages, the number has to be placed before the word "figure", for example. | 61007 |
| DejaVu font is now default in stead of BitStream Vera | DejaVu provides a wider range of characters, suitable for more languages/localizations. | 59853 |
Localisation
| Feature | Description | Specs/Issue |
|---|---|---|
| Serbia and Montenegro | Disentangled the Serbia and Montenegro locales | 71789 |
| Add locales of available dictionaries to language list box | New language list box entries available for font attribution: "Nyanja" [= ny-MW], "Kashubian" [= csb-PL], "Spanish (Cuba)" [= es-CU], "Tetun" [= tet-ID] | 76233 |
| Venezuela (es_VE): currency | From 2008-01-01 the Bolivar Fuerte, VEF, is the new currency for Venezuela. In OpenOffice.org 2.4 it will be the default currency for the es-VE locale. | 78601 |
| Farsi/Persian: numbering support | Added support of Farsi/Persian native numbering and alphabetic outline numbering, the latter appearing in Writer under Format -> Bullets and Numbering -> Options -> Numbering list box. It is not available in the preset numbering types or outlines yet. Native numbering is available through the number formatter for format codes using the [NatNum1] modifier. | 79797 |
| Bolivia, Quechua: added to language list box | New language list box entries available for character attribution: "Quechua (Bolivia, North)" [= qul-BO], "Quechua (Bolivia, South)" [= quh-BO] | 80114 |
| Low German (nds-DE): added to language list box. | New language list box entry available for character attribution: "Low German" [= nds-DE] | 80432 |
| Hiligaynon (hil_PH): added to language list box | Added a new language list box entry and locale data for Hiligaynon_Philippines (hil_PH), available for character attribution, number formats and as default document language. | 82723 |
| Sámi languages: added to language list box | Various Sami entries added to the language list box. These are available for character attribution and spell-checking: ... | 82927 ] |
| Somali (so_SO): added to language list box | Added a new language list box entry and locale data for Somali_Somalia (so_SO), available for character attribution, number formats and as default document language. | 83369 |
Base / DBA
| Feature | Description | Specs/Issue |
|---|---|---|
| Improved rendering of numeric(n) data from jdbc/oracle | The Advanced Settings dialog now has a property to disable the currency return value from the ResultSetMetaData. Thus numeric data can be rendered as number, in stead of (always) as currency. | 11746 |
| Easier choice of table name in "Copy table" | Now when you paste table-like data to OOo Base, with a table object selected, this table's existing name, along with the option "Append data", is pre-selected in the "Copy Table" wizard. | 18907 |
| Editing of views in HSQLDB | From OOo 2.4.0 it is possibe to edit a view's design (underlying statement) in embedded HSQL databases. | 49183 |
| Query designer for all properties which allow SQL command | From the property browser it is possible to invoke the query designer not only for the "Content" property of a database form (if it's content type is "SQL command"), but also for the list content of a list box control (or grid column), if its list content type is "SQL". The SQL command which you design in the query designer will, when saving it, be set as the respective property at the list box. | 66624 |
| Query designer in SQL view | From within the property browser for a database form, you can open the query designer, to graphically design the SQL command underlying the form. ... | 77492 |
| Relation design for MySQL databases | The relation design is now accessible for MySQL databases as well | 68858 |
| API: get selected table(s) or query(s) in the main Base window | The ability is added (by supporting of com.sun.star.view.XSelectionSupplier interface) to find which table(s) or query(s) are currently selected in the main Base window. | 69740 |
| Setting to check for required fields on forms | Now for databases, there exists a per-database setting which controls whether forms check for required fields when entering data. | 80930 |
| Support for Access 2007 (accdb) | The new file format for MS Access 2007 (accdb files) is now also supported by the OpenOffice.org Base. When creating a new database, one can now select "MS Access 2007" as type to connect to. | 81043 |
Calc
| Feature | Description | Specs/Issue |
|---|---|---|
| Convert text to columns | With this feature CSV data inside cells can be transformed into columns directly. It uses the already existing Text import dialog and transforms CSV data inside cells into multiple columns. Example: A1 holds '1,2,3,4". After using this feature, 1, 2, 3 and 4 are split over cells.
Start this feature with the menu Data>Text to Columns. |
Article |
| Cells in spreadsheet can be moved, copied, or linked | Select one or more columns or rows, or a range of cells, and hold down Alt while moving the selection with the mouse. When the mouse button is released, other cells/columns/rows are moved left or down, to insert the selection. Before this feature, target cells always were overwritten. | Article |
| Enter key returns to the column where the input started, one row below | Entering data row wise is made easier. The Enter 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. | Video |
| Formula input: "+" and "-" can also be used to start | 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. | 20496 |
| Individual zoom level per sheet | Each sheet in a spreadsheet document can now have its own zoom level. | 24372 |
| AutoFilter: choices clearer grouped and based on result of filtering in other columns | 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. Two things are new: there is a clearer grouping of static filter choices. And if in one column a filter is set, the filters in the other columns only show the options that are available in the visible rows. | 27745 |
| DataPilot: Manual Sorting | It's now possible to rearrange items in a DataPilot field via Drag&Drop or Copy&Paste. The default sorting for new tables is "Ascending", it is changed to "Manual" when items are moved. | 32307 |
| Double-click in Datapilot cell provides calculation data of that cell | When a cell within the data field is double-clicked, it inserts a new sheet containing a subset of rows from the original data source that constitutes the result data displayed in that cell. For instance, when the data field function is selected to be SUM, then the number that is shown in the data field cell must be identical to the sum of all the data field values in the constituent rows displayed in the inserted sheet. | 57030 |
| Performance improvement with functions VLOOKUP and MATCH | Spreadsheet functions VLOOKUP and MATCH results are used by OpenOffice.org to make these functions in the same row perform faster. | 81336 |
| Print dialog for Calc easier to use | The Print dialog in Calc makes it easier to choose what part of the spreadsheet has to be printed. The option 'print only selected sheets' is now on that dialog.
Furthermore the 'Sort' option is defaulted to on. This makes it easier to print multiple copies of a document. |
82071 |
| Print preview: PageUp and PageDown keys work | From 2.4.0 PgUp/PgDn scroll continuously through the print preview. Ctrl + PgUp/PgDn scroll to top of next/previous page. | 7269 |
| Sheet names in cell-hyperlinks: renamed properly | Now sheet names in cell-hyperlinks are renamed properly. This also corrects the import from Excel with cell references to other sheets. | 81154 |
Chart
| Feature | Description | Specs/Issue |
|---|---|---|
| Regression curves: show equations and R² value | The equation of trend lines and the R² value now can be displayed in the chart. | Article |
| Reverse axes | It is possible now to change the direction of axes. Thus the user can choose where the lower values and where the higher values are displayed at an axis. | Article |
| Different axes: bars displayed next to each other | In bar charts with two y axes it is now also possible to display all the bars next to each other, thus they don't hide each other anymore. | Article |
| Data labels: Number format | For data labels in charts it is now possible to choose a number format for the display of values and percentage values. Thus the precision of the displayed values can be changed for example. | Article |
| Data point label: display both value and percentage | For data labels in charts it is now possible to display the value and the percentage value at the same time. | Article |
| Data label: display each part in a separate line | The different parts of a data label now can be displayed in separate lines. | Article |
| Data labels: more flexible placement of labels | It is now possible to manipulate the placement of the data point labels relative to the data point. For example for symbol charts the labels can be placed above, below, left, right or centered on the symbol. | Article |
| Labels on pie segments: avoiding overlapping | There is an automatism now which tries to avoid the overlapping of data point labels on pie charts. | Article |
| Data point labels can be removed | It is now possible to remove selected data point labels with pressing the delete key or using the mouse. | Article |
Draw
| Feature | Description | Specs/Issue |
|---|---|---|
| Navigation (tab) order of page objects | When a shape is selected, the Tab-key brings the focus to the next object. Now the navigation (tab) order of the shapes can be set with drag and drop in the Navigator. Before, the tab order always was dependent on the paint order. | 68097 |
| PDF exported: page names as bookmark | When exporting to PDF, you can now able choose to make bookmarks of the names of the pages in a draw document. | Article |
| Reduce complexity: no longer necessary display options removed | Some no longer necessary display options are removed. These options were needed in very early office versions, but already were switched off in the configuration for some time. | 80528 |
Impress
| Feature | Description | Specs/Issue |
|---|---|---|
| Navigation (tab) order of page objects | When a shape is selected, the Tab-key brings the focus to the next object. Now the navigation (tab) order of the shapes can be set with drag and drop in the Navigator. Before, the tab order always was dependent on the paint order. | 68097 |
| Slide transitions: thrilling 3D effects | Transition is an animation where one page is visible in the beginning and another in the end. It is used during presentation slideshow to switch pages. OpenOffice.org 2.4 makes it possible to use an extension (using OpenGL) to show these 3D transitions, and when OpenOffice.org 2.4 is released, this extension will be available. | Article |
| PDF exported: slide names as bookmark | The PDF export filter is now able make bookmarks of the names of the slides in a presentation | Article |
| Background picture: easier to insert | Now choosing a picture file and set it as the background of a slide is in the context menu of a slide. This is much easier that how this had to be done previously. | 82911 |
Writer
| Feature | Description | Specs/Issue |
|---|---|---|
| Selecting rectangular region of text | The selection mode "block selection" allows the selection of text inside a rectangular region. Start this by holding down Alt while dragging, or start mode "block selection" with the control on the status bar. | Article |
| Find & Replace: backward references in regular expressions | Find & Replace now can substitute regular expression subexpression in replace. "$n" references the nth subexpression of the found string, n >= 0, n<=9. With "$0" the whole found string can be referenced. | Article |
| Spell checking: easier selecting of the language | A new control in the status bar of Writer is introduced to show the language at the current cursor position/selection. Furthermore the entire document language can be changed.
The same possibilities are now found in the menu Tools>Language. |
Article 1034 77208 Spec. |
| Insert&Insert Object toolbar redesign - Writer | Toolbars for Insert&Insert Object have been changed. Choices no longer needed, are removed. | 73117 Spec |
| Printing of hidden text can be turned on | Printing of hidden text (hidden paragraph field, hidden text field, hidden characters) is now possible. It is controlled via settings in Tools>Options>Writer>Print.
Or just for print command via File>Print>Options. |
81434 Spec |
| Printing text place holders can be turned off | It is no longer that text placeholders are always printed out. It can controlled via settings in Tools>Options>Writer>Print.
Or just for print command via File>Print>Options. |
81434 Spec |
| Shortcuts added for paragraph style Heading 4, Heading 5 and Textbody | The following shortcuts to apply paragraph styles have been added: ctrl+4 => Heading 4; ctrl+5 => Heading 5 (current shortcut for 1 1/2 will be dropped); ctrl+0 => Textbody; ctrl+shift+0 -> Default | 81514 Spec |
| Ctrl-click behaviour for hyperlinks can be changed | By default, hyperlinks in Writer are activated by holding down the Control key while clicking.
This can be turned off via Tools>Options>OpenOffice.org>Security ...>Options, Security options, "Ctrl-click required to follow hyperlinks". |
83402 Spec |
| Custom document properties: Text fields and UI support | In OOo 2.4.0 user interface support and text fields are added for custom document properties. Since OOo 2.0.3 the Word document variables (custom document properties) were imported. Further enhancements expected. | 5091 blog |
Extensions/ programmability / API
| Feature | Description | Specs/Issue |
|---|---|---|
| Extensible Help System for extensions | Now help content inside extensions is supported. Extension help content is provided together with the OpenOffice.org installed help content. It's also possible to extend the help index. The implementation supports extended tool tips and accessing extension help content by pressing F1 in UNO dialogs and menus. | 20164 Spec |
| Extensions can have a separate display name | An extension may have a display name, shown in the Tools>Extensions Manager dialog. It can be localized. If no display name is provided then the file name of Extension will be displayed. | 81326 Spec |
| Extensions: support of web based update | The Extension Manager online update feature now also supports web-based updates. The Update Extensions dialog shows available updates which one can only obtain through a particular website and which the Extension Manager cannot automatically download. When the user installs the updates, web browser will be started which navigate to the websites where the user can manually download the update. | Article |
| Extensions: additional information about the publisher and release notes | It is now possible to see additional information for an available update of an extension in the Update Extensions dialog (Extension Manager dialog -> button Updates). This is first the name of the publisher and second a link to the release notes. Also the publisher name is a link. Clicking on these links will open an browser and navigate to the respective web sites. | Article |
| Extensions: check for updates | When the office is configured to check for office updates automatically, the office will look for updates for the installed extensions, too. When any updates are found, the user will be notified via the menu bar about these updates. | 82851 Spec |
| Dialogs can have a wallpaper set | A new property for dialogs and tab pages is added, for an image URL which is used to display as a background image. | 83238 Spec |
| Transparent background for controls | A transparent for background of controls, e.g. for Labels, is now a property that can be set over the toollkit. | 83237 |
| Remote control presentations via API | API added for remote control of presentations, e.g. to advance to next slide and go back to previous slide, from an other application. | 15900 |
| API: get selected table(s) or query(s) in the main Base window | The ability is added (by supporting of com.sun.star.view.XSelectionSupplier interface) to find which table(s) or query(s) are currently selected in the main Base window. | 69740 |
| stoc library merge | Those various small UNO component libraries from stoc that are relevant at OOo startup (implreg.uno.so, nestedreg.uno.so, regtypeprov.uno.so, security.uno.so, servicemgr.uno.so, shlibloader.uno.so, simplereg.uno.so, typeconverter.uno.so, typemgr.uno.so, uriproc.uno.so) have been merged into two new larger bootstrap.uno.so (for those components that are used during binary UNO bootstrap and need UNO type information in a format independent of types.rdb) and stocservices.uno.so (for the rest). Client code should not be affected by this change. | 77885 |
Few of the bug Fixes
| Feature | Description | Specs/Issue |
|---|---|---|
| ??? | Table has no top border when over 2+ pages | 9860 |
| ??? | Fields from Endnote skipped during Word import in OOo 2 | 61075 |
| ??? | wrong cursor position when undoing "insert table row" | 18014 |
