https://bugs.documentfoundation.org/show_bug.cgi?id=154560
--- Comment #4 from najevi <[email protected]> --- The problem appears to be a matter of file format used. I did not notice until saving my experimental edits of the test case under a different filename but ... the test case file submitted is saved in xlsx format ... not ods format! Once the (unedited) test case file is saved in ods format, then closed and reopened: ... all data validity formula used in column A behave just as you would expect! SO .. I'm not sure any of the following helps but it is included for thoroughness... There is definitely something strange happening with the formula drawn in from an xlsx format file and used for the validity rule in column A but it is _not_ a problem with any circular reference. The "circular reference" is legitimate because the validity rule has the type: Allow: Custom which necessarily takes a Formula and that formula cannot possibly produce an input value-dependent result if the input value is not referred to within the formula. ... n'est-ce pas? Just about any edit of the formula causes the formula to behave as you would expect. i.e. an input that is not found in the list (from column A on the second sheet) is allowed but an input that matches any value already in that list is disallowed. Indeed selecting any cell in Parameters column A and then opening Data Validity then cutting and pasting the _very_same_formula_ then saving that validity rule causes the desired behaviour. ... ah hah! file format of test case is xlxs not ods !! -- You are receiving this mail because: You are the assignee for the bug.
