Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
Only because I don't have any keyboard shortcuts memorized except ctrl-c and ctrl-v. On Sun, May 19, 2024 at 11:25 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Any reason not to use CTRL+A? > > Regards, > Adrien > > On 5/19/24 9:08 PM, Joseph Keithley wrote: > > If the whole le

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Stan Brown (using GC 4.14)
Open the report in Excel and _then_ do your copy and pasting. (You probably want Edit » Paste Special » Values, keyboard Alt+E, S, V.) Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2024-05-19 17:35, David Long wrote: > Hi > I mean copy paste from a gnucash report. > Rgds > David > > >

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Adrien Monteleone
Any reason not to use CTRL+A? Regards, Adrien On 5/19/24 9:08 PM, Joseph Keithley wrote: If the whole left-click hold copy and drag doesn't work well, there is an alternate method. When you move the mouse cursor to the top left of the tab, move the cursor slowly to the right until the mouse cu

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
If the whole left-click hold copy and drag doesn't work well, there is an alternate method. When you move the mouse cursor to the top left of the tab, move the cursor slowly to the right until the mouse cursor changes from an arrow to a line (assuming your PC set up is similar to mine) and left-cl

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
Understood. I can tell you what I do with copy/pasting a paticular report. I've never had a problem with double quotes. In my case, I copy/paste the "Investment Portfolio" report under "Assets and Liabilities" to Excel. When the tab opens with the report, I put the mouse cursor on the top left

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread David Long
Hi I mean copy paste from a gnucash report. Rgds David On Mon, 20 May 2024, 04:13 Joseph Keithley, wrote: > Not sure what you mean by "copy". In the Windows version of GnuCash 5.5 > you can export your accounts to a csv file. You pick the account, the date > range, and the separator (usually

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Joseph Keithley
Not sure what you mean by "copy". In the Windows version of GnuCash 5.5 you can export your accounts to a csv file. You pick the account, the date range, and the separator (usually a comma). There is also an option to either add double quotes or not. On Sun, May 19, 2024 at 12:41 PM David Long

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread sunfish62--- via gnucash-user
And if your currency is using character strings ("USD", "CHF", etc.), you can customize the currency designator so that Excel can process them. ⁣David T. ​ On May 19, 2024, 8:50 PM, at 8:50 PM, "Stan Brown (using GC 4.14)" wrote: >On 2024-05-19 09:39, David Long wrote: >> When I copy data fro

Re: [GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread Stan Brown (using GC 4.14)
On 2024-05-19 09:39, David Long wrote: > When I copy data from Gnucash to Excel it arrives on text format along with > the currency denomination, so I cannot then manipulate it in Excel. > Is there anyway I can export data to Excel in data format?. > Thanks > David Hi, David! Which "data" are you

[GNC] Manipulating data extracted from gnucash to Excel

2024-05-19 Thread David Long
When I copy data from Gnucash to Excel it arrives on text format along with the currency denomination, so I cannot then manipulate it in Excel. Is there anyway I can export data to Excel in data format?. Thanks David ___ gnucash-user mailing list gnucash-