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....@gnucash.org> on behalf of
George Riner <georgeri...@mycogeo.com> Sent: Wednesday, March 29, 2023 1:11
PM
To: Gnucash Users <gnucash-user@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@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.
