Phpexcel error generate Excel using CONT.SES Formula with signal =

Asked

Viewed 74 times

0

Good afternoon,

I made an implementation to generate an excel spreadsheet where in a cell the formula CONT.SES() should be inserted. But if I put the equal sign (=) before the CONT.SES() -> =CONT.SES the following error message is thrown:

B4 -> Formula Error: An Unexpected error occured

Only works if you don’t have the = signal before CONT.SES.

Would anyone know how to fix it?

Thank you in advance.

  • But CONT.SES() needs the parameters, otherwise it returns error, it needs the interval and the comparator: =CONT.SES(range;"=Something")

  • Yes, it has all the parameters there in the code, I put here without the parameters CONT.SES() just to simplify.... The error is thrown if you have the signal = before, without the equal signal works perfectly.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.