Micro Focus QTP (UFT) Forums
FarPoint.Win.Spread.FpSpread HELP? - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: FarPoint.Win.Spread.FpSpread HELP? (/Thread-FarPoint-Win-Spread-FpSpread-HELP)

FarPoint.Win.Spread.FpSpread HELP? - Jackomcnabb - 08-05-2009

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

RE: FarPoint.Win.Spread.FpSpread HELP? - Jackomcnabb - 08-11-2009

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

RE: FarPoint.Win.Spread.FpSpread HELP? - basanth27 - 08-11-2009

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


RE: FarPoint.Win.Spread.FpSpread HELP? - Jackomcnabb - 08-14-2009

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