[GNC] importing or pasting reports into spreadsheets

[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
Hop

On Sun, 14 Apr 2024, 11:54 am David Carlson, <david.carlson.417 at gmail.com>
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 at 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.
>