[Libreoffice-bugs] [Bug 131309] Validity>Custom>Formula does not have the expected effect without additional measures.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #1 from Durgapriyanka <durgapriyanka.arun at gmail.com> ---
Thank you for reporting this bug. I can reproduce this partially, but not fully
in

Version: 6.4.0.0.alpha1+ (x86)
Build ID: ec7374ff84c71edfbb30d6e4dc5b486b6df7107f
CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win; 
TinderBox: Win-x86 at 42, Branch:master, Time: 2019-11-10_21:37:30
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

when I Create a new Calc document, 
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)
and click OK, No dropdown symbol shown right of it.

But, again when I Open the Validity dialog for DE2 again.
Cell>Criteria>Cell range , 'Source' is containing the correct expression.

Even without saving the document and reopening it, Now the Validity setting
works as originally expected.

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