Hello:
I have this XAML code:
<igDP:FieldSettings AllowResize="True" CellValuePresenterStyle="{StaticResource ResourceKey=CellValue}"> <igDP:FieldSettings.EditorStyle> <Style TargetType="{x:Type igEditors:XamTextEditor}"> <Setter Property="TextWrapping" Value="Wrap"/> </Style> </igDP:FieldSettings.EditorStyle> </igDP:FieldSettings>
This code makes that text wraps on the grid, but when I have exported the XamDataGrid to Excel, the text haven't wraps on Excel.
Any idea what it happens?
Thank you very much,
Best Regards
Hello Noe,
Thank you for your post. I have been looking into it and I have created a sample project for you with the functionality you want. Basically I created ResourceDictionary with FieldSettings instance and set its ExcelCellFormatSettings. I also added other Setting, not only text Wrapping, but you can remove them if you want. Please let me know if this helps you or you need further assistance on this matter.
Looking forward for your reply.
Hello Stefan:
Thanks for your reply and your code.
We've had problems with wrap (the last part of strings sometimes dissapeared when the main window growed or dicreased). We have downloaded the last 12 release (the same that you use in your code sample) and all the problems with wrap go out.
Thanks and best regards
Hello Shriharsha,
After looking into this and doing some research, AutoFit Row Height has 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 an 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:
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.
Hi Stefan,
I also had same requirement to wrap cell text. Applied the solution as per your example and text is wrapping in exported excel.
However wrapped text is not completely visible. It displays only 2 lines and below lines are blocked by limited Row height.
Clicking on Excel 2013 -> Home -> Format -> "AutoFit Row Height" shows all content.
My requirement is that after user exports the file and opens, all of the wrapped text should be shown by default.
Please guide me.
Thank you,
Shriharsha Bhat
Thank you for your feedback. I am glad that you resolved your issue and I believe that other community members may benefit from this as well.
Thanks again.