[Libreoffice-bugs] [Bug 142934] New: EDITING: Validity Custom Formula does not find newlines

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 142934
           Summary: EDITING: Validity Custom Formula does not find
                    newlines
           Product: LibreOffice
           Version: 7.1.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jk.kornelsen at gmail.com

Example in cell A1 containing an ASCII 10 newline (Ctrl+Enter):

    1
    2

This works as a spreadsheet formula but not in Data > Validity > Custom,
Formula.

    =NOT(ISERROR(SEARCH(CHAR(10);A1)))

Expected Result:

    Cell A1 should be accepted as valid.

Actual Result:

    Invalid value.

On further investigation, the following formula passes validity, so it seems
that newlines are handled to some extent.

    NOT(ISERROR(SEARCH(CHAR(10);"1" & CHAR(10) & "2")))

Discussion:
https://ask.libreoffice.org/en/question/314291/calc-validity-formula-matching-a-newline/

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