Unable to rotate text -90 or 270

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Unable to rotate text -90 or 270

Postby tmayne77 » Mon Nov 15, 2010 6:06 pm

I am unable to rotate text either -90 or 270 degrees using the following code:
sheet.Range(1,8 ).Style.rotation = -90

I get the following error:
Specified argument was out of the range of valid values. Parameter name: Rotation

I can rotate the text 90 degrees just fine however.
tmayne77
 
Posts: 9
Joined: Tue Nov 02, 2010 1:52 pm

Re: Unable to rotate text -90 or 270

Postby Jason.Tan » Tue Nov 16, 2010 6:02 am

Hello tmayne77,

Thank you for your inquiry.
You can use following code to set text rotation -90.
Code: Select all
sheet.Range(1,8 ).Style.rotation = 180;

180 degrees equals -90 degrees.

Best Regards
Jason Tan
Technical Support / Developer,
e-iceblue Support Team
User avatar
Jason.Tan
 
Posts: 30
Joined: Tue May 25, 2010 7:17 am

Re: Unable to rotate text -90 or 270

Postby tmayne77 » Sun Dec 19, 2010 2:00 am

But 180 doesn't do the same as -90 or 270.
tmayne77
 
Posts: 9
Joined: Tue Nov 02, 2010 1:52 pm


Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests

cron