[GNC] Exporting reports to spreadsheet

[R Losey]

As others have said, changing the extension doesn't change the data.

Instead of clicking on the file, start LibreOffice Calc, and open the data
from Calc.

On Wed, Mar 29, 2023 at 11:13 AM George Riner <georgeriner at mycogeo.com>
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?
>
> :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.
>


-- 
_________________________________
Richard Losey
rlosey at gmail.com
Micah 6:8