Hi.
I’m writing a complex Excel file using Infragistics2.Documents.Excel.v11.1 build 11.1.20111.1003 onto a Windows 7 x64 system. Some cells have a formula and opening the saved worksheet with Excel 2010 all works fine. But if I try to read a formula cell value while I populating the sheet I got the following strange data:
From Visual Studio 2010 immediate windows:
ws.Rows[row].Cells[column]
{Risparmi!$AC$538}
AssociatedDataTable: null
AssociatedMergedCellsRegion: null
CellFormat: {Infragistics.Documents.Excel.WorksheetCellOwnedFormatProxy}
ColumnIndex: 28
Comment: null
Formula: Formula: =R538C28/R531C28
HasComment: false
RowIndex: 537
Value: {#NAME?}
Worksheet: Worksheet: "Risparmi"
What’s mean #NAME? in the cell value property?
I’m reasonably sure that when I try to read this value all cells are populated and the formula should works.
Diego.
This usually means the cell has a formula which is either using a named reference name which doesn't exist or a function which currently isn't supported by the Excel library. But I can see from the formula that it is actually referring to 2 cells in R1C1 form. Is the workbook in the R1C1 reference mode?
Hi Mike.
Is the workbook in the R1C1 reference mode? --> Yes! We use R1C1 mode only.
Where we can find the complete list of supported Excel functions?
Thanks in advance.