Set validator for cell manually and undo

Set validator for cell manually and undo

Posted by: nguyendat012002 on 3 February 2025, 5:06 am EST

• 

  nguyendat012002

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 February 2025, 5:06 am EST

  Hi support team,

  I’m currently using SpreadJS v17. I’ve reproduced this problem with the dropdown picker in TableSheet.
  
  https://jscodemine.mescius.io/sample/_SYp831kDkuR8cGy3jr9VQ/
  
  I added a custom validator for cell col1-row1 (B2). After that, when I select an option from that dropdown, the validation is triggered. However, when I press Ctrl-Z (undo), the validator disappears. I’ve logged information about that validator, but found nothing.
  
  Since I need to add a different validator for each cell, I must set the validator for each cell again after calling setDataView.

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 4 February 2025, 9:55 am EST

  Hi,

  We too can observe the behavior you mentioned on our end. However, it seems like the data validations are meant for the whole column of the tablesheet and not just the single cell, which is why an unexpected behavior is observed on performing the Undo operation.

  We have also escalated your concern with the development team and will get back to you as soon as we get any update from their end.

  Internal_Tracking_Id: SJS-28156

  Please feel free to reach out if you encounter any further issues or require additional guidance.

  Best Regards,

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 6 February 2025, 2:10 am EST

  Hi,

  Thank you for your patience while our development team looked into the data validations of TableSheet.
  
  After a thorough review, our development team has confirmed that the data validations in TableSheet are designed for entire columns and not for individual cells. This is why the validator disappears during an Undo operation.

  The TableSheet is designed as a view for large datasets and differs from a standard worksheet. For better performance, validations are specifically designed to apply only to columns.

  Please let us know if you need further assistance!

  Best Regards,