Multiple Character changes in Textboxes

Aspose.Cells Product Family
1

Hi there,

I have been using your product and noticed a bug when trying to change characters within a string in a textbox multiple times. It only recognises the first instance and none of the others. Example code:

Dim ws As Worksheet = wb.Worksheets(0)
Dim txt As TextBox = ws.TextBoxes(ws.TextBoxes.Add(0, 0, 100, 100))
txt.Text = "hello"
txt.Characters(0, txt.Text.Length).Font.Color = Color.Blue
txt.Characters(2, 1).Font.Color = Color.Red

It is important for us to be able to multiple character changes in textboxes and this is supported for the Cells.Characters so could this be supported as well please?

Thank you

James


2

Hi James,

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our issue tracking system with issue id CELLSNET-12563.

Thank You & Best Regards,

3

Hi James,

p
{
margin: 0pt;
font-family: Arial,Verdana,Tahoma;
font-size: 12px;
}
.footer { color:Gray; font-size: 11px; text-align: center; }
.back1 { background-color: whitesmoke; }
.back2 { background-color: #f1f5e1; }
.back3 { background-color: cornsilk; }


We do not support characters contain other
Characters in the rich text of the shape.
We will support it soon. But, now, please simply try the following code for your requirement:

Worksheet ws = workbook.Worksheets[0];
TextBox txt = ws.TextBoxes[ws.TextBoxes.Add(0, 0, 100, 100)];
txt.Text = "hello";
txt.Font.Color = System.Drawing.Color.Blue;
txt.Characters(2, 1).Font.Color = System.Drawing.Color.Red;
workbook.Save(@"F:\FileTemp\dest.xls");


Thank you.
4

Hi James,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have supported your required feature.

Thank You & Best Regards,

5

Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have supported your required feature.

Thank You & Best Regards,

6

Works perfectly, thank you for such a speedy update!

7

The issues you have found earlier (filed as 12563) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.