[Libreoffice-bugs] [Bug 134311] New: Data validity fails when pasting into cell

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134311
           Summary: Data validity fails when pasting into cell
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: nkemp1165 at hotmail.com

Description:
I have a data validity rule set that works when entering data from the
keyboard.  It verifies { <0 OR "Void" }(less the {}). so -23 or Void is an OK
entry. 0, 12 or any other text fails.

The Bug: When I copied the number 4 from a webpage (or a LO word document) and
pasted (ctrl V) it into the cell the data validity rule failed to block the
entry.

Steps to Reproduce:
1.Create this data validity per ... OR(G28<0, G28="VOID")
2.Goto https://bikepacking.com/gear/rivnut-bottle-cage-mounts/
3.Goto the text: 4. INSTALL THE RIVNUT
4. Copy the "4" and past into the data validated cell

Actual Results:
Allows number to be entered when it should have blocked it

Expected Results:
Thrown the message that was created when the data validity failed.


Reproducible: Always


User Profile Reset: No



Additional Info:
I copied a number from a LO Document and it allowed pasting as did the text
from the webpage. The cell that failed using the paste did work before and
after the paste when typing the value.

-- 
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/20200625/419a3b4e/attachment.htm>