Wraps text and export to excel | Infragistics Forums

225

Wraps text and export to excel

Noe posted over 12 years ago

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

Parents

138253

Offline Stefan posted over 12 years ago

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.

XamDataGridExportSettings.zip
Cancel
Reply

Cancel
225

Verified Answer
Noe posted over 12 years ago in reply to Stefan

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
Cancel
Reply

Reject Answer

Cancel
138253

Offline Stefan posted over 12 years ago in reply to Noe

Hello Noe,

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.
Cancel
Reply

Cancel

Reply

65

Offline Shriharsha Bhat posted over 10 years ago in reply to Stefan

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
Cancel
Reply

Cancel

Children

138253

Offline Stefan posted over 10 years ago in reply to Shriharsha Bhat
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:

Log into the Infragistics Product Idea site at http://ideas.infragistics.com (creating a new login if needed).

Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)

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!

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.
Cancel
Reply

Cancel