Callback for custom drag down autofill

[Zauberfisch]

when you have the cols 11, 12, 13 the autofill will repeat the pattern to 11, 12, 13, 11, 12, 13

it would be nice to be able to hand a callback to the table that overwrites the basic repeat behaviour

[mike-aungsan]

I have more or less the same issue with autofill.

I need to calculate new value and it only called onBeforeChange once and it call onChange, many times = the number of drag cell.

What I was doing is when cell value are update, total value is updated automatically by using change.push on onChange method. Since onBeforeChange method is called only once, I cannot get a way to update new value.

I tried to update cell value from onChange value, but it does not work and fall into infinite loop.

[warpech]

Thanks for your patience guys!

Handsontable 0.9.0-beta1 adds new callbacks beforeAutofill that can be used for this purpose. You are welcome to test it. Until it is merged with master branch, you will need to checkout 0.9 branch

More about new Events.

I will close this ticket when branch 0.9 is merged with master. Thanks again!

[warpech]

Handsontable 0.9.0 now features the beforeAutofill callback.

More about new events here: https://github.com/warpech/jquery-handsontable/wiki/Events

[felixhagspiel]

@warpech sorry for replying on this again, but I dont understand how that event gives us the ability to change the behaviour of the autofill. As I understand the 'beforeAutofill' callback gives us only information about the cells and the pattern, but it does not give us the ability to change it. Neither can we stop the autofill. So what we have to do is to read the pattern, then wait until the cells are filled by autofill, and then overwrite them manually. Is there a better way, i.e. returning a callback with the new values for the cells? Or am I overseeing something? Sorry if so :)

[sasuke37]

hi ,
i have a problem with the autofill :

Anyone have a solution for my problem??

(i work the last free version)

[AMBudnik]

Hi @sasuke37 you're using ngHandsontable and formulas? (as I can see in your console)
Can you share a demo where this issue is replicable?