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.
I am currently using Infragistics4.WebUI.Excel.v10.3 version 10.3.20103.1013 and I am facing the same issue. If there are formulas in a Column then the first and the second row are displaying the correct data where as records from the third row are getting the formula from the second row. As the result the values are incorrect.
Do let me know if there is a workaround for the same.
Thanks and Regards,
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!