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.
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://es.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.
Hi Mike,
How do you get the autosizing work with a WorksheetMergedCellsRegion?
As with the cells, this is currently not supported. I would recommend submitting a feature request for this.
Is this feature available now? i am using export feature from infragistics, and after exporting data to excel, i want each colum width to be autofit its content.
Hello,
I have sent your product idea directly to our product management team. Our product team chooses new product ideas for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your feature is chosen for development, you will be notified at that time. Your reference number for this product idea is PI13040096.
If anyone else would like to submit a product idea for this functionality, please submit one using the link below:https://es.infragistics.com/my-account/feature-request
Thank you for your request.
The ability to auto-size the cells in a column to the size of their contents is still not available. I have forwarded this post to the Developer Support Manager to create a feature request on your behalf.
I want to know whether the feature (AutoFit) is available with Infragistics.Excel now.