Export report to spreadsheet

David Muir davidkmuir at gmail.com
Wed Apr 13 21:05:10 EDT 2011


On 14/04/11 07:56, Carpet Nailz wrote:
> On Wed, 2011-04-13 at 15:49 +0100, 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...!
>>
>> Maf
>  That's what I've been trying but it doesn't seem to work. I've tried a
> bunch of different ways. There must be some way. Maybe someone who
> understands how to program Calc and how Calc parses HTML could do a nice
> little feature that would let one just export a report to Calc and have
> a neat result with calculable numbers and nice alignment without the
> strange merged cells that a present paste job results in. I know a
> little bit of VBA so I can conceive of how it would be done with Excel,
> but I don't know how to do the coding for OO.o Calc.
>

I just open the report in Firefox, then copy paste the table into Calc.

David


More information about the gnucash-user mailing list