Is there any way to insert a Text Box into an Excel sheet. I found number of examples of how to insert image and comments, but nothing related to inserting text boxes.
Another issue I'm having is when placing images on a sheet. I know the width of the images in pixels and I know the width of the cells in "1/256s of average character width" (the width property on the cell). How can I convert that to pixels?
Thanks in advance,
Trausti
Thanks for that Hristo. Yes, this was solved by using Microsoft's Excel interface.
Hello ,
I just checking the progress of this issue. As far as I understand from you latest post, you were able to solve your issue.
Let me know if you have any further questions.
That could work. I decided to just use the Microsoft.Office interface to do this and some other things that are either not available or limited in the Infragistics.Excel interface.
Thanks,
Regarding the text boxes, I thought of one more thing you could try: your tmeplate file could have a large number of text boxes (more than you would ever need at runtime). Then when you generate your file, you would load in the template, customize the first X number of text boxes you need and then remove the rest from the Shapes collection of the worksheet.
Thanks Mike for the reply. From now on I'll post each question in a separate thread :)
I had not noticed the GetBoundsInTwips function, this is very helpful.
Unfortunatly, I need to create text boxes dynamically at run time. I'll submit feature request for this.
Thanks again,