How to obtain old and new value of the cells while performing drag fill operation in Spreadsheet?

You have to create a new class which is derived from FillSeriesController and override the FillSeries & CopyCells methods to get the old and new value of the cells while performing drag and fill operation.

FillSeries method is invoked when the cell values are filled in a series after dragging and CopyCells method is invoked when the cell values are copied after dragging. On both methods, you can get the filled range from the argument “newRange”. Get the old value of the cells before calling the base method and get the new value of the cells after calling the base method like below code example.

Then assign the instance of that custom FillSeriesController to the FillSeriesController property of each SpreadsheetGrid in the WorkbookLoaded and WorksheetAdded event of Spreadsheet.

C#

Sample Link:

WPF

UWP