Can i override the AutoFill behaviour for the below scenario?
I need to appy a specific calculation before autofilling the value in destination cells.
See the attached screenshot. I want to drag the value in JUN column of first row to the columns JUL, AUG and SEP. So i will select JUN cell and drag it to the right to copy the value (40 in this case) to JUL, AUG and SEP columns.
Hoewver, if the column is AUG, i need to copy twice the value in JUN… In other words, it should copy 80 to AUG column and 40 each to JUL and SEP columns. How can i override the default Autofill behaviour?
I tried overriding in beforeAutoFill hook, but no luck. Could you please suggest a possible solution?