Dirty Cells

Dirty Cells

Posted by: nchalla on 11 November 2017, 7:27 am EST

• 

  nchalla

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 November 2017, 7:27 am EST

  Is there any way I get all dirty cells after updating a formula/value for a cell?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 13 November 2017, 1:16 am EST

  Hello,

  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.

  Thanks,
  
  Deepak Sharma

• 

  nchalla

  • Post Options:
  • Link
    Copy

  Posted 15 November 2017, 5:28 am EST

  Any update on this?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 15 November 2017, 8:18 pm EST

  Hello,

  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.

  Thanks,
  
  Deepak Sharma

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 17 December 2017, 8:41 pm EST

  Hello,

  Developer has provide the following solution to get the dirty range:

  
  class Program
      {
          static void Main(string[] args)
          {
              Workbook book = new Workbook();
              IWorksheet sheet1 = book.Worksheets[0];
              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";
  
              Console.ReadLine();
          }
  
          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);
          }
  
  

  Thanks,
  
  Deepak Sharma