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.

I confirm this bug. I need to use setVersion(8) to be able to set the UTF-8 with setEncoding("utf8"). So using setTextRotate() in this case doesn't affect anything.

After some research I found a solution (patch) for this problem: I am not familiar with providing a patch, but just wanted to share the code, for if anyone needs it: There is the following line inside Format.php, method getXf($style): $rotation = 0x00; (in my version it is on line 432) If you replace this line with the following code it should work: switch($this->_rotation){ case 0: $rotation = 0; break; case 1: $rotation = 255; break; case 2: $rotation = 90; break; case 3: $rotation = 180; break; default: $rotation = 0; break; }

The following patch has been added/updated: Patch Name: Bug8701 Revision: 1249478543 URL: http://pear.php.net/bugs/patch-display.php?bug=8701&patch=Bug8701&revision=1249478543&display=1

The patch Bug8701 contains the text rotation for biff5 et biff8. Not only Biff8 like momobil.

The patch introduces tabs instead of spaces which are not allowed according to our coding standards - please fix that.

The following patch has been added/updated: Patch Name: Bug8701.patch Revision: 1249896652 URL: http://pear.php.net/bugs/patch-display.php?bug=8701&patch=Bug8701.patch&revision=1249896652&display=1

This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.