Nuove caratteristiche di OpenOffice.org 3.2 Beta

!!! Work in progress - incompleto!!!

Le note tecniche complete del rilascio, contenenti l'elenco delle caratteristiche e le aree di lavoro per singolo settore, possono essere consultate qui.

Migliorie generali

Tempi di avvio ridotti

I componenti Calc e Writer in OpenOffice.org 3.2 hanno un tempo di caricamento ridotto del 46% rispetto alla versione 3.0 realizzata appena un anno fa, tempi stimati dai test condotti dai nostri sviluppatori (i risultati sono mutevoli in base ai vari sistemi operativi ed ai diversi tipi di hardware imposto).

Supporto ODF

Lo standard Open Document Format (ODF), così come promulgato dall'Organization for the Advancement of Structured Information Standards (OASIS), è completamente supportato in base ai criteri internazionali per l'immagazzinamento elettronico/digitale dei documenti.

Questi standard comprovano l'importanza dell'interoperabilità e dello scambio intelligente delle informazioni, ad esempio, per la sicurezza che ogni documento creato oggi su un qualsivoglia terminale possa essere comunque letto da qualunque altro sistema informatico come dalla tecnologia futura.

OpenOffice.org 3.2 è stato creato interamente in aderenza a quanto previsto per l'utilizzo di ODF 1.2, includso le conformità e le specifiche ad OASIS ODFF/OpenFormula.

• As OpenOffice.org 3.2 currently requires a superset of the ODF 1.2 specification, the software now warns users when ODF 1.2 Extended features have been used.

• Il controllo automatico di integrità ora controlla anche la conformità di un documento ODF alle specifiche tecniche ODF document (poichè alcuni documenti ODF potrebbero non essere del tutto conformi alla versione ODF 1.2). Se viene riscontrata una difformità, il documento viene automaticamente trattato come documento rovinato, ed OpenOffice.org si offrirà di ripristinarlo.

Supporto ai file proprietari

OpenOffice.org 3.2 provides improved support for other common office document types.

• Password protected Microsoft Office XML files (supported document types: MS Word 2007 documents (*.docx, *.docm); MS Word 2007 templates (*.dotx, *.dotm); MS Excel 2007 documents (*.xlsx, *.xlsm); MS Excel 2007 binary documents (*.xlsb); MS Excel 2007 templates (*.xltx, *.xltm); MS Powerpoint 2007 documents (*.pptx, *.pptm); MS Powerpoint 2007 templates (*.potx, *.potm)).
• OLE objects, form controls and pivot tables can now be read from MS Excel 2007 documents (*.xlsx, *.xlsb).
• Encryption support within the Microsoft Word 97/2000/XP filter allows password protected Microsoft Word documents to be saved (using the Microsoft Office standard RC4 algorithm).
• Filters for AportisDoc and PocketWord now support type detection based on DocType. As a result, files in these formats can be loaded without explicitly selecting the document type in the file picker.
• When writing string data to SYLK files, embedded double quotes are no longer escaped by doubling; semicolons are now escaped by doubling. This improves compatibility with files created by other applications.

Supporto per caratteri tipografici OpenType basati su Postscript

There are many high quality commercial and free OpenType fonts that are based on Postscript outlines. They are now supported for formatting, printing, PDF-export and display.

Writer

Completamento della correzione automatica delle parole

Writer can remember permanently any additions to the autocorrect list collected while working on a document. A new CheckBox When closing a document, remove the words collected from it from the list makes this functionality more obvious.

Supporto per Mediawiki spostato come estensione

To avoid conflicts, the MediaWiki filter is no longer part of the OpenOffice.org installation. Instead it will be supplied as a part of Wiki Publisher extension, which will permit updates for the filter without having to wait for the next OpenOffice.org release.

Calc

I bordi delle celle ora supportano la selezione multipla

Previously it was only possible to apply cell borders to a single rectangular cell range. Now borders can be applied to any selection of cells. A list of rectangular ranges is determined from the selection, and inner/outer borders are applied to each of the ranges.

Il riempimento automatico ora gestisce casse (tipografiche) aggiuntive

If the starting cell for AutoFill contains a number at the start and the end, and there's no space after the first number, the number at the end is now incremented. This allows easier creation of things like lists of IP addresses (10.0.0.1 is followed by 10.0.0.2).

Migliorie nell'ordinamento

If "Sort" is invoked with a selection that is likely not to be the range the user wants to address, a new dialog will ask if the selection should be extended to contain the additional cells.

When a cell range is sorted using the "Sort Ascending" or "Sort Descending" toolbar button, cell formats are now sorted with the cells.

Migliore gestione delle celle unite

Merged cells can now be pasted from the clipboard onto other merged cells. Instead of an error message, the old cells are unmerged

Inserting or deleting cells, columns or rows into/from the middle of merged cells, which previously caused an error message, is now possible. The merged cell range is enlarged/reduced.

Copia e incolla complesso

This feature extends Calc's current copy and paste functionality, to allow copying of a set of multiple non-contiguous ranges. When pasted, all copied data get consolidated into a single range either horizontally or vertically. There are some restrictions when ranges are being copied, in order to ensure that the pasted range become a rectangular range.

Funzioni statistiche migliorate

• NORMDIST's 4th parameter is now optional.

         o 0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function.
         o If omitted, 1 is written to files for backwards compatibility.

• LOGNORMDIST's 2nd and 3rd parameters are now optional, an optional 4th parameter has been added.

         o The 2nd, mean, parameter has the default value 0 if omitted.
         o If omitted, 0 is written to files for backwards compatibility.
         o The 3rd, standard deviation, parameter has the default value 1 if omitted. If omitted, 1 is written to files for backwards compatibility.
         o The 4th, cumulative, parameter is defined as - 0 or FALSE calculates the probability density function. Any other value or TRUE or omitted calculates the cumulative distribution function. - If a value was given, earlier releases reading the file cannot interpret the function and return an error.

These changes align with the definitions given in the OASIS ODFF/OpenFormula specification

Conservazione dei caratteri di nuova riga nelle formule

Newline characters created with Control+Enter in multiline text cells are now preserved in spreadsheet formulas. Previously the newline character was replaced by a space character. The newline character can be searched for using the SEARCH or [HV]LOOKUP or MATCH functions with the \n regular expression.

Conversione automatica di numeri in stringhe

While interpreting a formula expression, string content is now converted to numeric values if conversion is unambiguous, or a #VALUE! error is set if no unambiguous conversion is possible. Leading and trailing blanks are ignored.

Note: conversion on the fly naturally is significantly slower than calculating with numeric values. Users may be prefer the Convert Text to Number (CTN) extension to interactively convert textual numbers to permanent numeric values.

Funzionalità aggiuntive nei filtri

The "Standard Filter" dialog now shows 4 instead of 3 conditions, and has a scroll bar which allows to access up to 8 conditions in total. It now supports the filter conditions 'Contains', 'Does not contain', 'Begins with', 'Does not begin with', 'Ends with' and 'Does not end with'.

Spostamento tra i riferimenti migliorato

The Shift-F4 shortcut to toggle between relative and absolute references in formulas can now be used for a selection of cells, and handles all the formula cells in the selection.

Molti nuovi fattori in CONVERT_ADD

Calc convert_addThe CONVERT_ADD spreadsheet function (known as CONVERT in other applications) has many more conversion factors implemented, as defined in OASIS ODFF/OpenFormula.

Nuove funzioni UNICODE e UNICHAR

The new UNICODE and UNICHAR spreadsheet functions are implemented as defined in the OASIS ODFF/OpenFormula specification.

• UNICODE returns the Unicode Standard / ISO 10646 code point corresponding to the first character of the text value;
• UNICHAR (UNICODE CHARacter) returns Character for any valid Unicode code point.

Draw

Nuovo stile dei commenti

Draw now supports comments (formerly known as sticky notes) to support collaboration

Aggiunto il conteggio pagina in Draw

Draw now supports the text field "Page Count".

Impress

Nuovo stile dei commenti

Impress now support comments (formerly known as sticky notes) to support collaboration

Aggiunto il conteggio pagina in Impress

Impress now supports the text field "Page Count".

Math

Modifiche ai menu di Math

The menu entry "View / Selection" in Math is now labeled "View / Formula Elements".

Base

Procedura guida di creazione database personalizzabile

OpenOffice.org 3.2 introduces a configuration option to control the availability of the "Create new database" option in the "Create Database" wizard.

A new configuration option controls whether the "Create Database" wizard (started via File/New/Database) exposes the "Create a new database" option.

Copiatura semplificata delle query tra documenti di database

When copying queries between database documents, Base will no longer prompt for a target name, unless the copy operation would overwrite an existing table name.

Possibilità di zoom nei moduli dei database

Database forms can now be zoomed just like other documents. The current <Ctrl+Scroll Wheel> functionality is supplemented by a View/Zoom menu item, and the zoom slider in the status bar.

Importazione più intelligente in Base

The Copy Table Wizard now contains an additional check box which is enabled when RTF or HTML format data is to be copied into a database. The check box is labelled: Use first line as column names: when checked the first row is used to identify column names, when not checked the first row is treated as a normal data row.

For further details of Base new features, please see the wiki.

Chart

Nuovi tipi di grafici

The Chart Wizard - used to create charts - now also includes Bubble and a new variant of Net - Filled Net (Radar) charts.

Miglioramento dell'usabilità

The Chart user interface has been given a makeover to improve aspects of usability. Users will note the generic Object Properties tag has been replaced by more specific terms such as Format Legend.... Menus are more context aware, ensuring the tools they need are only amouse click away. For full details, please see the GullFOSS blog posting.

Migliorie alle didascalie dati

The options for data labels have been extended. It is possible now to rotate data labels. This is useful especially for column charts to avoid overlap between the different labels.

Pagina a tipografia asiatica per elementi dei grafici

A new tab page Asian Typography is now available for Title, Legend, Axes and Data Series. It contains an option to enable or disable the spacing between the different types of text.

Internazionalizzazione e localizzazioni

Nuovo supporto per le lingue locali

OpenOffice.org 3.2 adds locale data for Oromo_Ethiopia [om-ET], Uyghur_China [ug-CN], Ancient Greek [grc-GR], Somali_Somalia [so-SO], Sorbian, Lower [dsb-DE] and Upper [hsb-DE, Asturian_Spain [ast-ES], Yiddish_Israel [yi-IL], Arabic (Oman) [ar-OM], Sardinian_Italy [sc-IT, and Quechua (Ecuador) [qu-EC].

Typically, the locale is selectable for character attribution and spell-checking, as default locale and default document language, and is available for number formats and outline numbering - see the Release Notes for details.

Ordine dei nomi giapponesi

In a Japanese Locale the order of the FirstName / LastName fields in the user data tabpage is reversed. This feature is not bound to the UI language, but to the selected Locale.

Supporto per la tecnologia dei caratteri Graphite

OpenOffice.org supporta ora la tecnologia del carattere Graphite per un miglior supporto di script e varianti utilizzati dalle minoranze. Grazie a questa tecnologia, il supporto per gli script di una nuova minoranza diventa gestibile. E' necessario sviluppare un solo tipo di carattere per le esigenze specifiche di tale minoranza.