https://bugs.documentfoundation.org/show_bug.cgi?id=96698
Bug ID: 96698
Summary: Data => Validity => Custom (like Excel) is missing
Product: LibreOffice
Version: unspecified
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In Excel (all the time) there is in Data => Validity an additional item to
select: "Custom"
https://support.office.com/en-nz/article/Apply-data-validation-to-cells-c743a24a-bc48-41f1-bd92-95b6aeeb73c9#bm4_8
Checking for values of other cells (or the actual content of the active cell)
can be done in LibreOffice also with a formula in the Minimum/Maximum values.
But 2 problems left:
1. A general valitdity check for the entered new content of the active cell -
especially for text - with a custom formula like in Excel is not possible.
A sometimes painful shortcoming :-(
2. Excel compatibility: As there is no "Custom" formula functionality in LO,
the Excel import and re-export must kill this (traditional) Excel
functionality.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
