Like other OpenOffice.org applications, Calc has several dozen options in how it is formatted and operates. These options are available from Tools -> Options -> OpenOffice.org Calc. Thanks to OpenOffice.org's habit of sharing code between applications, some of the tabs for these options resemble those found in other OpenOffice.org applications.

Spreadsheets might be called databases for the timid, since they're more user-friendly than databases and do a good job working with limited amounts of data. Some tools for databases can work well with spreadsheets too. Take for instance DataForm, a new OpenOffice.org Calc extension that provides a form-like interface designed to make entering and finding spreadsheet data easier.

While OpenOffice.org Base is good for storing and querying data, it doesn't provide any easy way to chart information. This is exactly what Calc does best, with its dedicated chart module. If you want to visualize data stored in a Base database, you can write an OOo Basic macro that pulls data from a database, inserts it into a Calc spreadsheet, and then creates a chart. Here's how.

I've been talking about using the Navigator in Writer. Here are a few ways to use the Navigator in OpenOffice.org Calc spreadsheets.

There is a hidden game in the Openoffice Spreadsheet program Calc, the game is an Easter Egg that let’s you play a simple version of Space Invaders, titled StarWars Galaxy, so if you are working with openoffice and you need a break, you do know what to do ;).

You can have virtually any shortcuts you want in OpenOffice.org. There are a zillion features you don't know about that you can apply shortcuts to. It's really easy to do. And once you've got it set to your preferences, you can easily give the file to your friends.

In-cell charting is not a new idea: do a quick Web search, and you'll find quite a few examples of how to create in-cell charts. While most of these examples are designed to work with Excel spreadsheets, you can easily use in-cell charting techniques in Calc.

This is an explanation of the news post (http://www.fsdaily.com/Community/Sun_Refuses_LGPL_for_OpenOffice_Novell_...) you should read it before you read this...

"Kohei Yoshida wrote a long post on the history of Calc Solver, an optimization solver module for the Calc component of OpenOffice.org. After three years of jumping through Sun's hoops on his own time, Sun says it will duplicate the work because Kohei doesn't want to sign over ownership of the code. Adding insult to injury, Sun then invites him join this duplication.