OpenOffice.org has far more features than Google spreadsheets. If you need only very simple features and you absolutely...
need to edit files at the same time as other co-workers, then you might want to try Google spreadsheets. However, there are other issues with Google spreadsheets such as speed and security, if your organization has qualms about having its data on Google's computers. Test both types of spreadsheets first with typical daily tasks before you make a decision.
If one user opens an OpenOffice.org spreadsheet, and another user tries to open the same file, the second user can only view that spreadsheet. But I think that's a good decision; what if both users are changing the same cell at the same time? That could cause problems.
You might also try to break your spreadsheets into smaller parts. If you have a spreadsheet with 20-30 tabs, see if it's necessary to have them all together.
Dig Deeper on Linux servers
Related Q&A from Solveig Haugland
A reader asks for advice on migrating from Microsoft Works databases to OpenOffice's Base. Continue Reading
How to create electronic signatures in OpenOffice 2.0. Continue Reading
An office suite expert describes how to convert Access files to OpenOffice for a one-time use. Continue Reading