Export report to spreadsheet

[John Ralls]

On Apr 13, 2011, at 7:49 AM, Maf. King wrote:

> On Wednesday 13 April 2011 15:41:56 Carpet Nailz wrote:
>> On Wed, 2011-04-13 at 15:20 +0100, Maf. King wrote:
>>> On Wednesday 13 April 2011 14:53:50 Carpet Nailz wrote:
>>>> I thought that in the past I had been able to use paste-special in OO.o
>>>> Calc to have just the numbers pasted and not have them pasted as links
>>>> back to some GnuCash file. But now I can't get that to work.
>>> 
>>> In the past, I've exported the reports as HTML, then opened (possibly
>>> inserted) the HTML in OOo calc.
>>> 
>>> HTH,
>>> Maf.
>> 
>> Very interesting. Excel has a "Values" option under "Paste special"
>> which does what I want. OO.o Calc doesn't seem to have this option, that
>> I can find.
> 
> Hmm,
> 
> now you say that, it rings a bell that I had to do something like 
> Format->Cells->Number Format [currency], in order that the individual lines 
> could be added together.  Haven't tried for best part of a year...!
> 

I don't know what report you're trying to copy, but I do the following with the Transaction Report:
Highlight and copy the part of the report that I want.
Do a regular paste into NeoOffice (OO with some Mac stuff wrapped around it). A dialog box comes up with import options. I select "space" as a delimiter in addition to tab; this splits asset type (e.g., stock symbol) into a separate column from amounts so that OO can recognize the numbers. It has the unfortunate side effect of breaking up description fields too, but they can be easily recombined after the import. Also select "recognize special numbers" then hit "OK". Dates come through as dates, numbers as numbers.

Regards,
John Ralls