<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Data => Validity => Custom (like Excel) is missing" href="https://bugs.documentfoundation.org/show_bug.cgi?id=96698#c5">Comment # 5</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Data => Validity => Custom (like Excel) is missing" href="https://bugs.documentfoundation.org/show_bug.cgi?id=96698">bug 96698</a> from <a class="email" href="mailto:jluth@mail.com" title="Justin L <jluth@mail.com>"> Justin L</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=134080" name="attach_134080" title="partial fix: custom formulas work as long as they don't reference the edited cell.">attachment 134080</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=134080&action=edit" title="partial fix: custom formulas work as long as they don't reference the edited cell.">[details]</a> partial fix: custom formulas work as long as they don't reference the edited cell. Currently, custom formulas do not work at all. The only time it MIGHT work out is working with non-zero numbers. The larger problem here is that the formula runs on the previous data, so whatever you typed is not being checked. So using my example document, if you type "comma,", then it will be accepted (since it evaluated an empty cell), but anything you enter after that will be rejected (because it is evaluating the old value of "comma,"). I think that is what this comment is trying to indicate. // for Custom, it must be eOp == SC_COND_DIRECT //TODO: the value must be in the document !!! It is easy to ensure that for Custom, eOp == SC_COND_DIRECT. That is why the patch does for .xls[xb] and .xls. I'm not submitting it on it's own though because the formula will almost always be checking it's own value, so the TODO part is an essential part of any fix.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>