Re: [GNC] importing or pasting reports into spreadsheets

2024-04-14 Thread Chris Skudder
e 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: [G

Re: [GNC] importing or pasting reports into spreadsheets

2024-04-14 Thread Maria Inmaculada de la Torre
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

Re: [GNC] importing or pasting reports into spreadsheets

2024-04-13 Thread Alan Hopkins
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