From be7cb5f81c4d389fd6ff8ab1d6cb9338ccd5c61c Mon Sep 17 00:00:00 2001 From: Seth Chaiklin Date: Wed, 28 Oct 2020 20:56:33 +0200 Subject: tdf#137277 add note about truncated lists in Excel export - remove all colspan="" rowspan="" in +

,some

Change-Id: I07430cde51ed1d4faeac2569b9e4066dcf290865 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104952 Tested-by: Jenkins Reviewed-by: Seth Chaiklin --- source/text/scalc/01/12120100.xhp | 50 +++++++++++++++++++-------------------- 1 file changed, 24 insertions(+), 26 deletions(-) diff --git a/source/text/scalc/01/12120100.xhp b/source/text/scalc/01/12120100.xhp index 94e9e1b9bc..f5fff7d7b4 100644 --- a/source/text/scalc/01/12120100.xhp +++ b/source/text/scalc/01/12120100.xhp @@ -1,6 +1,5 @@ - - + - Criteria @@ -35,7 +33,7 @@ UFI added index entry for new list feature. Guide needed. MW changed index entry -Criteria +

Criteria

Specify the validation rules for the selected cell(s).
@@ -43,86 +41,86 @@
For example, you can define criteria such as: "Numbers between 1 and 10" or "Texts that are no more than 20 characters". -Allow +

Allow

Click a validation option for the selected cell(s). The following conditions are available: - + Condition - + Effect - + All values - + No limitation. - + Whole number - + Only whole numbers corresponding to the condition. - + Decimal - + All numbers corresponding to the condition. - + Date - + All numbers corresponding to the condition. The entered values are formatted accordingly the next time the dialog is called up. - + Time - + All numbers corresponding to the condition. The entered values are formatted accordingly the next time the dialog is called up. - + Cell range - + Allow only values that are given in a cell range. The cell range can be specified explicitly, or as a named database range, or as a named range. The range may consist of one column or one row of cells. If you specify a range of columns and rows, only the first column is used. - + List - -Allow only values or strings specified in a list. Strings and values can be mixed. Numbers evaluate to their value, so if you enter the number 1 in the list, the entry 100% is also valid. + +Allow only values or strings specified in a list. Strings and values can be mixed. Numbers evaluate to their value, so if you enter the number 1 in the list, the entry 100% is also valid. Only up to 255 characters are saved, when using Excel format. - + Text length - + Entries whose length corresponds to the condition.
-Allow blank cells +

Allow blank cells

In conjunction with Tools - Detective - Mark invalid Data, this defines that blank cells are shown as invalid data (disabled) or not (enabled). Show selection list @@ -141,7 +139,7 @@ Value Enter the value for the data validation option that you selected in the Allow box. -Minimum +

Minimum

Enter the minimum value for the data validation option that you selected in the Allow box. Maximum -- cgit