AboutWelcome to Free Software Daily (FSD). FSD is a hub for news and articles by and for the free and open source community. FSD is a community driven site where members of the community submit and vote for the stories that they think are important and interesting to them. Click the "About" link to read more...
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.
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.
The multiplatform, multilingual office suite OpenOffice.org announces the official release of version 2.4 with 9 new chart features, 5 PDF export enhancements, text to columns in Calc, rectangular selection in Writer, bug fixes, performance improvements, improvements supporting the growing library of extensions such as 3D OpenGL transitions in Impress, and much more.
The last developer milestone ( DEV300m60) of OpenOffice.org has been released. The next version of OpenOffice.org 3.2 has more than 42 features and 167 enhancements . The final version is expected to be available at the end of November 2009.
Interested in the new Chart features that will be available in OOo 3.2? Have a look: Another new chart type in OpenOffice.org 3.2 is the Filled Net Chart. Bubble Chart is available as new chart type now. Bubble Charts are similar to the XY Charts.
Of all four OpenOffice.org applications, Base is probably the most complicated one. It is a powerful tool that allows you to build complex databases, but this power comes at a price: if you've never worked with database applications, you might find Base a bit overwhelming.
If you're coming fresh from Microsoft Excel, you might wonder where the Pivot tables are in OpenOffice.org Calc. The problem is, they're masquerading under the name of DataPilots. But, under any name, DataPilots are Calc's way of allowing you to quickly reorganize information in a range of cells so that you can gain a new insight into them.
There are really only two mainstream competitors to OOo Calc, one from the GNOME Office suite and the other from KDE’s KOffice Project. However, I’ll also look at a bit more of an exotic solution after that as well.