Carl Lowenstein wrote: > Is there any good way to transfer a spreadsheet developed in Gnumeric > to OpenOffice Calc? The export translator (ssconvert) from Gnumeric > to MS Excel (.xls) crashes when given my really rather simple 4-page > spreadsheet. > > The export translator from Gnumeric to OpenOffice OASIS is marked as > _UNFINISHED_ > It doesn't crash, but on the other hand it doesn't convert anything > but the page titles. No data seems to come across. This is Gnumeric > version 1.6.3 and ssconvert version 1.6.3. > > I can save from Gnumeric as comma-separated values (.csv), and then > import to Calc which brings across all the numeric values in their > proper cells, and the text column headings. But numeric formatting > and inter-cell formulas are lost. This can do only one page at a > time. > > carl
On FC5 with gnumeric 1.63, and OpenOffice.org 2.0.2 I can save a 2-sheet (ultra simple) spreadsheet as excel 5.0/95 (or 97, as well) and read that ok in gnumeric or OOcalc. Hmmm, I _am_ using 64bit rpms. Alright, I added some cell formatting and that worked ok, too. I'm just using A+B=C stuff, though .. one such per sheet. And I don't do anything explicit with ssconvert -- maybe that's it? I see that the save as to OO OSASIS says "Unfinished", but I didn't try that, because saving excel format worked for me. Your simple s/s is surely more complex than mine. Maybe you could try downloading a later rpm from fc6 or 7 (rpmbuild the src.rpm if the binary doesn't install). Regards, ..jim -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-newbie
