Description: ------------ I am not able to set the format for merged cells using worksheet's (not formats) setmerge function. I was trying to specify a border for a set of merged cells on multiple lines. I also could not see a way to vertically align the data. Reproduce code: --------------- // $this = custom excel writer class $formatArray = array( 'size' => 10, 'top' => 1, 'left' => 1, 'right' => 1,'align' => 'center' ); $this->format['box_trl'] = $this->xls->addFormat( $formatArray ); // getCol simply returns the integer $ws->write( $row, $this->getCol("N"), "Notes", $this->format['box_trl'] ); // Merge the 2x2 columns $ws->setMerge( $row++, $col++, $row--, $col ); Expected result: ---------------- A 2x2 merged cell with top, left and right borders. Actual result: -------------- The top and left borders appear on the first formatted cell, the rest are unformated.

This is an enormous problem when trying to create advanced excel spreadsheets used in business reporting. Is there even a workaround for this problem?

Here's a work around, however all entries in the border will be centered $cart =& $xls->addWorksheet('workSheet'); $borderC =& $xls->addFormat(); $borderC->setFontFamily('Arial'); $borderC->setSize('10'); $borderC->setAlign('left'); $borderC->setColor('black'); $borderC->setTextWrap(); $borderC->setBorder (1); $borderC->setAlign('merge'); # Required for cell merge setupMergeCells(1, 1, 4, 4, $borderC, $cart); $cart->write(1,1,"some testing",$borderC); function setupMergeCells($sRow, $sCol, $eRow, $eCol, $fStyle, $cart) { $cart->mergeCells ($sRow, $sCol, $eRow, $eCol); for($i = $sRow; $i <=$eRow; $i++) { for($j = $sCol; $j <= $eCol; $j++) { $cart->write($i,$j,'',$fStyle); } } }

this works for me: require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer('bla.xls'); $worksheet =& $workbook->addWorksheet('data'); $workbook->setVersion(8); $format = $workbook->addFormat(array('top' => 1, 'left' => 1, 'right' => 1,'align' => 'center')); $worksheet->write(1, 1, "hola", $format); $worksheet->writeBlank(1, 2, $format); $worksheet->writeBlank(2, 1, $format); $worksheet->writeBlank(2, 2, $format); $worksheet->mergeCells(1, 1, 2, 2); $workbook->close();

this works for me: require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer('bla.xls'); $worksheet =& $workbook->addWorksheet('data'); $workbook->setVersion(8); $format = $workbook->addFormat(array('top' => 1, 'left' => 1, 'right' => 1,'align' => 'center')); $worksheet->write(1, 1, "hola", $format); $worksheet->writeBlank(1, 2, $format); $worksheet->writeBlank(2, 1, $format); $worksheet->writeBlank(2, 2, $format); $worksheet->mergeCells(1, 1, 2, 2); $workbook->close();

this works for me: require_once 'Spreadsheet/Excel/Writer.php'; $workbook = new Spreadsheet_Excel_Writer('bla.xls'); $worksheet =& $workbook->addWorksheet('data'); $workbook->setVersion(8); $format = $workbook->addFormat(array('top' => 1, 'left' => 1, 'right' => 1,'align' => 'center')); $worksheet->write(1, 1, "hola", $format); $worksheet->writeBlank(1, 2, $format); $worksheet->writeBlank(2, 1, $format); $worksheet->writeBlank(2, 2, $format); $worksheet->mergeCells(1, 1, 2, 2); $workbook->close();

Hy, i used that function, and now i have a top border for my merged cells but i can't align vertical my text from that cell. Before, when i used function setMerge() i had a vertical align for my text, but doesn't want to work with function setupMergeCells() (for vertical alignment i used setVAlign('vcenter') ). So, i solved one problem and i create a new one. Do you have a solution for this? Thank.