Rotate Text with Shape inside the Worksheet

Possible Usage Scenarios

You can add text inside any shape using Microsoft Excel. If you add shape using the very old Microsoft Excel 2003, then the text will not rotate with shape. But if you add shape using newer versions of Microsoft Excel e.g. 2007, 2010, 2013 or 2016, etc. then the text will rotate with shape. You can control if the text should rotate with the shape or not using the ShapeTextAlignment.RotateTextWithShape property. The default value of it is true which means text will rotate with shape but if you set it as false, then the text will not rotate with shape.

Rotate Text with Shape inside the Worksheet

The following sample code loads the sample Excel file that has a triangle shape and its text rotates with shape. If you open the sample Excel file in Microsoft Excel and rotate the triangle shape, the text will also rotate with it. The code then sets the ShapeTextAlignment.RotateTextWithShape property as false and saves it as output Excel file. If you now open the output Excel file in Microsoft Excel and rotate the triangle shape, the text will not rotate with it. Please see the following screenshot showing the effect of the code on sample Excel file for a reference.

todo:image_alt_text

Sample Code

Set Margins of Comment or Shape inside the Worksheet Specify the Far East and Latin Name of the Font in Text Options of Shape