[GNC] Exporting reports to spreadsheet

[Maf. King]

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
> <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf of
> George Riner <georgeriner at mycogeo.com> Sent: Wednesday, March 29, 2023 1:11
> PM
> To: Gnucash Users <gnucash-user at gnucash.org>
> 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 at 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 at 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.