[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

Wolfgang Jäger <jag at psilosoph.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jag at psilosoph.de
             Status|RESOLVED                    |REOPENED
         Resolution|FIXED                       |---

--- Comment #12 from Wolfgang Jäger <jag at psilosoph.de> ---
Q&A thread: https://ask.libreoffice.org/en/question/233184/ 
In pursuit of the mentioned thread I first noticed that the Validity feature
got the new Allow:>Custom>Formula variant.  

I tested it (though I judge it to be completely useless; 'Cell range' option
always allowed to enter a formula, and this is sufficiently made clear there)
and found with version 6.2.5.2 and with 6.4.2.1 as well that the new feature
doesnt't work as requested and expected:

The formula entered under >Custom>Formula is passed to the respective control
under the 'Cell range' path, but isn't put in force as long as it not got at
least a fake edit.

(The feature also is not mentioned in the online helöp for 6.4)

My suggsetion: Make sure that formulas entered in 'Cell range' mode are treated
properly by the Excel filters when importing/exporting, and remove it from Calc
again OR cancel the redundancy concerning 'Cell range'. First alternative
clearly preferred.

-- 
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/20200312/442fdc5c/attachment.htm>