SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 8 of 8
  1. #1
    Member
    Join Date
    Feb 2010
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Copy and paste in SwfTable ??

    I have a column with 10 rows. I want to copy cell 1 selection to the other 9 cells. Tried following but not working. Ideas??

    SwfWindow("appname").SwfTable("C1FlexGrid1").Selec tCell 1,"ColumnName"
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type "Ctrl+C"
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type micShiftDwn
    For i = 1 To 9
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type micDwn
    Next
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type micShiftUp
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type "Ctrl+V"

  2. #2
    Member
    Join Date
    Feb 2010
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Copy and paste in SwfTable ??

    Anyone??

  3. #3
    Moderator
    Join Date
    Jul 2005
    Location
    Delhi
    Posts
    15,575
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    7 Thread(s)
    Total Downloaded
    0

    Re: Copy and paste in SwfTable ??

    SwfWindow("appname").SwfTable("C1FlexGrid1").Selec tCell 1,"ColumnName"
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type micCtrlDwn + "C" + micCtrlUp
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type micShiftDwn
    For i = 1 To 9
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type micDwn
    Next
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type micShiftUp
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type micCtrlDwn & "V" & micCTRLUp

  4. #4
    Member
    Join Date
    Feb 2010
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Copy and paste in SwfTable ??

    Tarun this did not work?

  5. #5
    SQA Knight
    Join Date
    Jun 2008
    Posts
    2,556
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: Copy and paste in SwfTable ??

    How about doing them one at a time?

    SwfWindow("appname").SwfTable("C1FlexGrid1").Selec tCell 1,"ColumnName"
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type "Ctrl+C"
    For i = 1 To 9
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type micDwn
    SwfWindow("appname").SwfTable("C1FlexGrid1").Type "Ctrl+V"
    Next

    If .Type still isn't working try using SendKeys.

  6. #6
    Member
    Join Date
    Feb 2010
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Copy and paste in SwfTable ??

    This also did not work??

  7. #7
    SQA Knight
    Join Date
    Jun 2008
    Posts
    2,556
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: Copy and paste in SwfTable ??

    Did you try using SendKeys? And what do you mean by not work? What part is it not performing? The copy? down? paste? All of the above?

  8. #8
    Member
    Join Date
    Feb 2010
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Copy and paste in SwfTable ??

    The following worked.

    Set WshShell = CreateObject("WScript.Shell")
    SwfWindow("Editor").SwfTable("C1FlexGrid1").SetCel lData 1,"LineComments","Hello"
    SwfWindow("Editor").SwfTable("C1FlexGrid1").Select Cell 1,"LineComments"
    WshShell.SendKeys "^c"
    SwfWindow("Editor").SwfTable("C1FlexGrid1").Select Column "LineComments"
    WshShell.SendKeys "^v"
    Set WshShell = Nothing

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin 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 01:09 PM.

Copyright BetaSoft Inc.