I want a specific column width say 50 and I want Text Wrap turned on. Not difficult.
Now I want the row to expand (stretch vertically) until all the text is filled in (similar to AutoFit Column except stretch row vertically rather than horizontally to accomodate the largest string).
In MS Office Excel 2003, the command = Format->Row->AutoFit (Hide, Height, Unhide are the other options). I assume it should be similar in other versions of Excel.
Let me know how to do this, Please....
Hello,
I am just checking about the progress of this issue. Let me know If you need any further assistance on this issue?
Thank you for using Infragistics Components.
Hello ,
WorksheetRow object has a property Hidden, that indicates if the row is hidden, also this object has a property Height, which sets the height of the row in twips. On the following link you could brows all members of WorksheetRow class:
http://help.infragistics.com/Help/NetAdvantage/WinForms/2012.2/CLR4.0/html/Infragistics4.Documents.Excel.v12.2~Infragistics.Documents.Excel.WorksheetRow_members.html
about WrapText and ShrinkToFit, you could determines the values for those properties trough CellFormat property of WorksheetRow object. On the following link you could brows all members of IWorksheetCellFormat class:
http://help.infragistics.com/Help/NetAdvantage/WinForms/2012.2/CLR4.0/html/Infragistics4.Documents.Excel.v12.2~Infragistics.Documents.Excel.IWorksheetCellFormat_members.html
So you could handle RowExported event of UltraGridExcelExporter in order to adjust those properties. On the following link you will find more information about this event:
http://help.infragistics.com/Help/NetAdvantage/WinForms/2012.2/CLR4.0/html/Infragistics4.Win.UltraWinGrid.ExcelExport.v12.2~Infragistics.Win.UltraWinGrid.ExcelExport.UltraGridExcelExporter~RowExported_EV.html
Please el tem know if you have any further questions.