| Summary: | EDITING: Validity Custom Formula does not find newlines | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jim Kornelsen <jk.kornelsen> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | miguelangelrv |
| Priority: | medium | ||
| Version: | 7.1.2.2 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
I think a duplicate. *** This bug has been marked as a duplicate of bug 125595 *** |
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/