SPONSORS:






User Tag List

Results 1 to 2 of 2
  1. #1
    Member
    Join Date
    Dec 2000
    Location
    India
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    hw can i use the updated version /??

    Does SilkTest support the Farpoint Spreadsheet object?

    SOLUTION
    ----------------------------------

    The Farpoint Spreadsheet object is recorded as a CustomWin.

    The include file and testsript in the Example section below show how to
    create a winclass and methods that makes DLL calls which successfully act on
    the Fairpoint Spreadsheet.

    EXAMPLE
    ----------------------------------

    The example below is comprised of fairpoint.inc and fairpoint.t.

    // fairpoint.inc
    // Set up 4Test DLL function prototypes.
    [ ] use "msw.inc"
    [ ]
    [+] dll "C:\tnessi\TBPRO3W.DLL"
    [ ] SSGetData (UINT sheet, LONG col, LONG row, out STRING value)
    [ ] SSGetTopLeftCell (UINT sheet, out LONG col, out LONG row)
    [ ] SSGetButtonText(UINT sheet, LONG col, LONG row, out STRING value)
    [ ] SSSetActiveCell(UINT sheet, LONG col, LONG row)
    [ ] SSSetValue(UINT sheet, LONG col, LONG row, string value)
    [ ] SSComboBoxSendMessage(UINT sheet, long col, long row, short msg, long
    wParam, string val)
    [ ] SSGetActiveCell(UINT sheet, out LONG col, out LONG row)
    [ ]
    [ ]
    [ ]//Create a winclass with methods that call the DLL funcitons.
    [+] winclass SS:AnyWin
    [-] string GetActiveCellValue()
    [ ] long row, col
    [ ]
    [ ] string val=space(100)
    [ ]
    [ ]
    [ ] SSGetActiveCell(this.hWnd, col, row)
    [ ] val=GetCellValue(col,row)
    [ ]
    [ ] return val
    [ ]
    [ ]
    [-] VerifyActiveCellValue(string expected)
    [ ] string cur_val=space(100)
    [ ]
    [ ] cur_val=this.GetActiveCellValue()
    [ ] Verify(cur_val, expected)
    [ ]
    [-] string GetCellValue(long col, long row)
    [ ] string value=space(100)
    [ ]
    [ ] SSGetData(this.hWnd, col, row, value)
    [ ] return value
    [-] string SetCellValue(long col, long row, string value)
    [ ]
    [ ] SSSetValue(this.hWnd,col, row, value)
    [ ] return value
    [-] VerifyCellValue(long col, long row, string expected)
    [ ] string cur_val=space(100)
    [ ]
    [ ] cur_val=this.GetCellValue(col, row)
    [ ] Verify(cur_val, expected, "Value in col {col} row {row} is
    incorrect")
    [ ]
    [-] SetCellActive(long col, long row)
    [ ]
    [ ] SSSetActiveCell(this.hWnd, col, row)
    [ ]
    [ ]
    [ ] attribute "Cell Value", VerifyActiveCellValue, GetActiveCellValue
    [ ]
    [ ]
    [+] window MainWin IPS
    [ ] tag "$C:\TNESSI\PROP.EXE"
    [+] Menu File
    [ ] tag "File"
    [+] MenuItem New
    [ ] tag "$1042"
    [+] MenuItem Open
    [ ] tag "$1001"
    [+] MenuItem Delete
    [ ] tag "$1006"
    [+] MenuItem Duplicate
    [ ] tag "$10004"
    [+] MenuItem Close
    [ ] tag "$1002"
    [+] MenuItem Save
    [ ] tag "$1004"
    [+] MenuItem SaveAs
    [ ] tag "$1005"
    [+] MenuItem SaveAll
    [ ] tag "$10006"
    [+] MenuItem Import
    [ ] tag "$1043"
    [+] MenuItem Export
    [ ] tag "$1024"
    [+] MenuItem Download
    [ ] tag "$1016"
    [+] MenuItem Snapshot
    [ ] tag "$1048"
    [+] MenuItem PrintPreview
    [ ] tag "$1014"
    [+] MenuItem Print
    [ ] tag "$1015"
    [+] MenuItem PrinterSetup
    [ ] tag "$1010"
    [+] MenuItem ObjectViewer
    [ ] tag "$1026"
    [+] Menu Database
    [ ] tag "Database"
    [+] MenuItem New
    [ ] tag "$10020"
    [+] MenuItem Open
    [ ] tag "$10030"
    [+] MenuItem Preferences
    [ ] tag "$1025"
    [+] MenuItem Exit
    [ ] tag "$1008"
    [+] Menu View
    [ ] tag "View"
    [+] MenuItem Next
    [ ] tag "$1012"
    [+] MenuItem Prev
    [ ] tag "$1013"
    [-] Menu Actions
    [+] MenuItem OpenClientFolder
    [ ] tag "$3003"
    [+] MenuItem ClientFile
    [ ] tag "$3002"
    [+] MenuItem SetInterestRates
    [ ] tag "$3108"
    [+] MenuItem SaveAsPreset
    [ ] tag "$3109"
    [+] Menu Producer
    [ ] tag "Producer"
    [+] MenuItem Select
    [ ] tag "$3004"
    [+] MenuItem Details
    [ ] tag "$3006"
    [+] MenuItem Delete
    [ ] tag "$30007"
    [+] Menu Insured
    [ ] tag "Insured"
    [+] MenuItem Select
    [ ] tag "$3005"
    [+] Menu GoTo
    [ ] tag "Go to"
    [+] MenuItem First
    [ ] tag "$30006"
    [+] MenuItem Last
    [ ] tag "$30008"
    [+] MenuItem Next
    [ ] tag "$30010"
    [+] MenuItem Previous
    [ ] tag "$30012"
    [+] MenuItem Details
    [ ] tag "$3007"
    [+] MenuItem Reset
    [ ] tag "$30004"
    [+] Menu Design
    [ ] tag "Design"
    [+] MenuItem RemoveRowS
    [ ] tag "$3104"
    [+] Menu Reports
    [ ] tag "Reports"
    [+] MenuItem Select
    [ ] tag "$1027"
    [+] Menu xWindow
    [ ] tag "Window"
    [+] MenuItem Cascade
    [ ] tag "$5001"
    [+] MenuItem TileVertical
    [ ] tag "$5002"
    [+] MenuItem TileHorizontal
    [ ] tag "$5005"
    [+] MenuItem N1ProposalManagerNewFolde
    [ ] tag "$-9536"
    [+] MenuItem N2NewFolderProposal4
    [ ] tag "$-9535"
    [+] Menu Help
    [ ] tag "Help"
    [+] MenuItem HelpContents
    [ ] tag "$1009"
    [+] MenuItem SearchForHelpOn
    [ ] tag "$1017"
    [+] MenuItem HowToUseHelp
    [ ] tag "$1018"
    [+] MenuItem Glossary
    [ ] tag "$1019"
    [+] MenuItem WhoToCall
    [ ] tag "$1020"
    [+] MenuItem GettingStarted
    [ ] tag "$1022"
    [+] MenuItem ShowMe
    [ ] tag "$8005"
    [+] MenuItem About
    [ ] tag "$1011"
    [+] ToolBar ToolBar1
    [ ] tag "$-1535"
    [+] StaticText CursorProductOptionText
    [ ] tag "$1052"
    [+] StaticText AcceptTheDefaultOptionORS
    [ ] tag "$16"
    [ ]
    [+] window ChildWin ProposalRequest
    [ ] tag "#1"
    [ ] parent IPS
    [+] StaticText N1stProducerText
    [ ] tag "1st Producer"
    [+] StaticText N1stInsuredText
    [ ] tag "1st Insured"
    [+] TextField PRODFirstName
    [ ] tag "#1"
    [+] TextField PRODLastName
    [ ] tag "#2"
    [+] TextField INSFirstName
    [ ] tag "#3"
    [+] TextField INSLastName
    [ ] tag "#4"
    [+] TextField Age
    [ ] tag "#5"
    [+] PopupList Gender
    [ ] tag "#1"
    [+] PopupList SmokingStatus
    [ ] tag "#2"
    [+] ComboBox State
    [ ] tag "#1"
    [+] PopupList Market
    [ ] tag "#3"
    [+] PopupList ProductLine
    [ ] tag "#4"
    [+] PopupList Strategy
    [ ] tag "#5"
    [+] PopupList SolveFor
    [ ] tag "#6"
    [+] SS GridArea
    [ ] mswdos tag "[TBSpread]1st Producer"
    [-] ScrollBar GridScrollBar
    [ ] tag "#1"
    [-] CustomWin GridTextBox
    [ ] mswdos tag "[SSwEdit]#1"
    [-] TextField GridPopUpList
    [ ] mswdos tag "[SSwCombobox]#1"
    [ ] tag "#1"
    [ ]
    [ ]

    // fairpoint.inc

    [-] testcase DoCellStuff ()
    [ ] print(ProposalRequest.GridArea.GetCellValue (3, 1))
    [ ]
    [ ] IPS.SetActive ()
    [ ] ProposalRequest.GridArea.Click (1, 398, 39)
    [ ] ProposalRequest.GridArea.SetCellValue (4, 1, "100000")
    [+] testcase DoOtherStuff ()
    [ ] ProposalRequest.Click (1, 313, 20)
    [ ] ProposalRequest.Click (1, 369, 117)
    [ ] print(ProposalRequest.GridArea.GetCellValue (3, 1))
    [ ]
    [ ] ProposalRequest.GridArea.VerifyCellValue (4, 1, "$100,000")
    [ ]
    [+] testcase Stuffit()
    [ ] IPS.SetActive ()
    [ ] ProposalRequest.GridArea.Click (1, 383, 33)
    [ ]
    [ ] print(ProposalRequest.GridArea.GetActiveCellValue( ))
    [ ] ProposalRequest.GridArea.VerifyActiveCellValue("N/A")
    [ ]
    [+] testcase CellTest ()
    [ ] ProposalRequest.GridArea.Click (1, 464, 33)
    [ ] ProposalRequest.GridArea.VerifyActiveCellValue ("1-M")
    [ ] ProposalRequest.GridArea.Click (1, 255, 96)
    [ ] ProposalRequest.GridArea.VerifyActiveCellValue ("Borrow Then Surrender")
    [+] testcase SetActiveCellStuff ()
    [ ] ProposalRequest.GridArea.SetCellActive (5, 1)
    [ ] ProposalRequest.GridArea.VerifyActiveCellValue ("1-M")


    ------------------
    btvenkatesh@yahoo.com

  2. #2
    Senior Member
    Join Date
    Dec 2001
    Location
    Bozeman, MT, USA
    Posts
    265
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: hw can i use the updated version /??

    would you be so kind as to encapsulate that in [ code] [ /code] tags.(remove the space after the [ )

    ------------------
    Ryan McCullough
    Accelrys Inc.
    ryan@accelrys.com

    [This message has been edited by rmccullough (edited 11-14-2002).]
    Ryan McCullough
    RightNow Tech. Inc.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 06:00 AM.

Copyright BetaSoft Inc.