Can we automation-test with FarPoint Spread control?

Posted by: itnewbie on 8 September 2017, 1:02 pm EST

  • Posted 8 September 2017, 1:02 pm EST

       I am building a tool for automation-testing. My client's application is using FarPoint Spread control. After taking much time to investigate this control, I found that I could not interact with it, for example, extract data in certain cells by using mechanism like SendMessage, Microsoft IAccessible. I can not have my client embed my code into their application (for testing).
       This kind of control (Spread) looks likely to spreadsheet control used in Microsoft Excel. Does FarPoint have any mechanisms like Microsoft Office Automation? If not, does FarPoint Spread control have any official technical information about extracting data by using SendMessage function, i.e : sending a special window message to this control to retrieve data in a certain cell or to count how many rows it has?
       Thank you very much! <img src="/emoticons/emotion-1.gif" alt="Smile [:)]" />

  • Replied 8 September 2017, 1:02 pm EST

    We do not have anything like Microsoft Office Automation nor do we have any official information about using SendMessage with the spread control.  I tried using the SendMessage with a command of WM_GETTEXT but it never returned anything other than a 0 when declared as an IntPtr and 'Nothing' when declared as a string.  Scott may have more information about this than I am aware of.
  • Replied 8 September 2017, 1:02 pm EST


    There are not any testing tools we have been able to use because Spread does not implement the interfaces needed by the testing tools. When speaking with representatives at some of these companies that make testing tools, there is not a spreadsheet control that has these interfaces implemeted. Mainly they work with single window controls like textboxes, etc.

    However, recently one of our customers say they are able to get the Functional Tester from Rationale to work. We have not tested this, but it may be something you may want to look at.

Need extra support?

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

Learn More

Forum Channels