Autofill/copy and paste operations causing table layout disruption

Tags: #<Tag:0x00007efc6d8087f0>
#1

Hi,
In handsontable v14.1.0, Under certain “Autofill” or paste operations, empty whitespace appears on the right side of the right-most column which causes table position disruption.

Steps to reproduce using the below JSFiddle link:

  1. Scroll all the way to the right-most side of the table
  2. Select one or more rows by clicking on their row headers
  3. Copy the rows to the clipboard (CTRL/CMD + C)
  4. Paste the data (CTRL/CMD + V) – either in place over existing row selection or to new/blank rows below.
  5. Observe the whitespace that appears on the right side.

Additional note: The issue does not appear to manifest if we disable the autoColumSize option and fix the column widths (e.g… colWidths: 100 ). However, our business need is to keep using autoColumSize as present.

LINK: https://jsfiddle.net/Blakeyg/1cjrdqzk/2/

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

A%20screenshot%20of%20a%20computer__Description%20automatically%20generated
A screenshot of a computer__Description automatically generated.png1133×648 78.7 KB

Thanks

#2

Thank you for sharing the issue. It might be related to the second one you reported.

I will investigate them both.

#3

It seems that this issue is not a regression. I tested versions as old as 8.4.0 and it works the same.

Here https://jsfiddle.net/1xoube5s/3/ is a simplified demo.

It seems that the length of the column header is the cause of the issue. When we scroll, and the viewport changes, the issue is replicable. When we force all of the columns to load (with viewportColumnRenderingOffset or renderAllColumns) this issue is not replicable.

I reported it internally and will come back to you as soon as we have updates on the subject.

Reference

#4

Hi @aleksandra_budnik
Thanks for suggesting the workaround but viewportColumnRenderingOffset or renderAllColumns options impacting our performance.
Just wanted to know what is the ETA & Can we also have link of GitHub to track the progress?
Thanks

#5

This issue is reported internally. But I created a notification to inform you when we have a pull request (that is public). So then you’ll be able to check the PR from the creation to the merge and then get my another notification after the release.

"Drag" fill (Autofill) creating incorrect errors
#6

Hi @aleksandra_budnik
When can we expect the issue to be fixed, and in which version will it be released?
Thanks

#7

Hi @siddhantjain15298

This issue hasn’t been estimated yet. I will make sure to keep you updated.

#8

Hi @aleksandra_budnik
We are just checking the status of the issue. Have you estimated the effort yet, and when can we expect a fix and release?
Thanks

#9

Hi @siddhantjain15298

This issue awaits investigation and estimation. I will inform you when we’ll fix it.

#10

Hi Aleksandra, hope you’re well. I work with Siddhant and, as he mentioned, we are an existing commercial customer. We raised this over a month ago so could you please escalate this for investigation/estimation? Thank you.

"Drag" fill (Autofill) creating incorrect errors
"Drag" fill (Autofill) creating incorrect errors
#11

As in [GH-DEV1889] "Drag" fill (Autofill) creating incorrect errors issue was estimated and scheduled to be fixed.

#12

Hey Aleksandra, just wondering if any update on this in terms of possible ETA for fix? Thanks!

#13

Hey @blake.gilchrist

This issue is in progress. We already have a draft for the fix at https://github.com/handsontable/handsontable/pull/11049 but the development is not ready yet.

#14

Ok, thank you. Please keep us posted.

#15

Hi @siddhantjain15298 @blake.gilchrist

We just released Handsontable14.5 which fixes the bug: https://github.com/handsontable/handsontable/pull/11049

1 Like
#16

That’s great, thanks Adrian. We’ll update to v14.5 ASAP and let you know if any further issues.

#17