Good afternoon, I would like to know if it is possible to use the advanced_excel extension to apply text length validations to cells. Specifically, as shown in the screenshot, I would like to apply a validation to a cell where the minimum length is 0 and the maximum length is also 0 (this is intended to prevent users from modifying the value that will be set by a specific formula).If this is not possible, would it be necessary to create a custom extension to achieve this functionality?
Found a solution. You can use the Cell_FormatRange function to set the cell you want to lock to false and then protect the worksheet. This way, you can lock specific cells, preventing users from modifying their content.