Report amounts are text, not numbers

[Paul Schwartz]

I have found that by unchecking the html links option for the reports and exporting the report to html, then opening the file with OpenOffice Spreadsheet imports the amounts as numbers.

YMMV
HTH

Paul



----- Original Message ----
> From: satjat <iason at pkon.gr>
> To: gnucash-user at gnucash.org
> Sent: Friday, August 22, 2008 4:58:42 AM
> Subject: Report amounts are text, not numbers
> 
> 
> I am trying to export data from GnuCash to a usable format, say Excel.
> I only really need the transaction journal, maybe with some filters.
> I have a report exactly the way I want it but I have two major problems:
> 1. The amounts listed are recognized as text by Excel so it is pretty much
> unusable
> 2. Apart from being in text mode, the amounts are also hyperlinks to the
> transactions. That is not so serious but it would be nice if it could be
> solved since clicking tries to open a non existing file and pops up an
> error.
> Thank you all in advance
> -- 
> View this message in context: 
> http://www.nabble.com/Report-amounts-are-text%2C-not-numbers-tp19105139p19105139.html
> Sent from the GnuCash - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.