incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lei Wang <lei.wang.l...@gmail.com>
Subject Re: [Call-for-​​Review][Calc]Data validity works incorrectly with criteria "Allow text length" for numbers
Date Fri, 27 Jul 2012 08:32:26 GMT
I am taking care of this

On Wed, Jul 25, 2012 at 1:11 PM, Zhang Lu <zhanglu.aoo@gmail.com> 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.
>

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