Linked by Thom Holwerda on Sat 3rd Feb 2007 16:40 UTC, submitted by jayson.knight
Features, Office A Microsoft-sponsored open-source project is expected on Friday to release a translator that will convert file formats between Microsoft Office and rival standard OpenDocument, or ODF. Microsoft started the project at SourceForge last year, relying on three partners to develop the code that lets a user open and save word processor documents in two different formats.
Permalink for comment 208983
To read all comments associated with this story, please click here.
RE: I am curious
by hal2k1 on Sun 4th Feb 2007 05:52 UTC in reply to "I am curious"
hal2k1
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

Reply Parent Score: 2