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.
Hello ,
After working on “OutLine border thin” and “Text Margin” and doing some research, ideas have been determined to be a new product idea. You can suggest new product ideas for future versions (or vote for existing ones) at <http://ideas.infragistics.com>.
There are many benefits to submitting a product idea:
- Direct communication with our product management team regarding your product idea.
- Notifications whenever new information regarding your idea becomes available.
- Ability to vote on your favorite product ideas to let us know which ones are the most important to you. You will have ten votes for this and can change which ideas you are voting for at any time.
- Allow you to shape the future of our products by requesting new controls and products altogether.
- You and other developers can discuss existing product ideas with members of our Product Management team.
Steps to create your idea:
1. Log into the Infragistics Product Idea site at http://ideas.infragistics.com (creating a new login if needed).
2. Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)
3. Add your product idea and be sure to be specific and provide as much detail as possible.
Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!
Include a link to this thread in your idea so product management will be able to look back at this case.
The Product Idea site puts you in the driver’s seat and allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
Thank you for contacting Infragistics.