Format numbers in php Excel format

I have this code to format a cell in numeric format,

$objPHPExcel->getActiveSheet() ->getStyle($colmun_alpha[$total_head+1].$row_total) ->getNumberFormat() ->setFormatCode('#,##0.00'); 

The problem is that it works with other cells, but with other cells, it does not work. It gives me the output ###### inside the cell. as you can see in the screenshot.

Screenshot here .

I was wondering what the problem is, since I used the same code to format other cells, as you can see. If you hover over ####, you can see this value, but not display like others.

Thanks for helping the guys.

+4
source share

Source: https://habr.com/ru/post/1484371/


All Articles