[Libreoffice-bugs] [Bug 131309] Validity>Custom>Formula does not have the expected effect without additional measures - evaluation of entered formula only happens after additional trigger

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Mike Kaganski <mikekaganski at hotmail.com> ---
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).

-- 
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/20201208/a449c90a/attachment.htm>