Resize only 'used' columns

[Evelyn]

I am using the RadSpreadsheet component and I am filling it with data from code behind. I would like to resize only the 'used' columns to a width that fits the content from each column. Something like the AutoFitWidth(). 

I tried to use this method (AutoFitWidth()) in a ColumnSelection, however I could only use in all columns, not just the ones I used and I took more than 2 minutes to open my window... I don't want this... As I fill my spreadsheet from code behind, I don't know how many columns I am using... It depends on the settings the user chose before the window opens...

Is there any solution for this?

[Deyan]

Hello Evelyn,

Thank you for contacting us.

You may use the UsedCellRange property in order to select only the columns in the used range. The following code snippet shows how to autofit the columns in the used range of some Worksheet instance:

worksheet.Columns[worksheet.UsedCellRange].AutoFitWidth();

I hope this is helpful. If you have any other questions or concerns please do not hesitate to contact us again.

Regards,
Deyan
the Telerik team