[GNC] Reports to match Quicken

[Greg Feneis]

For a one-off report, pasting into a spreadsheet program and batch editing
the pasted text (find, replace, etc.) may get you by. But if translating a
report is something you'll have to do regularly, spreadsheets can be
"programmed" to do this for you.  EG, if you paste your text into one area
of a sheet, you can set up formulas in the cells of another sheet to
process the pasted text/data into some format you can work with or print.




Kind regards,

Greg Feneis




On Sat, Aug 17, 2019 at 9:41 PM rsbrux via gnucash-user <
gnucash-user at gnucash.org> wrote:

> I had similar problems pasting HTML (from a website, not from GnuCash) into
> Excel 2016, both because of the currency symbol and because of a mismatch
> between the thousands separator and decimal symbol and those expected by
> Excel.  I'll have to see if I can do better with LibreOffice.
> Excel refused to accept simple reformatting of the cells as "Number" or
> "Currency", so I used a combination of search & replace (to eliminate the
> currency symbol) and "Text to Columns".  I found this reference helpful:
> https://contextures.com/xlDataEntry03.html
>
> >>
> The Transaction Report can produce various totals, including by account.
>
> But after you paste into a spreadsheet, you can strip the currency symbols
> with a find/replace. If that doesn?t change those cells to number, you
> could
> change the format on them. Most spreadsheets also have a function to
> convert
> strings of numbers to numbers as well.
>
> I?ve never experienced any problem with the currency symbols myself,
> however. (I use both Libreoffice and Apple Numbers) If you get a dialog
> when
> you paste, make sure the option to ?detect special numbers? is checked if
> it
> is available.
>
> Regards,
> Adrien
> <<
>
> > On Aug 17, 2019, at 3:50 PM, Graham <graham.balin at gmail.com> wrote:
> >
> > On 17/08/2019 19:50, Adrien Monteleone wrote:
> >> That looks like what you can get out of a Transaction Report.
> >>
> >> Regards,
> >> Adrien
> >
> >
> > Thanks, but the export of a transaction report seems to be pdf or html
> > only, and if I cut and paste into a spreadsheet, the values seem to
> > come out as a string, like
> >
> > $26.75
> >
> > and using the Sum function gives a zero total
> >
> > --
> > Cheerio,
> >
> > Graham
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>