auto adjust ROW heights + merged Cells

Topics: User Forum
Apr 7, 2011 at 4:48 PM
Edited Apr 7, 2011 at 5:10 PM

I've using a pre created xlsx template that is read and writen to by the Excel2007 Reader/Writer. When the final spreadsheet is downloaded by a user and opened in Excel it works. Rows that have merged cells in them are automatically adjusted this is great. But I have some users that are using OpenOffice. This can open xlsx but when cells are merged and auto adjust row heigh is set it doesn't work. The adjust row height works when cells are not merged.

Does anyone have a suggestion on how to resolve this or would there be a way to work out the heigh a row should be based on text and then set the row height accordingly?





This is what I tried to do.

1: Remove the merged cells

2: Populate the cell with data

3: Get the adjusted ROW height

4: Merge the two cells and set the row heigh to the returned value from 2: but the returned value is -1 which implies it should be autoadjusting