This is an automated email from the ASF dual-hosted git repository. mseidel pushed a commit to branch AOO42X in repository https://gitbox.apache.org/repos/asf/openoffice.git
commit 4a2058357b6e8b4aaa1f9e8a00dc2348c513307f Author: DiGro <[email protected]> AuthorDate: Sat Apr 3 19:10:57 2021 +0200 Update par_id3166505K with missing space Addd missing space (cherry picked from commit 3ba2053a0dcc040a3faf6e7350f7c9f465aed828) --- main/helpcontent2/source/text/scalc/01/04060106.xhp | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/main/helpcontent2/source/text/scalc/01/04060106.xhp b/main/helpcontent2/source/text/scalc/01/04060106.xhp index 3995f4a..81f5896 100644 --- a/main/helpcontent2/source/text/scalc/01/04060106.xhp +++ b/main/helpcontent2/source/text/scalc/01/04060106.xhp @@ -1384,8 +1384,7 @@ oldref="553">Example</paragraph> <paragraph xml-lang="en-US" id="par_id3165000K" role="paragraph" l10n="CHG">All <emph>Reference </emph> ranges shall have the same dimension and size, else an Error is returned. <emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. You may also enter a search text in the form of a regular expression, e.g. b.* for all words that begin with b. You may also indicate a cell range that conta [...] <paragraph xml-lang="en-US" id="hd_id3165037K" role="heading" level="3" l10n="U" oldref="553">Examples:</paragraph> -<paragraph xml-lang="en-US" id="par_id3166505K" role="paragraph" l10n="CHG">A1:A10 is a cell range containing the numbers <item type="input">2000</item> to <item type="input">2009</item>. B1:B10 is a cell range containing the numbers -<item type="input">2007</item> to <item type="input">2016</item>:</paragraph> +<paragraph xml-lang="en-US" id="par_id3166505K" role="paragraph" l10n="CHG">A1:A10 is a cell range containing the numbers <item type="input">2000</item> to <item type="input">2009</item>. B1:B10 is a cell range containing the numbers <item type="input">2007</item> to <item type="input">2016</item>:</paragraph> <paragraph xml-lang="en-US" id="par_id3581652K" role="paragraph" l10n="NEW"> <item type="input">=COUNTIFS(A1:A10;2006;B1:B10;2014)</item> - this returns 2</paragraph> <paragraph xml-lang="en-US" id="par_id5169225K" role="paragraph" l10n="NEW">
