[Libreoffice-bugs] [Bug 131309] New: Validity>

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131309
           Summary: Validity>
           Product: LibreOffice
           Version: 6.2.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: 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 editable line under
the 'Cell range' path, but isn't put in force as long as it not got at least a
fake edit IN THIS PLACE.  

The new setting will also work as soon as the document was saved to a file.
That's the reason fo what I cannot provide an attachment showing the issue. 

Instead of a demonstrating attachment:

Create a new Calc document, use first sheet e.g.
Enter a, b, c, d into <Cells A2 through A5.
Go to cell D2.
Call >Data>Validity
Open >Criteria>Custom
Go to 'Formula'
Enter OFFSET($A$2;1;0;2;1)
OK

Expected: 
Selecting D2 results in the dropdown symbol shown right of it.
Clicking on it offers a list containing 2 rows with b and c.

Observed:
No such functionality.

Open the Valdity dialog for DE2 again.
Call >Critria>Cell range

Extected:
Nothing shown in 'Source'

Observed:
'Source' is containing the correct ecpression.

...

Store the document to a file

Expected:
Nothing new

Observed:
Now the Validity setting works as originally expected
(Same thing if the range expression was edited in any way under 'Source'
without changing it.)

See also tdf#130738.

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