Bug #8701

Problems with the method setTextRotation()

Details

Submitted	2006-09-14 15:26 UTC
From	mjansen at databay dot de
Assigned	progi1984
Status	Closed
Package	Spreadsheet_Excel_Writer
PHP Version	4.3.1
OS	Linux/SuSE
Roadmaps	(Not assigned)

Comments

[2006-09-14 15:26 UTC] mjansen at databay dot de

Description:
------------
If I use the method setVersion(8) to merge some cells with the experimental method mergeCells(), the text rotating in these merged cells does not work anymore.

Test script:
---------------
require_once("Spreadsheet/Excel/Writer.php");
$this->workbook = new Spreadsheet_Excel_Writer();
$this->workbook->setVersion(8);
$this->worksheet =& $this->workbook->addWorksheet('xyz');
$this->format =& $this->workbook->addFormat(array('TextRotation'=>270, 'Align' => 'center', 'Top' => 1, 'Right' => 1, 'Bottom' => 1, 'Left' => 1));
$this->worksheet->write(0, 0, "abc123", $this->format);
$this->worksheet->mergeCells(0,0,10,10);
$this->workbook->close();

Expected result:
----------------
I expect, that the text appears in the horizontal center of the merged cells, with a border (left, right, bottom and top), rotated 270 degree.