Java UNO Calc API: detect empty cell

Hi all, In my LibO Calc Java extension I have a worksheet function receiving an argument declared as 'any' type in IDL, so I can detect a missing parameter. But I would like to detect also an empty cell, if that parameter holds a cell reference. Seems that I can't do that because the function rec

Re: Calc Add-in Java extension: assign function to a new category

> Now I am facing another issue that _is_ critical - I need to return > arrays from a worksheet function (for array formula as described here > https://help.libreoffice.org/3.3/Calc/Array_Functions). I see that > there's 'sequence' keyword in UNO IDL language to define arrays > (http://www.openoffi

Re: LibO Calc - detect if function is called within Function Wizard

Hi Eike, Thank you for the info Mike On Wed, Aug 5, 2015 at 6:49 PM, Eike Rathke wrote: > Hi Mikhail, > > On Saturday, 2015-08-01 00:17:36 +0300, Mikhail Zemlyanukha wrote: > >> I'm developing a java extension for calc, and I would like to detect >> if a workshee

Re: Calc Add-in Java extension: assign function to a new category

5 at 1:47 PM, Eike Rathke wrote: > Hi Mikhail, > > On Monday, 2015-08-03 00:53:40 +0300, Mikhail Zemlyanukha wrote: > >> In LibO Calc Java extension, in XAddIn interface there're 2 functions: >> getProgrammaticCategoryName() and getDisplayCategoryName(). From >> Javadoc

Calc Add-in Java extension: assign function to a new category

Hi all, I develop a Calc Add-In with huge set of sheet functions. I would like to put them into a new category. In LibO Calc Java extension, in XAddIn interface there're 2 functions: getProgrammaticCategoryName() and getDisplayCategoryName(). From Javadoc I see that getProgrammaticCategoryName mu

LibO Calc - detect if function is called within Function Wizard

Hi all, I'm developing a java extension for calc, and I would like to detect if a worksheet function (implemented in my addin) is called from Function Wizard. The function may work long (it performs a request to external DB), and I would like to return some stub value (let it be #VALUE!) when it i

Re: Building LO java extension with Gradle or Ant

Thanks for the info Jan-Marek, appreciated! Regards, Mike On Sun, Jun 21, 2015 at 12:25 AM, Jan-Marek Glogowski wrote: > Hi Mike > > Am 18.06.2015 um 16:56 schrieb Mikhail Zemlyanukha: >> I'm working on a LO java extension. Examples in LO SDK use Makefiles, >> while i

Building LO java extension with Gradle or Ant

Hi all, I'm working on a LO java extension. Examples in LO SDK use Makefiles, while in Java dev there are other build tools commonly used, such as Gradle, Maven and Ant. I'm looking for a script to build LO extension with those tools, preferable Gradle because it's builtin into IntelliJ Idea whic

Re: SDK Java Spreadsheet CalcAddIns example

Thanks a lot, I was starting to think that I live in another world while in the real one the CalcAddins example works for humans On Wed, Jun 17, 2015 at 6:59 PM, Stephan Bergmann wrote: > On 06/17/2015 01:10 AM, Mikhail Zemlyanukha wrote: >> >> I tried to build sdk/examples/j

Re: SDK Java Spreadsheet CalcAddIns example

Hi all, This is a second copy of my post, just I do not see the first post appeared in the list. If for some reason my question is not suitable for the list, do not hesitate to let me know, I'll try to handle it in other way )) --- I tried to build sdk/examples/java/Spreadsheet example, and buil

SDK Java Spreadsheet CalcAddIns example

Hi all, I tried to build sdk/examples/java/Spreadsheet example, and build was successful - CalcAddins.oxt assembled and was installed in LO, I see it in extensions manager. But when I open CalcAddins.ods, I see #NAME? when functions from addin is called (=org.openoffice.sheet.addin.calcaddins.get