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.

Reply via email to