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.
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.
Hello,
Do you have any further questions?
I believe not.
Thank you.
If one of the cells referenced in the formula is ultimately using a function not supported at runtime, we may be able to add that support as a bug fix, so that was why I wanted to know if you were using any functions like that.
Hello Mike.
We use only the supported function SUM(). Currently we don’t need others functions.
About the issue we have found a simple workaround: instead to read the value form the formula cell (while we populate the sheet) we get the desired value from our data model.
Regards.