blob: 98d750deb8d9109c8b900eb7e5d747c01aff4c3a [file] [log] [blame]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>OpenOffice.org 3.3 New Features</title>
<style type="text/css">
/*<![CDATA[*/
.MyPics {
border: solid silver 1px;
display: inline;
float: right;
}
.BigHead {
margin-top: 15px;
}
/*]]>*/
</style>
</head>
<body>
<h1>OpenOffice.org 3.3 New Features</h1>
<table id="toc" summary="Contents">
<tr>
<td colspan="2">
<h2>Contents</h2>
</td>
</tr>
<tr>
<td width="50%">
<ul>
<li>
<a href="#Productivity_Enhancements">Productivity Enhancements</a>
<ul>
<li><a href="#New_Custom_Properties_Handling">
New Custom Properties Handling</a></li>
<li><a href="#Embedding_of_Standard_PDF_Fonts">
Embedding of Standard PDF Fonts</a></li>
<li><a href="#New_Narrow_Font_Family">
New Narrow Font Family</a></li>
<li><a href="#Increased_Document_Protection_in_Writer_and_Calc">
Increased Document Protection in Writer and Calc</a></li>
<li><a href="#Automatic_Decimals_Digits_for_General_format_in_Calc">
Automatic Decimals Digits for "General" format in Calc</a></li>
<li><a href="#One_Million_Rows_in_a_Spreadsheet">
1 Million Rows in a Spreadsheet</a></li>
<li><a href="#New_Options_for_CSV_Comma_Separated_Value_Import_in_Calc">
New Options for CSV (Comma Separated Value) Import in Calc</a></li>
<li><a href="#Insert_Drawing_Objects_in_Charts">
Insert_Drawing_Objects_in_Charts</a></li>
<li><a href="#Hierarchical_Axis_Labels_for_Charts">
Hierarchical_Axis_Labels_for_Charts</a></li>
<li><a href="#Improved_Slide_LayoutHandling_in_Impress">
Improved Slide Layout Handling in Impress</a></li>
<li><a href="#Manual_Setting_for_Primary_Key_Support_for_Databases">
Manual Setting for Primary Key Support for Databases</a></li>
<li><a href="#Support_of_Read-Only_Database_Registrations">
Support of Read-Only Database Registrations</a></li>
<li><a href="#New_Math_Command_nospace">
New Math Command 'nospace'</a></li>
</ul>
</li>
<li>
<a href="#Internationalization">Internationalization</a>
<ul>
<li><a href="#Additional_Locale_Data">
Additional Locale Data</a></li>
</ul>
</li>
</ul>
</td>
<td width="50%">
<ul>
<li>
<a href="#Usability_and_Interface">Usability and Interface</a>
<ul>
<li><a href="#Common_Search_Toolbar">
Common Search Toolbar</a></li>
<li><a href="#New_Easier_to_Use_Print_Interface">
New Easier to Use Print Interface</a></li>
<li><a href="#More_Options_for_Changing_Case">
More Options for Changing Case</a></li>
<li><a href="#Redesign_of_Thesaurus">
Redesign of Thesaurus</a></li>
<li><a href="#Resetting_Text_to_the_Default_Language_in_Writer">
Resetting Text to the Default Language in Writer</a></li>
<li><a href="#Text_Rendering_of_Form_Controls_in_Writer">
Text Rendering of Form Controls in Writer</a></li>
<li><a href="#Changed_Defaults_for_Charts">
Changed Defaults for Charts</a></li>
<li><a href="#Colored_Sheet_Tabs_in_Calc">
Colored Sheet Tabs in Calc</a></li>
<li><a href="#Adapt_to_Marked_Selection_for_Filter_Area_in_Calc">
Adapt to Marked Selection for Filter Area in Calc</a></li>
<li><a href="#Sort_Dialog_for_DataPilot_in_Calc">
Sort Dialog for DataPilot in Calc</a></li>
<li><a href="#Display_Custom-Names_for_DataPilot_Fields_Items_and_Totals_in_Calc">
Display Custom Names for DataPilot Fields, Items and Totals in Calc</a></li>
</ul>
</li>
<li>
<a href="#Developer_Features_and_Extensibility">
Developer Features and Extensibility</a>
<ul>
<li><a href="#Grid_Control_Enhancements">
Grid Control Enhancements</a></li>
<li><a href="#New_MetaData_Node_for_Database">
New MetaData Node for Database</a></li>
<li><a href="#Extending_Database_Drivers_Using_Extensions">
Extending Database Drivers Using Extensions </a></li>
</ul>
</li>
</ul>
</td>
</tr>
<tr>
<td colspan="2">
<p><b>Sources for this document:</b></p>
<ul>
<li><a href="http://development.openoffice.org/releases/3.3.0rc3.html"
title="Full technical release notes">Full technical release notes</a></li>
<li><a href="http://wiki.services.openoffice.org/wiki/Feature_Freeze_Testing_3.3"
title="QA list of new features">QA list of new features</a></li>
<li><a href="http://blogs.sun.com/GullFOSS"
title="OpenOffice.org Engineering Blog GullFOSS">
OpenOffice.org Engineering Blog GullFOSS</a></li>
</ul>
</td>
</tr>
</table>
<br />
<h1 class="BigHead">Productivity Enhancements
<a name="Productivity_Enhancements" id="Productivity_Enhancements"></a></h1>
<h2>New Custom Properties Handling<a name="New_Custom_Properties_Handling"
id="New_Custom_Properties_Handling"></a></h2>
<p><a href="images/NewCustomPropertiesHandling.png"
title="New Custom Properties Handling">
<img class="MyPics" src="images/200px-NewCustomPropertiesHandling.png"
width="200" alt="New Custom Properties Handling" /></a>
OpenOffice.org allows users to define any number of custom document
properties as name/value pairs in the <b>File &gt; Properties</b> dialog.
With version 3.3 it is possible to also define DateTime values and values
that contain a duration.</p><br /><br /><br /><br /><br />
<h2>Embedding of Standard PDF Fonts<a name="Embedding_of_Standard_PDF_Fonts"
id="Embedding_of_Standard_PDF_Fonts"></a></h2>
<p>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.</p>
<h2>New Narrow Font Family<a name="New_Narrow_Font_Family"
id="New_Narrow_Font_Family"></a></h2>
<p>Oracle contributed a narrow font family to the free and open source
<a href="http://en.wikipedia.org/wiki/Liberation_fonts" title="Liberation
font families">Liberation font families</a>. 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.</p>
<h2>Increased Document Protection in Writer and Calc
<a name="Increased_Document_Protection_in_Writer_and_Calc"
id="Increased_Document_Protection_in_Writer_and_Calc"></a></h2>
<p><a href="images/IncreasedDocumentProtectionInWriterAndCalc.png"
title="Increased Document Protection in Writer and Calc">
<img class="MyPics"
src="images/200px-IncreasedDocumentProtectionInWriterAndCalc.png"
width="200" alt="Increased Document Protection in Writer and Calc" /></a>
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.</p>
<p>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.</p><br /><br /><br /><br /><br /><br /><br /><br />
<h2>Automatic Decimals Digits for "General" format in Calc
<a name="Automatic_Decimals_Digits_for_General_format_in_Calc"
id="Automatic_Decimals_Digits_for_General_format_in_Calc"></a></h2>
<p>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.</p>
<h2>1 Million Rows in a Spreadsheet<a name="One_Million_Rows_in_a_Spreadsheet"
id="One_Million_Rows_in_a_Spreadsheet"></a></h2>
<p>OpenOffice.org Calc spreadsheets now support 1,048,576 (1 Million) rows
instead of 65,536 rows.</p>
<h2>New Options for CSV (Comma Separated Value) Import in Calc
<a name="New_Options_for_CSV_Comma_Separated_Value_Import_in_Calc"
id="New_Options_for_CSV_Comma_Separated_Value_Import_in_Calc"></a></h2>
<p><a href="images/NewOptionsForCSVImportInCalc.png"
title="New Options for CSV (Comma Separated Value) Import in Calc">
<img class="MyPics" src="images/NewOptionsForCSVImportInCalc.png"
alt="New Options for CSV (Comma Separated Value) Import in Calc" /></a>
Two new options are available when importing CSV files that contain data
separated by specific characters.</p>
<p>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.</p>
<h2>Insert Drawing Objects in Charts
<a name="Insert_Drawing_Objects_in_Charts"
id="Insert_Drawing_Objects_in_Charts"></a></h2>
<p><a href="images/InsertDrawingObjectsInCharts.png"
title="Insert Drawing Objects in Charts">
<img class="MyPics" src="images/200px-InsertDrawingObjectsInCharts.png"
width="200" alt="Insert Drawing Objects in Charts" /></a>
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.</p>
<p>For further details of this new feature please see the
<a href="http://blogs.sun.com/GullFOSS/entry/new_chart_features_in_openoffice3">
GullFOSS blog article</a>.</p>
<h2>Hierarchical Axis Labels for Charts
<a name="Hierarchical_Axis_Labels_for_Charts"
id="Hierarchical_Axis_Labels_for_Charts"></a></h2>
<p><a href="images/HierarchicalAxisLabelsForCharts.png"
title="Hierarchical Axis Labels for Charts">
<img class="MyPics" src="images/200px-HierarchicalAxisLabelsForCharts.png"
width="200" alt="Hierarchical Axis Labels for Charts" /></a>
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.</p><br /><br />
<p><a href="images/HierarchicalAxisLabelsForChartsData.png"
title="Hierarchical Axis Labels for Charts Data">
<img class="MyPics"
width="200" src="images/200px-HierarchicalAxisLabelsForChartsData.png"
alt="Hierarchical Axis Labels for Charts Data" /></a>
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.</p>
<p>For further details of this new feature please see the
<a href="http://blogs.sun.com/GullFOSS/entry/new_chart_features_in_openoffice4">
GullFOSS blog article</a>.</p><br /><br /><br />
<h2>Improved Slide Layout Handling in Impress
<a name="Improved_Slide_Layout_Handling_in_Impress"
id="Improved_Slide_Layout_Handling_in_Impress"></a></h2>
<p><a href="images/ImprovedSlideLayoutHandlingInImpress1.png"
title="Improved Slide Layout Handling in Impress">
<img class="MyPics" width="200"
src="images/200px-ImprovedSlideLayoutHandlingInImpress1.png"
alt="Improved Slide Layout Handling in Impress" /></a>
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.</p><br /><br /><br /><br />
<p><a href="images/ImprovedSlideLayoutHandlingInImpress3.png"
title="Improved Slide Layout Handling in Impress">
<img class="MyPics" width="200"
src="images/200px-ImprovedSlideLayoutHandlingInImpress3.png"
alt="Improved Slide Layout Handling in Impress" /></a>
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).</p>
<p>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.</p><br /><br /><br />
<h2>Manual Setting for Primary Key Support for Databases
<a name="Manual_Setting_for_Primary_Key_Support_for_Databases"
id="Manual_Setting_for_Primary_Key_Support_for_Databases"></a></h2>
<p>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.</p>
<h2>Support of Read-Only Database Registrations
<a name="Support_of_Read-Only_Database_Registrations"
id="Support_of_Read-Only_Database_Registrations"></a></h2>
<p>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.</p>
<h2>New Math Command 'nospace'<a name="New_Math_Command_nospace"
id="New_Math_Command_nospace"></a></h2>
<p>It will now be possible to explicitly remove the small horizontal space that
always gets applied between two elements. The syntax is
<code>nospace { el1 el2 ... }</code></p>
<h1 class="BigHead">Usability and Interface
<a name="Usability_and_Interface" id="Usability_and_Interface"></a></h1>
<h2>Common Search Toolbar<a name="Common_Search_Toolbar"
id="Common_Search_Toolbar"></a></h2>
<p><a href="images/CommonSearchToolbar.png"
title="Common Search Toolbar">
<img class="MyPics" src="images/CommonSearchToolbar.png"
alt="Common Search Toolbar" /></a>
Usage data indicated that a large portion of OpenOffice.org 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.</p>
<h2>New Easier to Use Print Interface
<a name="New_Easier_to_Use_Print_Interface"
id="New_Easier_to_Use_Print_Interface"></a></h2>
<p><a href="images/NewEasierToUsePrintInterface.png"
title="New Easier to Use Print Interface">
<img class="MyPics" width="200"
src="images/200px-NewEasierToUsePrintInterface.png"
alt="New Easier to Use Print Interface" /></a>
The print dialog has been completely revamped in OpenOffice.org 3.3 to allow
for a more efficient and usable printing experience.</p>
<p>An integrated preview is available to show the appearance of the document
to be printed, and all relevant settings can be made from within this one
dialog, including number of pages, collation settings, document objects to
print or hide, page order, print multiple pages, and much more.</p>
<p>For further details of this new feature please see the
<a href="http://blogs.sun.com/GullFOSS/entry/new_print_ui_now_integrated">
GullFOSS blog article</a>.</p>
<h2>More Options for Changing Case<a name="More_Options_for_Changing_Case"
id="More_Options_for_Changing_Case"></a></h2>
<p>With version 3.3, you have more options for changing the case of a
selected text portion. Apart from toggling uppercase and lowercase, you can
now set the case to sentence case (first letter capitalized), capitalize
every word, or invert the current case.</p>
<h2>Redesign of Thesaurus<a name="Redesign_of_Thesaurus"
id="Redesign_of_Thesaurus"></a></h2>
<p><a href="images/RedesignOfThesaurus.png"
title="Redesign of Thesaurus">
<img class="MyPics" width="200" src="images/200px-RedesignOfThesaurus.png"
alt="Redesign of Thesaurus" /></a>
The thesaurus dialog has been redesigned for better usability. In addition,
a new "Synonyms" sub menu in the default context menu allows you to select
a synonym for the currently selected word right away.</p>
<br /><br /><br /><br /><br /><br /><br />
<h2>Resetting Text to the Default Language in Writer
<a name="Resetting_Text_to_the_Default_Language_in_Writer"
id="Resetting_Text_to_the_Default_Language_in_Writer"></a></h2>
<p><a href="images/ResettingTextToTheDefaultLanguageInWriter.png"
title="Resetting Text to the Default Language in Writer">
<img class="MyPics" width="200"
src="images/200px-ResettingTextToTheDefaultLanguageInWriter.png"
alt="Resetting Text to the Default Language in Writer" /></a>
You can now reset the language of text back to the default language using
the language status bar or the Tools &gt; Language menu.</p><br /><br /><br />
<h2>Text Rendering of Form Controls in Writer
<a name="Text_Rendering_of_Form_Controls_in_Writer"
id="Text_Rendering_of_Form_Controls_in_Writer"></a></h2>
<p>Form controls in text documents now render their text the same way the
document itself does, thus making the appearance of controls as part of a
text flow much more seamless and consistent.</p>
<h2>Changed Defaults for Charts<a name="Changed_Defaults_for_Charts"
id="Changed_Defaults_for_Charts"></a></h2>
<p>Several defaults have changed for OpenOffice.org charts: larger size,
larger font size, no black borders, better 3D look and more.</p>
<h2>Colored Sheet Tabs in Calc<a name="Colored_Sheet_Tabs_in_Calc"
id="Colored_Sheet_Tabs_in_Calc"></a></h2>
<p><a href="images/ColoredSheetTabsInCalc.png"
title="Colored Sheet Tabs in Calc">
<img class="MyPics" src="images/ColoredSheetTabsInCalc.png"
alt="Colored Sheet Tabs in Calc" /></a>
Each sheet in an OpenOffice.org Calc document can now be assigned a color
for its tab in the Sheet tabs area at the bottom left of the window.</p>
<h2>Adapt to Marked Selection for Filter Area in Calc
<a name="Adapt_to_Marked_Selection_for_Filter_Area_in_Calc"
id="Adapt_to_Marked_Selection_for_Filter_Area_in_Calc"></a></h2>
<p><a href="images/AdaptToMarkedSelectionForFilterAreaInCalc.png"
title="Adapt to Marked Selection for Filter Area in Calc">
<img class="MyPics" width="200"
src="images/200px-AdaptToMarkedSelectionForFilterAreaInCalc.png"
alt="Adapt to Marked Selection for Filter Area in Calc" /></a>
In OpenOffice.org Calc, a selection is now shrunk to the actually used data
columns when enabling a filter (AutoFilter, StandardFilter,
AdvancedFilter).</p>
<p>Users can select an entire row by clicking on a row header and expect a
filter to operate on the data below the selected row. If one single row is
selected the selection is shrunk to the actually used data columns and then
expanded over all contiguous data rows below. Selecting only a portion of a
row behaves similar by expanding the selected columns over the data rows.
An area selected, e.g. more than one entire row, is shrunk to the actual
used data columns.</p><br /><br />
<h2>Sort Dialog for DataPilot in Calc
<a name="Sort_Dialog_for_DataPilot_in_Calc"
id="Sort_Dialog_for_DataPilot_in_Calc"></a></h2>
<p><a href="images/SortDialogForDataPilotInCalc.png"
title="Sort Dialog for DataPilot in Calc">
<img class="MyPics" width="200"
src="images/200px-SortDialogForDataPilotInCalc.png"
alt="Sort Dialog for DataPilot in Calc" /></a>
The DataPilot (sometimes known as Pivot Table) now supports a convenient
way of sorting and filtering entries using a special popup window.</p>
<p>For further details of this new feature please see the
<a href="http://blogs.sun.com/GullFOSS/entry/behind_the_scenes_datapilot_improvements">
GullFOSS blog article</a>.</p>
<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />
<h2>Display Custom Names for DataPilot Fields, Items and Totals in Calc
<a name="Display_Custom_Names_for_DataPilot_Fields_Items_and_Totals_in_Calc"
id="Display_Custom_Names_for_DataPilot_Fields_Items_and_Totals_in_Calc"></a></h2>
<p>DataPilot fields, items and totals can now be assigned custom display
names by typing into the corresponding cell in the DataPilot table.</p>
<h1 class="BigHead">Internationalization
<a name="Internationalization" id="Internationalization"></a></h1>
<h2>Additional Locale Data<a name="Additional_Locale_Data"
id="Additional_Locale_Data"></a></h2>
<p>Arabic (Algeria) [ar-DZ], Bafia (Cameroon) [ksf-CM],
Bushi (Mayotte) [buc-YT], Campidanese (Sardinia) [sro-IT],
Gallurese (Sardinia) [sdn-IT], Gikuyu (Kenya) [ki-KE],
Latgalian (Latvia) [ltg-LV], Logudorese (Sardinia) [src-IT],
Maithili (India) [mai-IN], Malagasy Plateau (Madagascar) [plt-MG],
Maore (Mayotte) [swb-YT], Papiamentu (Netherlands Antilles) [pap-AN],
Rusyn (Slovakia) [rue-SK], Rusyn (Ukraine) [rue-UA],
Sassarese (Sardinia)[sdc-IT], Sorbian, Tahitian (French Polynesia) [ty-PF],
Upper Sorbian (Germany) [hsb-DE], Yoruba (Nigeria) [yo-NG]</p>
<h1 class="BigHead">Developer Features and Extensibility
<a name="Developer_Features_and_Extensibility"
id="Developer_Features_and_Extensibility"></a></h1>
<h2>Grid Control Enhancements<a name="Grid_Control_Enhancements"
id="Grid_Control_Enhancements"></a></h2>
<p>The grid control now accepts additional data types like numbers or
images. The XGridDatamodel method</p>
<pre>addRow(string headerName, sequence&lt;string&gt; data)</pre>
<p>has changed to</p>
<pre>addRow(string headerName, sequence&lt;any&gt; data)</pre>
<p>You can now control the appearance of a grid control using additional
parameters for horizontal and vertical alignment, row background colors,
line colors, and text colors For more information and examples, see the
OpenOffice.org Wiki pages.</p>
<h2>New MetaData Node for Database<a name="New_MetaData_Node_for_Database"
id="New_MetaData_Node_for_Database"></a></h2>
<p>You can now define a new property in a database driver's xcu file. This
is enabled by default for MySQL (JDBC) and ADO (including Microsoft Access)
drivers. The property is defined in the MetaData section.</p>
<pre>
&lt;node oor:name="SupportsColumnDescription" oor:op="replace"&gt;
&lt;prop oor:name="Value" oor:type="xs:boolean"&gt;
&lt;value&gt;true&lt;/value&gt;
&lt;/prop&gt;
&lt;/node&gt;
</pre>
<p>When this property is enabled, the table designer will display the column
description beside the normal description which is used as help text.</p>
<h2>Extending Database Drivers Using Extensions
<a name="Extending_Database_Drivers_Using_Extensions"
id="Extending_Database_Drivers_Using_Extensions"></a></h2>
<p>Some database drivers do not support special features like altering view
definitions or adding/dropping table keys. Starting with OpenOffice.org 3.3,
the corresponding interfaces can be implemented by an extension:</p>
<pre>
com.sun.star.sdb.tools.XViewAccess
com.sun.star.sdb.tools.XTableRename
com.sun.star.sdb.tools.XTableAlteration
com.sun.star.sdb.tools.XKeyAlteration
com.sun.star.sdb.tools.XIndexAlteration
</pre>
<p>For more details on the implementation of this feature, please see the
corresponding section in the
<a href="http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Database/Extending_Database_Drivers"
title="OpenOffice.org Developer's Guide">
OpenOffice.org Developer's Guide</a>.</p>
</body>
</html>