TEXT ALIGN of TextBox in Excell

hvtuan · September 5, 2014, 10:48pm

Hello Technical support team

We have been using Aspose.Cells for .NET.

I want to add one textbox in excel, using htmlText property. But TextAlignment always a direction.

Attached project: HtmlTextOfTextBox.rar

Thanks.

Hoang Van Tuan

shakeel.faiz · September 6, 2014, 2:55am

Hi Hoang,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after executing the following code using the latest version: Aspose.Cells
for .NET v8.2.0.3. Text alignment of the textbox is always left after setting it with the HTML.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-42971.

I have also attached the output xls file for a reference.

C#

var _zHtml = @“Hello

Hello

Hello”;

var _book = new Aspose.Cells.Workbook();

var _sheet = _book.Worksheets[0];

var _textBox = _sheet.Shapes.AddTextBox(1, 0, 1, 0, 200, 200);

_textBox.HtmlText = _zHtml;

_book.Save(“Test.xls”);

shakeel.faiz · September 10, 2014, 11:25pm

Hi Hoang,

Thanks for using Aspose.Cells.

We have evaluated this issue further. We are afraid, you cannot apply text alignment to partial text. You can only apply it to full text.

In order to apply alignment to full text, please use the following code.

_textBox.TextHorizontalAlignment = TextAlignmentType.Center;

C#

var _zHtml = @"Hello

Hello

Hello";

var _book = new Aspose.Cells.Workbook();

var _sheet = _book.Worksheets[0];

Aspose.Cells.Drawing.TextBox _textBox = _sheet.Shapes.AddTextBox(1, 0, 1, 0, 200, 200);

_textBox.HtmlText = _zHtml;

_textBox.TextHorizontalAlignment = TextAlignmentType.Center;

_book.Save(“Output.xlsx”);

hvtuan · September 11, 2014, 5:02am

Hi Shakeel Faiz,

I tried again. But all text alignment are center.

I want to Aspose.Cell TextBox displays:

But Aspose.Cell TextBox displays:

Thanks

hvtuan

shakeel.faiz · September 11, 2014, 10:38am

Hi Hoang,

Thanks for your posting and using Aspose.Cells.

Currently, you cannot apply different text alignment to partial text inside the TextBox. You can only apply the alignment to whole of the text inside the TextBox. So we are afraid this feature is not available as yet.

However, we have logged a New Feature request in our database to support it in our future versions. We will look into it and see if it is possible to implement it. Once, this feature is available or we have some other update for you, we will let you know asap.

This issue has been logged as

CELLSNET-42992 - Applying text alignment to partial text inside the TextBox

hvtuan · September 17, 2014, 1:01am

Hi Shakeel Faiz,

Issue CELLSNET-42992 - Applying text alignment to partial text inside the TextBox

We have a production Aspose.Cells license. We want to know when new updates are available.

Thanks,

hvtuan

amjad.sahi · September 17, 2014, 2:38am

Hi,

Well, I have checked the status of your issue “CELLSNET-42992”, it is pending for analysis. Once the relevant developer will evaluate and analyze the issue, we will be in better position to update you on it or provide an eta for it.

Once we have any update on it, we will let you know here.

Thank you.

aspose.notifier · August 15, 2018, 10:07am

The issues you have found earlier (filed as CELLSNET-42992) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi