Formula with error

Feb 1, 2011 at 7:06 AM

Hello.

 When I set CellFormula to "!Rec", the EPPlus does not create exception. But when open excel file with MS Excel, not set anything and cell is blank.

When set the cell formula in MS Excel to !Rec (=!Rec), Excel raise error.

How can I get error in EPPlus when set a formula with error?

Thanks a lot.

Coordinator
Feb 1, 2011 at 4:59 PM

Hi,

Do you mean #REF! ?

Feb 3, 2011 at 4:18 AM

No, any expression that start with "!" (=!MyExpression). There is same problem if set formula to a datetime value (=2011/05/07 12:01:05).

Coordinator
Feb 3, 2011 at 2:06 PM

Ok, I see what you mean.

There is no validation in EPPlus when the formula property is set, so you have to be carefull.

I think it's quite complicated to add, so that will be something for the future.

Jan