Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
605
Performance Issue & Unable to read certain formula fields
posted

I am using the following version of the Infragistics Excel dlls:-

Name: Infragistics3.Documents.Excel.v12.1

Version:12.1.20121.2008

I am facing following issues:-

  1. Infragistics excel dll unable to evaluate the certain field formula. For example in the attached excel sheet, for row 86 (A86 ="Royalty Installment Calculated"),  i got “#CIRCULARITY!”  instead of 0 for cells E86, F86, G86 etc.
  2. Infragistics excel took long time to read the first sheet.

 

 

DataFile.zip
  • 44743
    Verified Answer
    posted

    The first issue may be a bug. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue. As far as performance, when you access the first calculated value in the workbook, all formulas are calculated if they haven't been calculated yet. That is probably why the first sheet is taking so long. However, I will have DS submit a second issue so we can do a performance pass and see if any improvements can be made.