Infragistics Forums

Hi,

I have a grid with a cell value of double.NaN, showing as "n. def" (german locale). Thats correct and works as expected.

Now I export this grid to excel, and I would expect a result of  #NV (e.g. also shown when you add a formula =NV() ), showing that no value is defined for this cell of type double.

But, it is exported and shown a value 2,69653970229347E+308, which is definitely wrong and misleading.

 Is there a workaround?

P.S.

I do not want to change the value to zero within CellExporting, as zero is misleading (one would think it is a valid value), and is definitely another value than NaN.

I was unable to use the =NV() formula in Excel 2007. If you can post a workbook file with this error in one of the cells I might have a better understanding of how this error type works so I can offer more help.

file is attached:

D2 .. D5  the expported value:

 B8: The value that I would have expected (#nv)

It appears the function names might be localized and that is probably why I could not use the function. In the workbook you sent, the formula was =NA() and the error value was #N/A. However, while I agree with you that the value our Excel assembly is exporting is incorrect, I believe a divide by zero (#DIV/0!) error should be in the cell, not #NV. The reason for this is that Double.NaN occurs when you divide 0 by 0. If you place the formula =0/0 in a cell in Excel, it results in a #DIV/0! error.

In either case, it is a bug and I would recommend submitting this to the support group: http://www.infragistics.com/gethelp.