Hi~ One fix for review.
https://issues.apache.org/ooo/show_bug.cgi?id=93128 Step: 1 Select the cells for which you want to define a new validity rule 2 Choose Data - Validity 3 On the Criteria tab page, enter the conditions for new values entered into cells 4 In the Allow field, select "Text length" 5 In the Data field, select such as "less than" 6 In the Value field, enter into "10" Result: If you enter "11111" into the cells for which you want to define a new validity rule, there is a error message "Invalidate value". Expectation: we can enter anything into the cells Root cause: There is no flow to handle a real number when selecting string length operation Solution: if operation is string length type, to get the number's length, and consider it as a string.