Export report to spreadsheet
jomali
jomali3945 at gmail.com
Wed Apr 13 19:30:21 EDT 2011
Reply is interspersed with your message.
On Wed, Apr 13, 2011 at 7:13 PM, Carpet Nailz <
carpetnailz at researchintegration.org> wrote:
> On Wed, 2011-04-13 at 08:51 -0700, John Ralls wrote:
> > 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.
>
> This is what I would think. But when I do this in OO.o Calc, the
> delimiter that shows in the dialog box is an arrow. There seems to be no
>
The "arrow" is the OOo symbol for a tab. Just select the tab delimiter
option. (I assume that you selected the Table for Export option in the
Report Options.) I just did it for a simple transaction report and it worked
fine.
way to enter that arrow into the "Text delimiter" box. When I right
> click in the box, it shows a "Insert special character" option
> (Ctrl-Shift-S), but nothing happens when I try that. Nor does anything
> happen when I type in the code for the special character (U+2192) that I
> get from the "Special Character" option in the general Calc Insert menu.
> If the material showed up in the paste special dialog with some "normal"
> delimiter I would be OK. But I can't get it to enter the arrow. (I've
> got autocorrect set to change '->' to the arrow, but that doesn't work
> in the dialog box either.
>
> In the meantime I'll just have to fall back on exporting the stuff to
> Windows (which I have to do anyway to use TurboTax) and manipulating it
> in Excel, using its "Value" option under Paste Special.
>
> _______________________________________________
> 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.
>
More information about the gnucash-user
mailing list