[GH-DEV1889] "Drag" fill (Autofill) creating incorrect errors

Tags: #<Tag:0x00007f1360497620> #<Tag:0x00007f1360497490>
#1

Hi,
In Handsontable v14.1.0, When doing autofill by selecting more than one column and row, its throwing ‘invalid date’ error in the cell.

Steps to reproduce:

  1. In the below JSFiddle example, Select From C4, D4 to C5, D5 cells.
  2. Now Drag/Autofill to 11th row.
  3. Observe that There is a ‘invalid date’ is appearing.

Additional note: Its happening only when one of the columns in data have type date

LINK: https://jsfiddle.net/taLm7u50/69/

We are an existing customer and this is creating issues in our live product environment. It would be great if this could be fixed.
Please refer the attached image
Invalid%20Date

Thanks

#2

Thank you for sharing the example, @siddhantjain15298

I replicated the issue. I will investigate it further and update you after the weekend.

#3

Hey @siddhantjain15298

I wasn’t able to find the workaround for the issue. But after simplification of the example https://jsfiddle.net/L3z1nek8/ I found out that the date is causing the issue. If we type something incorrect to the date cell and autofill it, it adds a ' char to the result, and this only happens when the Formulas are on.

39

I have posted all the resources in our internal ticketing system and will get back to you as soon as we fix it.

#4

Hi @aleksandra_budnik

It’s been a week we have raised the issue. Just wanted to know what is the ETA & Can we also have link of GitHub to track the progress?

Thanks

#5

Hi @siddhantjain15298

as in [GH-DEV #1888] Autofill/copy and paste operations causing table layout disruption I created a notification to let you know when we create an official pull request.