Linux.com

Feature: Office Software

Test-driving OpenOffice.org 3.0

By Bruce Byfield on April 04, 2008 (4:00:00 PM)

Share    Print    Comments   

With OpenOffice.org 2.4 just released, OpenOffice.org 3.0 (OOo3) has already passed its feature freeze, and is scheduled for release in September. Based on recent development builds, what can you expect? In the Base, Draw, and Math applications, very little change, at least so far. But in the core programs of Writer, Impress, and Calc, some long-awaited new features are arriving. Combined with the improvements in the charting system that are the major feature of the 2.4 release, these new features promise to increase both usability and functionality, although some of the changes do not go far enough.

You can download packages for OOo3 development builds from the /developer/DEV300_m3 directories of the project's mirror sites, or from Pavel Janik's site. The packages can co-exist alongside other OOo installations, but you should not try to exchange files between the development build and existing versions, because OOo3 uses version 1.2 of the Open Document Format, which existing versions cannot read. While recent builds are remarkably stable, you probably shouldn't count on later ones being equally reliable.

The changes

Instead of opening on a blank gray editing window like earlier versions, OOo3 opens on a selection of icons for starting the basic applications -- a much more useful default for beginners, who might not think to open the File menu. Another new feature lets you password-protect your changes for collaborative editing, and you can now use a scanner from Impress and Draw. Designers in particular can also look forward to support for PostScript-based OpenType fonts and an item in the Insert menu for inserting non-breaking spaces and hyphens, in case they have trouble remembering the keyboard shortcuts.

The Write word processor benefits from several small but significant changes. Those whose documents contain paragraphs in multiple languages and who have started a spell-check only to find the program skipping whole paragraphs can now visit the Language sub-menu to change language settings on the fly.

Another major change is the expansion of cross-references. Instead of laboriously highlighting a reference and naming it, you can now add cross-references by selecting heading styles, bookmarks, or number paragraphs. This change brings Writer into line with other word processors by allowing you to easily use precisely the elements you are most likely to cross-reference. Disappointingly, though, building a cross-reference continues to be unnecessarily laborious, with no capacity for saving reference patterns (such as "For more information, see" to make the process easier.

But the most important change in Writer is the addition of View -> Zoom -> Columns. This new view allows you to display as many pages as you want side by side. It is particularly useful if you check the Book Mode box, so that you can display a document the way it would appear in a book, with the first page alone on the right, and subsequent two-page spreads appearing together. Until now, the only way to see a two-page spread was by selecting File -> Page Preview, which gave you a view that both required fiddling and was uneditable. For designers, Book Mode means that document design suddenly has fewer distractions and is therefore much easier.

The Calc spreadsheet also has several changes, although they tend to be minor compared to those in Writer. Calc's maximum number of columns has increased from 256 to 1,024, giving it parity with Microsoft Excel, but how useful this feature is to average users is debatable, especially since, if you have that many columns, you should almost certainly be switching from a spreadsheet to a database.

Advanced Calc users may notice a redesigned Solver. In addition to solving a formula for a minimum or maximum value, the new Solver also allows you to solve for an absolute value. More importantly, you now enter further limiting conditions within the main dialog window instead of opening an additional dialog that obscures the conditions you already entered.

In addition, Calc's highlighter is now translucent instead of solid black. This small change means that the act of selecting a file no longer displays the characters in it in hard-to-see white on black while obscuring the rest of the formatting. Remembering your place is so much easier with this change that I wish that other applications would do highlighting the same way.

But probably the biggest single change in any application so far is the introduction of tables to the Impress slide show application. The lack of tables has always been one of the ways that Impress fell short of Microsoft PowerPoint, and the workaround of drawing individual boxes for table cells is both time-consuming and clumsy. The new tables include a floating toolbar much like the one used for tables in Writer, and a new Table Design tray in the Task pane that includes several dozen preset styles.

Somewhat annoyingly, the default style is for colored cells, which means that slide show designers cannot quickly copy their habits when working in HTML and use tables for complex formatting. Moreover, the fact that you cannot nest tables further frustrates such efforts. Still, with OOo's drawing tools -- especially text frames -- you may have less need of such kludges, and the addition of tables at all is a major enhancement.

Still coming

These are not the only features scheduled for OOo3. For Mac users, the big news is that OOo3 will run natively for them, instead of under X Windows. Users who have to exchange files with users of the latest version of Microsoft Office may appreciate the coming translation filters for the new OOXML format, although you can already open and read simple documents in the format in OOO2.3.

Originally, too, OOo3 was supposed to be bundled with Mozilla Thunderbird to satisfy the frequent demands for an Outlook clone to go with the office programs. However, so far, the development builds give no indication of that change, nor of the rumored ability to edit PDF documents.

Judging OOo3 from the current build is probably rash. But, so far, OOo3 looks like less of a radical change than OOo2, which featured a major interface redesign, as well as dozens of features. Perhaps that is just as well. A new interface might have followed Microsoft Office's example and replaced tool bars and menus with ribbons, a change that would likely prove unpopular.

As for other features -- well, many builds are still to come between the current ones and the final release. But, even if more features are not forthcoming, those that are implemented are already enough to make OOo3 thoroughly welcome.

Bruce Byfield is a computer journalist who writes regularly for Linux.com.

Share    Print    Comments   

Comments

on Test-driving OpenOffice.org 3.0

Note: Comments are owned by the poster. We are not responsible for their content.

Test-driving OpenOffice.org 3.0

Posted by: Stephen P Rufle on April 04, 2008 05:04 PM
PDF editing +1 , I generally just need to remove a page.

#

Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 67.152.160.2] on April 04, 2008 06:00 PM
When do we get the ability to open files across a network??

#

Re: Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 12.111.169.2] on April 04, 2008 06:33 PM
I already do that every day. If I open a file with "smb://server/share/file" it asks me for my credentials and opens right up. Yes, this is from a Linux box connecting to a Windows server. No, it's not perfect, but it lets me do the work I need to more easily.

#

Re: Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 216.46.201.115] on April 04, 2008 07:40 PM
I open documents across the network all the time using KIO slaves. I am using 2.3 bundled with Kubuntu Gutsy.

File->Open->fish://<user@>hostname<:port>/path/to/file

As long as the other machine is running ssh you are good to go, no need for samba, nfs, etc.

#

Re: Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 64.160.184.131] on April 05, 2008 12:21 AM
At work, where I have a direct ethernet connection to our server, OOo 2.3 & 2.4 have always opened files across the network. At home, I VPN in to work (and I use OpenSuSE Linux 10.3) to create, access, modify, save, and print my files. I don't get what problem "67.152.160.2" is having.

#

Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 64.221.219.104] on April 04, 2008 06:55 PM
I think the big problem with using OO on a network is that you cannot share a file across a network. You are able to do this with MS Office and we would be using OO today if that capability were available. Since the early versions of OO I have seen a request for this feature, but they have been unable to come up with a solution. Therefore a large number of corporate and mid-size company users cannot use OO. I just had a VP the other day ask me when we could start using OO instead of MS. I had to tell him that for a small number of temporary workers we are using it, but for 98% of our employees it would just bring us to a grinding halt, because of our dependency on shared files.

#

Re: Test-driving OpenOffice.org 3.0 - sharing

Posted by: Anonymous [ip: 10.174.103.141] on April 05, 2008 12:08 AM
I have used OO to work with files on our networked file server without difficulty since version 1.x. There is no problem in sharing the file. However, a notice doesn't pop-up if the file you open is currently being accessed by another network user. Instead, the file opens as read-only, and this is indicated in the window header by "(read only)" and by a prevention of changes to the document displayed. The user still has the "save as" option to proceed as necessary. This is similar to the MS office function, with the exception of the pop-up. So share away :) !

#

Re(1): Test-driving OpenOffice.org 3.0 - sharing

Posted by: Anonymous [ip: 10.10.96.198] on April 05, 2008 02:20 AM
MS Office also allows multiple users to edit the document simultaneously and has had the feature for quite a while. OO3 will have this too if IIRC from the m3 build.

#

Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 65.112.244.2] on April 04, 2008 07:06 PM
Thanks for bringing up the cross references.

Corrections:
1. PDF import is coming for 3.0, but it's just not in the 3.0 alpha binary available today.
2. Changing languages for spell check is already in 2.4
3. OpenOffice.org 2.x can open ODF 1.0 files but advanced features will be lost
4. OpenOffice.org 2.x vanilla edition cannot read OOXML files out of the box, but there are many workarounds

More information is at OpenOffice.org's 3.0 new features (with screenshots).

--Andrew Z.
[Modified by: nanday on April 06, 2008 06:50 PM]

[Modified by: nanday on April 06, 2008 06:51 PM]

#

Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 70.107.143.10] on April 04, 2008 07:40 PM
I'm not sure what the problem is in this last comment, so perhaps I'm not getting what exactly he/she means by "share a file across a network," or at least what kind of network is involved. I work with a mixed network that includes Mandriva (KDE), Debian (Gnome), and Windows XP, and edit, save, and print shared files all the time. Each one of the three I mentioned has its own way of doing things, but once you work that out, everything is mostly fine, though I do have to say that XP (either flavor, Home or Pro) is the crankiest and most demanding. Where Openoffice is concerned, Debian with Gnome is the simplest - you just access a share open a file, edit, print, or save it. Mandriva with KDE needs a little more, but the simplest way is to use smb4k, which creates a mount point in your home folder. I put a link to that on my desktop, and Openoffice will open, print, etc. any share in that folder without complaint. This means I have to make sure that smb4k properly accesses those shares automatically when I boot up in the morning. Windows, I dunno. I mostly don't like to use it for editing because it seems slow even when accessing another Windows machine on the network, and it gets crazy about something like printing a file on another Windows machine to a network printer. But none of that is related to Openoffice per se, and rather than try to figure out whassup is and try to correct it, I mostly use the Linux machines for all the opening, editing, printing, and saving with openoffice. Much simpler. Anyway, I don't see Openoffice as the problem when working on a network. Each OS/distro/desktop seems to need something a little bit different, but all I've tried so far manage the task.

#

Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 66.151.59.138] on April 04, 2008 08:01 PM
Inkscape 0.46 lets you open, edit, and export pdf files perfectly. It was just released a few days ago and if you aren't lucky enough to be running Linux, they have windows versions also.

http://www.inkscape.org

#

Re: Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 71.115.63.76] on April 04, 2008 08:28 PM
Thanks for that information!

#

OOBase?

Posted by: Anonymous [ip: 137.229.96.114] on April 04, 2008 11:28 PM
Why is oobase receiving so little attention? I'd much rather use an open-source database program rather than Access for my personal projects... but Access 2007 has really left oobase in the dust as far as features are concerned.

#

OOBase

Posted by: Anonymous [ip: 62.49.242.3] on April 05, 2008 02:32 AM
OOBase really needs attention - we really need an access replacement to complete the package - we are mainly stuck with access to:
quickly generating complex reports in various formats and adding a script to automate and distribute them
.
adhoc data queries and updates connecting to a postgresql database.

OOBase gets my vote as a todo

#

Re: OOBase

Posted by: Anonymous [ip: 216.138.229.88] on April 06, 2008 03:37 PM
I am so glad to hear that others have the same concerns as I do about OOBase.

With the aquisition of MySQL, the potential exists for implementing a back-end that is far more robust that MS Access. That said, as a very quick (and very dirty) development tool, MSAccess is hard to match.

DISCLOSURE NOTE: I have ORACLE experience and found it's development tools to be superior in every respect (as you would expect at ORACLE's prices).

OOBase has crashed on me more times that I can remember and it is just not up to the job. I know that tons of work has been done by very good and well-intentioned people. I just wish that this was shipped over to Google's Summer of Code (as a start) and to have some monies come from Sun as well.

Last note: you could develop ORACLE's forms (in 8i) and then compile them right to java. They were immediately browser ready and platform independant. With Sun's opening of JAVA, if OOBase could achieve this, it would be amazing.

#

OOBase and why main components are more important

Posted by: Anonymous [ip: 80.235.55.204] on April 05, 2008 07:22 AM
While many people do wish to have a better OOoBase, then from what I've gleaned from development discussions in OOo's IssueZilla, is that much effort appears to be concentrating on framework and document format stuff, where some of the new issues depend on the document format specification, which must be updated before any changes are to be included in the code.

Some of the examples:
* ODF formula spec;
* Document comments /some basic/useful functionality can be seen in OOo 3.0 beta with existing comments functionality in the document format;
* Use of the overbar, which is important for electric/scientific/language uses. I don't know yet if the overbar (or overline) has been implemented into the ODF 1.2 spec yet or not.

Other outstanding issues are related to how dictionaries are installed both by administrators and normal users of a system and which would be the various default dictionaries installed by language editions of OOo and how the dictionaries are managed /issues pertaining to installation and removal and custom dictionaries.

The changes were considered to be so drastic that the target milestone was actually set to 3.0 /by then it was apprarently unfortunately too late for 2.4 anyway, which has reportedly come to bear the burden of being the last branch for Windows 98/Me :/.

I did notice some slight improvements in performance for 2.4 when loading a file with a WMF image in it. The improvement was actually that opening that particular file took about as much time, which means that the loading/opening time remained the same, despite changes in package bytesize.

To sum it up, the OOo people are working hard at modularizing the whole package, one of the reasons being that of several parties which want to use their own branding and include some of their own features, while keeping the base intact and separate; some people only want to generate documents, some others want to convert them and others yet want to use only specialized functions that still use the same document format.

Framework and modularization ideas here:
http://odftoolkit.openoffice.org/proposal.html

For new features in 2.4, see
http://wiki.services.openoffice.org/wiki/Features#Features_for_the_2.4_Release_.28March_2008.29

#

Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 89.57.44.104] on April 05, 2008 09:29 AM
In my opinion covers the article only very view features which will make in OO.o 3.0. There will be
* a bunch of performance improvements
* Notes2
* Error bars from cell ranges
to name a few. I can highly recommend everybody to read:
http://www.oooninja.com
http://blogs.sun.com/GullFOSS
http://planet.go-oo.org/
to get at least a little overview what is going on in the OOo development.

#

Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 74.47.80.105] on April 05, 2008 01:56 PM
When will we see UML icons in draw/impress?? So simple, yet its been a feature request since 2003!

#

Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 71.218.31.121] on April 06, 2008 05:20 PM
I just want a tabs option in my word processor similar to Firefox.

#

Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 149.173.6.110] on April 10, 2008 07:21 PM
Interesting that OOo has a bug since 1.0 and still not fixed in early 3.0 - if the document has more than 65535 styles it will crash on document close and may crash at some style or find/replace operations. Except that crash is pretty bad by iself it seems like this can be used as a security problem (as it is a buffer overflow).

#

Test-driving OpenOffice.org 3.0

Posted by: Anonymous [ip: 194.46.182.191] on April 18, 2008 12:03 AM
What many of us need is decent bibliographic software integrated with OO Bibus allegedly does this, but I have never been able to make
it work. Endnote is still far better in operation, but does not run on Linux

#

This story has been archived. Comments can no longer be posted.


 
Tableless layout Validate XHTML 1.0 Strict Validate CSS Powered by Xaraya