From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- sc/uiconfig/scalc/ui/validationcriteriapage.ui | 321 +++++++++++++++++++++++++ 1 file changed, 321 insertions(+) create mode 100644 sc/uiconfig/scalc/ui/validationcriteriapage.ui (limited to 'sc/uiconfig/scalc/ui/validationcriteriapage.ui') diff --git a/sc/uiconfig/scalc/ui/validationcriteriapage.ui b/sc/uiconfig/scalc/ui/validationcriteriapage.ui new file mode 100644 index 000000000..3e98accaa --- /dev/null +++ b/sc/uiconfig/scalc/ui/validationcriteriapage.ui @@ -0,0 +1,321 @@ + + + + + + + True + False + True + True + 6 + 6 + 12 + + + True + False + _Allow: + True + allow + 0 + + + 0 + 0 + + + + + False + True + _Data: + True + data + 0 + + + 0 + 4 + + + + + True + False + + All values + Whole Numbers + Decimal + Date + Time + Cell range + List + Text length + Custom + + + + Click a validation option for the selected cell(s). + + + + + 1 + 0 + + + + + False + True + + equal + less than + greater than + less than or equal + greater than or equal to + not equal + valid range + invalid range + + + + Select the comparative operator that you want to use. + + + + + 1 + 4 + + + + + True + False + _Minimum: + True + mingrid + 0 + + + 0 + 5 + + + + + + True + False + True + + + + True + False + True + 12 + + + True + True + True + True + True + + + Enter the minimum value for the data validation option that you selected in the Allow box. + + + + + 0 + 0 + + + + + True + True + True + center + center + + + 1 + 0 + + + + + 0 + 0 + + + + + True + True + True + True + in + + + True + True + True + True + + + Enter the entries that will be valid values or text strings. + + + + + + + 0 + 1 + + + + + 1 + 5 + + + + + False + True + Ma_ximum: + True + max + 0 + + + 0 + 7 + + + + + Allow _empty cells + True + True + False + True + True + + + In conjunction with Tools - Detective - Mark invalid Data, this defines that blank cells are shown as invalid data (disabled) or not (enabled). + + + + + 1 + 1 + + + + + Show selection _list + True + True + False + True + True + + + Shows a list of all valid strings or values to select from. The list can also be opened by selecting the cell and pressing Ctrl+D. + + + + + 1 + 2 + + + + + Sor_t entries ascending + True + True + False + 12 + True + True + True + + + Sorts the selection list in ascending order and filters duplicates from the list. If not checked, the order from the data source is taken. + + + + + 1 + 3 + + + + + False + True + A valid source can only consist of a contiguous selection of rows and columns, or a formula that results in an area or array. + True + 50 + 0 + 0 + + + 1 + 6 + + + + + True + True + True + True + True + + + Enter the maximum value for the data validation option that you selected in the Allow box. + + + + + 1 + 7 + + + + + + + + + + + + + + + + + Specify the validation rules for the selected cell(s). + + + + + + + + + + + + -- cgit v1.2.3