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