Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with columns with long info in Excel
Message
 
 
To
08/09/2006 04:57:45
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01152063
Message ID:
01152228
Views:
25
>For what it is worth
>
>(1) You do the autofit after all rows have been filled out, I take it
>
>(2) I'm using another 'autofit'. Do not know whether it makes a difference
>
>xlSheet.PageSetup.PrintTitleRows = "$1:$1"
>for i = 1 to m.ncols
>
> =m.xlSheet.Columns(m.i).EntireColumn.AutoFit
>endfor
>
May be EntireColumn can make a difference, but I doubt. I played with the file in Excel itself and trying to autofit didn't make the column width correct.

Anyway, I'm going to give it a shot. See my other response for the latest "formula" I use.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform