AutofitColumn

Hi,

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.
e.g.
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



Program_265b2c9b.zip

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.

Regards,
G.Yavana

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.

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.

Regards,
G.Yavana