Description: ------------ I have tried several ways to get cells to merge. My last attempt was taken the code that is posted in example 23-3. The output is what I expected except that there are no merged cells. Reproduce code: --------------- require_once 'Spreadsheet/Excel/Writer.php'; // We give the path to our file here //$workbook = new Spreadsheet_Excel_Writer('./test/test.xls'); $workbook = new Spreadsheet_Excel_Writer(); $format_title =& $workbook->addFormat(); $format_title->setMerge(); $worksheet =& $workbook->addWorksheet(); $worksheet->write(0, 0, "", $format_title); $worksheet->write(0, 1, "", $format_title); $worksheet->write(0, 2, "", $format_title); $worksheet->write(1, 0, "Quarter", $format_bold); $worksheet->write(1, 1, "Profit", $format_bold); $worksheet->write(2, 0, "Q1"); $worksheet->write(2, 1, 0); $worksheet->write(3, 0, "Q2"); $worksheet->write(3, 1, 0); $workbook->send('test.xls'); $workbook->close();

Can you try the latest code from cvs? I added a new Worksheet::setMerge() method, but it will only work for BIFF8. You will have to do: $workbook->setVersion(8); // this is just a temporary method $worksheet =& $workbook->addWorksheet(); $worksheet->setMerge(0, 0, 0, 1); // merging just 2 cells It wont be a real fix until BIFF8 becomes the default though.