Performance Issue & Unable to read certain formula fields | Infragistics Forums

State See Verified Answer
Replies 6 replies
Subscribers 8 subscribers
Views 1617329 views
Users 0 members are here

Excel Library

605

Performance Issue & Unable to read certain formula fields

Garth posted over 12 years ago

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:-

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.
Infragistics excel took long time to read the first sheet.

DataFile.zip

605

Garth posted over 11 years ago in reply to Mike Dour

Thanks for updates!
Cancel
Reply

Cancel
44743

Mike Dour posted over 11 years ago in reply to Mike Dour

I apologize, I see that you reported this issue in 12.1. The first SR to contain the fix for this version is 12.1.20121.2071.
Cancel
Reply

Cancel
44743

Mike Dour posted over 11 years ago in reply to Garth

As it turns out, these were both one issue. The circularity errors were causing the performance problem. It was fixed on 10/1/12 and the first SR to contain the fix was 12.2.20122.2006.
Cancel
Reply

Cancel
605

Garth posted over 11 years ago in reply to Robert Stoffers

Did both issues mentioned above fixed now? If yes , then what is the SR number?
Cancel
Reply

Cancel
34510

Verified Answer
Offline Robert Stoffers posted over 12 years ago

Hi Garth,

I have been asked to create a case for you for this issue. Your case number is CAS-97706-4LB0JS. I have also logged these issues with development for further investigation. They have been linked to your case so that when a fix or other resolution is found you will be notified automatically. The ID for each of these issues are:

118629 - "#CIRCULARITY!" issue

118632 - Reading performance issue
Cancel
Reply

Reject Answer

Cancel