[GNC] Exporting reports to spreadsheet

[Adrien Monteleone]

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?