Bug 142934 - EDITING: Validity Custom Formula does not find newlines
Summary: EDITING: Validity Custom Formula does not find newlines
Status: RESOLVED DUPLICATE of bug 125595
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-06-18 16:34 UTC by Jim Kornelsen
Modified: 2021-06-19 00:07 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jim Kornelsen 2021-06-18 16:34:01 UTC 
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/
Comment 1 m_a_riosv 2021-06-19 00:07:41 UTC 
I think a duplicate.

*** This bug has been marked as a duplicate of bug 125595 ***