We want to adapt xlloop library ([url removed, login to view]) adding 2 different features:
In xl2007 reply immediately OK (if conn with server is OK) and put the call to the server in a separate thread. No need to handle the error (if any)
in xl2010 add an AsyncUDF option ("isAsync") to the Java library, and reflect such option in the code.
We will provide a working xlloop source code with all needed libs, that compiles both for Excel 2007 and for Excel 2010 and works.
Required output is that script compile_all works and produces the new xll's with the above features
1) XL2007: C++, multithreading, XL API expertise
In BinaryProtocol::execute, HttpProtocol::execute
At startup, create 1 single thread for sending msgs to servers
check if conn up, else up it, if cannot connect or other error return error (#NA)
else put operation in thread & return always OK. In thread perform the send & get the return val. If any err pass err to mock logger, that ignores it (create also mock logger, for future use & document this mock component as such)
2) XL2010: C++, Java, multithreading, XL API expertise
add to java register function call boolean isAsync ([url removed, login to view]) add boolean isAsync (as isVolatile)
define XLOPER, Excel4v etc conditionally based on XLAPI2010 define
Registration mode is different in xl2007 and xl2010; adapt when using xlfRegister