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

Aspose.Cells Product Family
1

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
2

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”);