Does anyone know if it's possible to automatically resize the column width allowing the text of every cell of that column to be shown?
I find a autoGrow property of a cell but it enlarges the height of a cell, not the width of the cell/column...
Is the best way to handle the problem to write a sub routine that checks every cell for overflow, and if it occures, enlarge the width of the column and check all cells again?
Sure, that should work just fine. But to get text to 'overflow' you should set the cell height to some fixed distance, otherwise the cell will just get larger.
Oh -- and it doesn't work if the text in that cell contains one or more hard returns or line breaks.