search

liuggio / ExcelBundle

Excel integration in Symfony2 thanks to https://github.com/PHPOffice/PHPExcel library
www.welcometothebundle.com
MIT License
369 stars 142 forks source link

getCalculatedValue doesn't work when formula has accent #130

Closed thibaudgirard closed 3 years ago

thibaudgirard commented 6 years ago

Hi,

When parsing file, the method getCalculatedValue throws PHPExcel_Calculation_Exception when it encountered an accentuated character in formula (rendered : �). Especially in _parseFormula function in Calculation class. Here is an example of formula encountered :

VLOOKUP(Feuil1!C17,réf,2,0)

Thank you for any help.