I am taking care of this On Wed, Jul 25, 2012 at 1:11 PM, Zhang Lu <[email protected]> wrote:
> 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. >
