FunctionVisualizer using parameters to create graphics

Posted by: niels on 3 April 2023, 6:26 am EST

  • Posted 3 April 2023, 6:26 am EST - Updated 3 April 2023, 6:35 am EST

    The screenshot shows the goal.

    B2 contains a formula with a custom Visualizer function.

    The function takes 2 parameters

    The function will get data from an external source

    I am unable to do 2 things.

    1. It should show a graphical representation in cell B2 (like the other cells)

    2. If the parameters are arrays, it should automatically display graphics in next cells…just like the spilling of a dynami array

    Problem is that in the Paint method of the FunctionVisualizer, there is not access to the parametes like in the Evaluate method.

    And in the Paint method, it is not possible to get the Rectangles of the next cells for spilling

  • Posted 3 April 2023, 6:28 am EST

    For clarity, the graphics are faked

  • Posted 3 April 2023, 6:32 am EST

    And the function in th graphics is worng. It should be


  • Posted 3 April 2023, 6:33 am EST


  • Posted 3 April 2023, 6:33 am EST


  • Posted 4 April 2023, 10:15 pm EST


    Apologize for the delay.

    Could you please provide a sample? So, that we can replicate this issue and assist you accordingly. It would be helpful to have a sample for investigation with your use case.



  • Posted 5 April 2023, 6:15 am EST

    Hi Nitin

    I already send this to Kevin by Email. But here is it again.

  • Posted 5 April 2023, 11:09 pm EST


    Thanks for the sample.

    We are discussing this requirement with the development team. Will get back to you once we have any update from them.[Internal Tracking Id - SPNET-29332]



  • Posted 6 April 2023, 1:07 am EST

    Nice, thank you, looking forward

  • Posted 10 April 2023, 3:22 pm EST


    I hope, Kevin reached to you with the solution to override IsArrayParameter() method.

    And for your follow-up question. The development team provided a solution. Kevin will provide the solution to you.

    Just in case you have another issue. Then you can create a new forum post.



Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels