This is a migrated thread and some comments may be shown as answers.

Vertical text ?

2 Answers 277 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Ian
Top achievements
Rank 2
Bronze
Iron
Iron
Ian asked on 08 Nov 2018, 08:18 AM

Does this control - or any of the other WinForms table-style controls - have the ability to show vertical text?

I have quite large tables, with 50-100 columns, and the column names are 30-80 chars long, so showing them Excel-style with text rotated 90 degrees would be perfect.

I've not found any of the controls which can do this.

Or is there some other way?

Ideally, it would be in this Spreadsheet control, as it seems to be the fastest for loading the kinds of data I'm using.

2 Answers, 1 is accepted

Sort by
0
Hristo
Telerik team
answered on 09 Nov 2018, 09:22 AM
Hello Ian,

The RadSpreadsheet control does not currently support vertical text as Excel. I logged a feature request on our feedback portal, here: ADD. RadSpreadsheet - implement text orientation for cell content. I have also updated your Telerik points.

I can suggest using the RadGridView control. Assuming that you would have a text box column with a large header, you can set the WrapText and Multiline properties of the column: 
GridViewTextBoxColumn textBoxColumn = ((GridViewTextBoxColumn)this.radGridView1.Columns["Description"]);
textBoxColumn.HeaderText = "DescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescriptionDescription";
textBoxColumn.Multiline = true;
textBoxColumn.WrapText = true;

Additionally, you may want to auto-size the rows or increase the table header height: 
//this.radGridView1.AutoSizeRows = true;
this.radGridView1.TableElement.TableHeaderHeight = 80;

Regards,
Hristo
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Ian
Top achievements
Rank 2
Bronze
Iron
Iron
answered on 09 Nov 2018, 02:02 PM

Thanks Hristo - I've tried all these options, but the header text has some long expressions, which don't wrap nicely - vertical text seems like the only solution.

Hopefully your developers will pick up the feature request!

Thanks for the advice - great support from Telerik, as always...

Tags
Spreadsheet
Asked by
Ian
Top achievements
Rank 2
Bronze
Iron
Iron
Answers by
Hristo
Telerik team
Ian
Top achievements
Rank 2
Bronze
Iron
Iron
Share this question
or