Saving formula with percentage problem

Topics: Developer Forum
Sep 21, 2011 at 8:25 AM

Hi,

I have reported following problem. In source xls file I have a formula with % symbol such as "=A2*50%+B2". Loading of this file works fine. But after saving file in Excel5 format using PHPExcel_Writer_Excel5, the output spreadsheet contains cell with truncated formula like "=A2*50%". In other words, saving removes all characters after % symbol. Saving for Excel2007 is OK for this case.

Maybe it is bug in Excel5 Writer or exist another solution? Thanks.