Setting text wrapping to true doesn't change the height of the row

Aspose.Cells Product Family
1

Dear Laurence,



We have a problem with the height of rows containg cells with text wrap
enabled. When we generate the workbook from scratch the height of each
row is adjusted correctly, but when we open a template file and change
the format of a cell to enable text wrapping, the height doesn’t change.



Thanks and best regards,

Ulf




2

Hi Ulf,

Aspose.Cells for Java doesn't support to auto-adjust row height when setting WrapText property. You have to set the row height with your own code.

3

Ok, but why does it work when we create workbooks from scratch. I guess
that Excel does this when there is no height set for a row? Wouldn’t it
be possible to do this even when we create workbooks from templates?
Would it be enough to set the row height to the default row height?



Thanks,

Ulf

4

Hi Ulf,

I will check this issue with our developers.

5

Dear Laurence,



I have attached a zip archive containing three dummy files generated by
JExcelApi, POI and Aspose. Look at the table for ‘alternative bids’ in
the ‘single bids’ sheet. As you can the files generated JExcelApi and
POI is automatically adjusted when you open them in Excel. I hope this
information will help you. (None of these apis are calculating any row
heights themselves)



Best regards,

Ulf

6

Hi ,

We will release new version tomorrow.When setting text wrapped is true,the row will use default row height(which decided by font and contents of the cells in the row).And we will afford Row.setUseDefaultHeight method to decide whether row has default row height.

7

That is great news. Thanks a lot!!



Best regards,

Ulf

8

Hi Warren -

I am having the same problem. Wrapping is set to True, yet the row height is not being adjusted accordingly. I loaded Version 1.9.0.1 of Aspose.Web.Grid. I am using Windows XPPro, VS2005, MSSQL2005, ASP.Net, and C#.

What am I doing wrong?

In my Grid html I have

ActiveTabStyle-Wrap="True"

HeaderBarStyle-Wrap="True"

TabStyle-Wrap="True"

Style-Wrap="True" in the BindColumn html.

9

Hi,

Aspose.Grid.Web doesn't support automatically changing row height.