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 > <[email protected]> on behalf of > George Riner <[email protected]> Sent: Wednesday, March 29, 2023 1:11 > PM > To: Gnucash Users <[email protected]> > 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 > [email protected] > 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 > [email protected] > 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 [email protected] 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.
