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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
