Strange formula problem

Aspose.Cells Product Family
1

I am successfully createing a spreadsheet that uses a column that displays rankings depending of the previous column values. A sample formula looks like this:

=IF(ISERROR(RANK(O7,O6:O48,0)),"",RANK(O7,O6:O48,0))

When I actually send the file through the browser, the user sees a #NAME error on the formula. If they go into the formula by hitting F2 and then immediatly hit the Enter key, the formula works as exected. Any idea as to what is happening? The cell that this formula is looking at (O7 in this case) is actually another formula, which looks like this:

=IF(SUM(G7:N7)=0,"",SUM(G7:N7))

TIA,

Rob

2

Hi Rob,

ISERROR function is not supported and it caused this problem. I added it in the attached fix. Please try it.

3

Thank you! It's great to see a company respond so quickly with an update.

Thanks again,

Rob