I'm using the perl module Spreadsheet::WriteExcel and wanted to add support for
rotating the y-axis text of charts. This is what I found to get this
functionality supported.
Excel axis formatting Alignment Orientation
TickRecord
.zero3 = degrees of orientation, if set autoRotation is false
for 0 - 90 degrees in above interface zero3 is 0-90
00-5A
for -1 - -90 degrees in above interface zero3 is 91-180
5B-B4
.rotation will depend on the actual amount of rotation
.rotation = 2 at +90, 3 at -90, 0 otherwise
Hope this is useful for this effort as well. I found your BiffViewer helpful in
investigating the above.
Thanks,
Matthew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
