Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
370
Excel formula computing
posted

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.

Parents Reply Children