Re: [GNC] Exporting reports to spreadsheet - Solved
Very useful hint. Thanks a lot! Am 18.04.23 um 09:00 schrieb flywire: https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html That's a great question George which has been annoying me for ages so I flicked it over to the LibreOffice Ask site: https://ask.libreoffice.org/t/open-html-file-in-calc-from-os/90615 It would make a good tip for our docs. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Exporting reports to spreadsheet - Solved
https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html That's a great question George which has been annoying me for ages so I flicked it over to the LibreOffice Ask site: https://ask.libreoffice.org/t/open-html-file-in-calc-from-os/90615 It would make a good tip for our docs. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
As others have said, changing the extension doesn't change the data. Instead of clicking on the file, start LibreOffice Calc, and open the data from Calc. On Wed, Mar 29, 2023 at 11:13 AM George Riner wrote: > The setting: > > Windows 10 > Gnucash 4.13 > > When I Export a report I've been supplying a windows extension of > ".ods". Which I assumed would cause that exported report file to open in > some OpenDocumentSpreadsheet application, in my case: LibreOffice Calc. > > But it doesn't do that. I double-click the file to open it in the > default application and it opens in LibreOffice Writer. > > Opening the exported report in a text editor I see that it's really an > HTML file. And that, in fact, I can specify any windows extension I want > when exporting the report from Gnucash, and it will always write out a > file that contains HTML. > > I think Windows is seeing ".ods" as something to open in LibreOffice, > which starts reading the file and detects that it's HTML and then > without any asking, renders the HTML in the exported report as a > LibreOffice Writer document. > > However, if I export a report and specify a file extension of ".xlsx" > and then double click that to open it, then LibreOffice Calc starts up > and offers to convert the HTML that's in that file to an actual > spreadsheet which I can then save as a ".ods" file that opens in > LibreOffice Calc. > > I find myself in circles trying to find the straight path from Gnucash > exported reports to LibreOffice Calc and can't seem to untangle the > Windows/Gnucash/LibreOffice interactions to get this to happen. > > Any Windows + LibreOffice users out that that get this working? > > :George > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
George, You created the circle. Skip adding/changing the extension entirely. Just export, then open the file *from* Calc. (double-clicking will most likely use your default HTML editor, whatever that may be, or even a web browser) Regards, Adrien On 3/29/23 11:11 AM, George Riner wrote: The setting: Windows 10 Gnucash 4.13 When I Export a report I've been supplying a windows extension of ".ods". Which I assumed would cause that exported report file to open in some OpenDocumentSpreadsheet application, in my case: LibreOffice Calc. But it doesn't do that. I double-click the file to open it in the default application and it opens in LibreOffice Writer. Opening the exported report in a text editor I see that it's really an HTML file. And that, in fact, I can specify any windows extension I want when exporting the report from Gnucash, and it will always write out a file that contains HTML. I think Windows is seeing ".ods" as something to open in LibreOffice, which starts reading the file and detects that it's HTML and then without any asking, renders the HTML in the exported report as a LibreOffice Writer document. However, if I export a report and specify a file extension of ".xlsx" and then double click that to open it, then LibreOffice Calc starts up and offers to convert the HTML that's in that file to an actual spreadsheet which I can then save as a ".ods" file that opens in LibreOffice Calc. I find myself in circles trying to find the straight path from Gnucash exported reports to LibreOffice Calc and can't seem to untangle the Windows/Gnucash/LibreOffice interactions to get this to happen. Any Windows + LibreOffice users out that that get this working? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
On Mar 29, 2023, at 3:03 PM, George Riner wrote: Yeah... isn't that curious? Gnucash writes out HTML regardless of any windows filename extension you supply. But if the filename I supply ends with the extension ".xlsx" then surprise! - it opens in LibreOffice Calc with an opening dialog box offering to convert the file to a Calc file! So doesn’t it make sense for Gnucash to use whatever extension is provided by the user, and .html if none? IF the file is given the file extension .xlsx and IF your computer has LibreOffice Calc to use as the application for objects of that type, then clicking on that object will cause LibreOffice Calc to attempt to open it << IF the data in that file is something that LibreOffice Calc can handle, it will work just fine >> Understand? Just putting that extension on the file does NOT in and by itself make the data formatted that way. The conversion offered by LibreOffice Calc depends on the actual data format being one that LibreOffice Calc knows how to convert. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
> On Mar 29, 2023, at 3:03 PM, George Riner wrote: > > Yeah... isn't that curious? Gnucash writes out HTML regardless of any > windows filename extension you supply. But if the filename I supply ends with > the extension ".xlsx" then surprise! - it opens in LibreOffice Calc with an > opening dialog box offering to convert the file to a Calc file! So doesn’t it make sense for Gnucash to use whatever extension is provided by the user, and .html if none? Cheers, Brook ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
On Wednesday, 29 March 2023 22:03:56 BST George Riner wrote: > I suspect LO is being way more "clever"! > > :George Yeah. File->Open in LO calc seems the most bullet proof route around any "cleverness" in LO... or the copy-and -paste as David T suggests. Maf. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
Yeah... isn't that curious? Gnucash writes out HTML regardless of any windows filename extension you supply. But if the filename I supply ends with the extension ".xlsx" then surprise! - it opens in LibreOffice Calc with an opening dialog box offering to convert the file to a Calc file! I suspect LO is being way more "clever"! :George On 3/29/2023 1:36 PM, Maf. King wrote: I _think_ that LibreOffice is more clever than just looking at the file extension. ISTR that LO examines the file as it opens, and decides if a text editor (writer) would be more appropriate than Calc for the contents of the file, regardless of name.extension And HTML is "text" 0.02 Maf. On Wednesday, 29 March 2023 21:14:43 BST Murugan Muruganandam wrote: can you please try and save it with extension ".ods" and check if it is directly opening in the Calc application Saludos Cordiales Murugan From: gnucash-user on behalf of George Riner Sent: Wednesday, March 29, 2023 1:11 PM To: Gnucash Users Subject: [GNC] Exporting reports to spreadsheet The setting: Windows 10 Gnucash 4.13 When I Export a report I've been supplying a windows extension of ".ods". Which I assumed would cause that exported report file to open in some OpenDocumentSpreadsheet application, in my case: LibreOffice Calc. But it doesn't do that. I double-click the file to open it in the default application and it opens in LibreOffice Writer. Opening the exported report in a text editor I see that it's really an HTML file. And that, in fact, I can specify any windows extension I want when exporting the report from Gnucash, and it will always write out a file that contains HTML. I think Windows is seeing ".ods" as something to open in LibreOffice, which starts reading the file and detects that it's HTML and then without any asking, renders the HTML in the exported report as a LibreOffice Writer document. However, if I export a report and specify a file extension of ".xlsx" and then double click that to open it, then LibreOffice Calc starts up and offers to convert the HTML that's in that file to an actual spreadsheet which I can then save as a ".ods" file that opens in LibreOffice Calc. I find myself in circles trying to find the straight path from Gnucash exported reports to LibreOffice Calc and can't seem to untangle the Windows/Gnucash/LibreOffice interactions to get this to happen. Any Windows + LibreOffice users out that that get this working? :George ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
> On Mar 29, 2023, at 4:38 PM, Maf. King wrote: > > I _think_ that LibreOffice is more clever than just looking at the file > extension. ISTR that LO examines the file as it opens, and decides if a > text > editor (writer) would be more appropriate than Calc for the contents of the > file, regardless of name.extension And HTML is "text" > The files have meta data that reveals the type of file it is, or did in the ancient past of 15-20 years ago. That is why why files didn’t need an extension to hint at its contents. Ken Schneider ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
I _think_ that LibreOffice is more clever than just looking at the file extension. ISTR that LO examines the file as it opens, and decides if a text editor (writer) would be more appropriate than Calc for the contents of the file, regardless of name.extension And HTML is "text" 0.02 Maf. On Wednesday, 29 March 2023 21:14:43 BST Murugan Muruganandam wrote: > can you please try and save it with extension ".ods" and check if it is > directly opening in the Calc application > > > > > Saludos Cordiales > > > Murugan > > > From: gnucash-user > on behalf of > George Riner Sent: Wednesday, March 29, 2023 1:11 > PM > To: Gnucash Users > Subject: [GNC] Exporting reports to spreadsheet > > The setting: > > Windows 10 > Gnucash 4.13 > > When I Export a report I've been supplying a windows extension of > ".ods". Which I assumed would cause that exported report file to open in > some OpenDocumentSpreadsheet application, in my case: LibreOffice Calc. > > But it doesn't do that. I double-click the file to open it in the > default application and it opens in LibreOffice Writer. > > Opening the exported report in a text editor I see that it's really an > HTML file. And that, in fact, I can specify any windows extension I want > when exporting the report from Gnucash, and it will always write out a > file that contains HTML. > > I think Windows is seeing ".ods" as something to open in LibreOffice, > which starts reading the file and detects that it's HTML and then > without any asking, renders the HTML in the exported report as a > LibreOffice Writer document. > > However, if I export a report and specify a file extension of ".xlsx" > and then double click that to open it, then LibreOffice Calc starts up > and offers to convert the HTML that's in that file to an actual > spreadsheet which I can then save as a ".ods" file that opens in > LibreOffice Calc. > > I find myself in circles trying to find the straight path from Gnucash > exported reports to LibreOffice Calc and can't seem to untangle the > Windows/Gnucash/LibreOffice interactions to get this to happen. > > Any Windows + LibreOffice users out that that get this working? > > :George > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
can you please try and save it with extension ".ods" and check if it is directly opening in the Calc application Saludos Cordiales Murugan From: gnucash-user on behalf of George Riner Sent: Wednesday, March 29, 2023 1:11 PM To: Gnucash Users Subject: [GNC] Exporting reports to spreadsheet The setting: Windows 10 Gnucash 4.13 When I Export a report I've been supplying a windows extension of ".ods". Which I assumed would cause that exported report file to open in some OpenDocumentSpreadsheet application, in my case: LibreOffice Calc. But it doesn't do that. I double-click the file to open it in the default application and it opens in LibreOffice Writer. Opening the exported report in a text editor I see that it's really an HTML file. And that, in fact, I can specify any windows extension I want when exporting the report from Gnucash, and it will always write out a file that contains HTML. I think Windows is seeing ".ods" as something to open in LibreOffice, which starts reading the file and detects that it's HTML and then without any asking, renders the HTML in the exported report as a LibreOffice Writer document. However, if I export a report and specify a file extension of ".xlsx" and then double click that to open it, then LibreOffice Calc starts up and offers to convert the HTML that's in that file to an actual spreadsheet which I can then save as a ".ods" file that opens in LibreOffice Calc. I find myself in circles trying to find the straight path from Gnucash exported reports to LibreOffice Calc and can't seem to untangle the Windows/Gnucash/LibreOffice interactions to get this to happen. Any Windows + LibreOffice users out that that get this working? :George ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
You could always forego the export aspect altogether. In the report window of GnuCash, select the entire report (Ctrl-A), copy the data (Ctrl-C), switch to LibreOffice (Alt-Tab), and paste your data (Ctrl-V). Finally, save the LibreOffice as a spreadsheet file, which should assign it the proper formatting and extension. David T. On Mar 29, 2023, 8:27 PM, at 8:27 PM, Patrick James wrote: >George, > >This is a Windows 'feature,' as Windows has file extension >associations. > >If you do a quick online search, you should be able to find the >instructions on how reassign the association of the ".ods" extension to >LibreOffice Calc. > >Alternatively, try right-clicking the icon and selecting "Open with" > >> On 03/29/2023 9:11 AM George Riner wrote: >> >> >> The setting: >> >> Windows 10 >> Gnucash 4.13 >> >> When I Export a report I've been supplying a windows extension of >> ".ods". Which I assumed would cause that exported report file to open >in >> some OpenDocumentSpreadsheet application, in my case: LibreOffice >Calc. >> >> But it doesn't do that. I double-click the file to open it in the >> default application and it opens in LibreOffice Writer. >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >https://lists.gnucash.org/mailman/listinfo/gnucash-user >- >Please remember to CC this list on all your replies. >You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
When I Export a report I've been supplying a windows extension of ".ods". Which I assumed would cause that exported report file to open in some OpenDocumentSpreadsheet application, in my case: LibreOffice Calc. But it doesn't do that. I double-click the file to open it in the default application and it opens in LibreOffice Writer. Important! There is a common misconception that the file extension you supply (or have an application supply) when you save a file actually changes the format of the data. This is not so (except that an application might do that sort of data conversion as part of the save). All a file extension does is inform the system what application to use if you "click the object" (select it for opening). You CAN use a different application by starting that and then telling it to open the file. For example, if you "clicked" on a file that had an extension .exe your computer would RUN this program. But if you started a hex editor and told IT to open this program is would let you look at it (examine the machine code) --- a hex editor can open ANYTHING. You changed the extension from .html to that of an open document format but that didn't make the data itself change. But the LibreOffice suite does work differently. When you tell it to change to another format it won't just do the extension but will also convert the data. Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Exporting reports to spreadsheet
George, This is a Windows 'feature,' as Windows has file extension associations. If you do a quick online search, you should be able to find the instructions on how reassign the association of the ".ods" extension to LibreOffice Calc. Alternatively, try right-clicking the icon and selecting "Open with" > On 03/29/2023 9:11 AM George Riner wrote: > > > The setting: > > Windows 10 > Gnucash 4.13 > > When I Export a report I've been supplying a windows extension of > ".ods". Which I assumed would cause that exported report file to open in > some OpenDocumentSpreadsheet application, in my case: LibreOffice Calc. > > But it doesn't do that. I double-click the file to open it in the > default application and it opens in LibreOffice Writer. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Exporting reports to spreadsheet
The setting: Windows 10 Gnucash 4.13 When I Export a report I've been supplying a windows extension of ".ods". Which I assumed would cause that exported report file to open in some OpenDocumentSpreadsheet application, in my case: LibreOffice Calc. But it doesn't do that. I double-click the file to open it in the default application and it opens in LibreOffice Writer. Opening the exported report in a text editor I see that it's really an HTML file. And that, in fact, I can specify any windows extension I want when exporting the report from Gnucash, and it will always write out a file that contains HTML. I think Windows is seeing ".ods" as something to open in LibreOffice, which starts reading the file and detects that it's HTML and then without any asking, renders the HTML in the exported report as a LibreOffice Writer document. However, if I export a report and specify a file extension of ".xlsx" and then double click that to open it, then LibreOffice Calc starts up and offers to convert the HTML that's in that file to an actual spreadsheet which I can then save as a ".ods" file that opens in LibreOffice Calc. I find myself in circles trying to find the straight path from Gnucash exported reports to LibreOffice Calc and can't seem to untangle the Windows/Gnucash/LibreOffice interactions to get this to happen. Any Windows + LibreOffice users out that that get this working? :George ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.