Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Discoverer Export to Excel but Using Open Office

Robert ChaltonAug 6 2010 — edited Aug 9 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2010
Added on Aug 6 2010
3 comments
1,098 views