Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / EditBaseCellType Class / TextRotationAngle Property

In This Topic
    TextRotationAngle Property (EditBaseCellType)
    In This Topic
    Gets or sets the rotation angle of the text for the cell.
    Public Property TextRotationAngle As Double
    Dim instance As EditBaseCellType
    Dim value As Double
    instance.TextRotationAngle = value
    value = instance.TextRotationAngle
    public double TextRotationAngle {get; set;}

    Property Value

    Double-precision value of the number of degrees of rotation
    This example sets the TextRotationAngle property.
    fpSpread1.Sheets[0].Cells[1, 3].Text = "Test"; //Cell has to have value
    fpSpread1.Sheets[0].Cells[1, 3].Border = new FarPoint.Win.ComplexBorder(new FarPoint.Win.ComplexBorderSide(Color.Red, 2));// Cell has to have border
    FarPoint.Win.Spread.CellType.TextCellType cellType = new FarPoint.Win.Spread.CellType.TextCellType();
    cellType.TextOrientation = FarPoint.Win.TextOrientation.TextRotateCustom;
    cellType.TextRotationAngle = 60; // Cell has to have rotation angle to see the effect.
    fpSpread1.Sheets[0].Cells[1, 3].CellType = cellType;
    FarPoint.Win.Spread.DrawingSpace.TriangleShape a = new FarPoint.Win.Spread.DrawingSpace.TriangleShape();
    a.BackColor = Color.Blue;
    fpSpread1.ActiveSheet.AddShape(a, 1, 1);
    FarPoint.Win.Spread.DrawingSpace.SpreadCameraShape test = new FarPoint.Win.Spread.DrawingSpace.SpreadCameraShape();
    test.Formula = "B1:E6";
    test.Location = new System.Drawing.Point(20, 20);
    fpSpread1.Sheets(0).Cells(1, 3).Text = "Test" 'Cell has to have value
    fpSpread1.Sheets(0).Cells(1, 3).Border = New FarPoint.Win.ComplexBorder(New FarPoint.Win.ComplexBorderSide(Color.Red, 2)) ' Cell has to have border
    Dim cellType As New FarPoint.Win.Spread.CellType.TextCellType()
    cellType.TextOrientation = FarPoint.Win.TextOrientation.TextRotateCustom
    cellType.TextRotationAngle = 60 ' Cell has to have rotation angle to see the effect.
    fpSpread1.Sheets(0).Cells(1, 3).CellType = cellType
    Dim a As New FarPoint.Win.Spread.DrawingSpace.TriangleShape()
    a.BackColor = Color.Blue
    fpSpread1.ActiveSheet.AddShape(a, 1, 1)
    Dim test As New FarPoint.Win.Spread.DrawingSpace.SpreadCameraShape()
    test.Formula = "B1:E6"
    test.Location = New System.Drawing.Point(20, 20)
    See Also