FunctionVisualizer using parameters to create graphics

FunctionVisualizer using parameters to create graphics

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

• 

  niels

  • Post Options:
  • Link
    Copy

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

  The screenshot shows the goal.

  

  1012×579 105 KB

  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

  

  1004×606 113 KB

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 3 April 2023, 6:28 am EST

  For clarity, the graphics are faked

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 3 April 2023, 6:32 am EST

  And the function in th graphics is worng. It should be
  
  =VF.Chrom(A3:A6,C1:C1)

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 3 April 2023, 6:33 am EST

  =VF.Chrom(A3:A6,C1:G1)

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 3 April 2023, 6:33 am EST

  =VF.Chrom(A3:A6,B1:F1)

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 4 April 2023, 10:15 pm EST

  Hi,

  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.

  Regards,
  
  Nitin

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 5 April 2023, 6:15 am EST

  QuantReviewTestPublic.zip

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

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 5 April 2023, 11:09 pm EST

  Hi,

  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]

  Regards,
  
  Nitin

• 

  niels

  • Post Options:
  • Link
    Copy

  Posted 6 April 2023, 1:07 am EST

  Nice, thank you, looking forward

• 

  nitin.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 10 April 2023, 3:22 pm EST

  Hi,

  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.

  Regards,
  
  Nitin