Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with columns with long info in Excel
Message
 
 
À
08/09/2006 04:57:45
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01152063
Message ID:
01152228
Vues:
26
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform