Let us know how we can make Jedox even better!
There is a lot of spreadsheet function we can't use in PHP with application like :
application() - > isformula("A1")
Instead of "A1" we could put an paramater that select the cell A1 like the class range, like this :
application() - > isformula(activesheet() -> range('A1'))
So this function could return if the cell A1 got a formula or not(like it should do).
There many other function like this, if you want I can list them all if you're undertaking modifications on those functions
Thanks for the idea. This feature has been evaluated by us and we will not implement at this time.
As a workaround, spreadsheet functions that involve cell references could be placed in an actual cell and then being accessed by Macro as range.