FAQ
Edit report at https://pear.php.net/bugs/bug.php?id=18897&edit=1

ID: 18897
Updated by: daniel.oconnor@gmail.com
Reported By: patrick dot douret at axyus dot com
Summary: Excel format rotation angle
-Status: Open
+Status: Feedback
Type: Bug
Package: Spreadsheet_Excel_Writer
Operating System: Debian
Package Version: 0.9.2
PHP Version: 5.3.1
Roadmap Versions:
New Comment:

-Status: Open
+Status: Feedback
Can you fork & send in a pull request for this?


Previous Comments:
------------------------------------------------------------------------

[2011-10-10 14:05:52] pdouret

Description:
------------
When setting up a rotation for a cell format, rotation angle is never
taken into account.

Test script:
---------------
$workbook = & new Spreadsheet_Excel_Writer_Workbook($fname);
$workbook->setVersion(8);
$worksheet = & $workbook->addworksheet("MyWorkSheet");
$fHzTitre_1 = & $workbook->addformat(array('bold' => 1,
'color' => 'black',
'font' => 'Arial',
'size' => 10,
'align' => 'center',
//'align' => 'vcentre',
'border' => 1,
'textwrap'));
$fHzTitre_1->setTextRotation(30);
...


Expected result:
----------------
In my case, each cell having "fHzTitre_1" as format, should have a
rotation angle of 30°

Actual result:
--------------
No rotation

To get the rotation OK, I had to modify as follow function
"setTextRotation" of library "Format.php":

function setTextRotation($angle)
{

if($this->_BIFF_version == 0x0600) {
$this->_rotation = $angle;
} else {
switch ($angle) {
case 0:
$this->_rotation = 0;
break;
case 90:
$this->_rotation = 3;
break;
case 270:
$this->_rotation = 2;
break;
case -1:
$this->_rotation = 1;
break;
default :
return $this->raiseError("Invalid value
for angle.".
" Possible
values are: 0, 90, 270 and -1 ".
"for stacking
top-to-bottom.");
$this->_rotation = 0;
break;
}
}
}

------------------------------------------------------------------------

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
grouppear-bugs @
categoriesphp
postedJan 26, '12 at 2:24a
activeJan 26, '12 at 2:24a
posts1
users1
websitepear.php.net

1 user in discussion

Daniel Oconnor: 1 post

People

Translate

site design / logo © 2022 Grokbase