Question about defined functions that return a solution matrix

[salvo79]

Hi Someone has worked with defined functions that return an objects [,] to the grid. In other words, using NativeFunctionObject with a 2D solution instead of a single solution. My code

this.grid.Srm["ORION_5G"] = new NativeFunctionObject("ORION_5G", (ctx, owner, args) =>
            {  var result= ORION_CC.ORION5G(args[0].ToString(), args[1], args[2]);
               return (args.Length < 1) ? null : (result);});
        }

The expected solution is a object[,] 2d matrix Regards

[jingwood]

Returning a rectangular multiple dimensional array is possible, but the array cannot be set onto worksheet automatically. Since formula does only effect to single cell.

Best practice maybe is to set data directly onto worksheet inside the function instead of returning an array.

[jingwood]

@salvo79 How about this now?