source/text/scalc/01/12120100.xhp | 50 ++++++++++++++++++--------------------
1 file changed, 24 insertions(+), 26 deletions(-)
New commits:
commit be7cb5f81c4d389fd6ff8ab1d6cb9338ccd5c61c
Author: Seth Chaiklin <sdc.bla...@youmail.dk>
AuthorDate: Wed Oct 28 20:56:33 2020 +0200
Commit: Seth Chaiklin <sdc.bla...@youmail.dk>
CommitDate: Thu Oct 29 15:10:53 2020 +0100
tdf#137277 add note about truncated lists in Excel export
- remove all colspan="" rowspan="" in <tablecell>
+ <h1>,some <h2>
Change-Id: I07430cde51ed1d4faeac2569b9e4066dcf290865
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/104952
Tested-by: Jenkins
Reviewed-by: Seth Chaiklin <sdc.bla...@youmail.dk>
diff --git a/source/text/scalc/01/12120100.xhp
b/source/text/scalc/01/12120100.xhp
index 94e9e1b9b..f5fff7d7b 100644
--- a/source/text/scalc/01/12120100.xhp
+++ b/source/text/scalc/01/12120100.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -19,7 +18,6 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-<helpdocument version="1.0">
<meta>
<topic id="textscalc0112120100xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Criteria</title>
@@ -35,7 +33,7 @@
</bookmark><comment>UFI added index entry for new list feature. Guide needed.
MW changed index entry</comment>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage"
id="bm_id3145673" localize="false"/>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/@@nowidget@@"
id="bm_id3145673" localize="false"/>
-<paragraph role="heading" id="hd_id3153032" xml-lang="en-US" level="1"><link
href="text/scalc/01/12120100.xhp" name="Criteria">Criteria</link></paragraph>
+<h1 id="hd_id3153032" xml-lang="en-US"><link href="text/scalc/01/12120100.xhp"
name="Criteria">Criteria</link></h1>
<paragraph role="paragraph" id="par_id3156327" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/ValidationCriteriaPage">Specify
the validation rules for the selected cell(s).</ahelp></paragraph>
</section>
<section id="howtoget">
@@ -43,86 +41,86 @@
</section>
<paragraph role="paragraph" id="par_id3155923" xml-lang="en-US">For example,
you can define criteria such as: "Numbers between 1 and 10" or "Texts that are
no more than 20 characters".</paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/allow" id="bm_id3148663"
localize="false"/>
-<paragraph role="heading" id="hd_id3153896" xml-lang="en-US"
level="2">Allow</paragraph>
+<h2 id="hd_id3153896" xml-lang="en-US">Allow</h2>
<paragraph role="paragraph" id="par_id3150400" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/allow">Click a validation option
for the selected cell(s).</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3148797" xml-lang="en-US">The following
conditions are available:</paragraph>
<table id="tbl_id3150870">
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablehead" id="par_id3150447"
xml-lang="en-US">Condition</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablehead" id="par_id3155854"
xml-lang="en-US">Effect</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3153092" xml-lang="en-US">All
values</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3155411" xml-lang="en-US">No
limitation.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3147434" xml-lang="en-US">Whole
number</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3154319" xml-lang="en-US">Only whole
numbers corresponding to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3145802"
xml-lang="en-US">Decimal</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3153160" xml-lang="en-US">All numbers
corresponding to the condition.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3149377"
xml-lang="en-US">Date</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3150718" xml-lang="en-US">All numbers
corresponding to the condition. The entered values are formatted accordingly
the next time the dialog is called up.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3146969"
xml-lang="en-US">Time</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3155066" xml-lang="en-US">All numbers
corresponding to the condition. The entered values are formatted accordingly
the next time the dialog is called up.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_idN106A0" xml-lang="en-US">Cell
range</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_idN106A5" xml-lang="en-US">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.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_idN106AB"
xml-lang="en-US">List</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="tablecontent" id="par_idN106B0" xml-lang="en-US">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.</paragraph>
+<tablecell>
+<paragraph role="tablecontent" id="par_idN106B0" xml-lang="en-US">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.</paragraph> <paragraph role="note"
id="par_id221603980244052">Only up to 255 characters are saved, when using
Excel format.</paragraph>
</tablecell>
</tablerow>
<tablerow>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3154756" xml-lang="en-US">Text
length</paragraph>
</tablecell>
-<tablecell colspan="" rowspan="">
+<tablecell>
<paragraph role="tablecontent" id="par_id3147339" xml-lang="en-US">Entries
whose length corresponds to the condition.</paragraph>
</tablecell>
</tablerow>
</table>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/allowempty"
id="bm_id263985" localize="false"/>
-<paragraph role="heading" id="hd_id3154704" xml-lang="en-US" level="2">Allow
blank cells</paragraph>
+<h2 id="hd_id3154704" xml-lang="en-US">Allow blank cells</h2>
<paragraph role="paragraph" id="par_id3153967" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/allowempty">In conjunction with
<emph>Tools - Detective - Mark invalid Data</emph>, this defines that blank
cells are shown as invalid data (disabled) or not (enabled).</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/showlist" id="bm_id5339518"
localize="false"/>
<paragraph role="heading" id="par_idN10709" xml-lang="en-US" level="2">Show
selection list</paragraph>
@@ -141,7 +139,7 @@
<paragraph role="heading" id="hd_id3153782" xml-lang="en-US"
level="2">Value</paragraph>
<paragraph role="paragraph" id="par_id3153266" xml-lang="en-US">Enter the
value for the data validation option that you selected in the <emph>Allow
</emph>box.</paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/min" id="bm_id3149528"
localize="false"/>
-<paragraph role="heading" id="hd_id3149814" xml-lang="en-US"
level="2">Minimum</paragraph>
+<h2 id="hd_id3149814" xml-lang="en-US">Minimum</h2>
<paragraph role="paragraph" id="par_id3153199" xml-lang="en-US"><ahelp
hid="modules/scalc/ui/validationcriteriapage/min">Enter the minimum value for
the data validation option that you selected in the <emph>Allow
</emph>box.</ahelp></paragraph>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/validationcriteriapage/max" id="bm_id3150206"
localize="false"/>
<paragraph role="heading" id="hd_id3149035" xml-lang="en-US"
level="2">Maximum</paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
