Apache OpenOffice (AOO) Bugzilla – Issue 109763
Using Form Based Filtering and the form: IN Operator the warning dialog regarding (,) vs (;) syntax usage is too vague to be useful
Last modified: 2013-08-07 15:45:41 UTC
to reproduce: Open a form with a number field. Open the filter mode and type in the field in (nr1,nr2). Press Enter. Parser recognizes the expression (setting to IN (nr1,nr2)). Repeat the procedure with 3 or more arguments. Parser changes the expression to IN ('nr1,nr2,nr3'). If you remove the quotes and filter the form, then the navigator bar is disabled, you can only close the form.
Checked w/ Xp, OOo3.2 - OOo3.0.1 - DEV300m_72 Using form based filters in no case accepted IN( N1, N2 ). The syntax IN( 'N1', 'N2', 'N3' ) is accepted, checked and no problems found. For numbers there is a different syntax IN( 1;2;3 ) also functions properly. In both 3.0.1 and 3.2 there is the problem that if the user enters IN( 1, 2 ) then tabs out of the field this is incorrectly quoted as IN( '1,2' ). Under DEV300m_72 this is no longer the case, rather an error box is displayed when you tab out of the field. The error text is, IMO, much too cryptic to be of any real use.
just tested, input in (1,2) is recognized, see attachment. using ";" as a delimiter solves my problem, nevertheless I consider the current behavior buggy.
Created attachment 68140 [details] three pics for input, enter, filter
The problem are the blanks. Try IN (1,2) or IN (1 , 2) or IN (1, 2).
@eberlein I just went through this again with DEV300m_75 In your last comment the problem is that you should be using: IN( 1; 2 ) Blanks are of no importance if you use the correct syntax. Two things however - First there is nothing in the help about this, that I can find. That may be poor searching on my part. - Second the error box, correctly displayed IMO, when the incorrect syntax is entered displays a string that is, again IMO, much less useful then it really *need* to be. I am going to change the summary here, move from defect to enhancement, set keyword usability and assign to CLU for UX
clu->oj: in my opinion a rather seldom case, so i would propose to fix it if you rework this area
In a DEV300m90 I don't see any error message. Could please add screen shot of the error message? Thanks.
Created attachment 75312 [details] Error Msg Version = 330m15
just tested with m101: entering IN(1,2,3,4,5,8) in a numerical Field makes the navigation bar disabled, you can only close the form.