Im writing a program for a company the now and one of the requirnments was it outputs into excel. However I cant seem to get it to do what I want.
I want it to automatically adjust the height of a row of merged cells, ie the cells are merged so that they cover the width of the page and I want all the text in them to be visiable ie it automatically adjusts the height to fit the text. I have tried the Format->Row->Auto but it still doesnt do it. Have tried google, but keep getting the same answer
Anyone know any way to get this?
Cheers
Stu