main logo
Subject: RE: VSFlexgridPro ActiveX
Author: "Dave Crozier"
Posted: 2003/06/13 01:03:00
 
View Entire Thread
New Search


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
<-- Prior Message New Search Next Message -->