Automate fpSpread testings

Posted by: dror_farhi on 27 January 2019, 3:58 am EST

  • Posted 27 January 2019, 3:58 am EST


    I have an active x control that I am using on vb6:
    We currently updated this control to the new fpSpread version 8.0.28.

    Our QA team is trying to automate their testings using the tool:
    UFT 14.03 (HPE Unified Functional Testing Version 14.03 )

    The problem is that the tool cannot identify the fpSpread control.
    Do you have any idea how to solve this problem ?
    The file fpSPR80.OCX was written in vb6 ? or was written in another language, and converted to ocx ?

    Dror Farhi
  • Replied 28 January 2019, 12:39 am EST


    I am not well versed with how UFT 14.0.3 works.
    Taken from an old conversation with developer I can tell you that Spread COM supports the standard OLE automation interface IDispatch and can work with window automation tools like that -- usually they provide some limited API for scripting mouse click here, this key down/up, etc. and Spread should work fine with that, though it might be tricky to track edit mode and the cell editor control (that gets shown/hidden as needed when the user edits cells). If the tool provides a way to call the control's OLE automation interface, then it should be able to get access to the whole API exposed by the type library, including the events (if the scripting model supports that).

    But Spread doesn't provide any special interface at the window level for such automated testing tools (the DLL control and core window code I mean) - it's only the ActiveX controls that have the OLE automation support and IDispatch implemented. So unless the tool has some way to do like you can in C++ with CWnd::GetControlUnknown, there might not be any way to access the automation interface from the windows handle (HWND). In C++ it's done like this:

    I believe, the source of Spread COM is written in C++.

    Deepak Sharma
  • Marked as Answer

    Replied 29 January 2019, 12:59 am EST


    I'll pass the information to the QA team.

    Dror Farhi
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels