Hi,
I am performing Export to Excel. Inside Excel i am adding Rectangular Shapes along with the Text.
For the text inside the shapes i am using Infragistics.Document.Excels.FormattedText
Code snippet for adding shape with text in excel:
RectangleShape shape = (RectangleShape)WorksheetShape.CreatePredefinedShape(PredefinedShapeType.Rectangle);
FormattedText fs = new FormattedText("Text1");
fs.GetFont(0, 5).Name = "Arial";
fs.GetFont(0, 5).Height = 140;
shape.Text = fs;
shape.SetBoundsInTwips(this.gridWorkSheet, new Rectangle(1185, 1800, 1935, 500));
this.gridWorkSheet.Shapes.Add(shape);
QUERIES:
1) How can i aligned the Text inside the shapes to be CENTER aligned ?
2) How can i reduce the Width(or line weight) of the Shapes in excel using code?
I have attached the screen shot for better understanding
Thanks,
Chitra
Hello,
In order to center the text you should use VerticalAlignment property, in the context of your code snipped you should use code like:
fs.VerticalAlignment = VerticalTextAlignment.Center;
if you want to remove the outline border you should set Outline to null
shape.Outline = null;
Please let me know if you have any further questions.
Thanks for your reply.
By setting fs.VerticalAlignment = VerticalTextAlignment.Center; the text appeared at the center of shape, i wanted Top - Center
i used the following code and got the text Top - Center alignment
fs.Paragraphs[0].Alignment = HorizontalTextAlignment.Center;
fs.Paragraphs[0].FormattedText.VerticalAlignment = VerticalTextAlignment.Top;
Appart from this is there a way to set the Left, Right, Top, Bottom Margin of the Text through code?
Also i dont want to remove the border completely, just want to reduce the width of the border. Is it possible?
Hi Histro,
I am awaiting your reply.
I am just checking about the progress of this issue. Let me know If you need my further assistance on this issue?
Thank you for using Infragistics Components.