source/text/scalc/01/04060106.xhp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
New commits: commit 85e06dcbee5956f0f25a4d25677fae61206a7195 Author: Andrea Gelmini <andrea.gelm...@gelma.net> AuthorDate: Fri Sep 6 19:43:50 2019 +0200 Commit: Julien Nabet <serval2...@yahoo.fr> CommitDate: Fri Sep 6 23:21:04 2019 +0200 Fix typo Change-Id: I1a9958dedf6b836acef6e1033a9d79f3f94202e0 Reviewed-on: https://gerrit.libreoffice.org/78730 Tested-by: Jenkins Reviewed-by: Julien Nabet <serval2...@yahoo.fr> Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org> diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index c134e8dbb..7e42bdcb5 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1138,7 +1138,7 @@ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3163656" role="code" xml-lang="en-US">SUM(Number1; Number2; ...; Number30)</paragraph> <paragraph id="par_id3163671" role="paragraph" xml-lang="en-US"><emph>Number1 to Number30</emph> are up to 30 arguments, either cells or ranges, whose sum is to be calculated.</paragraph> -<tip id="par_id151567608802604">SUM ignores any text or empty cell within a range or array. If you suspect wrong results of the SUM function, look for text in the data ranges. Use the <link href="text/scalc/01/03080000.xhp" name="value highllight">value highlighting</link> feature to highlight the text contents in the range that may represent a number.</tip> +<tip id="par_id151567608802604">SUM ignores any text or empty cell within a range or array. If you suspect wrong results of the SUM function, look for text in the data ranges. Use the <link href="text/scalc/01/03080000.xhp" name="value highlight">value highlighting</link> feature to highlight the text contents in the range that may represent a number.</tip> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3163704" role="paragraph" xml-lang="en-US">If you enter the numbers <item type="input">2</item>; <item type="input">3 </item>and <item type="input">4</item> in the Number 1; 2 and 3 text boxes, 9 will be returned as the result.</paragraph> <paragraph id="par_id3151740" role="paragraph" xml-lang="en-US"><item type="input">=SUM(A1;A3;B5)</item> calculates the sum of the three cells. <item type="input">=SUM (A1:E10)</item> calculates the sum of all cells in the A1 to E10 cell range.</paragraph> _______________________________________________ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits