Posted 11 November 2017, 4:27 pm ESTIs there any way I get all dirty cells after updating a formula/value for a cell?
Posted by: nchalla on 11 November 2017, 4:27 pm EST
Replied 13 November 2017, 10:16 am ESTHello,
I have asked the development if there is a direct way of finding all dirty cells updated through formula or using Value.
I will let you know as soon as I get an update on this. The tracking id for this issue 249737.
Replied 15 November 2017, 2:28 pm ESTAny update on this?
Replied 16 November 2017, 5:18 am ESTHello,
I have asked for an update from the development team about this issue. I will let you know as soon as I get an update on this.
Marked as Answer
Replied 18 December 2017, 5:41 am ESTHello,
Developer has provide the following solution to get the dirty range:
static void Main(string args)
Workbook book = new Workbook();
IWorksheet sheet1 = book.Worksheets;
sheet1.Range["a1"].Value = 5;
sheet1.Range["a2"].Value = 10;
sheet1.Range["c1"].Formula = "2*a1*a2";
sheet1.Range["e1"].Formula = "3*a1*a2";
IWorksheet sheet2 = book.Worksheets.Add();
sheet2.Range["a1"].Formula = "4 * sheet1!a1 * sheet1!a2";
sheet2.Changed += Sheet2_Changed;
sheet1.Changed += Sheet1_Changed;
sheet1.Range["a2"].Value = "20";
private static void Sheet2_Changed(object sender, RangeEventArgs e)
Console.WriteLine("Sheet2 Affected Ranges: " + e.Range);
private static void Sheet1_Changed(object sender, RangeEventArgs e)
Console.WriteLine("Sheet1 Affected Ranges: " + e.Range);