Replies

“My next computer will not be using Microsoft Office.

I’ll be using “OpenOffice”.”

While I use both and promote OpenOffice frequently, there are a few bumps in the road. If I only had my choice of MS Access or ooBase, Access would win hands down. If it were not for a very active users forum ooBase might be unusable. Macros are just a step above hieroglyphics. Also ooBase does not allow VB to be used as a more feature rich user interface to the database. To be fair that is not OpenOffice’s fault but no VB->ooBase database file driver has been written and I don’t see that as OO’s responsibility.

I just got bit by a lack of a very useful feature in Calc. I had a bunch of columns with calculations based on values in other columns and when I inserted a row on my spreadsheet, it broke the order of the cells these calculations pointed to and all info past the insertion was wrong. Also inserting a column has a similar problem.

I have not checked if this problem extends to a 2nd worksheet in the same file with a cell link to another sheet. That could get very ugly.

A simple highlighting the offending rows/columns (250 of them) the Alt-E-I-D corrected it but had I not spotted this loss of function everything past the row insertion point would have been wrong.