We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


Thread ID:





74374 Jun 10,2008 11:31 AM UTC Jul 17,2008 06:52 AM UTC WinForms 3
Tags: XlsIO
Administrator [Syncfusion]
Asked On June 10, 2008 11:31 AM UTC


I've to autofit a range of cells. There are some cells of the column containing a bigger value, but those should be ignored by auto sizeing.
B1: a very long text should be ignored
B2: a short one
B3: a nother short one

In my example, I tried to
mySheet.Range[5, 2, 19, 2].AutofitColumns();

I suppose that the component watches on all cells of the column and not only the range (like Excel does). Is there a way to tell xlsIO just to watch the range? Or any other work around?

I'm using version '6.302.0.6' of xlsIO

best regards

Joachim Brust


Yavanaarasi G [Syncfusion]
Replied On June 11, 2008 12:48 PM UTC

Hi Joachim,

Thank you for your interest in Syncfusion products.

We have already logged a feature request regarding this issue. We will get back to you once the feature has been implemented.

Please let me know if you have any other concerns.


blah blah
Replied On July 16, 2008 03:09 PM UTC

I know you've already logged this as a feature request...

I've been using your Excel classes since 2004 and would love the requested functionality as well. Our Excel reports have a standard header in the first column that takes up a few rows. The report data follows that. It would be great to be able to get AutofitColumns() to ignore those header rows.

I'm aware that I can currently work around this by setting the report data and calling AutofitColumns() before I set the header rows, but that adds much unneeded complexity.

Yavanaarasi G [Syncfusion]
Replied On July 17, 2008 06:52 AM UTC

Hi Joachim,

Thanks for your effort.

Unfortunately this feature is not implemented. This feature implementation will take time and can’t be implemented in short period. But we have increased its priority. We will get back to you once the feature has been implemented. Sorry for the inconvenience caused.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon