search

mk-j / PHP_XLSXWriter

Lightweight XLSX Excel Spreadsheet Writer in PHP
MIT License
1.84k stars 665 forks source link

Adding border style to PHP_XLSX causes Excel load to fail #255

Closed pdubinsky closed 3 years ago

pdubinsky commented 4 years ago

If I add a style like this:

$styles1 = array( array(),['border'=>'left,top,bottom'],['border'=>'top,bottom'],['border'=>'top,bottom,right']); $writer->writeSheetRow('Iota-5', $row, $styles1);

MS Excel refuses to load the xlsx file while LibreOffice opens the xlsx file correctly. If I remove the $style1 from the code like this:

$writer->writeSheetRow('Iota-5', $row);

Both MS Excel and LibrOffice load correctly. The rows are 3 cells wide.