[GNC] Exporting reports to spreadsheet

Michael or Penny Novack stepbystepfarm at comcast.net
Wed Mar 29 18:14:38 EDT 2023


>> On Mar 29, 2023, at 3:03 PM, George Riner <georgeriner at mycogeo.com> wrote:
>>
>> 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!
> So doesn’t it make sense for Gnucash to use whatever extension is provided by the user, and .html if none?

IF the file is given the file extension .xlsx and IF your computer has 
LibreOffice Calc to use as the application for objects of that type, 
then clicking on that object will cause LibreOffice Calc to attempt to 
open it << IF the data in that file is something that LibreOffice Calc 
can handle, it will work just fine >>

Understand? Just putting that extension on the file does NOT in and by 
itself make the data formatted that way.

The conversion offered by LibreOffice Calc depends on the actual data 
format being one that LibreOffice Calc knows how to convert.

Michael D Novack




More information about the gnucash-user mailing list