To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93128 Issue #|93128 Summary|Validity: wrong error messages if Text length item wor |ks Component|Spreadsheet Version|OOO300m3 Platform|PC URL| OS/Version|Windows XP Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|amy2008
------- Additional comments from [EMAIL PROTECTED] Tue Aug 26 08:16:00 +0000 2008 ------- In OOo300_m3_EN on WinXP. To reproduce: 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 Help contents: "Text Length" stipulates that cells are allowed to contain text only. If I formatted the cells as text, then define a new validity rule for thes rules, now we can enter numbers into these cells without any error messages. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]