Posted 8 September 2017, 3:18 pm ESTWhat is the easiest method to allow Spread columns to autosize based on the data in the header and the data cells AND retain the autosort and autofilter icons?
I have looked through this forum and read many (old) posts re:
1) Set wordwrap off, but to do that you have to define the column header cell type yourself.
2) When you define the column header cell type you lose the autosort and autofilter icons.
Yes, I saw a post about overriding the Paint event to do it all yourself, but that is just ridiculous.
In Spread 6, you can easily set wordwrap off and set the grid to autosize all columns and you're done.
There must be a way to do this in Spread 8 without jumping through a bunch of hoops; isn't there?