Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Not Planned
Workspace Jedox Platform
Created by Guest
Created on Apr 26, 2022

Make spreadsheet function involving cell reference in paramater usable in PHP

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

  • ADMIN RESPONSE
    Apr 29, 2022

    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.