Space: Apache OpenOffice Community (https://cwiki.apache.org/confluence/display/OOOUSERS) Page: AOO 3.4 Release Notes (https://cwiki.apache.org/confluence/display/OOOUSERS/AOO+3.4+Release+Notes)
Change Comment: --------------------------------------------------------------------- Added infos about new color picker Edited by Armin Le Grand: --------------------------------------------------------------------- h2. General Remarks The Apache OpenOffice 3.4 features can be split in two separate areas based on the timeline by the change step from OpenOffice to Apache OpenOffice. One set was already present, one set is the result of work based on Apache since then. h2. New Features from OpenOffice 3.4 beta This features were already part of the OpenOffice 3.4 beta. The 3.4 beta was built from the OOO340 codeline which was cloned from DEV300m106. This code line is the base for the Apache OpenOffice code. h3. Improved ODF1.2 encryption support The ODF1.2 specification allows to use W3C-specified algorithms to encrypt ODF1.2 documents. The new implementation let the following algorithms be used in case ODF1.2 encrypted document is stored: Start key generation: SHA256 Derived key generation: PBKDF2 Encryption algorithm: AES-256 Checksum generation: SAH256_1K It is possible to let start key and checksum generation use SHA1/SHA1_1K algorithms during storing of ODF1.2 encrypted document by setting the configuration entry org.openoffice.Office.Common/Save/ODF/UseSHA1InODF12 to "true". It is also possible to let Blowfish algorithm be used in this case by setting the entry org.openoffice.Office.Common/Save/ODF/UseBlowfishInODF12 to "true". The storing of encrypted ODF1.1/ODF1.0 documents is not affected. Please see http://docs.oasis-open.org/office/v1.2/csprd03/OpenDocument-v1.2-csprd03-part3.html for details. h3. Spreadsheet: TIME function returns values 00:00:00 <= x <= 23:59:59.999 The TIME spreadsheet function returns values between 00:00:00 and 23:59:59.999... inclusive and wraps values equal to or greater than 24:00:00. h3. Chart: Resizeable Legend The legend within charts can be resized now. h3. Spreadsheet: Changed "DataPilot" to "Pivot Table" In the Spreadsheet GUI, the term "DataPilot" has been replaced with the term "Pivot Table". h3. Spreadsheet: CSV export option "Quote all text cells" Previously, in Spreadsheet CSV export, all content from text cells was quoted with the selected text delimiter. Now this is optional and happens only if the new check box "Quote all text cells" is selected. By default, the text delimiter is added only if the cell content contains the field delimiter, text delimiter or multiple lines. When a CSV file is loaded and saved again without editing the filter settings, the import option "Quoted field as text" is used for the "Quote all text cells" option. The default for "Quoted field as text" is now "off" (but if it's changed in the import dialog, that is still saved as new default in the configuration). h3. Spreadsheet: Unlimited number of fields in Pivot Table layout dialog In the Pivot Table layout dialog, it is now possible to add more than 8 fields to the "Row Fields", "Column Fields", and "Data Fields" areas, and more than 10 fields to the "Page Fields" area. h3. Chart: Date Axis Date axis are available now for category charts. h3. MailMerge: Scan rows for correct type information for Text databases The MaxRowScan setting allows to define how many rows should be scanned to find the correct type of a column. In the past only the first row was scanned. h3. Math: new option to save only used symbols for each formula In order to save on document file size (namely in Writer documents with many formulas) there is now a new option to save only those symbols which each that are used in that very formula. By default that option will be active. Geek info: However there is a small drawback, so far, if you work with different office installations, documents with formulas could be used to implicitly import ALL user-defined symbols in Math from one office installation to the next, even if none of them got used in a formula. Since now only the actually used symbols get saved only those can be implicitly imported into a different office installation. To get the old behavior simply turn off this new option. h3. Draw/Impress default enhancements: - Better defaults for impress & draw snap. - Changed default for "copy when moving". - Better defaults for grid settings in impress & draw - Better defaults for bullet spacing and indention - Animate outline shapes 'By 1st level paragraphs' as default - New default colors of drawing objects - Setting default shadow distance for shapes to 0,2cm - Enhancement to the "mouse as pen" feature in impress slideshow - Default full width for text in shapes - Change outline default bullet symbol order from 'Oo-' in 'O-O-O' - Shortcut for inserting comments changed h3. Formula: Automatic baseline for Math objects With CWS tlmath01 there is a new check-box named 'Math baseline alignment' available in the 'Formatting Aids' tab of the Writer and WriterWeb option pages. When this option gets checked then *ALL* Math OLE objects already existing in the Writer document that are anchored 'as character' (and only those with this anchor type!) will be automatically aligned to match the baseline of the formula with the one of the surrounding text. Also new Math objects inserted later on will be automatically aligned as well. As long as this option is active manually movement of Math objects that are anchored 'as character' is not possible, and thus vertical alignment in the 'Object' context dialog is now disabled as well. For new documents this option is set by default. When loading old documents it is not set. In any case, once a document gets saved again the current value of this option will be saved along with the document. This automatic baseline alignment was implemented by Michal Spisiak as part of this years Google Summer of Code, the mentor for this was Eric Bachard. Thanks to both of them! h3. Password entry in PDF export dialog changed During PDF export one can enter two passwords ("open" and "permission" password). These can now be entered in one pass instead of two separate dialogs. h3. Mozilla Address Book support removed, in favour of Seamonkey Since the Mozilla product has long been superseded by the SeaMonkey suite, and the profile formats of both changed incompatibly, the Mozilla Address Book support in OpenOffice.org has been removed, in favor of support for the SeaMonkey address books. h3. List box controls: "Bound field" is allowed to be 0 The "Bound field" property of a list box control, specifying which column of the list boxes result set should be used for data exchange, can have the value "0" now. h3. Base: object trees: selecting entries by typing their name The tree lists in Base's main application window, now support selecting entries by typing their name. h3. Stylist / Navigator / Options Dialog: selecting entries by typing their name The tree lists in the application's Navigator, Stylist ("Styles and Formattings"), and in the options dialog, now support selecting entries by typing their name. h3. Print file format changes on Linux systems Printing on Unix systems can now produce PDF files instead of PostScript. h3. Math symbol catalog supports UTF-32 characters now h3. Draw/Impress: Setting pixel resolution when exporting graphics h3. Spreadsheet: Calc CSV export improved h3. Remove binfilter export filters h3. Further development/bug fixes for DOCX import filter h3. OOo/Mac running headless as daemon h3. Implement better defaults from renaissance project for impress/draw application h3. RTF export filter enhancements Rewrite of the RTF export filter. Now it supports nested tables, more character properties, sections, graphics for Wordpad, bookmarks, fields, drawings and OLE objects. h3. Various BugFixes h2. New Features for Apache OpenOffice 3.4 This features are the result of the work at Apache on OpenOffice since the change: h3. Support for Line Cap Property Now you can add a cap to the ends of a line. Such caps are not only known in the ODF1.2 standard but in HTLM5 and SVG too. Also other Office Sites provide caps in different styles to be added to thick lines. Three styles exist * without a cap, called 'Butt' in programming and 'Flat' in UI (as in MS Office) * with a round cap, called 'Round' * with a rectangle cap, called 'Square' The property value 'Flat' corresponds to the old behavior and is now the default. !LineCap_PureLines.png! The caps are added to the lines, so that the total length of the lines increases with two-times a half line width. Select the value from a drop-down-list in the line property dialog, just beside the settings for corner style. The new property is only available in contexts, where the corner style is active too. !LineCap_Dialog.png! If a line is dashed, the single dashes get caps too. Hereby a dot is treated as dash. You can style not only pure lines and curves, but the border of graphic objects as well. !LineCap_BorderlineDotted.png! !LineCap_CurveDashed.png! The next example shows the new property applied to a connector. Left side without cap, in the middle with 'round' cap, and on the right side with 'square' cap. !LineCap_CapOnConnectors.png! The caps are available for 3D-objects too, when you turn on lines and make them thick. The example shows lines, which are styled to look “dotted”. !LineCap_SphereDotted.png! and a zoom… !LineCap_SphereZoom.png! Linecaps defined in svg-graphics are supported, so that those graphics look like in modern browsers. h3. ODF 1.2 support AOO supports ODF 1.2, which has many benefits, one of which is its extended cryptography options (e.g. AES encryption and SHA256 message digests). h3. Better UI Defaults for Draw and Impress [Better Bullet UI|http://wiki.services.openoffice.org/wiki/BetterDefaults_BulletsColorsShortcuts_workout] [Better Grid UI|http://wiki.services.openoffice.org/wiki/Specification_BetterDefaults_Gridhandling#Detailed_Specification] h3. ODF Spreadsheet learns new Conditional Functions Support conditional functions COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS h3. Time Axis supported in Chart !timeaxis_sample.png! h3. PDF File Size Reduction PDFs containing monochrome bitmaps are smaller now h3. PivotTable has been extended PivotTable (formerly known as DataPilot) is no longer limited in the number of fields h3. Improved CSV export Better interoperability with other applications supporting the import of CSV (Comma Separated Values) files as the style for exporting strings is configurable now h3. Improved Printing on Unix Printing via PDF (if the system supports it) allows object transparency to be handled directly by the printer subsystem h3. Support for shear transformations for GraphicObjects [(Blog entry)|https://blogs.apache.org/OOo/entry/features_for_graphicobjects_and_oleobjects] GraphicObjects which get created when inserting graphics in Draw/Impress and Spreadsheet support now not only rotation but also shear, slant and distort. The visualization during interactions got improved, also the break for vector-based GraphicObjects to draw objects was improved. Writer has it's own GraphicObjects, the ones from the other applications can be copied to it as workaround. h3. Support for attributes and transformations for OLEObjects [(Blog entry)|https://blogs.apache.org/OOo/entry/features_for_graphicobjects_and_oleobjects] OLEObjects (OLE is for Object Linking and Embedding) in Draw/Impress and Spreadsheet support now all draw attributes and geometrical transformations. They can have line style, fill style, shadow and text. They support all kinds of transformations, e.g. rotations and shear. This is handy for e.g. having a mathematical formula shown rotated by 90 degrees or adding a border to a chart. Break to draw objects is also enhanced. h3. Enhanced crop support for GraphicalObjects Crop for GraphicObjects now works correctly together with horizontal and/or vertical mirroring in all applications. h3. Support for Scalable Vector Graphics (SVG) [(Blog entry)|https://blogs.apache.org/OOo/entry/native_svg_support_for_apache] Svg is now supported as content for GraphicObjects in all applications. The new implemented generic Svg interpreter supports Svg format 1.1. The geometric content is internally processed as vector data in all usages, e.g. PDF export and printing, which guarantees good visualization quality. Svg graphics can be broken to draw objects and be processed further. A blog entry can be found [here|http://eric.bachard.org/news/index.php?post/2011/12/03/In-progress-%3A-native-support-of-the-SVG-graphic-format-in-Apache-OpenOffice.org]. h3. Support for MultiImage in ODF For Svg support it was necessary to allow multiple image representations for one GraphicObject to be present in the ODF file format, e.g. a pixel graphic and the original Svg is written in case of a GraphicObject with Svg content. This allows to stay compatible with other and older ODF supporting applications. The number of images for one GraphicObject is not limited; applications using this may choose the image with the format which supports it's purpose best, e.g prefer to use a pixel graphic for ODF viewers. AOO 3.4 uses a weighting function which prefers pixel images with transparency over such without and vector formats over pixel formats. h3. Enhanced chart visualisation The visualization quality of charts has been enhanced by using a new mechanism for more direct visualisation. This increases speed, reduces memory usage and enhances chart visualisation in all visualisations, including PDF export and printing. h3. Enhanced RTF export Now it supports nested tables, more character properties, sections, graphics for Wordpad, bookmarks, fields, drawings and OLE objects h3. New regular expressions (regexp) engine The existing regular expression engine has been replaced by the ICU engine. This solves several bugs in "Find and Replace" with the old implementation and speeds up the search. The new engine also offers better standards compliance especially regarding Unicode, which also means that some non-standard syntax extensions like {{\<}} and {{\>}} for word boundary matching are now deprecated. For the convenience of a smooth upgrade experience they get emulated by the {{\b}} operator though. See [ICU regex syntax|http://userguide.icu-project.org/strings/regexp#TOC-Regular-Expression-Metacharacters] for expressions supported in the new regular expression engine. It is recommended to stay on the common ground though and [regex flavors|http://www.regular-expressions.info/refflavors.html] gives an overview where this common ground is. The modified syntax applies to macros too: regular expressions in macros that were relying on the deprecated syntax should be converted to use widely supported regex expressions. Users of Japanese scripts should be aware that several non-trivial transliterations could behave slightly differently, especially when transliteration rules like "ProlongedSoundMark", "IterationMark", "Ignore-Width", "BaFa", "SeZe", "HyuByu", "IandEfollowedByYa" or "KiKuFollowedBySa" might be involved. h3. Faster Startup Startup is faster as the program now has enough initial knowledge about its components so that it doesn't have to start each of them h3. New ColorPicker dialog The old color picker which is used in the office code for over a decade has been replaced by a new, more intuitive one which offers a wide variety of color selection possibilities. A picture says more than words, feel free to take a look at a comparison of the old and the new color picker [here|https://issues.apache.org/ooo/attachment.cgi?id=77172]. This feature was developed by Christian Lippka, kudos to him for offering it under Apache License. Change your notification preferences: https://cwiki.apache.org/confluence/users/viewnotifications.action
