[GNC] importing or pasting reports into spreadsheets

[Chris Skudder]

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-request at gnucash.org wrote:
> Date: Sat, 13 Apr 2024 20:53:32 -0500 From: David Carlson 
> <david.carlson.417 at gmail.com> To: "gnucash-user at gnucash.org" 
> <gnucash-user at 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 <hoppo52 at gmail.com> To: David 
> Carlson <david.carlson.417 at gmail.com> Cc: GnuCash users group 
> <gnucash-user at 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