You may or may not care about this one but when a xls file has a picture embedded within it and AutoFit is called it appears that when the “Move but don’t size with cells” option for the picture is selected the picture still gets resized, BUT if “Don’t move or size with cells” is set the picture is unaltered.
It would be nice if the AutoFit understood this setting which can be found by RIGHT-CLICK on the picture then select “Format Picture…” then navigating to the “Properites” tab there is a radio control for this in Microsoft Office 2003.
Could you please give me a sample for this issue? I tested in my machine and AutoFitColumn method did understand the setting of pictures.
Excel excel = new Excel();
excel.Open("d:\\pic.xls");
excel.Worksheets[0].AutoFitColumn(1);