Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

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

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

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