[Libreoffice-bugs] [Bug 96698] Data => Validity => Custom (like Excel) is missing

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=96698

--- Comment #5 from Justin L <jluth at mail.com> ---
Created attachment 134080
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134080&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170617/728f9eee/attachment.html>