An Early Look at OpenOffice.org 3.0

ahziem writes "With the final release 167 days away and an alpha version available, it's time to look at OpenOffice.org 3.0's new features: view multiple pages in Writer, notes in the margin, Microsoft Office 2007 file format support, Solver in Calc, new visual theme in Calc, native tables in Impress, more columns in Calc, error bars in charts, performance improvements, real native Aqua Mac support, and more."

Comments

Re:Database support ?

[AKAImBatman]

Any chance to get database support outside of Windows ?

??? It already exists? OpenOffice Base has a dependency on Java, but otherwise it's available for all platforms. (The core database is HSQLDB.) As I recall, you can use either JDBC or ODBC drivers to connect to a remote database.

The data sources configured in OpenOffice Base can then be used in programs like Calc.

So... I'm not really sure what the issue is?

Re:Aqua?

[caerwyn]

You're a little confused.

Aqua is the set of widgets and such that make up the MacOS X user interface. It has evolved over the various versions of the OS, but it's still Aqua.

Quartz is the underlying PDF-based drawing technology that MacOS X uses to draw everything to the screen- including the Aqua UI widgets.

Referring to native Aqua is quite correct.

Re:For the scientists: ERROR BARS

[xtracto]

You should better go with a real statistical analysis package. Even for those kind of things in the long term it will be easier for you and they are more robust.

When I started my PhD I used Gnumeric for several statistical analysis however, after spending some time I had to learn to use a real statistical package. I went for R, which is very well known an accepted through the research community (mainly because it is the open version of S, and can be scrutinized). After using it for about six months I found it better to make even the most simple statistical analysis on it. Oh, and the charts really look professional. No matter what I did in Gnumeric (tried once in OpenOffice but its graphics capabilites simply suck \BBBbig Time), I could not obtain decent charts to add to a LaTex publication.

I would suggest rKward to use R. it is the best IDE (IMO, after trying several and trying and failing to setup several others).

One of the most important advantages of using a statistical package like R is that you can get it to output to standard output in a console. That way you can use whatever scripting language you know (I used GAWK, sed, and other bash niceties) to prepare your data to be included in whatever word processing/typsetting program you need. It really saves a lot of time.

Re:For the scientists: ERROR BARS

[proxima]

I am interested in the Standard Deviation, SEM, and a one- or two-tailed T-test. As a molecular immunologist, that's about all I need for 99% of my data analysis.

[...]
But if you can suggest a good data analysis application that runs on Linux, I will listen, and will surely try it.

I'm usually the first to encourage people to move beyond spreadsheets and use better tools for statistical analysis. That said, a spreadsheet is a really quick and easy way of doing simple data analysis, and it's perfectly fine to use it at such.

The problem comes in when people start trying to use spreadsheet applications for more complicated analysis or want to do more complicated graphics than a spreadsheet easily allows. If and when that time comes, it becomes really worthwhile to have at least one other tool in which to work. As the other reply suggested, R is a free (and excellent) implementation of the SPLUS language. The package is explicitly designed with statistical analysis and graphics in mind. In fact, a nice introduction to the language is Data Analysis and Graphics Using R - An Example-Based Approach by
John Maindonald and John Braun . You might be able to find the book at a university library before deciding whether to plunk down the money to buy it.

MATLAB is more of a general purpose language, which can be very useful for some fields and not as useful in others. It's definitely overkill to buy MATLAB to do basic statistical analysis, and it's probably not the best tool for the job unless you already know the language well. Most other commercial statistics packages (SAS, SPSS, Stata) have Linux versions, as this community has tended to be more server/unix-oriented historically.

To bring this back on topic, it's nice that OpenOffice.org is expanding its feature set in the statistical/graphing arena - I've personally found it quite lacking compared to Excel. That said, it's also important to know when you've moved beyond what a spreadsheet is relatively good at and find a package which can do the more complicated analysis. Spreadsheets and stats programs are both complements and substitutes in various ways.