Bad formula result

Topics: Developer Forum
Oct 18, 2013 at 10:27 AM

I've this formula into several column of a Excel file.

Into Excel, i read result without problem.
With PHPExcel, i often get result without problem, but sometime i get "#N/A".

I don't understand why, it looks like PHPExcel bug because i don't have any error into MS Excel.

I read something onto office website (sorry, in french only:
If i sort Excel VLOOKUP target, i get result without error.

Is it a PHPExcel bug, or did i badly use it ?

Thanks for help.
Oct 22, 2013 at 11:23 AM
Please read the section of the developer documentation on locale settings and formulae