I suspect that what you are seeing may be Excel's default behaviour but I do not know this for certain and would ask you to try to reproduce what I have just done.
Open a new, blank workbook with Excel. Select any cell and just type in some text, enough to extend beyond the right hand edge of the cell so that it would have to wrap. Click on the tick to accept this text and you should see that the height of the row remains the same. Select that cell again, choose format and then Wrap Text. This time, the height of the row should increase automatically to accomodate the text. Select another row on the sheet and change the height of the row. Repeat the steps above to enter too much text and then set word wrap on. When I did this, the height of the row did not increase in response even though the text did indeed wrap in the cell. If you see the same then I reckon we can conclude that this is Excel's default bahaviour; if you change the height of the row yourself rather than accept the default row height, then Excel will not over-ride this. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-Removing-the-height-of-a-row-to-get-an-auto-height-tp5710132p5710156.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
