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

Report Viewer: Upon Excel export - set Textbox to nowrap

2 Answers 191 Views

General Discussions

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

Von Aaron asked on 10 May 2017, 03:35 AM

excelissue.png

Hi,

I have report which dynamically create a htmltextbox. Upon exporting to Excel via Report Viewer, the htmltextbox where merge. Is it possible to set it to nowrap and not merge programatically?. (Please see Attachment.)

I tried to set can grow to false/true but no luck.

Appreciate your help.

Thank you.

private Telerik.Reporting.HtmlTextBox CreateTxtHeader(string FieldName, double swidth, double PosX, double PosY, bool isBold)

{

Telerik.Reporting.HtmlTextBox txtHead = new Telerik.Reporting.HtmlTextBox();

txtHead.Size = new Telerik.Reporting.Drawing.SizeU(Unit.Inch(swidth), Telerik.Reporting.Drawing.Unit.Inch(0.3));

txtHead.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(PosX), Telerik.Reporting.Drawing.Unit.Inch(PosY));

txtHead.Style.BorderStyle.Default = BorderType.None;

txtHead.Style.Font.Bold = isBold;

txtHead.Style.Font.Size = Telerik.Reporting.Drawing.Unit.Point(intScale);

txtHead.Style.Font.Name = "Arial";

txtHead.Style.TextAlign = HorizontalAlign.Left;

txtHead.Style.VerticalAlign = VerticalAlign.Middle;

txtHead.StyleName = FieldName;

txtHead.Value = FieldName;

txtHead.CanGrow = true;

return txtHead;

}

-Im using Telerik Reporting Q3 2015 9.2.15.930

Report Viewer: Upon Excel export - set Textbox to nowrap

2 Answers, 1 is accepted