Thanks Dan, No, I tried that and it doesn't work. HOWEVER I found that you can set the .Row and .Col property and then call the .Cell(nX) property without the extra 4 x row/col properties and that will set/read the current cell. It works Fine - just cant simply format/read a range in one command. No problem though as long as I can access one cell at a time.
Take a look at the control evaluation download. It seems to be really good and I have converted the Basic Invoicing demo into VFP - it works great.
Only drawback so far - you can't bind to a VFP datasource but you can to an ADO recordset.
Dave Crozier DaveC AT Replacement-Software .DOT co.uk
-----Original Message----- From: profox-bounces@leafe.com [mailto:profox-bounces AT leafe .DOT com] On Behalf Of Dan Covill Sent: 12 June 2003 20:53 To: ProFox Email List Subject: Re: VSFlexgridPro ActiveX
At 15:29 06/12/03 +0100, Dave Crozier wrote: >Syntax >------ >vsFlexGrid.Cell(Setting As CellPropertySettings, [R1 As Long], [C1 As >Long], [R2 As Long], [C2 As Long]) [ = Value ]
Dave:
This is calling for (optionally) one or two Row,Colum pairs, presumably defining the sub-grid to be queried/set. Twould be nice if it specified
what the default is for those you don't specify, but I'd assume that if you omit R2,C2 you get the single cell defined by R1,C1.
>If I put, for example oGrid.Cell(0,1,1) in the debugger I can see that >it has a value "". However when I assign it i.e >oGrid.Cell(0,1,1)="Title" I get back a VFP Error 31 - Invalid subscript
>error.
You have defined Row 1 as 0 (an invalid coordinate in VFP), and have not
specified Column 2 (presumably zero by default). Your debug value of empty looks like an "I don't know what you mean" result.
Try oGrid.Cell(1,1)="Title", and see what you get.
Dan Covill
[excessive quoting removed by server]
©2003 Dave Crozier |