TextOrientation does not work

Aspose.Cells Product Family
1

Hi,

I used the following code with the intention to display text from Top to Bottom or rotate it in merged cells:

Dim cell_RowFactor As Aspose.Cells.GridDesktop.GridCell = sheet.Cells(2, 0)
Dim style_RowFactor As Aspose.Cells.GridDesktop.Style = cell_RowFactor.GetStyle
sheet.Merge(2, 0, Numeric_Template_NumRow.Value + 1, 0)
cell_RowFactor.Value = Txtbox_Template_RowFactor.Text
style_RowFactor.TextDirection = Aspose.Cells.TextOrientationType.TopToBottom
cell_RowFactor.SetStyle(style_RowFactor)

However it does not work, the text is displayed horizontally. I use version 2.0.3.2000

Hope you can help me with that.

Oliver

2

Hi,

Thank you for considering Aspose.
We are looking in to this issue. Can you please forward us your sample application? This will help us finding the issue.
Thanks,

3

Hi,

Following code snippet will help you to rotate (text orientation) the text. If still there is any confusion. Please reach us with the sample application.

Code:

Workbook workbook = new Workbook();
Cells cells = workbook.Worksheets[0].Cells;
Cell cell = cells["A1"];
cell.PutValue("sdfsdfsdfsdfsdfsdf");
cells.Merge(0, 0, 5, 1);
Range range = cells.CreateRange(0,0,5,1);

Style style = cell.GetStyle();
style.Rotation = 255;
range.Style = style;
workbook.Save(@"F:\FileTemp\dest.xls");

Thanks,