Dirty Cells

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

  • 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?
  • Replied 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
  • Replied 15 November 2017, 5:28 am EST

    Any update on this?
  • Replied 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
  • Marked as Answer

    Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels