Hi there,
I am using Infragistics.Excel.WorksheetCell and Infragistics.Excel.Worksheet to create an Excel file which is filled with some values and then saved to disk. I have trouble to find/set a property which will enable cell to autosize automatically to their content (I've tried by setting ShrinkToFit property on CellFormat property of individual Column or WorksheetCell to ExcelDefaultableBoolean.False as well as WrapText, but to no avail). Is there a way to size cell to its contents (without changing font size).
Best regards.
Hi Mike,
How do you get the autosizing work with a WorksheetMergedCellsRegion?
Which type of autosizing are you referring to? If you want a column to automatically size to allow the contents of its cells to be fully visible, this feature is not available and I would recommend submitting a feature request for this: http://devcenter.infragistics.com/Protected/RequestFeature.aspx. If you want a row which has not had its height explicitly set to expand for its cells which have WrapText set to True, this should work as it does in Excel. If it is not behaving this way, you can submit it to the support group: http://ko.infragistics.com/gethelp. If you are not referrring to either of these two auto-size modes, please provide instructions on how you would accomplish the auto-sizing in the Excel UI so I can better understand the question.