Formula error in 1.7.2

Jan 25, 2010 at 8:40 AM


my application use phpexcel 1.7.1 successfully. i tried version 1.7.2 but i always have an error : _raiseFormulaError message is Formula Error: An unexpected error occured

Here is the formula which worked with phpExcel 1.6.7 and 1.7.1


Do you have any idea ?

Jan 25, 2010 at 8:58 AM

So i replaced ; with , and now this error seems to be corrected

But i have another one : <b>Warning</b>:  mb_substr() expects parameter 3 to be long, string given in <b>C:\wamp\www\copix_svn\utils\phpexcel\Classes\PHPExcel\Calculation\Functions.php</b> on line <b>5195</b><br />

It seems to be the MID functions which has a problem because of the third params. I use MID 2 times, the first time the third param is the LEN(c19))-MID(c19;1;FIND("-";c19;1)-1) and the second time it is inside the first time : MID(c19;1;FIND("-";c19;1)-1)

It worked in previous version, any idea ?

Jan 25, 2010 at 9:15 PM

Can you upload an example of a worksheet that uses this formula, specifically indicating the values in cells C19, D19, E19, F19 and G19. I'd like to identify what value is actually being passed as that third parameter to MID()

Jan 26, 2010 at 6:55 AM
Edited Jan 27, 2010 at 12:11 PM

Here is a sample of the line 19, cells from C to G are string : "HH:MM-HH:MM".
This is when the cells are empty that the error happens (cells E19 and G19 in that case).

If i can upload the sample i'll do and update this post, thanks.

C D  E F
 G Formula
08:15-18:00 08:15-18:00   08:15-18:00   29:15
Jan 29, 2010 at 7:26 PM

I've not yet managed to replicate this error; so if you can manage to provide an excel file that demonstrates the problem, I'd appreciate it.