openoffice-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject [CONF] Apache OpenOffice Community > AOO 3.4 Release Notes
Date Thu, 16 Feb 2012 06:54:00 GMT
Space: Apache OpenOffice Community (
Page: AOO 3.4 Release Notes (

Change Comment:
replace link to new ColorPicker demo PDF with emebedded screenshots to improve usability

Edited by Juergen Schmidt:
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
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"

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


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.


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.


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

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|]
[Better Grid UI|]

h3. ODF Spreadsheet learns new Conditional Functions
Support conditional functions COUNTIFS, SUMIFS, AVERAGEIF and AVERAGEIFS

h3. Time Axis supported in Chart

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)|]

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

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 

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 {{\&lt;}} and {{\&gt;}} 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|]
for expressions supported in the new regular expression engine. It is recommended to stay
on the common ground though and [regex flavors|]
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.
This feature was developed by Christian Lippka, kudos to him for offering it under Apache
License. A picture says more than words.

|| Old || New ||
| !ColorPicker_Old.png|thumbnail! | !ColorPicker_New.png|thumbnail!  |

Change your notification preferences:

View raw message