ITextBoxShape - set line to none

[Marcus Olsson]

How do I hide the border on ITextBoxShape?

I've tried the following, but nothing happens:

ITextBoxShape tbShape = wb.Worksheets[0].TextBoxes.AddTextBox(3, 2, 480, 576);
tbShape.Line.BackColorIndex = ExcelKnownColors.None;
tbShape.Line.ForeColorIndex = ExcelKnownColors.None;

[John Bowlin Bosco K]

Hi Marcus,

Thank you very much for your interest in Syncfusion Products.

Essential XlsIO can hide the text box border by using the IShapeLineFormat interface, which is used to modify the border. So, to hide the border of the text box, you can use the below code snippet. Please try this at your end and let us know if this helps you.

[C#]
ITextBoxShape textBox = workbook.Worksheets[0].TextBoxes.AddTextBox(2, 2, 25, 100);
textBox.Line.Visible = false;

To know more about the text box, please navigate to the below link and refer the documentation.
http://help.syncfusion.com/ug_91/Reporting/XlsIO/Windows%20Forms/default.htm?turl=Documents%2Ftextbox.htm

Please let us know if you need any further assistance.

Regards,
Pauline Bosco.

[Marcus Olsson]

Actually, setting Visible to false didn't solve my problem.
The border is still there.

[John Bowlin Bosco K]

Hi Marcus,

Thank you very much for your update.

By setting the visible property, the border of the text box is hidden in the XlsIO generated xls file and it is not hidden in the XlsIO generated xlsx file. We suspect this issue could be a defect and have forwarded to our development team for further analysis. We deeply regret for the inconvenience caused.

Could you please raise the ticket in the Direct Trac Developer Support System with a simplified issue reproducing sample? So that, we can provide you with the patch for this issue, as well as you can take the advantage of the expertise of a dedicated support engineer and a guaranteed response time. We hope you will take advantage of this system as well.

Direct Trac Link:
https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

Please let us know if you need any further assistance.

Regards,
Pauline Bosco