"Drag" fill (Autofill) creating incorrect errors

Tags: #<Tag:0x00007efc62384ea0>
#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.

#6

Hi @aleksandra_budnik
I just wanted to check the status of the issue. Could you please provide an update on the progress and when we might expect this to be released?
Thanks

#7

Hi @siddhantjain15298

We do not have any updates regarding this issue yet.

Autofill/copy and paste operations causing table layout disruption
#8

Hi Aleksandra. As per my comment under another ticket ([GH-DEV #1888] Autofill/copy and paste operations causing table layout disruption) could you please escalate this for investigation/estimation? Thank you.

#9

Hi @blake.gilchrist

We have reported this issue and [GH-DEV #1888] Autofill/copy and paste operations causing table layout disruption as a separate issue. However, both of them were discussed today on the planning meeting and got an estimation.

I will inform you as soon as we fix it. Both issues are added to the sprint, but unless they are merged with the develop branch and tested, everything can happen.

#10

Thank you. Good to hear you’ve done initial estimations and hope these aren’t too large/difficult to fix. Please do keep us updated.

1 Like
#11

Hi Aleksandra, any update on this one please? Thanks.

#12

Hi @blake.gilchrist

If everything works well on the production (during code freeze), this issue will be fixed in the next version.

Here’s the demo with the current build https://jsfiddle.net/gafc8dxz/. Please let me know if it works well for you.

#13

Hey Aleksandra, sorry for the delayed reply. That’s great, thank you. The updated demo that you linked worked for me and the error no longer occurs.

When is the next version scheduled for release, please (even if just approximate)?

#14

Most of the issues we wanted to solve are already finished, but based on vacation schedules, we might have a slight delay with the code freeze, so the date could be the end of July the soonest, but most probably the beginning of August (we plan to have a minor version released).

If you’d like to test it now I can recommend using our pre-release builds at https://www.npmjs.com/package/handsontable?activeTab=versions. The last one was updated ~20 hours ago.

1 Like
#15

Great, thank you.

#16

Hi @siddhantjain15298 @blake.gilchrist

I am happy to inform you that this issue is fixed in the newest release of Handsontable 14.5: https://github.com/handsontable/handsontable/pull/11038

1 Like
#17