Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel AddLine() Method - Determining Position
Message
 
 
À
12/06/2007 03:05:58
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01232175
Message ID:
01232298
Vues:
14
Why not use Borders? They don't require absolute positioning.
oBT = oSheet.RANGE("A71", "J71").Borders(xlEdgeTop)
oBT.Weight = xlThin
oBT.LineStyle = xlContinuous
...
oBB = oSheet.RANGE("A71", "J71").Borders(xlEdgeBottom)
...
oBT = NULL
oBB = NULL
>
>I prefer using the Addline() Method to put a line on Top and another on the Bottom of cells that show Totals. This time the cell that will hold the total is Dynamic (depending on the number of entries) and therefore is not pre-defined. If I know the Cell address and its width, is it possible to know the BeginX, Beginy, EndX, EndY positions that can place the line as explained above ?
>
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform