I am using the following code to modify a template excel sheet with a very basic formula .i.e =SUM(B1,B2,C1,D2)
$objReader = PHPExcel_IOFactory::createReader('Excel2007');
//we load the file that we want to read
$objPHPExcel = $objReader->load("test.xlsx");
//we change the file
//we create a new file
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
The new generated file will be generated with reversed GUI. Where as if I remove the SUM formula then everything works fine.
PFA excel file for example.
Does anyone have any idea how to fix this?
Thanks in advance
I also faced same issue.
Steps to reproduce this issue:
1) create excel file using phpexcel lib.
2) download the file and edit it libre-office.
3) upload the edited file. Try to alter few cells through code using phpexcel and save the file using the phpexcel.
The final file will have reverse GUI as explained in the previous post.
Thanks and Regards,