2010-10-19T13:55:01Z

Lutz Hoeger:

__NOTOC__
= OpenOffice.org 3.3 New Features =

[[#Productivity Enhancements]]

Usability and Interface

Internationalization

Developer Features and Extensibility

''The full technical release notes containing a list of features and integrated child workspaces can be read [http://development.openoffice.org/releases/3.3.0rc1.html here].''

== Productivity Enhancements ==

[[Image:NewCustomPropertiesHandling.png|200px|thumb|right|alt=New Custom Properties Handling]]

=== New Custom Properties Handling ===

OpenOffice.org allows users to define any number of custom document properties as name/value pairs in the '''File > Properties''' dialog. With version 3.3 it is possible to also define DateTime values and values that contain a duration.
 

=== Embedding of Standard PDF Fonts ===

In previous versions, the standard PDF standard fonts (Times, Helvetica, Courier, Symbol and ZapfDingbats) were only embedded into the resulting PDF when the resulting file was of the PDF/A type, since the PDF/A standards requires this. In version 3.3, you can optionally embed these fonts in all PDF documents created by OpenOffice.org to enhance display accuracy in PDF viewers.

=== New Narrow Font Family ===

Oracle contributed a narrow font family to the free and open source [http://en.wikipedia.org/wiki/Liberation_fonts Liberation font families]. Being metrically compatible to the Arial Narrow font, widely used on Microsoft Windows systems, this font family now completes the Liberation family and delivers a compatible and free set of fonts available on all platforms.

[[Image:IncreasedDocumentProtectionInWriterAndCalc.png|200px|thumb|right|alt=Increased Document Protection In Writer And Calc]]

=== Increased Document Protection in Writer and Calc ===

OpenOffice.org Writer and Calc now allow two levels of document protection. As before, you can save a document with a password that prevents unauthorized users to read the content. Now you can also set a password to protect a document against unwanted changes.

This way, you can make the content of a document available for reading to a selected group of people, and for reading and editing to a different group. This behaviour is now compatible with Microsoft Word and Excel file protection.
 

=== 1M Rows in a Spreadsheet ===

OpenOffice.org Calc spreadsheets now support 1,048,576 (1M) rows instead of 65,536 rows.

[[Image:NewOptionsForCSVImportInCalc.png|200px|thumb|right|alt=New Options For CSV Import In Calc]]

=== New Options for CSV (Comma Separated Value) Import in Calc ===

Two new options are available when importing CSV files that contain data separated by specific characters.

These options determine whether quoted data will always be imported as text, and whether OpenOffice.org Calc will automatically detect all number formats, including special number formats such as dates, time, and scientific notation. The detection depends on the language settings.
 

=== Automatic Decimals Digits for "General" format in Calc ===

In OpenOffice.org Calc, numbers formatted with the "General" number format will display as many decimal digits as required. In former versions, a maximum of 2 decimal digits were displayed with the "General" number format.

[[Image:InsertDrawingObjectsInCharts.PNG|200px|thumb|right|alt=Insert Drawing Objects In Charts]]

=== Insert Drawing Objects in Charts ===

The Chart functionality is enhanced and now supports drawing objects. The drawing toolbar allows to insert simple shapes such as lines, rectangles and text objects and even complex shapes such as cubes, symbols, block arrows, flowcharts and stars. The drawing objects can be edited by several dialogs which can be opened via the context menu. Also the font and formatting of text objects can be changed.
 

[[Image:HierarchicalAxisLabelsForCharts.png|200px|thumb|right|alt=Hierarchical Axis Labels For Charts]]

=== Hierarchical Axis Labels for Charts ===

If the categories in charts that get their data from spreadsheet span multiple rows and multiple columns, the direction of the first data series is detected. If the data for the first series comes from rows, the categories are split into multiple rows. Otherwise the categories are split into multiple columns. The split categories are then applied as different hierarchical labels at the x-axis.
 

[[Image:HierarchicalAxisLabelsForChartsData.png|200px|thumb|right|alt=Hierarchical Axis Labels For Charts Data]]

For charts with own data (typically used in Impress or Writer), there is a new icon to add text columns, which then will be used for the different levels in the x-axis labels.
 

[[Image:ImprovedSlideLayoutHandlingInImpress1.png|200px|thumb|right|alt=Improved Slide Layout Handling In Impress 1]]

=== Improved Slide Layout Handling in Impress ===

Handling of slide layouts in presentations is vastly improved. The content type of slide sections is now defined directly on the slide by clicking on one of the four content type icons: table, chart, picture, or movie, or entering text directly.
 

[[Image:ImprovedSlideLayoutHandlingInImpress3.png|200px|thumb|right|alt=Improved Slide Layout Handling In Impress 3]]

This reduces the number of slide layout varieties making the layout selection much clearer. In addition, you can now also assign layouts to slides and create new slides with a specific layout using the toolbar. One new toolbar element is used to add a new slide (or duplicate the currently selected slide).

A similar toolbar element is used to assign a layout to the currently selected slide, or reset the layout to the assigned layout after making changes.
 

=== Manual Setting for Primary Key Support for Databases ===

When connecting to a database via an ODBC, JDBC, or ADO driver, Base used to apply a heuristic method to determine whether the database supports primary keys. In some cases, this heuristic method failed. Therefore, version 3.3 introduces an explicit option to declare primary key support. When this setting is enabled, Base will always assume that the database supports primary keys, regardless of the result of the heuristic analysis.

=== Support of Read-Only Database Registrations ===

In OpenOffice.org, database registrations are stored in the application configuration files. Therefore, it is possible to deploy additional configuration fragments containing additional registrations. If those configuration fragments are declared as read-only (by using the usual configuration mechanisms for this), OpenOffice.org now blocks modifications (editions, removal) of the corresponding registration entry.

=== New Math Command 'nospace' ===

It will now be possible to explicitly remove the small horizontal space that always gets applied between two elements. The syntax is <tt> nospace { el1 el2 ... } </tt>

== Usability and Interface ==

[[Image:CommonSearchToolbar.png|200px|thumb|right|alt=Common Search Toolbar]]

=== Common Search Toolbar ===

Usage data indicated that a large portion of Open Office users want to quickly search inside a document's text. This is now possible using the new “Find” toolbar containing a search field, and a next and previous button.

User:Lutz Hoeger/wng33

2010-10-19T13:48:24Z

2010-10-19T12:26:59Z

Lutz Hoeger: Created page with '= OpenOffice.org 3.3 New Features = Productivity Enhancements Usability and Interface Internationalization Developer Features and Extensibility ''The full technica…' (checkpoint save)

= OpenOffice.org 3.3 New Features =

Productivity Enhancements

Usability and Interface

Internationalization

Developer Features and Extensibility

 ''The full technical release notes containing a list of features and integrated child workspaces can be read [http://development.openoffice.org/releases/3.3.0rc1.html here].''

 

== Productivity Enhancements ==

=== New Custom Properties Handling ===

i97029

Oracle Open Office allows users to define any number of custom document properties as name/value pairs in the File > Properties dialog. With version 3.3 it is possible to also define DateTime values and values that contain a duration. [[Image:File.jpg]]

File:NewCustomPropertiesHandling.png

2010-10-19T12:25:01Z

Lutz Hoeger:

Setup - Bundled Extensions

2010-07-08T14:26:26Z

Lutz Hoeger: /* Detailed Specification */

=Setup - Bundled/Integrated Extensions=

{{Specification_Header|Lutz Hoeger|Jun 17, 2010|Standard}}

== Abstract ==
Integrated extensions - such as dictionaries for spell checking - will be displayed in the OOo installer module selection (during custom installation). This allows users to gain more control over what will be installed on their system. At the same time, managing such extensions (remove, update) will be moved from the extension manager into the application installer.

__TOC__

== References ==

{| border="2" cellpadding="4" cellspacing="0" style="margin: 1em 1em 1em 0; border: 1px #cccccc solid; border-collapse: collapse; width: 100%"
|-
| width="300" bgcolor="#dddddd" | '''Reference Document''' || bgcolor="#dddddd" | '''Check''' || bgcolor="#dddddd" | '''Location (URL)'''
|-
| '''Product Requirement, RFE, Issue ID''' (required)
| [available]
| http://www.openoffice.org/issues/show_bug.cgi?id=112404
|-
| '''[[Test case specification]]''' (required)
| [available]
| http://www.openoffice.org/nonav/issues/showattachment.cgi/70050/Bundled%20Extensions.html
|-
|}

== Contacts ==

{| border="2" cellpadding="4" cellspacing="0" style="margin: 1em 1em 1em 0; border: 1px #cccccc solid; border-collapse: collapse; width: 100%"
|-
| width="300" bgcolor="#dddddd" | '''Role''' || bgcolor="#dddddd" | '''Name''' || bgcolor="#dddddd" | '''E-Mail Address'''
|-
| '''Developer'''
| Joachim Lingner
| jl@openoffice.org
|-
| '''Quality Assurance'''
| Olaf Felka
| of@openoffice.org
|-
| '''Documentation'''
| Uwe Fischer
| ufi@openoffice.org
|-
|}

== Detailed Specification ==

This document distinguishes between '''bundled''' extensions and '''integrated''' extensions.

'''Bundled Extensions''':
* The extension package is '''co-located with the main product installer'''. This can be in a separate directory, next to the installer, or on an additional medium.
* There is '''no integration into the installation process''' of the main product.
* The purpose of bundled extensions is to achieve a moderate level of '''convenience''' for users, and to add value to the overall '''product bundling'''.

'''Integrated Extensions''':
* The extension is '''part of the installation''' package of the main application. It is installed via the main product installer.
* The purpose of integrated extensions is to '''add functionality to the main product''', while maintaining the flexibility given by extensions.
* Typical integrated extensions - such as dictionaries for spell checking - will be '''displayed in the OOo installer''' module selection (during custom installation).
* On Windows and Unix, user can de-select items; on Mac, all items will be installed
* At the same time, managing integrated extensions (remove, update) will be '''removed from the Extension Manager''' and put into the application installer.
* Integrated extensions shall '''not ping for updates'''. Any update available will be deployed exclusively via later releases of the main product OOo.

----

'''Display of Dictionaries:'''
* Location in setup: Optional Components, #1 after Java
* Module name: Dictionaries
* Module description: Spelling and hyphenation dictionaries and thesauri
* Default: ON (incl. all sub-modules, according to spellchecker selection per language specific installation set)
* Sub-modules: See list below.

=== Dictionaries ===
Note: The set of dictionaries actually included in a language specific installation set – or in a multi language set – does not change. The following list just enlists all dictionary languages possibly shipped in OOo.

The set of languages display in setup should be sorted alphabetically by Module name.

{| border="2" cellpadding="4" cellspacing="0" style="margin: 1em 1em 1em 0; border: 1px #cccccc solid; border-collapse: collapse; width: 100%"
|-
| width="300" bgcolor="#dddddd" | '''Language''' || bgcolor="#dddddd" | '''Module Name''' || bgcolor="#dddddd" | '''Module descrition'''
|-
| af
| Afrikaans
| Afrikaans spell checker
|-
| pt
| Brazilian Portuguese
| Brazilian Portuguese Spelling Dictionary - 1990 Spelling Agreement
|-
| ca
| Catalan
| Spelling and hyphenation dictionaries and thesaurus for Catalan language (general)
|-
| cs
| Czech
| Czech thesaurus
|-
| da
| Danish
| Spelling and hyphenation dictionary for Danish
|-
| nl
| Dutch
| Dutch spelling and hyphenation dictionaries
|-
| en-US
| English
| English spelling and hyphenation dictionaries and thesaurus
|-
| et
| Estonian
| Estonian spelling and hyphenation dictionaries
|-
| fr
| French
| French "Classic and Reform 1990" spelling, thesaurus and hyphenation
|-
| gl
| Galician
| Galician spellchecker dictionary for OpenOffice.org
|-
| de-AT
| German (Austria)
| German (AT-frami) spelling, hyphenation, thesaurus
|-
| de-DE
| German (Germany)
| German (DE-frami) spelling, hyphenation, thesaurus
|-
| de-CH
| German (Switzerland)
| German (CH-frami) spelling, hyphenation, thesaurus
|-
| he
| Hebrew
| Hebrew spell check dictionary
|-
| hu
| Hungarian
| Hungarian spelling dictionary, hyphenation patterns, and thesaurus
|-
| it
| Italian
| Italian spelling and hyphenation dictionaries and thesaurus
|-
| ku-TR
| Kurdish (Turkey)
| Kurdish (Turkey) spell check dictionary
|-
| lt
| Lithuanian
| Lithuanian spelling and hyphenation dictionaries
|-
| ne
| Nepali
| Nepali spelling dictionary and thesaurus
|-
| no
| Norwegian
| Norwegian dictionaries (Nynorsk and Bokmål)
|-
| pl
| Polish
| Polish spell check dictionary, hyphenation rules and thesaurus
|-
| ro
| Romanian
| Romanian Dictionaries
|-
| ru
| Russian
| Russian hyphenation dictionary and thesaurus
|-
| sr
| Serbian
| Serbian spelling and hyphenation dictionaries
|-
| sk
| Slovak
| Slovak spell check dictionary, hyphenation rules and thesaurus
|-
| sl
| Slovenian
| Slovenian dictionary pack
|-
| es
| Spanish
| Spanish spelling dictionary
|-
| sw
| Swahili
| Swahili spelling dictionary
|-
| sv
| Swedish
| Swedish Dictionary
|-
| th
| Thai
| Thai spelling dictionary
|-
| vi
| Vietnamese
| Vietnamese spellchecker dictionary
|-
| zu
| Zulu
| Zulu hyphenation dictionary
|-
|}

[[Specification_Template_Help#Detailed_Specification|Help]] | [[UI-Elements|User Interface Element Templates]] | [[Specification_Example|Example Spec]]

== Accessibility ==
Accessibility not impacted.

== Migration ==
Bundled dictionaries in OOo versions previous to 3.3 were installed as shared extensions. Shared extensions are not migrated.

As of 3.3 bundled extensions will always be removed when uninstalling OOo. They are therefore not eligible for being migrated.

== Configuration ==
Bundled extensions, such as the dictionaries, can be configured if they provide their own options pages in OOo's options dialog.

[[Specification_Template_Help#Configuration|Help]] | [[Configuration-Table|Configuration Table Template]]

== Open Issues ==
* Pre-bundled extensions still show up in the Extension Manager. This is considered a minor impact, as the user cannot change such extension in this place. Issue will be resolved in the future.

[[Category:Specification]]
[[Category:Extensions]]
[[Category:Installation]]

Setup - Bundled Extensions

2010-07-08T14:24:41Z

Lutz Hoeger: /* Setup - Bundled Extensions */

=Setup - Bundled/Integrated Extensions=

{{Specification_Header|Lutz Hoeger|Jun 17, 2010|Standard}}

== Abstract ==
Integrated extensions - such as dictionaries for spell checking - will be displayed in the OOo installer module selection (during custom installation). This allows users to gain more control over what will be installed on their system. At the same time, managing such extensions (remove, update) will be moved from the extension manager into the application installer.

__TOC__

== References ==

{| border="2" cellpadding="4" cellspacing="0" style="margin: 1em 1em 1em 0; border: 1px #cccccc solid; border-collapse: collapse; width: 100%"
|-
| width="300" bgcolor="#dddddd" | '''Reference Document''' || bgcolor="#dddddd" | '''Check''' || bgcolor="#dddddd" | '''Location (URL)'''
|-
| '''Product Requirement, RFE, Issue ID''' (required)
| [available]
| http://www.openoffice.org/issues/show_bug.cgi?id=112404
|-
| '''[[Test case specification]]''' (required)
| [available]
| http://www.openoffice.org/nonav/issues/showattachment.cgi/70050/Bundled%20Extensions.html
|-
|}

== Contacts ==

{| border="2" cellpadding="4" cellspacing="0" style="margin: 1em 1em 1em 0; border: 1px #cccccc solid; border-collapse: collapse; width: 100%"
|-
| width="300" bgcolor="#dddddd" | '''Role''' || bgcolor="#dddddd" | '''Name''' || bgcolor="#dddddd" | '''E-Mail Address'''
|-
| '''Developer'''
| Joachim Lingner
| jl@openoffice.org
|-
| '''Quality Assurance'''
| Olaf Felka
| of@openoffice.org
|-
| '''Documentation'''
| Uwe Fischer
| ufi@openoffice.org
|-
|}

== Detailed Specification ==

This document distinguishes between '''bundled''' extensions and '''integrated''' extensions.

'''Bundled Extensions''':
* The extension package is '''co-located with the main product installer'''. This can be in a separate directory, next to the installer, or on an additional medium.
* There is '''no integration into the installation process''' of the main product.
* The purpose of bundled extensions is to achieve a moderate level of '''convenience''' for users, and to add value to the overall '''product bundling'''.

'''Integrated Extensions''':
* The extension is '''part of the installation''' package of the main application. It is installed via the main product installer.
* The purpose of integrated extensions is to '''add functionality to the main product''', while maintaining the flexibility given by extensions.
* Typical integrated extensions - such as dictionaries for spell checking - will be '''displayed in the OOo installer''' module selection (during custom installation).
* On Windows and Unix, user can de-select items; on Mac, all items will be installed
* At the same time, managing integrated extensions (remove, update) will be '''removed from the Extension Manager''' and put into the application installer.
* Integrated extensions shall '''not ping for updates'''. Any update available will be deployed exclusively via later releases of the main product OOo.

* Display of Dictionaries:
** Location in setup: Optional Components, #1 after Java
** Module name: Dictionaries
** Module description: Spelling and hyphenation dictionaries and thesauri
** Default: ON (incl. all sub-modules, according to spellchecker selection per language specific installation set)
** Sub-modules: See list below.

=== Dictionaries ===
Note: The set of dictionaries actually included in a language specific installation set – or in a multi language set – does not change. The following list just enlists all dictionary languages possibly shipped in OOo.

The set of languages display in setup should be sorted alphabetically by Module name.

{| border="2" cellpadding="4" cellspacing="0" style="margin: 1em 1em 1em 0; border: 1px #cccccc solid; border-collapse: collapse; width: 100%"
|-
| width="300" bgcolor="#dddddd" | '''Language''' || bgcolor="#dddddd" | '''Module Name''' || bgcolor="#dddddd" | '''Module descrition'''
|-
| af
| Afrikaans
| Afrikaans spell checker
|-
| pt
| Brazilian Portuguese
| Brazilian Portuguese Spelling Dictionary - 1990 Spelling Agreement
|-
| ca
| Catalan
| Spelling and hyphenation dictionaries and thesaurus for Catalan language (general)
|-
| cs
| Czech
| Czech thesaurus
|-
| da
| Danish
| Spelling and hyphenation dictionary for Danish
|-
| nl
| Dutch
| Dutch spelling and hyphenation dictionaries
|-
| en-US
| English
| English spelling and hyphenation dictionaries and thesaurus
|-
| et
| Estonian
| Estonian spelling and hyphenation dictionaries
|-
| fr
| French
| French "Classic and Reform 1990" spelling, thesaurus and hyphenation
|-
| gl
| Galician
| Galician spellchecker dictionary for OpenOffice.org
|-
| de-AT
| German (Austria)
| German (AT-frami) spelling, hyphenation, thesaurus
|-
| de-DE
| German (Germany)
| German (DE-frami) spelling, hyphenation, thesaurus
|-
| de-CH
| German (Switzerland)
| German (CH-frami) spelling, hyphenation, thesaurus
|-
| he
| Hebrew
| Hebrew spell check dictionary
|-
| hu
| Hungarian
| Hungarian spelling dictionary, hyphenation patterns, and thesaurus
|-
| it
| Italian
| Italian spelling and hyphenation dictionaries and thesaurus
|-
| ku-TR
| Kurdish (Turkey)
| Kurdish (Turkey) spell check dictionary
|-
| lt
| Lithuanian
| Lithuanian spelling and hyphenation dictionaries
|-
| ne
| Nepali
| Nepali spelling dictionary and thesaurus
|-
| no
| Norwegian
| Norwegian dictionaries (Nynorsk and Bokmål)
|-
| pl
| Polish
| Polish spell check dictionary, hyphenation rules and thesaurus
|-
| ro
| Romanian
| Romanian Dictionaries
|-
| ru
| Russian
| Russian hyphenation dictionary and thesaurus
|-
| sr
| Serbian
| Serbian spelling and hyphenation dictionaries
|-
| sk
| Slovak
| Slovak spell check dictionary, hyphenation rules and thesaurus
|-
| sl
| Slovenian
| Slovenian dictionary pack
|-
| es
| Spanish
| Spanish spelling dictionary
|-
| sw
| Swahili
| Swahili spelling dictionary
|-
| sv
| Swedish
| Swedish Dictionary
|-
| th
| Thai
| Thai spelling dictionary
|-
| vi
| Vietnamese
| Vietnamese spellchecker dictionary
|-
| zu
| Zulu
| Zulu hyphenation dictionary
|-
|}

[[Specification_Template_Help#Detailed_Specification|Help]] | [[UI-Elements|User Interface Element Templates]] | [[Specification_Example|Example Spec]]

== Accessibility ==
Accessibility not impacted.

== Migration ==
Bundled dictionaries in OOo versions previous to 3.3 were installed as shared extensions. Shared extensions are not migrated.

As of 3.3 bundled extensions will always be removed when uninstalling OOo. They are therefore not eligible for being migrated.

== Configuration ==
Bundled extensions, such as the dictionaries, can be configured if they provide their own options pages in OOo's options dialog.

[[Specification_Template_Help#Configuration|Help]] | [[Configuration-Table|Configuration Table Template]]

== Open Issues ==
* Pre-bundled extensions still show up in the Extension Manager. This is considered a minor impact, as the user cannot change such extension in this place. Issue will be resolved in the future.

[[Category:Specification]]
[[Category:Extensions]]
[[Category:Installation]]

MimeType Icons

2010-06-15T13:37:26Z

Lutz Hoeger:

=== Unified ODF Icons ===

 
[[File:ODF_textdocument_48x48.png]] [[File:ODF_spreadsheet_48x48.png]] [[File:ODF_presentation_48x48.png]] [[File:ODF_drawing_48x48.png]] [[File:ODF_database_48x48.png]] [[File:ODF_formula_48x48.png]]

====The [http://ui.openoffice.org/VisualDesign/ODF_icons4print.html unified ODF MimeType Icons] for OpenOffice.org 3.2.1====

* [http://odftoolkit.org/ODF-Icons#ODF_Icons all ODF mime type icons]
* [http://odftoolkit.org/projects/odftoolkit/pages/ODF-Icons-HighContrast#ODF_Icons all ODF mime type icons - High Contrast version]

 
 

----

 

=== Overview ===

====OpenOffice.org 3.2.1====

Overview of all [http://odftoolkit.org/ODF-Icons Unified ODF Icons]

====OpenOffice.org 3.0====

Overview of all [http://ui.openoffice.org/nonav/VisualDesign/OOo30MimeType.html OpenOffice.org 3.0 MimeType Icons]

==== OpenOffice.org 2.0 ====

Overview of all [http://ui.openoffice.org/nonav/VisualDesign/OOo20MimeType.html OpenOffice.org 2.0 MimeType Icons]

 
 

----

 

=== History ===

'''The History of OpenOffice.org MimeType Icons'''

The evolution of document icons:

[[Image:OOo_MimeType_History.png]]

 

[[Category:Visual Design]]
[[Category:Icons]]
[[Category:Branding]]
[[Category:ODF]]