Formula Feature - Handsontable Angular wrapper

amol · September 14, 2017, 5:10am

One of the key feature required in my application is Drag-Copy formula.
Details:
When I drag bottom right square for cells with formula only value is getting copied and not the actual formula.
e.g A1 cell having formula set to =B1*2
When drag from A1 across A5 only value from A1 cell gets copied in the rest of the 4 cells.

Expected results : Respective formulas should have carried forward. and auto referencing of cells. This feature is available in Handontable demo

Plz chk - http://handsontable.github.io/handsontable-ruleJS/

aleksandra_budnik · September 14, 2017, 6:59am

As previously mentioned. When it comes to this feature I think that I have found a workaround.

The getSourceDataAtCell method returns the formula under coordinates (row, col). You can use this information while handling data copy in the beforeChange hook with the 2nd parameter set to 'Autofill.fill'. It will allow you to use the setDataAtCell method with the getSourceDataAtCell (plain formula).