I am having a problem importing Excel value/formulas from an .xlsx spreadsheet where the spreadsheet contains formulas created in Excel by dragging the fill handle to copy formulas.
I open a spreadsheet in Excel and create a cell with a simple formula in a cell (say =A1) then drag the 'fill handle' down the column to copy the formula to other rows in then column.
I then read the spreadsheet from my app using using Infragistics.Excel 10.2:Worksheet.Rows[row].Cells[column].Value;
I can retrieve the correct values and formula from first row and the second row of the column. Unfortunately the third and subsequent rows all incorrectly show the value/formula of the second row.
Interestingly, I have no problem reading the same formulas from an .xls files.
Is this a known bug/limitation?
This is a known issue that has been fixed and released in the SRs for 10.1 and later. Try installing the latest SR and it should fix the issue.
Thanks Mike, I (finally!) updated to the latest version and SR (2011 ver2 2019). Excel formula values created with "copy down" are now correctly read from .xlsx files. Thanks for the tip!