We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Divide by Zero error #DIV/0?

Hi There,

I use GridWeb Cells control to render my data.

I use formulas to on certail cells, which look like this

A10 = (A8+A9)/(A6+A7)

When the grid loads, it may not contain any value. Hence that the A10 cell shows value as "#DIV/0?".

Is there any way to avoid such error, and show value 0 when such error occurs?

Please reply ASAP.

Thanks in advance,

~Yuva

Hi,


It is not an issue. Aspose.Cells.GridWeb follows MS Excel standards and does the same as MS Excel does. You may confirm this in MS Excel and you can see MS Excel also shows #DIV/0?” error the formula.

Thank you.