GnuCash
Contact   Instructions
Bug 796746 - Cannot copy and paste anything into the amount field (both credit and debit)
Summary: Cannot copy and paste anything into the amount field (both credit and debit)
Status: NEW
Alias: None
Product: GnuCash
Classification: Unclassified
Component: Windows (show other bugs)
Version: 3.2
Hardware: PC Windows
: Normal major
Target Milestone: ---
Assignee: windows
QA Contact: windows
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-07-08 20:57 EDT by Alex Mak
Modified: 2019-04-02 05:34 EDT (History)
5 users (show)

See Also:


Attachments
Cell Format is attached (Excel) (278.14 KB, image/jpeg)
2018-07-09 20:53 EDT, Alex Mak
no flags Details

Description Alex Mak 2018-07-08 20:57:21 EDT
Step 1: Open a account and transaction windows appear
Step 2: Copy (Ctrl + C) some number from other source (say excel)
Step 3: Paste (Ctrl + V) the number into the amount field (credit or debit)

Results : Copy and Paste is not working, Nothing shown in the amount field
Comment 1 Alex Mak 2018-07-09 01:39:35 EDT
It is solved after change the format of the cell (Excel) to Text or Number. Then Copy and Paste is working.
Comment 2 John Ralls 2018-07-09 10:06:49 EDT
Ah, and what was the format of the cell beforehand? 

In Gtk's paste mechanism the receiver lists types that it can understand and the source lists types it can provide. The code tries to find a common type. 

And that means that step 2 is "from excel with a cell in some format" rather than "from other source (say excel)".
Comment 3 Alex Mak 2018-07-09 20:53:16 EDT
Created attachment 372911 [details]
Cell Format is attached (Excel)

Cell Format is custom, 2.6.x should work for cut & paste before.
Comment 4 Wm 2019-04-02 05:34:42 EDT
I think some tidying up of "what is accepted input" is overdue.

There are a whole bunch of outstanding bugs related to this.

Note You need to log in before you can comment on or make changes to this bug.