autofitrow

[Giancarlo Aguilera]

Hi!

This is in reference to
http://www.syncfusion.com/support/Forums/message.aspx?MessageID=18534

I am experiencing this same problem. When will the fix be available


Thanks

GA

[Giancarlo Aguilera]

Oh, and by the way, my code looks like

this.Worksheet.Range[rowIndex, columnIndex].Text
= "Long Text";
this.Worksheet.Range[rowIndex, columnIndex].CellStyle.WrapText = true;
this.Worksheet.AutofitRow(rowIndex);
currentY += this.Worksheet.GetRowHeightInPixels(rowIndex)

The code snippet from the post I referenced is bit different

Thanks

GA

[Melba Winshia]

Hi Ga,

I was able to reproduce the problem. I have forwarded this issue to the development team. I will provide a time frame for fixing this issue with in a week. Sorry for the inconvenience.

Please let me know if you have any other questions.

Best Regards,
Melba

[Giancarlo Aguilera]

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

[Melba Winshia]

Hi GA,

Thanks for sharing your valuable idea with us. We will provide a time frame for fixing this issue with in two days.

Kindly let me know if you have any other questions.

Best Regards,
Melba