Maybe something like that. This is Number '09 version 2.3
Say I import a csv. Under the Table menu: Resize Rows to Fit Content, and Resize Columns to Fit Content.
Maybe after using that once something gets locked, so that when you expand or contract the width of a column in just the right way, it snaps back really narrow so the text is squashed, or it shoots off the right part of the screen to accommodate the widest text. Regardless, it happens on its own. I ought to be able to change the width of a column to whatever place I want without program taking over. I mean...helping.