https://issues.apache.org/ooo/show_bug.cgi?id=93128
binguo <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED CC| |[email protected] Resolution|FIXED |--- --- Comment #8 from binguo <[email protected]> --- Verified on Aoo_Trunk_20121109.1800 rev 1407366 run the following steps: 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 number OR text which length of them are equal or greater than "10" such as "1234567890" or "abcdefghijh" into the cells for which you want to trigger validity rule, but no error message Expectation: there should be error message saying "Invalidate value". NOTES: In MS Excel 2003 side, if you set rule "Text length" "less than" "10" to the cells, the cells can not input number OR text which length of them are equal or greater than "10". So Reopen it. -- You are receiving this mail because: You are on the CC list for the bug.
