Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Not Planned
Workspace Jedox Platform
Categories Jedox Web
Created by Guest
Created on Oct 15, 2020

Expose the PHP functions in the spreadsheet functions

for instance I want to compare 2 ranges, I have a function:

function arrayintersect($array1,$array2)
{
return array_intersect($array1,$array2);
}

this would be helpful if the array_intersect function would be directly accessible from the spreadsheet without needing to create such an alias function that serve the same purpose

  • ADMIN RESPONSE
    Feb 11, 2022

    Thanks for the idea. This feature has been evaluated by us and we will not implement at this time.

    We are trying to reduce the need for people to write custom code, so whilst we are not preventing the current approach via a wrapper function, we do not plan to add new support in this area.

  • Attach files
  • Guest
    Mar 1, 2022

    thanks for the review of this idea.

    actually the need would not be to support all the PHP functions explicitely, but a generic one (such as "call_user_func") that would allow to use all possible php functions

    we don't write custom code as a hobby but rather because it enhances the capabilities in Jedox Spreadsheets when something is not possible (yet) ; supporting such a function would just ease the development of custom macros.