FarPoint.Win.Spread.FpSpread HELP?

[Jackomcnabb]

I have an new windows application that has an inbedded grid that uses FarPoint.Win.Spread.FpSpread. When I spy the object I only see it as a SwfObject and cannot see the grid.

I have managed to to get the row count using:

Code:

SwfObject("ObjectName").Object.ActiveSheet.rowcount

But what ever I try to do to get the values from the Cells in the table I do not get anything back, I need to verify that the value I am looking for is in the first cell (User_iD)in a row and if so select that cell.

any help or ideas would be good

[Jackomcnabb]

I have been working with QTP support and it seems that this object is not supported.... Great Back to Manual testing.....!!!

[basanth27]

Jack -
Sorry, i read your post late. I wont be the guy to cross QTP support's drawn line but would you try the below and let me know if you get anything in return,

Code:

msgbox SwfObject("ObjectName").Object.ActiveSheet.Item(1).Name

or

Code:

msgbox SwfObject("ObjectName").Object.ActiveSheet.rows(1).Cells(1).Value

or

Code:

msgbox SwfObject("ObjectName").Object.ActiveSheet.Cells.Item(1).Name

[Jackomcnabb]

thanks for your help..
I tried your code and got the following:

Code:

msgbox SwfObject("ObjectName").Object.ActiveSheet.Item(1).Name

Object doesn't support this property or method: 'ActiveSheet.Item'

Code:

msgbox SwfObject("ObjectName").Object.ActiveSheet.rows(1).Cells(1).Value

Object required: 'ActiveSheet.rows(...)'

Code:

msgbox SwfObject("ObjectName").Object.ActiveSheet.rows(1).Cells(1).Value

Object required: 'ActiveSheet.Cells.Item(...)'


but I now have found that the FarPoint control will be supported with QTP 10.... and we are due to get that soon so I guess I will wait