percentage format not working Excel2007

Topics: Developer Forum
Oct 16, 2014 at 6:09 AM
Edited Oct 16, 2014 at 6:10 AM
Hello.

We are using below code for reading and writing xlsx. and also that xlsx have many conditonal formatting and percentage values.
 $objReader = PHPExcel_IOFactory::createReader('Excel2007');
 $objPHPExcel = $objReader->load('input.xlsx');

 $objWriter =PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
 $objWriter->save('output.xlsx');
but on result output.xlsx file not showing same as input xlsx file
We are not fetching same result of percentage value and can't showing percentage symbol/format value on cell.

example like in
 input.xlsx file cell value 85%
than result is
output.xlsx file cell value 0.85
Could you please help us for above issue?

Any help on this problem would be greatly appreciated!

Thank you in advance!