# Exporting **URL:** \ **Category:** Chatting over the Back Fence\ **Created:** [March 1, 2013, 6:50pm UTC](https://forums.suse.com/t/exporting/23686 "2013-03-01T18:50:00Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![System1](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@System1](https://forums.suse.com/u/System1)\ **Post date:** [March 1, 2013, 6:50pm UTC](https://forums.suse.com/t/exporting/23686/1 "2013-03-01T18:50:00Z")
Hi, There are some accounting programs like Quickbooks and Peachtree that export to Excel. AccountEdge exports to a spreadsheet. I am searching for a way to fool the crippled programs into thinking they are exporting to Excel when it is actually OpenOffice or LibreOffice that is installed - or anything else for that matter (Numeric). Has any one looked into this? What do you think? Bob ---
**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\ **Post date:** [March 1, 2013, 9:27pm UTC](https://forums.suse.com/t/exporting/23686/2 "2013-03-01T21:27:02Z")
Try installing Excel Viewer? On 3/1/2013 11:50 AM, Bob Crandell wrote:[color=blue] > Hi, > > There are some accounting programs like Quickbooks and Peachtree that > export to Excel. AccountEdge exports to a spreadsheet. I am searching > for a way to fool the crippled programs into thinking they are exporting > to Excel when it is actually OpenOffice or LibreOffice that is installed - > or anything else for that matter (Numeric). > > Has any one looked into this? What do you think? > Bob > [/color] – Craig Wilson - MCNE, MCSE, CCNA Novell Knowledge Partner Novell does not officially monitor these forums. Suggestions/Opinions/Statements made by me are solely my own. These thoughts may not be shared by either Novell or any rational human. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\ **Post date:** [March 2, 2013, 7:56pm UTC](https://forums.suse.com/t/exporting/23686/3 "2013-03-02T19:56:41Z")
Bob Crandell wrote: [color=blue] > I am searching > for a way to fool the crippled programs into thinking they are > exporting to Excel when it is actually OpenOffice or LibreOffice[/color] OpenOffice and LibreOffice can open Excel files. Do those accounting programs offer the option to simply create a spreadsheet file or do they try to launch Excel directly? I remember several years ago some programs trying to launch Microsoft Word directly. I never did find a way to get them to use OpenOffice. ☹ – Kevin Boyle - Knowledge Partner If you find this post helpful and are logged into the web interface, show your appreciation and click on the star below… ---
**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\ **Post date:** [March 3, 2013, 2:58am UTC](https://forums.suse.com/t/exporting/23686/4 "2013-03-03T02:58:35Z")
Don’t they export to CSV? If they export to Excel, they should export to CSV, and CSV can be opened by any spreadsheet program. : ) – Susan Novell Community Chat Moderator [http://forums.novell.com/faq.php?faq=novfor#faq\_rules](http://forums.novell.com/faq.php?faq=novfor#faq_rules) [http://www.ncci.org](http://www.ncci.org) NCCIrregulars Web Site [https://www.facebook.com/groups/NCCIrregulars](https://www.facebook.com/groups/NCCIrregulars) Please read the following before posting in here: [http://preview.tinyurl.com/27zopdy](http://preview.tinyurl.com/27zopdy) ---
**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\ **Post date:** [March 4, 2013, 3:40pm UTC](https://forums.suse.com/t/exporting/23686/5 "2013-03-04T15:40:17Z")
On 3/2/2013 12:56 PM, KBOYLE wrote:[color=blue] > Bob Crandell wrote: > [color=green] > > > I am searching > > for a way to fool the crippled programs into thinking they are > > exporting to Excel when it is actually OpenOffice or LibreOffice[/color][/color] Quickbooks exports either to csv or iif. I don’t think it can even do an export in xls format. [color=blue] > OpenOffice and LibreOffice can open Excel files. Do those accounting > programs offer the option to simply create a spreadsheet file or do > they try to launch Excel directly? > > I remember several years ago some programs trying to launch Microsoft > Word directly. I never did find a way to get them to use OpenOffice. ☹ > [/color] ---
**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\ **Post date:** [March 4, 2013, 6:30pm UTC](https://forums.suse.com/t/exporting/23686/6 "2013-03-04T18:30:48Z")
On Sat, 02 Mar 2013 17:56:41 +0000, KBOYLE wrote: [color=blue] > Bob Crandell wrote: > [color=green] > > > I am searching > > for a way to fool the crippled programs into thinking they are > > exporting to Excel when it is actually OpenOffice or LibreOffice[/color] > > OpenOffice and LibreOffice can open Excel files. Do those accounting > programs offer the option to simply create a spreadsheet file or do they > try to launch Excel directly? > > I remember several years ago some programs trying to launch Microsoft > Word directly. I never did find a way to get them to use OpenOffice. :-([/color] That is what I’m trying to do. Though those programs will export other formats, they make the end user jump through more hoops which takes all the fun out of it. A long time ago a user let me experiment with their computer. I forget which accounting system they were using but without MS Office installed there was no export option. With OpenOffice installed there was still no export option. Installed MS Office and then there was an export option. It was a sad couple of days. Without MS Office installed she could fumble around and find a way to export some stuff in a couple of formats but the ability to bring up a report and have the option to print or export wasn’t available until MS Office was installed. Oh well. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex022/uploads/suse/original/2X/5/5012ba89e3ffb5220dac47d5ea0ba032e2fe1cb6.png) [@system](https://forums.suse.com/u/system)\ **Post date:** [March 5, 2013, 1:45am UTC](https://forums.suse.com/t/exporting/23686/7 "2013-03-05T01:45:02Z")
Bob Crandell wrote: [color=blue] > Without MS > Office installed she could fumble around and find a way to export > some stuff in a couple of formats but the ability to bring up a > report and have the option to print or export wasn’t available until > MS Office was installed.[/color] Maybe the answer is to find out what the program needs to see to offer the export function and then add a couple of entries to the registry. 😉 – Kevin Boyle - Knowledge Partner If you find this post helpful and are logged into the web interface, show your appreciation and click on the star below…