Hi Melba!
Unfortunately I am unable to wait for the fix. Thanks anyway.
For anyone else facing this small pickle until the fix is out, I have attached a code file that contains a helper that assists in calculating what the row height should be (CalcRowHeight) for a row taking into account cells that:
1) have text
2) do or do not have wraptext = true
3) do or do not have cell indentation
4) do or do not merge across (but NOT down)
Make sure to dispose of the helper after you're done using it, and ideally the helper should be created right before all the report generation code and disposed of immediately thereafter.
This helper is useful in cases where you need to render reports to XlsIO in a manner similar to using a printdocument, whereby you need to keep track of the currentY in order to determine if and where a new page should start. Currently I am using XlsIO as a full blown reporting tool, with each worksheet corresponding to one and only one printed page. Without this helper, I was unable to determine relatively accurate row heights, thereby preventing me from keeping track of the currentY.
Having said all of this, I would have much preferred to NOT have had to spend my friday night writing this helper, and am hoping that Syncfusion will address this soon for the sake of those of us using XlsIO as a full blown reporting tool (and it does an excellent job of that I can assure you). With my user hat on I say that this is plumbing code I have no time for.
XlsIOReportingHelper.zip