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.
Alex,
The list that Mike posted earlier in this thread is still the current list of supported functions. If there are more functions that you would like to see implemented you can request them on our ideas site: http://ideas.infragistics.com/
Let me know if you have any questions.
Hi Mike,
I found the list of supported functions very useful... thank you. I imagine the list as of 2014 is longer. Do you happen to have a new list available?
Thanks!
Alex
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.
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.
I believe not.
Thank you.