This project has moved and is read-only. For the latest updates, please go here.

Columns.AdjustToContents - Problem with formula result

Oct 29, 2013 at 1:50 PM
I have successfully used Columns.AdjustToContents and have limited the rows to 1 to 30 to improve performance. The problem I have found is that it does not seem to consider results of formulas in the column. Text and values are considered but when the formula result is wider than the maximum actual width then ######## is displayed.

Can anyone help please!

Jun 11, 2014 at 3:14 PM
I have the same issue.
Jun 17, 2014 at 10:05 PM
Pick the latest source code.
Jun 2, 2016 at 9:23 PM

I still have the issue even with latest version. I have formula in cells and when I run Columns.AdjustToContents() it still shows'#####'. Please advise!