Sort date, then paste data, causes error

Tags: #<Tag:0x00007fc46784a728>

Steps to reproduce error:

  1. Sort the table by ‘Performance Date’
  2. Copy/Paste data from csv file (paste starting with performance date)
  3. See errrors on DateValidator and TimeValidator

I tried uploading the csv, it says it is not an allowable type.
Here is the comma separated version:
Performance Date,Performance Time,Duration In Minutes,Event Code
2/1/2020,2:00PM,165,EAV0201M
2/1/2020,5:00PM,165,EAV0201E
2/1/2020,8:00PM,165,EAV0201L
2/2/2020,12:00PM,165,EAV0202M
2/2/2020,3:00PM,165,EAV0202E
2/6/2020,7:00PM,165,EAV0206E
2/7/2020,8:00PM,165,EAV0207E
2/8/2020,2:00PM,165,EAV0208M
2/8/2020,5:00PM,165,EAV0208E
2/8/2020,8:00PM,165,EAV0208L
2/9/2020,2:00PM,165,EAV0209M
2/9/2020,5:00PM,165,EAV0209E
2/10/2020,7:00PM,165,EAV0210E
2/11/2020,7:00PM,165,EAV0211E
2/12/2020,7:00PM,165,EAV0212E
2/13/2020,7:00PM,165,EAV0213E
2/14/2020,6:00PM,165,EAV0214E
2/14/2020,9:00PM,165,EAV0214L
2/15/2020,12:00PM,165,EAV0215A
2/15/2020,3:00PM,165,EAV0215M
2/15/2020,6:00PM,165,EAV0215E
2/15/2020,9:00PM,165,EAV0215L
2/16/2020,12:00PM,165,EAV0216A
2/16/2020,3:00PM,165,EAV0216M
2/16/2020,6:00PM,165,EAV0216E

Thanks!!
Tonia

Hey Tonia,

Am I doing this right?

GIF

The background is red as the cell pattern does not meet the requirements. But I do not get any other (console) issues.

Are you pasting the Time into the Date column?

To reproduce the issue:
Sort the table by Performance Date (click once to change the sort on that column)
Then, copy the csv file data
image
Next, put cursor in first empty cell under the last performance Date in the handsontable (row 5 column 2) and paste
Errors show up in console.


Thanks!!

Thank you for sharing additional information. I asked our colleague to check this on his device.