Re: [GNC] importing or pasting reports into spreadsheets
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 To: "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 To: David Carlson Cc: GnuCash users group 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.
Re: [GNC] importing or pasting reports into spreadsheets
Hello David, I do the same for my reports but paste it into Excel and whenever I had that issue I either use powerquery for the clean up or more quick and dirty approach of using functions to extract the correct figures, some MID/RIGHT function, within the CLEAN one wrapping the result and if you still have issues maybe using the VALUE formula to convert the final output (I would try this one first as it might work out with the previous ones) In any case I think not all the reports cause the issue of being pasted as text, so maybe if you try to play with formatting options to number first and set those setting by default in the file it might help you. Thanking you. Regards, Inma On Sun, 14 Apr 2024 at 02:54, David Carlson wrote: > 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 > ___ > 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. > ___ 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.
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 On Sun, 14 Apr 2024, 11:54 am David Carlson, wrote: > 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 > ___ > 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. > ___ 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.
[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 ___ 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.
