Bug 36132

Created attachment 45474 [details]
Extensionfile ocapy.oxt with Calc-addin-function "Testrange"

Building a Calcaddin-extension I want to return a Cellrange, similar to return of a Calcformula, for Example '=A1:C5' as Arrayformula.

I try it with following:

Xexample.idl
########################
#include  /opt/libreoffice/basis3.3/sdk/idl/com/sun/star/uno/XInterface.idl

// Xexample.idl
module com { module sheetfunctions {
    interface ocapy
    {
        any testrange( [in] any cellrange );
    };
}; };
##########################
*Test with Type "any [ ][ ] testrange.." leads to Compiler-errors from idlc

Pythonscript:
#################################
import uno
import unohelper
from com.sheetfunctions import Xexample


wrapper = uno.createUnoStruct('com.sun.star.script.ArrayWrapper')
wrapper.IsZeroIndex = False

class functions( unohelper.Base, Xocapy ):
    def __init__(self, ctx):
        self.ctx = ctx

    def testrange( self, cellrange ):
        if isinstance(cellrange, tuple):
            return  cellrange 
            #involving wrapper to return a range works only thru basic-bridge:
            #wrapper.Array = cellrange
            #return wrapper
             
        else:
            return cellrange

    
def createInstance( ctx ):
	return functions( ctx )

g_ImplementationHelper = unohelper.ImplementationHelper()
g_ImplementationHelper.addImplementation( \
	createInstance,"com.sheetfunctions.ocapy.functions",
		("com.sun.star.sheet.AddIn",),)
#################################################

Inside python I can work with Input "cellrange" as nestet tuple, but calling from Calc for Example "=TESTRANGE(A1:B3)" as Arrayfomula or not returns: '#Value'.
Calling the Function with a single Celladdress returns the Content from Celladdress.

Is it a bug - is it a missing feature - or do I something wrong ?