<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Validity>Custom>Formula does not have the expected effect without additional measures - evaluation of entered formula only happens after additional trigger" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131309#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Validity>Custom>Formula does not have the expected effect without additional measures - evaluation of entered formula only happens after additional trigger" href="https://bugs.documentfoundation.org/show_bug.cgi?id=131309">bug 131309</a> from <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>So the problem here seems that the two formula areas ("Custom" and "Cell Range") are not separated and checked strictly. 1. The formulas in the two areas are expected to be different. The "Custom" formula should result in a scalar value that would be converted to boolean for the purpose of the check. The "Cell Range" expects to return a range which would be used as a source to find a match for the value in the cell in the validity check. But when you enter the formula, it's not checked that its result matches the area. 2. A formula entered in "Custom", which gives a range, will automatically end up in "Cell Range" (but the drop-down will not appear immediately). This automatic "migration" could be unexpected (?). IMO it's OK to have it migrated as it is now, but the check that it's in fact a range formula should be made at the stage of dialog closing, and the actions should be performed according to its final type (range result detected => Cell Range validity rule => create a list).</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>