#266 [NEW]: setmerge
| From: | russ at snowcompanies dot com | Date: | Tue, 18 Nov 2003 03:45:06 +0000 |
| Subject: | #266 [NEW]: setmerge | ||
| Groups: | php.pear.webmaster | ||
| Request: | Send a blank email to pear-webmaster+get-770@lists.php.net to get a copy of this message | ||
From: russ at snowcompanies dot com
Operating system: red hat
PHP version: 4.3.3
PHP Bug Type: Web Site
Bug description: setmerge
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();
--
Edit bug report at http://pear.php.net/bugs/bug.php?id=266&edit=1
--