Setting of textbox properties

Aspose.Cells Product Family
1

Hi,

I need to use a textbox of fixed width and height in my excel. Even if the column width increases or decreases this textbox must not increase or decrease in width. There is a property in excel, which allows me to set - "Dont move or size with cells". This does not make the textbox to expand with the column. How can I acheive this with Aspose. Currently I am using thisw code -

workbook.Worksheets[0].TextBoxes.Add(2, 0, 40, 400);

workbook.Worksheets[0].TextBoxes[0].Text = "Testing Textbox";

workbook.Worksheets[0].TextBoxes[0].Font.IsBold = true;

PS- See attachment for referance

Rgds,

Soumya

2

This feature is not supported yet. We will add a new property in the future version to enable you to set it.

3

Oh ok, but how long do you think it would take? Would it be possible for you to let me know once this feature has been provided? Our requirement is urgent.

Rgds,

Soumya

4

We can make it within one week.

5

Thank you, it would be of great help.

Rgds,

Soumya

6

Hi ,

Does the latest DLL provide the feature requested in this Query?

7

Sorry, I forget to include this feature in v4.1. However, in this attached version it's available. Please try this piece of code:

Workbook workbook = new Workbook();

workbook.Worksheets[0].TextBoxes.Add(2, 0, 40, 400);

workbook.Worksheets[0].TextBoxes[0].Text = "Testing Textbox";

workbook.Worksheets[0].TextBoxes[0].Font.IsBold = true;

workbook.Worksheets[0].TextBoxes[0].Placement = PlacementType.FreeFloating;

workbook.Save("d:\\test\\abc.xls");

8

Thanks, this solves half of my problem. The second problem is I have a logo that must go next to this free floating textbox(atleast makes it appear as it is inside the textbox). Using the new DLL provided by you I rendered an excel which gives me a freefloating textbox, saved the excel. To this saved excel I inserted an image just after the textbox.For the image property selected "Dont move or resize" , grouped the text box and the picture and selected "Dont move or resize" . PLease see the attachement, would it be possible for me to get the same using Aspose?

Rgds,

Soumya

9

Hi Soumya,

Well Grouping of Objects are not supported yet. We may consider this feature in future.

Regards

Amjad Sahi

Aspose Nanjing Team

10

thanks!!! , it would be great if grouping, ordering of objects(like image and textbox) and adding color to the textbox features can also be incorporated for the next release.

RGds,

Soumya

11

Could you please let me know if I can get these features in the next dll release?

12

Hi Soumya,

Related TextBoxes, its size, width settings etc, obviously the next release will include these features.

Regards

Amjad Sahi

Aspose Nanjing Team

13

sorry I forgot to put in the features tht I am looking for in my previous post. This is wha t iam looking for -

  1. Grouping of objects
  2. Ordering of objects ( for images, text boxes etc)
  3. Adding color to the textboxes ( at the moment we can add color to the font in side a textbox

Can I get these pls?

14

1. Grouping of objects

We are wokring on this feature but this is a complex feature. Hopefully you can get it in Q1 2007.

2. Ordering of objects ( for images, text boxes etc)

Same as above.

3.Adding color to the textboxes ( at the moment we can add color to the font in side a textbox

You will get it in the next month.