[8.0.0] Sort date, then paste data, causes error

Tags: #<Tag:0x00007efc61ca01c0>
#1

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

#2

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.

#3

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.

image
image.png1467×831 71 KB

Thanks!!

#4

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

#5

Thank you. I look forward to a response.

#6

I think we need to wait to version 8.0.0 in which all toPhysicalRow / toPhysicalColumn / toVisualRow / toVisualColumn functions won’t return non-nullable index for unpresent element anymore.

#7

Is there a temporary fix in the meantime that I can implement to allow for sorting by date column and then pasting in new rows?

Thank you!

#8

I’ll try to find a workaround to this within a few days.
Maybe at the end of this week, I can share with you some advice.

#9

Hey @toniamarie2000

we’ve investigated the subject with @piotr.nowak but it looks like the best way to get this done is to wait for the official 8.0.0. Any other workaround would be too messy and could cause additional issues.

I will update you as soon as we publish 8.0.0

#10

Thank you. I would appreciate that.

#11

Hi @toniamarie2000

I’m glad to announce that Handsontable v8.0.0 that solves this issue is live!

CDN https://cdn.jsdelivr.net/gh/handsontable/handsontable@latest/dist/handsontable.full.css
https://cdn.jsdelivr.net/gh/handsontable/handsontable@latest/dist/handsontable.full.js
NPM npm i handsontable
Release Notes https://github.com/handsontable/handsontable/releases

If you’d share any feedback please send it to support@handsontable.com

#12