Create Java Calc Add-In project in NetBeans. Create a Java function with a parameter of type "long". Map this parameter in IDL file using "hyper" type. Create and install an extension. Function doesn't work and parameter is not visible in Function Wizard: Java function: ============== public int fName2(long p1) { return 42; } IDL map: ========= Java <=> IDL "int" <=> "long" "long" <=> "hyper" long fName2([in] hyper p1); Workaround: ============ Use "Object" public int fName2(Object p1) { return 42; } and it map as "any": long fName2([in] any p1); It's not perfect because "any" type is visible as "optional" parameter in Function Wizard.
Calc add-ins by design do not support UNO type hyper, only UNO types long, double, etc. See <http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Spreadsheet_Add-Ins> and the description of the com.sun.star.sheet.AddIn service linked from there.
Java "int" is mapped in IDL file as "long". Java "long" is mapped in IDL file as "hyper". IDL "unsigned hyper" works fine with Java "long" but "hyper" does not. See: http://wiki.services.openoffice.org/wiki/IDL_Files_and_Cpp (table: Further with IDL)