incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zhang Lu <zhanglu....@gmail.com>
Subject [Call-for-​​Review][Calc]Data validity works incorrectly with criteria "Allow text length" for numbers
Date Wed, 25 Jul 2012 05:11:27 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message