We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

TextOrientation does not work

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

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,

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,