{section}
{column:width=30%}
{Panel:|borderColor=#EEE|bgColor=#FFF}
{toc:style=disc|indent=5px|maxlevel=3}
{Panel}
{column}
{column}
In addition to the [New Features in StarOffice 9], numerous changes were introduced with the update version StarOffice 9.1:
h2. General Improvements
Many improvements were developed in the time between the StarOffice 9.0 and StarOffice 9.1 release. The following improvements enhance the screen presentation and usability of all program modules.
h3. Improved screen appearance
StarOffice now uses a technique called anti-aliasing to improve the way it draws on screen (lines, circles, etc). You will notice an immediate improvement in the clarity of graphics - particularly charts - wherever they appear throughout StarOffice.
!anti.jpg|width=375px,align=none,vspace=5!
Using modern graphics display adapters, you will recognize an improved 'graphic geometry' - e.g. when you overlay one shape on another to create a combined shape.
h3. Making 'dragging' easier with graphics
When you drag an object in a drawing across the screen, StarOffice now shows you a 'shadow' of the object, rather than just a dotted outline. This makes it much easier to place images accurately in complicated drawings.
!drag.jpg|width=375px,align=none,vspace=5!
h3. Improved file locking
If you are working on a network where several people may have access to the same document, file locking prevents people accidentally overwriting other people's changes. As StarOffice works on different operating systems, it cannot rely on the operating system alone to tell users when a document is in use. StarOffice now has its own mechanism, which allows it to have a reliable locking when the locking from the operating systems fails. It also allows StarOffice to see who has already opened the document.
h3. Overlining
StarOffice now supports overlining for text as well as underlining, with the same range of options as underlining (type of line, colour).
!over.jpg|width=375px,align=none,vspace=5!
h2. Writer
h3. Subtle highlights
Highlighted text is now displayed with a subtle background colour, rather than reverse video. Easier on the eye, easier to use.
h3. Improvements to Comments
It's now possible for a series of editors to carry out a structured conversation through Comments, by right-clicking on a Comment and selecting 'Reply'.
As a further enhancement, the Search facility now also searches the text of Comments.
h3. Further grammar checker integration
With StarOffice 9.1, the grammar checker framework has been extended. Note that StarOffice has a grammar checking framework, but does not come with a grammar checker. This can be installed as an Extension.
h3. Outline levels within paragraphs
Writers of documents with complex ordering formats can now specify a new paragraph and paragraph style attribute "outline level". This transforms a normal paragraph into a heading, independent of any list style or paragraph style.
!outl.png|vspace=5!
h2. Calc
h3. Rename sheets with a double-click
Double-clicking on a tab in a Calc sheet now pops up the Rename dialog box. In previous versions, you had to right click on the tab and then select the Rename option from a pop-up box. This change makes it easier to carry out this frequently-used function.
h3. Zoom slider in the Status bar
The new zoom slider control in the Status bar was a popular addition to Writer in StarOffice 9.0. With 9.1, it's available in Calc, Draw, and Impress, too, giving quick and accurate control over the level of zoom of the display on the screen.
h3. Formula hot hints
Calc now keeps the syntax of a formula displayed right next to the cell as you type as a handy aide-memoire for how to use a formula.
!calcprev.png|vspace=5!
h3. Improved sorting
There are a number of changes to make sorting more logical, consistent, and powerful. The first time you use sort (or if you use the toolbar button to sort), Calc will assume you want to sort by the column where the cursor is located. The toolbar buttons now use the same logic as the sort dialog to determine if a range has column headers. Finally, when you sort, Calc now preserves the original order of entries with equal sort keys.
h3. Formulae changes
A new EUROCONVERT spreadsheet function to convert between former currencies of the Eurozone, including import from and export (binary) to MS-Excel file formats.
New GAMMA, CHISQDIST, and CHISQINV spreadsheet functions, and changes to GAMMADIST, CHIDIST, and CHIINV spreadsheet functions for statistical analysis.
The BETADIST spreadsheet function now has an additional optional 'cumulative' parameter to specify whether to calculate the probability density function or the cumulative distribution function, defaulting to TRUE for compatibility.
h3. Performance improvements
Performance bottlenecks in Calc have been removed, resulting in dramatic performance improvements in the two test cases: from 24 seconds to 1.2 seconds in the first case; and from one hour to approx 12 minutes in the second case. This is part of a continous improvement activity to squeeze performance improvements from Calc.
h2. Chart
h3. Flexible positioning of axes
StarOffice charts now offer a range of options for the placement of axes. This feature has been in great demand, particularly from educational users.
!chartpos.png|vspace=5!
h3. Handling missing data
You may now also choose how StarOffice charts handle missing data points - leave a gap, assume zero, or continue the line through the missing value.
!chartgap.png|vspace=5!
h2. Impress
h3. Font size buttons
Impress now has convenient toolbar buttons to increase or decrease the font size of text quickly and easily. Make your text fit perfectly in seconds\!
!incrfont.png|vspace=5!
h2. Base
h3. SQL Syntax highlighting
When you edit SQL, Base now uses colours to highlight SQL syntax. It will also 'flash' to indicate matching parentheses (). This makes it easier to spot spelling mistakes, errors in your SQL syntax, etc.
You can create your own colour schemes using Tools \-> Options \-> StarOffice \-> Appearance \-> SQL Syntax Highlighting, and choose your own font from Tools \-> Options \-> StarOffice \-> Fonts.
h3. Macro applications in Base
With StarOffice 9.1, it is possible to build a complete 'database application' by including macros and scripts within a Base document (.odb). This feature already exists in other document types.
!macrowiz.png|vspace=10!
This means macros can now be run from either the document itself, or any of its sub components: forms, reports, table design, query design, relation design, table data view. This is an important enhancement for people wishing to create complete 'packaged applications' in Base.
Note: developers creating Base applications are advised to read the [wiki article|http://wiki.services.openoffice.org/wiki/Base/New_features_in_3_1|New Base Features in 9.1] for important information about other developer features, and backwards compatibility issues.
h2. Internationalization and Localizations
h3. Arab version of StarOffice 9.1
StarOffice 9.1 is available in an Arabic language version. The user interface, the locale settings, and more, are Arabic. The Help is English for this time.
!ARAB_01.PNG|width=700px,align=none,vspace=5!
StarOffice 9.1 adds new Arabic locales to the language list box, selectable for character attribution and spell-checking: Arabic (Chad), Arabic (Comoros), Arabic (Djibouti), Arabic (Eritrea), Arabic (Israel), Arabic (Mauritania), Arabic (Palestine), Arabic (Somalia), Arabic (Sudan). The language table and list box now also have an "Arabic" entry (without region/country) which doesn't correspond to a locale. It doesn't provide language attribution etc, but is selectable if an Arabic language pack is installed, instead of the previous "Arabic (Egypt)".
h3. Improved support for bidirectional scripts
Complex Text Layout and BiDirectional Text have improved considerably especially for justified text and for vocalized text.
Control forms and Charts now support BiDirectional layouts.
h3. New Locale support
StarOffice 9.1 adds locale data for Maltese (Malta), Myanmar (Myanmar), Shuswap (Canada), and Tok Pisin (Papua New Guinea). The locale is selectable for character attribution and spell-checking, as default local, default document language and available for number formats and outline numbering.
{column}
{section}
{column:width=30%}
{Panel:|borderColor=#EEE|bgColor=#FFF}
{toc:style=disc|indent=5px|maxlevel=3}
{Panel}
{column}
{column}
In addition to the [New Features in StarOffice 9], numerous changes were introduced with the update version StarOffice 9.1:
h2. General Improvements
Many improvements were developed in the time between the StarOffice 9.0 and StarOffice 9.1 release. The following improvements enhance the screen presentation and usability of all program modules.
h3. Improved screen appearance
StarOffice now uses a technique called anti-aliasing to improve the way it draws on screen (lines, circles, etc). You will notice an immediate improvement in the clarity of graphics - particularly charts - wherever they appear throughout StarOffice.
!anti.jpg|width=375px,align=none,vspace=5!
Using modern graphics display adapters, you will recognize an improved 'graphic geometry' - e.g. when you overlay one shape on another to create a combined shape.
h3. Making 'dragging' easier with graphics
When you drag an object in a drawing across the screen, StarOffice now shows you a 'shadow' of the object, rather than just a dotted outline. This makes it much easier to place images accurately in complicated drawings.
!drag.jpg|width=375px,align=none,vspace=5!
h3. Improved file locking
If you are working on a network where several people may have access to the same document, file locking prevents people accidentally overwriting other people's changes. As StarOffice works on different operating systems, it cannot rely on the operating system alone to tell users when a document is in use. StarOffice now has its own mechanism, which allows it to have a reliable locking when the locking from the operating systems fails. It also allows StarOffice to see who has already opened the document.
h3. Overlining
StarOffice now supports overlining for text as well as underlining, with the same range of options as underlining (type of line, colour).
!over.jpg|width=375px,align=none,vspace=5!
h2. Writer
h3. Subtle highlights
Highlighted text is now displayed with a subtle background colour, rather than reverse video. Easier on the eye, easier to use.
h3. Improvements to Comments
It's now possible for a series of editors to carry out a structured conversation through Comments, by right-clicking on a Comment and selecting 'Reply'.
As a further enhancement, the Search facility now also searches the text of Comments.
h3. Further grammar checker integration
With StarOffice 9.1, the grammar checker framework has been extended. Note that StarOffice has a grammar checking framework, but does not come with a grammar checker. This can be installed as an Extension.
h3. Outline levels within paragraphs
Writers of documents with complex ordering formats can now specify a new paragraph and paragraph style attribute "outline level". This transforms a normal paragraph into a heading, independent of any list style or paragraph style.
!outl.png|vspace=5!
h2. Calc
h3. Rename sheets with a double-click
Double-clicking on a tab in a Calc sheet now pops up the Rename dialog box. In previous versions, you had to right click on the tab and then select the Rename option from a pop-up box. This change makes it easier to carry out this frequently-used function.
h3. Zoom slider in the Status bar
The new zoom slider control in the Status bar was a popular addition to Writer in StarOffice 9.0. With 9.1, it's available in Calc, Draw, and Impress, too, giving quick and accurate control over the level of zoom of the display on the screen.
h3. Formula hot hints
Calc now keeps the syntax of a formula displayed right next to the cell as you type as a handy aide-memoire for how to use a formula.
!calcprev.png|vspace=5!
h3. Improved sorting
There are a number of changes to make sorting more logical, consistent, and powerful. The first time you use sort (or if you use the toolbar button to sort), Calc will assume you want to sort by the column where the cursor is located. The toolbar buttons now use the same logic as the sort dialog to determine if a range has column headers. Finally, when you sort, Calc now preserves the original order of entries with equal sort keys.
h3. Formulae changes
A new EUROCONVERT spreadsheet function to convert between former currencies of the Eurozone, including import from and export (binary) to MS-Excel file formats.
New GAMMA, CHISQDIST, and CHISQINV spreadsheet functions, and changes to GAMMADIST, CHIDIST, and CHIINV spreadsheet functions for statistical analysis.
The BETADIST spreadsheet function now has an additional optional 'cumulative' parameter to specify whether to calculate the probability density function or the cumulative distribution function, defaulting to TRUE for compatibility.
h3. Performance improvements
Performance bottlenecks in Calc have been removed, resulting in dramatic performance improvements in the two test cases: from 24 seconds to 1.2 seconds in the first case; and from one hour to approx 12 minutes in the second case. This is part of a continous improvement activity to squeeze performance improvements from Calc.
h2. Chart
h3. Flexible positioning of axes
StarOffice charts now offer a range of options for the placement of axes. This feature has been in great demand, particularly from educational users.
!chartpos.png|vspace=5!
h3. Handling missing data
You may now also choose how StarOffice charts handle missing data points - leave a gap, assume zero, or continue the line through the missing value.
!chartgap.png|vspace=5!
h2. Impress
h3. Font size buttons
Impress now has convenient toolbar buttons to increase or decrease the font size of text quickly and easily. Make your text fit perfectly in seconds\!
!incrfont.png|vspace=5!
h2. Base
h3. SQL Syntax highlighting
When you edit SQL, Base now uses colours to highlight SQL syntax. It will also 'flash' to indicate matching parentheses (). This makes it easier to spot spelling mistakes, errors in your SQL syntax, etc.
You can create your own colour schemes using Tools \-> Options \-> StarOffice \-> Appearance \-> SQL Syntax Highlighting, and choose your own font from Tools \-> Options \-> StarOffice \-> Fonts.
h3. Macro applications in Base
With StarOffice 9.1, it is possible to build a complete 'database application' by including macros and scripts within a Base document (.odb). This feature already exists in other document types.
!macrowiz.png|vspace=10!
This means macros can now be run from either the document itself, or any of its sub components: forms, reports, table design, query design, relation design, table data view. This is an important enhancement for people wishing to create complete 'packaged applications' in Base.
Note: developers creating Base applications are advised to read the [wiki article|http://wiki.services.openoffice.org/wiki/Base/New_features_in_3_1|New Base Features in 9.1] for important information about other developer features, and backwards compatibility issues.
h2. Internationalization and Localizations
h3. Arab version of StarOffice 9.1
StarOffice 9.1 is available in an Arabic language version. The user interface, the locale settings, and more, are Arabic. The Help is English for this time.
!ARAB_01.PNG|width=700px,align=none,vspace=5!
StarOffice 9.1 adds new Arabic locales to the language list box, selectable for character attribution and spell-checking: Arabic (Chad), Arabic (Comoros), Arabic (Djibouti), Arabic (Eritrea), Arabic (Israel), Arabic (Mauritania), Arabic (Palestine), Arabic (Somalia), Arabic (Sudan). The language table and list box now also have an "Arabic" entry (without region/country) which doesn't correspond to a locale. It doesn't provide language attribution etc, but is selectable if an Arabic language pack is installed, instead of the previous "Arabic (Egypt)".
h3. Improved support for bidirectional scripts
Complex Text Layout and BiDirectional Text have improved considerably especially for justified text and for vocalized text.
Control forms and Charts now support BiDirectional layouts.
h3. New Locale support
StarOffice 9.1 adds locale data for Maltese (Malta), Myanmar (Myanmar), Shuswap (Canada), and Tok Pisin (Papua New Guinea). The locale is selectable for character attribution and spell-checking, as default local, default document language and available for number formats and outline numbering.
{column}
{section}