Export report to spreadsheet

[David Carlson]

On 4/13/2011 2:50 PM, David T. wrote:
>
> It seems to me that some reports have the option of removing links from the report output, simplifying this at least for those reports that have it. I'm not at my machine to check this though.
>
> David
>
> --- On Wed, 4/13/11, John Ralls <jralls at ceridwen.us> wrote:
>
>> From: John Ralls <jralls at ceridwen.us>
>> Subject: Re: Export report to spreadsheet
>> To: "Maf. King" <maf at chilwell.net>
>> Cc: gnucash-user at gnucash.org
>> Date: Wednesday, April 13, 2011, 8:51 AM
>>
>> 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
>>
>>
>> _______________________________________________
>> 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.
>>
> _______________________________________________
> 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.
>
I am still wondering about what has recently changed in the universe so
that supposedly simple text files saved in .csv format no longer have
text in number or date 'fields'.  The other day I could not create a
.csv file that gnucash could import because it could not read dates.


David
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0xDC7C8BF3.asc
Type: application/pgp-keys
Size: 1729 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20110413/bffcb3ff/attachment.bin>