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.
Hello,
Do you have any further questions?
I've attached the latest list of supported functions. If you are using any functions that are not marked as supported at runtime, let me know.
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.
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?