Export report to spreadsheet

[Carpet Nailz]

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.