Very useful hint. Thanks a lot!
Am 18.04.23 um 09:00 schrieb flywire:
https://lists.gnucash.org/pipermail/gnucash-user/2023-March/106080.html
That's a great question George which has been annoying me for ages so I
flicked it over to the LibreOffice Ask site:
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
wrote:
> The setting:
>
> Windows 10
> Gnucash 4.13
>
> When I Export a report I've been
George,
You created the circle.
Skip adding/changing the extension entirely.
Just export, then open the file *from* Calc. (double-clicking will most
likely use your default HTML editor, whatever that may be, or even a web
browser)
Regards,
Adrien
On 3/29/23 11:11 AM, George Riner wrote:
On Mar 29, 2023, at 3:03 PM, George Riner 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
> On Mar 29, 2023, at 3:03 PM, George Riner 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
>
On Wednesday, 29 March 2023 22:03:56 BST George Riner wrote:
> I suspect LO is being way more "clever"!
>
> :George
Yeah. File->Open in LO calc seems the most bullet proof route around any
"cleverness" in LO...
or the copy-and -paste as David T suggests.
Maf.
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
> On Mar 29, 2023, at 4:38 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
>
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
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
on behalf of
George Riner
Sent: Wednesday, March 29, 2023 1:11 PM
To: Gnucash Users
Subject:
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
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
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
13 matches
Mail list logo