This project has moved. For the latest updates, please go here.

Columns.AdjustToContents - Problem with formula result

Oct 29, 2013 at 1:50 PM
Hi,
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!

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

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!