Summary of new features in OpenOffice.org 2.3

Here’s a summary of the features from the 2.3 new features list that I considered the most useful or important to write about. This page  http://wiki.services.openoffice.org/wiki/New_Features_2.3 about the new features is an excellent guide, as well.

General

• This is convenient for anyone who prints to multiple printers, all over the world. You can load or ignore the printer settings for your documents. This means you don’t end up accidentally printing to the printer in building 4 which is on the opposite side of the country, just because you were on a business trip there last week and that’s where you last printed your document.
  

• If your document isn’t wider than the OpenOffice.org window, then it will be centered in the window, not left-aligned.
  

• Lots of locale information was added, for locations such as Tagalog, Frisian, and Hausa.
  

Writer and Web

• The HTML editor now has a preview feature. Choose File > Preview in Web Browser and the document opens in the default browser.

• I love this feature. You know how when you get a hyperlink but then want to retype it or reformat it, but clicking on it takes you to the target of the link? No more. You can select hyperlinked text all you want; you now have to Ctrl Click to open a link. This is very nice.
  

• The notes say that there is a new compatibility option on Tools > Options > OpenOffice.org Writer > Compatibility: Do Not Justify Alignment in Lines Ending With Manual Line Break. However, I’m mentioning this because I couldn’t see it. The illustration shows the compatibility options that are there.
  

• When you open the Styles and Formatting window (Format > Styles and Formatting), you can set what kinds of styles you wanted to see: Applied, Custom, Automatic, etc. Previously, you had to reset this every time you opened a new document or re-opened OpenOffice.org. Now, thankfully, that category will stick. The setting is saved per application. However, the choice you make for Paragraph, Character, Frame, List, or Page doesn’t stick.
  
  

• When you right-click on text, you used to see Default as one of the options. Now you see Default Formatting, which is clearer. (Default Formatting is a great way to just clear out any extraneous formatting and apply the default style to the selected item.) This is a very nice feature regardless of the text; for one thing, it’s the best way to remove the hotlink from a URL.
  

• A new export filter lets you export to MediaWiki format. Choose File > Export and select MediaWiki in the file format list.

Calc

• This is a very, very smart change. By default, the print options for Calc are now set to Print Only Selected Sheets and Suppress Output of Empty Pages. If the Print Only Selected Sheets option is enabled, the Calc page preview shows only the displayed sheet and the message “There is nothing to print.” To change these options, choose Tools > Options > OpenOffice.org Calc > Print, or choose File > Print and click the Options button.
  

• Here’s another very smart change that will screw up all my documentation. :) The SUM icon on the main Calc toolbar has changed. Now you can select the range of numbers to add, click the SUM icon, and get the total in the first cell below the selected range. Phew. But if you liked it the old way, it still works that way, too.
  

• Graphics can be linked to macros. This should help with Excel compatibility.
  

• The Excel export filter now handles the cotangent functions COT, ACOT, COTH, and ACOTH.

• Calc now supports inline matrix/array constants in formulas. An inline array is surrounded by curly braces '{' and '}'. Elements can be each a number (including negatives), a logical constant (TRUE, FALSE) or a literal string. See this link for more detail. http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=230

• You can now use dynamic ranges, rather than absolute ranges defined with $, in lists in Data Validity. Choose Data > Validity, and under the Criteria tab select Cell Range from the list.
  
  

• The GETPIVOTDATA function returns a result value from a DataPilot table, so it can be used in a cell formula.
  

Mail Merge, Databases, and Forms

• The infamous checkbox on the print message when you print a mail merge document, Do Not Show Warning Again, is gone. Phew! See this blog http://openoffice.blogs.com/openoffice/2006/10/how_to_get_the_.html for why that caused problems.
  
  

• This is nice. When you choose File > Print with a mail merge document, in the Mail Merge window, you can choose to save the document as separate documents or as one document.
  
  

• Unfortunately, in Base there is still no File > Export or File > Import feature. File > Export does appear, but it’s dimmed.

---

---

Comments

[rodrigo]

Hello.

Your blog is very useful.
There is some problem if I translate your post to the Spanish in my blog?.

Greetings.

Rodrigo.

[Solveig]

Hi Rodrigo,

Thanks! No problem with translation as long as you link to the original entry.

Solveig

[Dov]

Hi' nice blog.
Do you know Is there is compatibility white MS DOCX ?

[Solveig]

Hi Dov,

I was just exchanging emails with someone who said that they had problems before with docx but now it's working fine with 2.3.

Solveig

[Dov]

Can you give an update about the Docx issue when you will know ?

[JZA]

Hi Solveig I made a presentation for OOo 2.3 that has also generated great demand. I put it around 1 week ago and it already generated around 3656 views.

Unfortunately is in spanish but maybe it will inspire you to do something similar:
http://www.slideshare.net/jza/openofficeorg-23-innovacion-sin-paralelo/

[John Bishop]

A note on the new Justify settings.
The new setting is there, it's just worded in a strange way. The last line that starts with "Expand word space..." is what you need to uncheck to avoid justifying lines with manual breaks.

[Charles R Gaush]

With Ubuntu Hardy Heron, I am trying to print a spreadsheet which has always printed before. Now I get the error message "There is nothing to print. Selected page range or sheet is empty". However it printed a beautiful test page, very colorful! Why is this thing being so stubborn - I thought Ubuntu was supposed to be very intuitive?

[Solveig]

Hi Charles,

that's odd! I would try Format > Print Ranges > Remove or > Edit and see if a print range got slapped on. Also try Format > Cells, Cell Protection tab, and see if Hide When Printing got turned on.

[Ashok Marar]

With MS Office Excel, we can send our selected range of cells as message body in our e-mail. Is this method possible with Oo.Calc. One more question is, I changed the cell format in Oo.Calc as dd-mm-yy(User Defined), but most of my sheets needed to type 07-15-08 instead of 15-07-08.

Expecting a favourable reply.

Regards,

Ashok Marar

[Titus]

Hi!
I have the same question as Ashok. I was wondering if it is possible to send the active worksheet as message body in an email, using Evolution preferrably.
Kind regards!
Titus