Hello,

I am using Infragistics 15.1, I have an excel file with Rank.EQ formulas in it.

The goal is to load the file and fill in the columns with data which inturn would recalc the Rank columns.

When I load the file I receive the following error.

The formula has extra expressions after the end of it.

Portion with error: (D3,D3:D34)

Here is the C# code I use to open the file, which works fine if I remove the Rank.EQ formulas.

Workbook workbook = Workbook.Load( Application.StartupPath + @"\ExcelTemplates\Excel Formula Test.xlsx" );

In the excel file in Column E3 I have the formula =RANK.EQ(D3,D3:D34)

I would attach the Excel file but the file type is being refused in uploading.

Thanks in advance!