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

Free Support Forum - aspose.com

New version of aspose cell does not interpret '\t' in textbox

We have been using aspose cell 7.3.0.3 version.

We were inserting textboxes in excel sheet with content “\t hello” and \t was interpreted as tab character,

But with aspose cell 7.4.3.0 version, \t is not interpreted as tab character and textbax displays only “hello” without a tab (eg " hello").

Regards,
Aniket

Hi,

Thanks for your posting and using Aspose.Cells.

We have tested your issue with the latest version: Aspose.Cells
for .NET v7.4.3.5
with the following code and found it is working fine. We have attached the output file generated by this code for your reference.

C#


String containingText = “\thello”;


Workbook book = new Workbook(FileFormatType.Xlsx);

Worksheet sheet = book.Worksheets[0];


Aspose.Cells.Drawing.TextBox textboxInBack = sheet.Shapes.AddTextBox(1, 0, 1, 0, 50, 100);

textboxInBack.Text = containingText;

textboxInBack.Font.IsBold = true;


textboxInBack.TextFrame.AutoSize = true;


book.Save(@“F:\Shak-Data-RW\Downloads\TestCase.xlsx”);