Discoverer Export to Excel but Using Open Office
Hi,
I used to use MS Excel as my spreadsheet but I have migrated to using Open Office's Calc. All works fine except....
Previously, exporting my Discoverer work sheet results to Excel allowed MS Excel to open up the exported spreadsheet with all formatting intact.
However, I am unable to replicate this using Open Office (latest version). The exported spreadsheet opens ok, no errors are displayed.... but... all formatting is lost.
Anyone know if its possible to open up the exported spreadsheet in Open Office and retain formatting?
Thanks in advance,
Rob
Edited by: Robert Chalton on 06-Aug-2010 17:13