report question

[timothy]

On Mon, 2016-12-19 at 20:54 -0500, Jack wrote:
> I'm starting to do some tax planning work, and I just discovered that  
> in exported reports, even the amount columns are ouput in quotes.  This  
> makes is difficult to do calculations on them.  (I use various  
> spreadsheet functions to take different cuts of various accounts and  
> categories.)  I looked in my spreadsheet from last year, and apparently  
> I found some way to convert, but I don't remember whether I simply did  
> it manually (unlikely) or managed to play with the import process.  Is  
> there any easy way to avoid the quotes around values that really should  
> be numbers, and so not forced to text?  (this is in the export files  
> for reports)
> 
> Jack

Hi Jack

I export my reports (with quotes) to a csv file and then open directly
in Libre Office Calc with "Text delimiter" option set as " and separator
as Comma. You can then change the text to numbers with the Format option
in Calc if necessary.

Regards
Timothy