Let us know how we can make Jedox even better!
Allow pasting array formulas in Macro Engine, using a method "FormulaArray" like in VBA, e.g.:
activesheet()->range('D3:G3')->formulaArray = "=TRANSPOSE(C4:C7)";
Thanks for the idea. This feature has been evaluated by us and we will not implement at this time.