Linked by Thom Holwerda on Sat 3rd Feb 2007 16:40 UTC, submitted by jayson.knight
Permalink for comment 208983
To read all comments associated with this story, please click here.
To read all comments associated with this story, please click here.




Member since:
2005-11-11
//I know there are some features in Excel (like Pivot Tables) that is missing or limited in oo.o or koffice.//
In OpenOffice Calc, to do the equivalent of a pivot table, you select Data->Data Pilot from the menus. There is not quite the power provided in the OpenOffice application as you get with Excel pivot tables.
http://www.openofficetips.com/blog/archives/2004/09/datapilot_101.h...
http://www.openoffice.org/product/calc.html
"Advanced DataPilot technology makes it easy to pull in raw data from corporate databases; cross-tabulate, summarise, and convert it into meaningful information."
There is no problem in viewing pivot tables from Excel spreadsheets, and no problem for the ODF format to store a pivot table. The small limitations of OpenOffice are in the OpenOffice application itself, not in the ODF format per se.
Edited 2007-02-04 06:11