Difference between revisions of "New Features 2.4"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(fix list of regressions)
 
(87 intermediate revisions by 6 users not shown)
Line 9: Line 9:
 
Full list is available below.
 
Full list is available below.
  
−
=== Chart ===
+
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
  
−
TBD
+
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)
  
−
=== Writer ===
+
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
  
−
TBD
+
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
  
−
=== Calc ===
+
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
  
−
TBD
+
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
  
−
=== Base ===
+
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]
  
−
TBD
+
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
  
−
=== Draw ===
+
== Blogs & Screen Shots ==
  
−
TBD
+
=== Blogs ===
  
−
=== Impress ===
+
<!-- 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. -->
  
−
TBD
+
* [http://blogs.sun.com/GullFOSS/entry/ooo_2_4_localisation "OOo 2.4 localisation"]
 +
* [http://blogs.sun.com/GullFOSS/entry/new_chart_features_in_openoffice "New Chart features in OpenOffice.org 2.4"]
 +
* [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://www.oooninja.com/2008/03/new-features-openofficeorg-240.html New Features in OpenOffice.org 2.4]
  
−
=== Language Support ===
+
=== Screen Shots ===
  
−
TBD
+
<gallery>
−
 
+
Image:ooo24rc1_prt_hidden_txt.jpg|Print Hidden Text
−
=== Extensions ===
+
Image:ooo24rc1_lang_sel.jpg|Language Selector
−
 
+
Image:ooo24rc1_pdfa.jpg|PDF/A Export
−
TBD
+
Image:Chart_OOo2.4_01.png|Chart: Equations for regression curves
−
 
+
Image:Chart_OOo2.4_02.png|Chart: Reverse axes
−
=== Other ===
+
Image:Chart_OOo2.4_03.png|Chart: Display bars on different axes next to each other
−
 
+
Image:Chart_OOo2.4_04.png|Chart: Number format for data labels
−
TBD
+
Image:Chart_OOo2.4_05b.png|Chart: Display both in the data point label: value and percentage
 +
Image:Chart_OOo2.4_06.png|Chart: Allow to display each part of a data label in a separate line
 +
Image:Chart_OOo2.4_07.png|Chart: More flexible placement of labels on data points
 +
Image:Chart_OOo2.4_08.png|Chart: Automatic positions for labels on pie segments
 +
Image:Ooo24rc1_change_icon.png|Persistent Icon List
 +
Image:Ooo24rc1_print_file_directly.png|Enhanced tooltip for "Print Directly" toolbar button
 +
</gallery>
  
 
== Release notes ==
 
== Release notes ==
Line 56: Line 131:
  
 
|-
 
|-
−
| TBD
+
| ...
−
| TBD
+
| ...
−
TBD
+
| ...
−
| [http://www.openoffice.org/issues/show_bug.cgi?id=12345 12345]
+
−
 
+
 
|}
 
|}
  
 
<br>
 
<br>
  
−
See list of [http://qa.openoffice.org/issues/buglist.cgi?Submit+query=Submit+query&version=OOo+2.3&version=OOo+2.3+RC2&version=OOo+2.3+RC3&version=OOo+2.3.0+RC1&email1=&emailtype1=exact&emailassigned_to1=1&email2=&emailtype2=exact&emailreporter2=1&issueidtype=include&issue_id=&changedin=&votes=&chfieldfrom=&chfieldto=Now&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&field0-0-0=noop&type0-0-0=noop&value0-0-0=&cmdtype=doit&order=Reuse+same+sort+as+last+time regressions found in OpenOffice.org version 2.3.0].
+
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 77: Line 150:
  
 
|-
 
|-
−
| Stylist filter selection persistent
+
| Connect WebDAV servers via HTTPS
−
| Now the selection of a stylist filter is persistent. On a new session, the last selected filter is active. One selection for every application.  
+
| OOo is now able to connect WebDAV servers via HTTPS.
−
| [http://www.openoffice.org/issues/show_bug.cgi?id=4854 4854]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=31053 31053] [http://specs.openoffice.org/appwide/fileIO/WebDAV_over_HTTPS.odt Spec]
−
 
+
 
|-
 
|-
−
| bgcolor="yellow" | Behavior of hyperlinks
+
| Custom icons for toolbars imported
−
| To follow a hyperlink, now on the most places Ctrl+click must be used.
+
| 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://specs.openoffice.org/appwide/hyperlinks/Behavior_of_Hyperlinks_in_OOo_Documents.odt specs]  
+
| [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]
−
 
+
 
|-
 
|-
−
| Dialog PDF Export
+
| ODF in the names of the file types
−
| The options dialog is now shown before the file dialog
+
| The 'ODF' abbreviation replaces the 'OpenDocument' description of file types.
−
| [http://specs.openoffice.org/appwide/pdf_export/PDFExport.sxw specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=13154 13154]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=80206 80206] [http://specs.openoffice.org/appwide/fileIO/FileFormatNames.sxw Spec]
−
 
+
 
|-
 
|-
−
| Shortcut for 'repeat'
+
| Master password/ password configuration
−
| Ctrl-Shift-Y is shortcut for the menu Edit>Repeat
+
| 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=41586 41586]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=82892 82892] [http://specs.openoffice.org/appwide/security/Electronic_Signatures_and_Security.sxw Spec]
−
 
+
 
|-
 
|-
−
| Configuration of behaviour with a line break
+
| Warning if document is from a newer ODF version
−
| Lines ending with manual line break can be set not to justify alignment This is a compatibility setting in Tools|Options|Writer |Compatibility
+
| 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://specs.openoffice.org/writer/compatibility/Compatability_Options.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=45491 45491]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=83653 83653] [http://specs.openoffice.org/appwide/onlineupdate/ODF_Online_Update_Trigger.odt Spec]
−
 
+
 
|-
 
|-
−
| Web HTML Preview
+
| Relative links can be created in PDF documents
−
| The new function "Preview Document in Web Browser" provides an easy way to display the current document as a html export in the system web browser.  
+
| 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://specs.openoffice.org/appwide/web_preview/Web_Preview_Specification.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=74477 74477]
+
| [http://www.oooninja.com/2008/02/create-relative-links-in-pdfs.html Article]
−
 
+
[http://www.openoffice.org/issues/show_bug.cgi?id=56629 56629]  
 
|-
 
|-
−
| Document stored printer setting may be ignored
+
| Document references can be converted in PDF targets
−
| There is a new setting that allows to ignore printer settings stored in the document. It is found in Tools|Options|Load/Save
+
| 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
−
| [http://specs.openoffice.org/appwide/printing/Load_printer_settings_with_document.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=76885 76885]
+
| [http://www.oooninja.com/2008/02/convert-document-references-pdf-targets.html Article]
−
 
+
 
|-
 
|-
−
| Macro Security Default Level to High
+
| PDF/A (ISO 19005-1) supported
−
| The default Macro Security Level changed from Medium to High. Thus it is impossible to execute malicious macros by accident by just clicking OK
+
| 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://specs.openoffice.org/appwide/security/Electronic_Signatures_and_Security.sxw  specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=79170 79170]
+
| [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#desc22 Spec]
 
|-
 
|-
−
| Easier branding of OOo builds
+
| Mac OS X: Quicktime support for movies and sound
−
| Easier branding of OOo builds for better support the creation of adapted OpenOffice.org installation sets
+
| The Mac OS X native used Quicktime player is now supported by OpenOffice.org.
−
| [http://tools.openoffice.org/servlets/ReadMsg?list=features&msgNo=28 announcm.] / [http://www.openoffice.org/issues/show_bug.cgi?id=66426 66426]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=82234 82234] [http://specs.openoffice.org/Mac_Port/System_Integration/macosx_quicktime.odt Spec]
−
 
+
 
|-
 
|-
−
| Location of file and other properties selectable
+
| Mac OS X: use the built in spell checker
−
| The location of the file and the other properties, in File|Properties>General, now can be selected an copied.
+
| 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=64785 64785]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=77592 77592] [http://specs.openoffice.org/appwide/linguistic/macosx_spellchecker.odt Spec.]
−
 
+
 
|-
 
|-
−
| Layout in Tools|Customize>Keyboard
+
| Print dialog: cursor on field 'number of copies'
−
| The layout in Tools|Customize>Keyboard has improved: so that there is more room for various list boxes.
+
| 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=75754 75754]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=9521 9521]  
−
 
+
 
|-
 
|-
−
| Online update - info
+
| Print dialog: 'Sort' option default
−
| Tools|Options|OpenOffice.org shows when was last checked for an update.
+
| 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=70315 70315]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=82071 82071]  
−
 
+
[http://specs.openoffice.org/appwide/printing/Print_Dialog.odt Spec]
 
|-
 
|-
−
| Online update - Direct download
+
| Warning when limit of characters reached for edit boxes
−
| On Windows it is possible to download direct from Online update, not on a website.
+
| 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://specs.openoffice.org/installation/online_update/Online_Update_Download_Installation.odt  specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=72386 72386]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=73360 73360]  
−
 
+
 
|-
 
|-
−
| Java GUI installation wizard on Linux
+
| AutoCaption format localisable
−
| The Java GUI installation wizard is included in installations with JRE for easier installation on Linux
+
| Now the AutoCaption format (figures, tables) is localisable. In some languages, the number has to be placed before the word "figure", for example.
−
| [http://installation.openoffice.org/Java_GUI_Installer.odt  specs]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=61007 61007]  
−
 
+
−
|-
+
−
| Identifiers for extensions
+
−
| Extensions now can have an unique identifier This removes the restriction that no two extensions can have the same filename
+
−
| [http://specs.openoffice.org/appwide/packagemanager/extensionidentifiers.odt  specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=69910 69910]
+
−
 
+
−
|-
+
−
| Options Dialog and Extensions
+
−
| Extensions can integrate options pages into the options dialogs of the different applications.
+
−
| [http://specs.openoffice.org/appwide/packagemanager/options_dialog_for_extensions.odt  specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=75869 75869]
+
−
 
+
−
|-
+
−
| Merging of toolbar and menu items in extensions
+
−
| Now it is possible to add, exchange or remove menu or toolbar items in extensions. Previously this was possible only for top-level menus and whole toolbars.
+
−
| [http://wiki.services.openoffice.org/wiki/Framework/WorkInProgress/Addon_Menu_Toolbar_Merging Wiki] / [http://www.openoffice.org/issues/show_bug.cgi?id=78020 78020]
+
−
 
+
−
|-
+
−
| "Get Extensions" link
+
−
| The dialog Extensions Managers now has the link "Get Extensions" to http://extensions.services.openoffice.org/
+
−
| [http://specs.openoffice.org/appwide/packagemanager/link_to_extensions_services_openoffice_org.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=78209 78209]
+
−
 
+
 
|-
 
|-
−
| FontOOo exits with an error message
+
| DejaVu font is now default in stead of BitStream Vera
−
| The Add Fonts from Web Wizard exits with an error message. This is fixed and the fix is in the issue.
+
| DejaVu provides a wider range of characters, suitable for more languages/localizations.
−
|[http://www.openoffice.org/issues/show_bug.cgi?id=81102 81102]
+
| [http://qa.openoffice.org/issues/show_bug.cgi?id=59853 59853]
 
|}
 
|}
  
Line 176: Line 218:
 
=== Localisation ===
 
=== Localisation ===
  
−
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
+
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
−
|-
+
! Feature
−
| Data for 12 new locales
+
! Description
−
| Added are data for:
+
! Specs/Issue
−
 
+
−
Hausa Ghana (ha_GH), Ewe language (ee_GH), Frisian Western (Netherlands), Tagalog_Philippines (tl_PH), Jewish (for en-US), Uzbek (uz_UZ), Occitan-languadocian's (oc_FR), Lingala (ln_CD), Sango – sg_CF, English Ghana (en_GH), Ganda Uganda (lg_UG), Armenian_Armenia (hy_AM)
+
−
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+
  
 
|-
 
|-
−
| Changes for two localisations
+
| Serbia and Montenegro
−
| Currency changed for Bolivar Fuerte and Ghana Cedi
+
| Disentangled the Serbia and Montenegro locales
−
| &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=71789 71789]
−
 
+
−
|}
+
−
 
+
−
<br>
+
−
 
+
−
=== Calc ===
+
−
{|  cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
+
 
|-
 
|-
−
| Default values print options
+
| Add locales of available dictionaries to language list box
−
| Now enabled by default are the options: print only selected sheets and suppress output of empty pages. This is shown in the print preview. A warning message is shown if nothing is to print.
+
| New language list box entries available for font attribution: "Nyanja" [= ny-MW], "Kashubian" [= csb-PL], "Spanish (Cuba)" [= es-CU], "Tetun" [= tet-ID]
−
| [http://blogs.sun.com/oootnt/entry/printing_spreadsheets Blog] / [http://www.openoffice.org/issues/show_bug.cgi?id=25278 25278], [http://www.openoffice.org/issues/show_bug.cgi?id=78488 78488]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=76233 76233]  
−
 
+
 
|-
 
|-
−
| Matrix/array constants in formulas
+
| Venezuela (es_VE): currency
−
| Calc now supports matrix/array constants in formulas
+
| 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]  
−
Supported by import/export Excel
+
−
| [http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=230 Announcm.] / [http://www.openoffice.org/issues/show_bug.cgi?id=32342 32342]
+
−
 
+
 
|-
 
|-
−
| Shortcurt dialog cell formatting
+
| Farsi/Persian: numbering support
−
| Shortcut key Ctrl-1 opens the dialog for cell formatting
+
| 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=35738 35738]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=79797 79797]  
−
 
+
 
|-
 
|-
−
| Shortcut keys insert/delete cells
+
| Bolivia, Quechua: added to language list box
−
| Ctrl+ works for inserting and Ctrl- for deleting cells. Both work like the menu entries and can function for rows and columns also.
+
| 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=38108 38108]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=80114 80114]  
−
 
+
 
|-
 
|-
−
| Shortcut keys show formulas
+
| Low German (nds-DE): added to language list box.
−
| The shortcut key Ctrl~ toggles between formula result and formula For all cells on a sheet. (English keyboard layouts only.)
+
| New language list box entry available for character attribution: "Low German" [= nds-DE]
−
| [http://www.openoffice.org/issues/show_bug.cgi?id=56202 56202]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=80432 80432]  
−
 
+
 
|-
 
|-
−
| Value of function GETPIVOTDATA in cell formula
+
| Hiligaynon (hil_PH): added to language list box
−
| The GETPIVOTDATA function returns a result value from a DataPilot table, so it can be used in a cell formula.
+
| 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]
 +
|-
 +
| 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: ...
 +
| [http://www.openoffice.org/issues/show_bug.cgi?id=82927 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.  
 +
| [http://www.openoffice.org/issues/show_bug.cgi?id=83369 83369]
 +
|}
  
−
Supported by import export Excel
+
<br>
−
| [http://www.openoffice.org/issues/show_bug.cgi?id=45843 45843]
+
  
−
|-
+
=== Base / DBA ===
−
| Various improvements
+
−
| Error codes on import Excel, context menu, naming of strings
+
−
| [http://www.openoffice.org/issues/show_bug.cgi?id=47732 47732], [http://www.openoffice.org/issues/show_bug.cgi?id=47644 47644], [http://www.openoffice.org/issues/show_bug.cgi?id=50436 50436], [http://www.openoffice.org/issues/show_bug.cgi?id=50439 50439], [http://www.openoffice.org/issues/show_bug.cgi?id=53756 53756], [http://www.openoffice.org/issues/show_bug.cgi?id=55972 55972], [http://www.openoffice.org/issues/show_bug.cgi?id=77653 77653],
+
  
−
|-
+
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
−
| Extended automatic summation
+
! Feature
−
| Capabilities to sum up cell values automatically are extended. Cell range is specified by the user
+
! Description
−
| [http://specs.openoffice.org/calc/ease-of-use/autosum.odt specs] / [http://blogs.sun.com/GullFOSS/entry/improving_calc_usability_autosum Blog] / [http://www.openoffice.org/issues/show_bug.cgi?id=51564 51564]
+
! Specs/Issue
  
 
|-
 
|-
−
| Named ranges in validation lists
+
| Improved rendering of numeric(n) data from jdbc/oracle
−
| Now it is possible to use named ranges in the definition of cell validation lists.
+
| 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=56566 56566]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=11746 11746]  
−
 
+
[http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw Spec]
 
|-
 
|-
−
| Import drawing objects and pictures with macros
+
| Easier choice of table name in "Copy table"
−
| Drawing objects and pictures can be linked to a macro. Now that is handheld with the import from Excel files.
+
| 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://specs.openoffice.org/calc/compatibility/AutoShapeMacroSupport.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=59082 59082]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=18907 18907]  
−
 
+
 
|-
 
|-
−
| JIS and ASC with katakana characters
+
| Editing of views in HSQLDB
−
| The JIS and ASC functions support work with katakana characters (Japanese).
+
| From OOo 2.4.0 it is possibe to edit a view's design (underlying statement) in embedded HSQL databases.
−
| [http://wiki.services.openoffice.org/mwiki/index.php?title=Calc/Features/JIS_and_ASC_functions&oldid=34845 wiki] / [http://www.openoffice.org/issues/show_bug.cgi?id=70213 70213]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=49183 49183]  
−
 
+
 
|-
 
|-
−
| Cotangent functions in export
+
| Query designer for all properties which allow SQL command
−
| All cotangent functions are converted in the export to Excel, that doesn't know these functions.
+
| 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=72768 72768]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=66624 66624]  
−
 
+
 
|-
 
|-
−
| Toolbar Form Objects removed
+
| Query designer in SQL view
−
| The toolbar Form Objects has been removed from Calc. All items are found on the toolbar Form Design
+
| 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=72799 72799]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=77492 77492]  
−
 
+
 
|-
 
|-
−
| Toolbar Insert and Insert Object
+
| Relation design for MySQL databases
−
| The toolbar Insert Object has been removed. Items were moved to the Toolbar Insert
+
| The relation design is now accessible for MySQL databases as well
−
| [http://specs.openoffice.org/appwide/toolbars/Toolbar_content_spec.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=73123 73123]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=68858 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.
 +
| [http://www.openoffice.org/issues/show_bug.cgi?id=69740 69740]  
 
|-
 
|-
−
| Auto capitalisation
+
| Setting to check for required fields on forms
−
| The first character of a word or the first sentence in a cell isn't automatically capitalized any more.
+
| 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=78661 78661]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=80930 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.
 +
| [http://www.openoffice.org/issues/show_bug.cgi?id=81043 81043]  
 +
[http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw Spec]
 
|}
 
|}
  
 
<br>
 
<br>
  
−
=== Writer ===
+
=== Calc ===
  
−
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
+
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
 +
! Feature
 +
! Description
 +
! Specs/Issue
  
 
|-
 
|-
−
| Pages centered in window
+
| Convert text to columns
−
| Pages that aren't wider than the width of the window, will be centered.
+
| 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.
−
| [http://www.openoffice.org/issues/show_bug.cgi?id=1761 1761]
+
  
 +
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.openoffice.org/issues/show_bug.cgi?id=4040 4040]
 +
[http://specs.openoffice.org/calc/ease-of-use/Text_to_Columns.odt Spec]
 
|-
 
|-
−
| Export to MediaWiki
+
| Cells in spreadsheet can be moved, copied, or linked
−
| A new xslt based export filter for the MediaWiki format. After installing the filter, File|Export can make wiki-pages of your Writer documents
+
| 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://specs.openoffice.org/writer/fileIO/MediaWiki_Export_Filter.odt specs] / [http://blogs.sun.com/oootnt/entry/using_openoffice_org_to_write Blog] / [http://www.openoffice.org/issues/show_bug.cgi?id=48409 48409]
+
| [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]
 
|-
 
|-
−
| Option Update charts independent
+
| Enter key returns to the column where the input started, one row below
−
| Now Update Charts (Tools|Options|OOo Writer|General) is independent from the setting of Update Fields
+
| 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.openoffice.org/issues/show_bug.cgi?id=55007 55007]
+
| [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]
 
|-
 
|-
−
| Language guessing for paragraphs
+
| Formula input: "+" and "-" can also be used to start
−
| When the language of a paragraph is not set, now it is guessed when spellchecking.
+
| 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://specs.openoffice.org/appwide/linguistic/Automatic_Language_Guessing_Component.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=73713 73713]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=20496 20496]  
−
 
+
[http://specs.openoffice.org/calc/ease-of-use/Enhanced_Formula_Input.odt Spec]
 
|-
 
|-
−
| Enhancement Smart Tags
+
| Individual zoom level per sheet
−
| Smart tags functionality is available when when one or more are installed as extension.
+
| Each sheet in a spreadsheet document can now have its own zoom level.
−
 
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=24372 24372]  
−
Now context menus are integrated.
+
[http://specs.openoffice.org/calc/dialogs/Options_Dialog.odt Spec]
−
| [http://specs.openoffice.org/appwide/SmartTags/Smart_Tags_Specification.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=75130 75130]
+
−
 
+
 
|-
 
|-
−
| Mail merge
+
| AutoFilter: choices clearer grouped and based on result of filtering in other columns
−
| The Simple Mail Merge Dialog now offers the possibility to save as one document. Also the window is resizable.
+
| 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://specs.openoffice.org/writer/mail_merge/Simple_Mail_Merge_Print_Dialog.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=76853 76853]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=27745 27745]  
−
 
+
[http://specs.openoffice.org/calc/ease-of-use/AutoFilter_Behavior.odt Spec]
 
|-
 
|-
−
| Mail merge warning message
+
| DataPilot: Manual Sorting
−
| The option "Do not show this message again" when choosing to print the document directly or to make mail merge, has been removed.
+
| 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://specs.openoffice.org/writer/mail_merge/Simple_Mail_Merge_Print_Dialog.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=76853 76853], [http://www.openoffice.org/issues/show_bug.cgi?id=51906 51906]
+
| [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]
 
|-
 
|-
−
| Soft page breaks export
+
| Double-click in Datapilot cell provides calculation data of that cell
−
| ODF 1.1 allows the export of soft page breaks. This export now is implemented. Useful for a.o. digital books.
+
| 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://specs.openoffice.org/writer/SoftPageBreak/SoftPageBreak.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=78650 78650]
+
| [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
 +
| 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://wiki.services.openoffice.org/wiki/Calc/To-Dos/Performance/VLOOKUP Spec]
 +
|-
 +
| 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.  
 +
| [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]
 
|}
 
|}
  
Line 330: Line 389:
 
=== Chart ===
 
=== Chart ===
  
−
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
+
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
−
|-
+
! Feature
−
| New Chart Wizard
+
! Description
−
| Simplified chart creation, with less steps.
+
! Specs/Issue
−
| [http://specs.openoffice.org/chart/wizards/ChartWizard.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=20344 20344]
+
  
 
|-
 
|-
−
| Flexible source ranges
+
| Regression curves: show equations and R² value
−
| Source ranges can be associated to different chart-objects. Thus for example different x-axis values can be used. Improves interoperability with other applications.
+
| The equation of trend lines and the R² value now can be displayed in the chart.
−
| [http://specs.openoffice.org/chart/dataselection/FlexibleSourceRangeSelection.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=3997 3997]
+
| [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://specs.openoffice.org/chart/DisplayTrendLineEquations.odt Spec]
 +
[http://wiki.services.openoffice.org/wiki/Chart2/Features2.4#Display_bars_on_different_axes_next_to_each_other Screen Shots]
 
|-
 
|-
−
| More clear information about regression curves
+
| Reverse axes
−
| Formula and r^2 value of a selected regression curve are shown in status bar.
+
| 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://specs.openoffice.org/chart/ChartObjectNames.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=78442 78442]
+
| [http://www.oooninja.com/2008/02/reverse-axis-chart-bar-graph.html Article]
−
 
+
[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://specs.openoffice.org/chart/Chart_Scales_and_Intervals.odt Spec]
 
|-
 
|-
−
| Improvements for 3D charts
+
| Different axes: bars displayed next to each other
−
| Better and clearer dialog, 'right angle axes' option, simple 3D look, default illumination accordingly, exploded 3D Pies
+
| 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://specs.openoffice.org/chart/Chart3DViewDialog.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=75176 75176], [http://www.openoffice.org/issues/show_bug.cgi?id=67754 67754], [http://www.openoffice.org/issues/show_bug.cgi?id=14202 14202], [http://www.openoffice.org/issues/show_bug.cgi?id=76430 76430], [http://www.openoffice.org/issues/show_bug.cgi?id=20321 20321]
+
| [http://www.oooninja.com/2008/01/show-bars-side-by-side-double-column.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=26795 26795]
 +
[http://specs.openoffice.org/chart/BarChartOptions.odt Spec]
 
|-
 
|-
−
| New colors
+
| Data labels: Number format
−
| New colors have been chosen and added to the default colors in the Office color palette
+
| 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://ui.openoffice.org/VisualDesign/OOoChart_colors_drafts.html#02 info] / [http://specs.openoffice.org/chart/OptionsChartColors.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=7019 7019], [http://www.openoffice.org/issues/show_bug.cgi?id=75202 75202]
+
| [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://specs.openoffice.org/chart/ChartDataLabels.odt Spec]
 
|-
 
|-
−
| Enhanced Logarithmic scales
+
| Data point label: display both value and percentage
−
| Free manual choose of minimum and maximum values and user defined major interval.
+
| For data labels in charts it is now possible to display the value and the percentage value at the same time.  
−
| [http://specs.openoffice.org/chart/Chart_Scales_and_Intervals.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=27694 27694], [http://www.openoffice.org/issues/show_bug.cgi?id=26869 26869]
+
| [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://specs.openoffice.org/chart/ChartDataLabels.odt Spec]
 
|-
 
|-
−
| Easier working on various points
+
| Data label: display each part in a separate line
−
| Selection by mouse of chart objects, automatic scaling of axises, and placing of title have been improved.
+
| The different parts of a data label now can be displayed in separate lines.  
−
| [http://specs.openoffice.org/chart/ChartSelectionHandling.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=58161 58161]
+
| [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://specs.openoffice.org/chart/ChartAxisAutoScaling.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=30426 30426] [http://specs.openoffice.org/chart/ChartInsertTitleDialog.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=13443 13443]
+
[http://www.openoffice.org/issues/show_bug.cgi?id=82051 82051]
−
 
+
[http://specs.openoffice.org/chart/ChartDataLabels.odt Spec]
 
|-
 
|-
−
| Enhancement of the data editor
+
| Data labels: more flexible placement of labels
−
| In charts with their own data (not from a spreadsheet) the data editor allows to modify, add and delete all data  
+
| 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://specs.openoffice.org/chart/ChartDataDialog.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=64824 64824]
+
| [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://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.
 +
| [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://specs.openoffice.org/chart/ChartDataLabels.odt Spec]
 
|-
 
|-
−
| New menu, toolbar, Help
+
| Data point labels can be removed
−
| The new Charts comes with new menu items, toolbar entries, help information
+
| It is now possible to remove selected data point labels with pressing the delete key or using the mouse.
−
| [http://www.openoffice.org/issues/show_bug.cgi?id=60358 60358], [http://www.openoffice.org/issues/show_bug.cgi?id=70287 70287], [http://www.openoffice.org/issues/show_bug.cgi?id=27351 27351], [http://www.openoffice.org/issues/show_bug.cgi?id=74907 74907], [http://www.openoffice.org/issues/show_bug.cgi?id=74909 74909]
+
| [http://www.oooninja.com/2008/03/data-label-options-calc-chart.html Article]
 +
[http://www.openoffice.org/issues/show_bug.cgi?id=83344 83344]
  
 
|}
 
|}
Line 382: Line 460:
 
<br>
 
<br>
  
−
=== Impress ===
+
=== Draw ===
  
−
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
+
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
 +
! Feature
 +
! Description
 +
! Specs/Issue
  
 
|-
 
|-
−
| Export to HTML
+
| Navigation (tab) order of page objects
−
| Export to HTML now supports png-graphics
+
| 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://specs.openoffice.org/draw/draw_html_export.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=23353 23353]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=68097 68097]  
−
 
+
[http://specs.openoffice.org/draw/NavOrder.odt Spec]
 
|-
 
|-
−
| Custom animation paths
+
| PDF exported: page names as bookmark
−
| The animation path for moving objects on slides now is editable.
+
| When exporting to PDF, you can now able choose to make bookmarks of the names of the pages in a draw document.
−
| [http://specs.openoffice.org/impress/slideshow/CustomAnimation.odt specs]  
+
| [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]
 
|-
 
|-
−
| Play sound all over the slide show
+
| Reduce complexity: no longer necessary display options removed
−
| Now it is possible to play a sound without interrupt over multiple slides
+
| 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=24969 24969]  
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=80528 80528]  
−
 
+
[http://www.openoffice.org/nonav/issues/showattachment.cgi/49524/ReCo.odt Spec]
−
<!--
+
−
|-
+
−
| Sun Presentation Minimizer
+
−
| Extension that offers the choose between different options to reduce the size of presentations and to remove content before distributing the presentation. (Not available for download as of 2007-09-23?)
+
−
| [http://specs.openoffice.org/impress/extensions/PresentationMinimizer.odt specs]  
+
−
-->
+
−
 
+
 
|}
 
|}
  
 
<br>
 
<br>
  
−
=== Draw ===
+
=== Impress ===
  
−
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
+
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
 +
! Feature
 +
! Description
 +
! Specs/Issue
 
|-
 
|-
−
| Export to HTML
+
| Navigation (tab) order of page objects
−
| Export to HTML now supports png-graphics
+
| 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://specs.openoffice.org/draw/draw_html_export.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=23353 23353]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=68097 68097]  
−
 
+
[http://specs.openoffice.org/draw/NavOrder.odt Spec]
 
|-
 
|-
−
| Alternative text for image maps and drawing layers
+
| Slide transitions: thrilling 3D effects
−
| Image maps and drawing layers now provide for alternative text that is essential for accessibility
+
| 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://specs.openoffice.org/appwide/drawing_layer/imagemapdialog.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=68099 68099], [http://specs.openoffice.org/draw/layer.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=68100 68100]
+
| [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]
 +
|-
 +
| PDF exported: slide names as bookmark
 +
| 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.openoffice.org/issues/show_bug.cgi?id=40318 40318]
 
|-
 
|-
−
| Maximum page size enlarged
+
| Background picture: easier to insert
−
| Now it is possible to make pages up to 300 x 300 cm. If more is needed, it may be changed in 'MaximumPaperWidth/MaximumPaperHeight' in share\registry\schema\org\openoffice\Office\Common.xcs where these defaults are defined. WARNING: See explanations in given task before doing this!
+
| 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=4219 4219],
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=82911 82911]
 +
[http://specs.openoffice.org/impress/sd.insertbackground.odt Spec]
 
|}
 
|}
  
 
<br>
 
<br>
  
−
=== Base/DBA ===
+
=== Writer ===
  
−
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
+
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
 +
! Feature
 +
! Description
 +
! Specs/Issue
  
 
|-
 
|-
−
| Window size and state of forms and reports
+
| Selecting rectangular region of text
−
| Forms now have windows size and state that is independent from that from normal Writer documents
+
| 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.openoffice.org/issues/show_bug.cgi?id=45663 45663]
+
| [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://specs.openoffice.org/writer/selection_enhancement/Block_Selection_of_Text Spec]
 
|-
 
|-
−
| Keyboard shortcuts
+
| Find & Replace: backward references in regular expressions
−
| (More) shortcuts are available in the task pane, forms,  
+
| 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.openoffice.org/issues/show_bug.cgi?id=71900 71900], [http://www.openoffice.org/issues/show_bug.cgi?id=74918 74918],
+
| [http://www.oooninja.com/2007/12/backreferences-in-replacements-new.html Article]
−
 
+
[http://www.openoffice.org/issues/show_bug.cgi?id=15666 15666]  
 +
[http://specs.openoffice.org/appwide/find_and_replace/Regular_Expressions.odt Spec]
 
|-
 
|-
−
| No slashes in names of objects
+
| Spell checking: easier selecting of the language
−
| Slashes (/) in the name of reports, forms etc are not allowed any more.
+
| 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.
−
 
+
−
When present in existing base documents, slashes will be automatically converted to underscores (_)
+
−
| [http://www.openoffice.org/issues/show_bug.cgi?id=73084 73084]
+
  
 +
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://specs.openoffice.org/appwide/linguistic/Set_Language_Attribute_for_Text.odt Spec.]
 
|-
 
|-
−
| Report Builder (designer) extension
+
| Insert&Insert Object toolbar redesign - Writer
−
| A full new report designer has been made available as extension.  
+
| 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://specs.openoffice.org/appwide/toolbars/Toolbar_content_spec.odt Spec]
−
To create reports with content from OOo Base as well as a wide range of proprietary and OpenSource relational databases.  
+
|-
−
| [http://extensions.services.openoffice.org/project/reportdesign Download] , [http://dba.openoffice.org/specifications/ReportDesigner.odt specs], [http://wiki.services.openoffice.org/wiki/SUN_Report_Builder Wiki] / [http://www.openoffice.org/issues/show_bug.cgi?id=76758 76758]
+
| 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.
 +
| [http://www.openoffice.org/issues/show_bug.cgi?id=81434 81434] [http://specs.openoffice.org/writer/printing/Print_Hidden_Text.odt 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.
 +
| [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
 +
| 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://specs.openoffice.org/appwide/keyboard/assign_keyboard_shortcuts_to_styles.sxw 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".
 +
| [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=5091 5091] [http://blogs.sun.com/GullFOSS/entry/custom_properties_and_fields blog]
 
|}
 
|}
  
 
<br>
 
<br>
  
−
=== XML-Forms ===
+
=== Extensions/ programmability / API  ===
  
−
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
+
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
 +
! Feature
 +
! Description
 +
! Specs/Issue
  
 
|-
 
|-
−
| Window size and state of XML-forms
+
| Extensible Help System for extensions
−
| XML-forms now have windows size and state that is independent from that from normal Writer documents
+
| 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=75146 75146]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=20164 20164] [http://specs.openoffice.org/appwide/help/ExtensibleHelp.odt Spec]
−
 
+
−
|}
+
−
 
+
−
<br>
+
−
 
+
−
=== API / programming ===
+
−
 
+
−
{|  cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
+
 
|-
 
|-
−
| Sequence as input
+
| Extensions can have a separate display name
−
| A possibility to represent a sequence as a seekable input stream is offered.
+
| 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=77185 77185] + idl specification
+
| [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&section=14
 
|-
 
|-
−
| Number of heading rows of table
+
| Extensions: support of web based update
−
| Now it is possible to set the number of heading rows by API
+
| 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://www.openoffice.org/nonav/issues/showattachment.cgi/46767/headerrows.odt info] / [http://www.openoffice.org/issues/show_bug.cgi?id=79458 79458]
+
| [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]
 
|-
 
|-
−
| Keys and document macros
+
| Extensions: additional information about the publisher and release notes
−
| It is possible now to assing keys to macros contained in a document.
+
| 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://www.openoffice.org/issues/show_bug.cgi?id=56351 56351]
+
| [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]
 
|-
 
|-
−
| Listeners and changes on shapes
+
| Extensions: check for updates
−
| Impemented listeners now are notified about changes of properties of shapes
+
| 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=71036 71036]
+
| [http://www.openoffice.org/issues/show_bug.cgi?id=82851 82851] [http://specs.openoffice.org/appwide/onlineupdate/Online_Update_Notification_of_Extensions.odt Spec]
−
 
+
−
 
+
 
|-
 
|-
−
| Tree control
+
| Dialogs can have a wallpaper set
−
| A tree control is available
+
| A new property for dialogs and tab pages is added, for an image URL which is used to display as a background image.
−
| [http://specs.openoffice.org/appwide/dialog_ide/New_Tree_Control_in_IDE.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=78847 78847]
+
| [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]
 
|-
 
|-
−
| Single Dialog Export
+
| Remote control presentations via API
−
| Now it is possible to export single Dialogs in the Dialog Editor (as *.xdl files. This export includes possible localized properties files.
+
| 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://specs.openoffice.org/appwide/dialog_ide/Export_single_dialog_from_library.odt specs] / [http://www.openoffice.org/issues/show_bug.cgi?id=77640 77640], [http://www.openoffice.org/issues/show_bug.cgi?id=75778 75778]
+
| [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
 +
| 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]  
 
|}
 
|}
  
Line 519: Line 627:
 
=== Few of the bug Fixes ===
 
=== Few of the bug Fixes ===
  
−
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
+
{| cellpadding=2 cellspacing=0 border=1px style="border-collapse:collapse; border-color:#AAA; background:#F9F9F9;"
−
|-
+
! Feature
−
| PDF File size
+
! Description
−
| Due to a bug in 2.2,1 the exported PDF could become very large. This has now been corrected.
+
! Specs/Issue
−
| [http://www.openoffice.org/issues/show_bug.cgi?id=78613 78613]
+
  
 
|-
 
|-
−
| Number formatting in Writer tables
+
| ???
−
| Number formatting now also works in cells with more than one paragraph.
+
| Table has no top border when over 2+ pages 
−
| [http://www.openoffice.org/issues/show_bug.cgi?id=77649 77649]
+
| [http://qa.openoffice.org/issues/show_bug.cgi?id=9860 9860]
−
 
+
|-
 +
| ???
 +
| Fields from Endnote skipped during Word import in OOo 2
 +
| [http://qa.openoffice.org/issues/show_bug.cgi?id=61075 61075]
 +
|-
 +
| ???
 +
| wrong cursor position when undoing "insert table row" 
 +
| [http://qa.openoffice.org/issues/show_bug.cgi?id=18014 18014]
 
|}
 
|}
  
 
<br>
 
<br>
 +
 
=== Performance improvements ===
 
=== Performance improvements ===
  
−
See [[Integrated_Performance_Improvements#In_2.3|Integrated_Performance_Improvements]]
+
See [[Integrated_Performance_Improvements#In_2.4|Integrated_Performance_Improvements]]

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

Draw

  • Navigation (tab) order of page objects
  • PDF export: page names as bookmark
  • Reduce complexity: no longer necessary display options removed

Impress

Writer

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

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

56629

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

59651 Spec

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

Spec

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

Spec

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

Spec


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

4040 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. Article

7180 Spec

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

15546 Spec

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

Spec

Individual zoom level per sheet Each sheet in a spreadsheet document can now have its own zoom level. 24372

Spec

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

Spec

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

Spec

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

Spec

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

Spec

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

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

7998 Spec Screen Shots

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

Screen Shots 24614 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 other, thus they don't hide each other anymore. Article

Screen Shots 26795 Spec

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

Screen Shots 37792 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. Article

Screen Shots 43489 Spec

Data label: display each part in a separate line The different parts of a data label now can be displayed in separate lines. Article

Screen Shots 82051 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. Article

Screen Shots 63857 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. Article

Screen Shots 4039 Spec

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

83344


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

Spec

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

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

Spec


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

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

82460

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

40318

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

Spec


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

1596 Spec

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

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

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

82775 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. Article

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


Performance improvements

See Integrated_Performance_Improvements

Retrieved from "https://wiki.openoffice.org/w/index.php?title=New_Features_2.4&oldid=75390"
Personal tools