Reopen: Autofill with copyable:false

Tags: #<Tag:0x00007efc656b3268>
#1

Sorry, I didn’t get the time to test the copy/paste plugin till now and you closed my issue…

I mentioned this test case (http://jsfiddle.net/ccrider/3jqf0pmf/) in my Question
“Autofill with copyable:false” a few weeks ago.

I created a new version, loading hot version 1.12.0 here: http://jsfiddle.net/3jqf0pmf/9/

Unfortunately copy/paste is still loosing
values when pasting to read only cells, or am I doing something wrong?

Thanks for your help

#2

Hi @johnny.petersen

Sorry for a delay. I will investigate the case and send you my results later today.

#3

Thank you for sharing the example.

The result that I’ve got is the same (tested on Chrome 60/Win10 and v1.12.0/1.13.0).

GIF.gif1237×535 159 KB

What we are doing is

  1. Copying ColA into cell A1, which is added correctly (cell has readOnly: false, so it’s correct)
  2. Copying ColB into cell B1, which is hidden
  3. Copying an empty string to C1, nothing is added so it’s correct
  4. Adding 1 value to columns D1 which is hidden
  5. Adding 1 value to columns E1 which is hidden

The only value that is not copied is 1 added to E1, however, as you mentioned the cell is marked as readOnly: true which disallows user to change the cells value by any of the actions: edit, paste, autofil.

#4

Yes, but the value from E1 is lost in before change hook. It’s ok to leave out read only cells, but not to cut off the array in following hooks. If you compare the values (array) in before past and before change hook, you see that the value for column I is missing.

#5

You’re right. I will need to discuss this with our devs.
I have scheduled a meeting for Monday and I am back with any news later that day.

1 Like
#6

I am marking this issue as a bug.

#7

Thank you. Is there a roadmap somewhere, or can you pls tell me, when it will be fixed approx?

#8

Our source is currently on Gitlab (closed for commits). I have left myself a note to inform you as soon as the issue will get updated.

#9

As mentioned in the emails we have missed the skipColumnOnPaste (it is not a bug)

#10