[GNC] Exporting reports to spreadsheet

[David T.]

You could always forego the export aspect altogether. In the report window of GnuCash, select the entire report (Ctrl-A), copy the data (Ctrl-C), switch to LibreOffice (Alt-Tab), and paste your data (Ctrl-V). Finally, save the LibreOffice as a spreadsheet file, which should assign it the proper formatting and extension. 

⁣David T. ​

On Mar 29, 2023, 8:27 PM, at 8:27 PM, Patrick James <patrickjames14 at comcast.net> wrote:
>George,
>
>This is a Windows 'feature,' as Windows has file extension
>associations.
>
>If you do a quick online search, you should be able to find the
>instructions on how reassign the association of the ".ods" extension to
>LibreOffice Calc.
>
>Alternatively, try right-clicking the icon and selecting "Open with" 
>
>> On 03/29/2023 9:11 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.
>_______________________________________________
>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.