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:
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:
https://ask.libreoffice.org/t/open-html-file-in-calc-from-os/90615
It would make a good tip for our docs.
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.
e 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: [GNC] Exporting reports to spreadsheet
The setting:
Windows 10
Gnucash 4.13
When I Export a report
> 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
>
t;
> From: gnucash-user
> on behalf of
> George Riner Sent: Wednesday, March 29, 2023 1:11
> PM
> To: Gnucash Users
> Subject: [GNC] Exporting reports to spreadsheet
>
> The setting:
>
> Windows 10
> Gnucash 4.13
>
> Wh
s
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 ca
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
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
15 matches
Mail list logo