[GNC] Exporting reports to spreadsheet

[George Riner]

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
>> <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.
>
>
>
> _______________________________________________
> 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.