I have some merged cells in Excel with WrapText true. The row height does not increase automatically. As a workaround, I create a temporary worksheet with one column whose width matches total of merged cells width. I set first cell in it to same value as in merged cells. This causes the contents to wrap and height also increases automatically. I want to get value of this increased height and apply to height of merged cells. But, I get -1 when I read height of the temporary cell. If I try the same concept in Excel manually, I can get the correct height value. How can I get it thru Infragistics 14.2 Excel assembly?
Hi Kirpal,
The reason that you are getting -1 for the height of a row is because this value isn't calculated until the export of the Excel file is complete. I recommend submitting a product idea for an option to automatically increase the row height when the text wraps. You can suggest new product ideas for future versions (or vote for existing ones) at http://ideas.infragistics.com.
Submitting your idea will allow you to communicate directly with our product management team, track the progress of your idea 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.
Remember when submitting your idea to explain the context in which a feature would be used and why it is needed as well as anything that would prevent you from accomplishing this today. 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. You can also link back to this thread for additional details.Thank you in advance to submitting your product idea.