Menu Commands (org.boris.xlloop.GetMenu)

  • Caspar

    Caspar - 2011-01-04


    I can see in the source code references to menu commands, also the XLL addin calls the Java server and checks for a method called org.boris.xlloop.GetMenu

    Does this provide menus (with  commands)?  If so it would be great if you would provide a simple example of usage.

    (XLLOOP is fantastic btw)


  • Peter Smith

    Peter Smith - 2011-01-05

    Hi Caspar,

    This is still work in progress.

    The intention is the provide the ability to add menus (with submenus). The menu items would make a call to the server, which would return a list of commands to execute on the sheet (eg, like add sheet, set cell values etc…). This would allow the server to generate spreadsheet fragments for the user. Potentially it could also return javascript/vbscript to be executed on the client like a web browser…

    The menu generation currently works - you can see an example in org.boris.xlloop/java/test/org/boris/xlloop/ The command execution is not yet implemented though.


  • Caspar

    Caspar - 2011-01-05

    Great thanks Peter,

    By overriding the MenuHandler and accessing the IFunctionContext it's possible to hold some state on the Java side which allows me to workaround not being able to write back to the sheet.

    Returning scripts would be fantastic, I look forward to future releases.



Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks