Thanks Fran! I had previously resorted to Account Report or Transaction Report with copy/paste, but I hadn’t noticed the Export > Active Register option. I wonder how new that is?
I see it could be quite useful as it includes data that is otherwise hidden from the Register tab. (transaction ID, Currency, Rate/Price, Reconcile Date) While most people might not have a use for them, I could see they might come in hand when trying to solve a problem —say with an import. I also like that you get a column both with and without currency symbols. (some spreadsheets don’t play nice with the symbols, so you have to remove them. This saves a step) I don’t use Excel, but some years ago, I recall a few threads where there were quirks. It seemed OOo or LO (and I suppose Google Sheets) were better suited, or at least didn’t require extra hoops to get to the end result. I can’t remember what Excel was choking on though. Regards, Adrien > On May 19, 2020 w21d140, at 11:55 AM, Fran_3 via gnucash-user > <gnucash-user@gnucash.org> wrote: > > To get a register, or part of a register out of GC and into a spreadsheet > you can... > File > Export > etcThen import the csv file into the spreadsheetthen dink > with it to delete or hide unwanted columns, etc... > Or do it faster and with more control via... > > Open the registerClick Reports Transaction ReportEdit Report Options > And then just highlight the transactions with the mouse and paste them right > into a Google Sheet ! > Much quicker (to me) and you have more control in that you can select the > columns you want and more. > I wonder if this works in Excel too? _______________________________________________ gnucash-user mailing list gnucash-user@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.
