I do this using the "Export" choice in GnuCash, saving the report as an
html file on the desktop, then right-click + open with LibreOffice Calc.
In addition to what Hop said below about ticking the box for:
"Detect special numbers (such as dates)" in the import ...
I also need to do this step:
- Select the entire column of numbers that aren't numerical values,
by clicking on the letter at the column header)
- In the "Data" menu dropdown, select "Text to Columns", then click OK.
Hope that helps too.
Chris
(Xubuntu 22.04, Xfce desktop, GnuCash 5.4 flatpak, LibreOffice 7.3.7.2)
------------------------------------------------------------------------
On 4/14/24 02:01, gnucash-user-requ...@gnucash.org wrote:
Date: Sat, 13 Apr 2024 20:53:32 -0500 From: David Carlson
<david.carlson....@gmail.com> To: "gnucash-user@gnucash.org"
<gnucash-user@gnucash.org> Subject: [GNC] importing or pasting reports
into spreadsheets I have found that I can select the text of reports
directly in GnuCash, then paste it into a Libre Office Calc
spreadsheet. The problem then is that values are preceded with a
dollar sign in the US and it seems that they are not currency numbers
but some form of text, as numeric operators do not recognize them. It
also looks like dates are in some form of text as they have a format
code "@" whatever that means. I am not very proficient with these
format issues. Does someone know of an elementary reference that is
easier to understand than the spreadsheet help file? Just in case it
makes a difference I am using GnuCash release 4.8 in Lubuntu 22.04
with a LXQT desktop.
-- David Carlson ------------------------------ Date: Sun, 14 Apr 2024
12:20:35 +1000 From: Alan Hopkins <hopp...@gmail.com> To: David
Carlson <david.carlson....@gmail.com> Cc: GnuCash users group
<gnucash-user@gnucash.org> Subject: Re: [GNC] importing or pasting
reports into spreadsheets Hi David When you paste into Calc (I'll
assume you are using Ctrl-v), you should get an Import options screen
pop up in which you can tick a box "Detect special numbers (such as
dates). I find this works for me (using different versions of Linux on
differing hardware) I hope that helps! Cheers Hop
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
