First and foremost and I wanna say thanks for all your help, whoever the folks are that answer my posts (melba) yet sure enough I never say thanks for the answers. Also, so far XlsIO kicks butt, loving it
Anyway, I'm having a problem. I have attached an excel file that illustrates the problem I am having. Please open the sheet called "Page 2".
1) Please take a look at cell C49, notice that it displays the value "Total (Equiv.)", yet the actual value of this cell is "Total (Equiv.) Units". I have set the wraptext property of this cell to true yet it has no effect, the row height remains such that you cannot see the contents of the cell. The result is the same whether I do or do not invoke autofitrow for this row. Also, please note the cell immediately below this one (C50), this cell does not manifest this problem rather the row's height adjusts such that the entire value of the cell is visible. Why is this?
2) Please take a look at cell M62, which has the same problem as above. However, this cell contains a number, not text, not sure if this matters. I can definitely live with this problem for the above cell (C49) since I have the workaround of simply not wrapping its text and letting the extra characters flow to the next cells, since these next cells have no content. However, for cell M62 this is a huge problem for me. Furthermore, I cannot simply autofit the entire column because it will result in a much bigger size that what I need, rather I need the column width to stay fixed and the actual autowrap functionality to work.
What do you think the problem could be? For me this is a huge problem simply because I am using XlsIO as a full blown reporting tool (and so far things have gone great except for this), and any reporting tool MUST be able to consistently wrap text, since I believe this to be very basic functionality of any reporting tool. Should I not be using XlsIO as a full blown reporting tool? Your prompt attention to this matter is greatly appreciated