Property Formulas in Form Control

Property Formulas in Form Control

Posted by: Jean.s on 18 March 2024, 2:21 am EST

• 

  Jean.s

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 March 2024, 2:21 am EST

  Hi,
  
  how is possible to bind a formula to a property of a Form Control in the same way that I can do with a Shape?

  For instance I wanto to set a dynamic value (based on a count formula) to the maxvalue property of a scrollbar.

  Thank You

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 19 March 2024, 7:45 pm EST

  Hi,

  Currently, this feature is not supported, and I’ve escalated this to the relevant team for further review. The internal track ID for this issue is “SJS-23451”. I’ll keep you updated once I receive any information.

  Regards,
  
  Priyam

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 21 March 2024, 7:55 pm EST

  Hi,

  The developer has informed that this behavior is expected and by design. The FormControl closely follows to the specifications of Excel FormControls. Properties like minValue or maxValue are control-specific and do not support formulas, as they are distinct from common properties shared by shapes. Therefore, it is not supported.

  Regards,
  
  Priyam

• 

  Jean.s

  • Post Options:
  • Link
    Copy

  Posted 21 March 2024, 8:17 pm EST

  Hi Priyam,

  I understand your position but I think that this functionality would be very useful to manage dynamic scenarios.
  
  Would it be possible to add that in the roadmap?

  Regards

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 21 March 2024, 11:23 pm EST

  Hi,

  I’ve shared your concern to the dev team in the same escalated case. I’ll keep you updated once I receive any information.

  Regards,
  
  Priyam

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 4 April 2024, 11:57 pm EST

  Hi,

  This request has been added to the product backlog with the internal track ID “SJS-23571”. I will provide you with updates as soon as they are available.

  Regards,
  
  Priyam