E9.2 Screen reloads/refreshes/flashes after pasting value into grid cell.

Adam (DF)

Active Member
Dear JDEList,

Our users are trying to speed up data entry using paste and automation, but in a headerless detail, when you paste a value into a blank cell the screen refreshes. Note these details:
- It happens as soon as you paste
We first noticed this on a large grid (20 columns and > 100 rows), but this also happens with a small grid (e.g. UDC), even with a single row.
- It does not happen when there is an existing value in the cell.
- It does not happen when typing a value into a cell (blank or otherwise).
- This happens in any browser.

I have attached a video wherein I demonstrate the screen refresh. I first (0:06) clear the cell and type the value (no refresh), then (0:11) clear the cell and paste the value (refresh).

Is this an issue anyone else sees, and is there any fix or work-around?

Adam
 

Attachments

  • 2021-04-27_9-19-47.zip
    268 KB · Views: 3

Adam (DF)

Active Member
Interesting Update: If you use shift + insert to paste, the screen does not refresh. If you use control + v, then it refreshes. This applies to all browsers mentioned.

So this appears to be at least an 80% work-around.
 
Last edited:
Call Orchestrations From Excel – The Easy Way to Make the Orchestrator Work for You.

Adam (DF)

Active Member
- It does not happen when there is an existing value in the cell.
This is inaccurate:
  • It always happens if the cell is empty or blanks.
  • If there is a value in the cell, it does not happen if part or all of the text is selected when the paste happens.
  • If there is a value in the cell and no text is selected, the refresh happens.
This means:
  • If I have a value in the cell (say "21"), and no text is selected, the value left in the cell after the paste is the contents of the clipboard only. Say "AD" is in my clipboard, then whether my cursor is before the 2, between the 2 and 1, or after the 1, the cell value is "AD" after the paste.
  • If the text is partially or totally selected, it replaces the selected portion like you would normally expect. Say "AD" is on my clipboard and I have the "2" in "21" selected, the cell value is "AD1" after the paste.
So it seems like JDE is trying to execute a full-cell replacement when you use control + v and a normal paste when you use shift + insert or text is selected.

I reckon it has to do with running mass updates via copy/paste. Can anyone conform that?
 
Last edited:

Adam (DF)

Active Member
After some further testing and experimenting, I have confirmed that when you press control+v on a grid cell, it pastes whole cell values and multiple rows. When you have text selected, or use shift+insert, or are not in a grid cell, JDE pastes plain text inside the cell or field.
 
Top