[Libreoffice-commits] help.git: AllLangHelp_scalc.mk source/text
tagezi
lera.goncharuk at gmail.com
Wed Oct 14 01:04:13 PDT 2015
AllLangHelp_scalc.mk | 1
source/text/scalc/01/04060109.xhp | 4
source/text/scalc/01/func_error_type.xhp | 129 +++++++++++++++++++++++++++++++
3 files changed, 134 insertions(+)
New commits:
commit bd002743972148b9a2dca39248e9f0f406c34eea
Author: tagezi <lera.goncharuk at gmail.com>
Date: Mon Oct 12 19:48:10 2015 +0300
Added description the ERROR.TYPE function
func_error_type.xhp is NEW and contains the description
maybe, need to add more good examples
AllLangHelp_scalc.mk added the link to the file
04060109.xhp added the link to name and description on the function
Change-Id: Ic178c3198ffa91bf02dcf611013347ca7814ab30
Reviewed-on: https://gerrit.libreoffice.org/19361
Reviewed-by: Caolán McNamara <caolanm at redhat.com>
Tested-by: Caolán McNamara <caolanm at redhat.com>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 0c180ca..09735b8 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -194,6 +194,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_eastersunday \
helpcontent2/source/text/scalc/01/func_edate \
helpcontent2/source/text/scalc/01/func_eomonth \
+ helpcontent2/source/text/scalc/01/func_error_type \
helpcontent2/source/text/scalc/01/func_hour \
helpcontent2/source/text/scalc/01/func_minute \
helpcontent2/source/text/scalc/01/func_month \
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp
index 0abddba..aab9735 100644
--- a/source/text/scalc/01/04060109.xhp
+++ b/source/text/scalc/01/04060109.xhp
@@ -178,6 +178,10 @@
oldref="44">Example</paragraph>
<paragraph xml-lang="en-US" id="par_id3146904" role="paragraph" l10n="U" oldref="45">If cell A1 displays Err:518, the function <item type="input">=ERRORTYPE(A1)</item> returns the number 518.</paragraph>
</section>
+<section id="error_type">
+<paragraph id="hd_id275141466817507" role="heading" level="2" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_error_type.xhp#error_type_head"/></paragraph>
+<paragraph id="par_id164731033513430" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_error_type.xhp#error_type_des"/></paragraph>
+</section>
<section id="Section5">
<bookmark xml-lang="en-US" branch="index" id="bm_id3151221"><bookmark_value>INDEX function</bookmark_value>
</bookmark>
diff --git a/source/text/scalc/01/func_error_type.xhp b/source/text/scalc/01/func_error_type.xhp
new file mode 100644
index 0000000..4933739
--- /dev/null
+++ b/source/text/scalc/01/func_error_type.xhp
@@ -0,0 +1,129 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+-->
+
+<meta>
+ <topic id="textscalc01func_error_typexml">
+ <title id="tit" xml-lang="en-US">ERROR.TYPE function</title>
+ <filename>text/scalc/01/func_error_type.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+<section id="error_type_function">
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ERROR_TYPE_ODF" id="bm_id346023460234602" localize="false"/>
+<bookmark xml-lang="en-US" branch="index" id="bm_id346793467934679">
+ <bookmark_value>ERROR.TYPE function</bookmark_value>
+ <bookmark_value>index of the Error type</bookmark_value>
+</bookmark>
+
+<paragraph id="hd_id348223482234822" role="heading" level="2" xml-lang="en-US"><variable id="error_type_head"><link href="text/scalc/01/func_error_type.xhp">ERROR.TYPE</link></variable> function</paragraph>
+<paragraph id="par_id350283502835028" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="error_type_des">Returns a number representing a specific Error type, or the error value #N/A, if there is no error. </variable></ahelp></paragraph>
+</section>
+
+<paragraph id="hd_id351323513235132" role="heading" level="3" xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id1861223540440" role="code" xml-lang="en-US">ERROR.TYPE(Error_value)</paragraph>
+<paragraph id="par_id217737315" role="paragraph" xml-lang="en-US"><emph>Error_value</emph> – required argument. The error value or a reference to a cell, whose value needs to be processed.</paragraph>
+
+<table id="func_error_type_des_table">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id15254419018421" role="tablehead" xml-lang="en-US">Error value</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id134093102310948" role="tablehead" xml-lang="en-US">Returns</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121020152053105891" role="tablecontent" xml-lang="en-US">Err:511</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121020152052446273" role="tablecontent" localize="false" xml-lang="en-US">1</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121020152053148760" role="tablecontent" xml-lang="en-US">#DIV/0!</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121020152052481542" role="tablecontent" localize="false" xml-lang="en-US">2</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121020152053296785" role="tablecontent" xml-lang="en-US">#VALUE!</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121020152052517316" role="tablecontent" localize="false" xml-lang="en-US">3</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121020152053329868" role="tablecontent" xml-lang="en-US">#REF!</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121020152052546364" role="tablecontent" localize="false" xml-lang="en-US">4</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121020152053353976" role="tablecontent" xml-lang="en-US">#NAME?</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121020152052574920" role="tablecontent" localize="false" xml-lang="en-US">5</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121020152053408216" role="tablecontent" xml-lang="en-US">#NUM!</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121020152052596412" role="tablecontent" localize="false" xml-lang="en-US">6</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121020152054007072" role="tablecontent" xml-lang="en-US">#N/A</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id121020152053027085" role="tablecontent" localize="false" xml-lang="en-US">7</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id121020152054075191" role="tablecontent" xml-lang="en-US">Anything else</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="" role="tablecontent" xml-lang="en-US">#N/A</paragraph>
+ </tablecell>
+ </tablerow>
+</table>
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
+
+<paragraph id="hd_id352113521135211" role="heading" level="3" xml-lang="en-US">Examples</paragraph>
+<paragraph id="hd_id182972884627444" role="heading" level="4" xml-lang="en-US">Simple usage</paragraph>
+<paragraph id="par_id15812966716957" role="paragraph" xml-lang="en-US"><item type="input">=ERROR.TYPE(#N/A)</item></paragraph>
+<paragraph id="par_id280533214928308" role="paragraph" xml-lang="en-US">Returns 7, because 7 is the index number of the error value #N/A.</paragraph>
+<paragraph id="par_id1047088636291" role="paragraph" xml-lang="en-US"><item type="input">=ERROR.TYPE(A3)</item></paragraph>
+<paragraph id="par_id24308515918391" role="paragraph" xml-lang="en-US">If A3 contains an expression equivavlent to the division by zero, the function returns 2, because 2 is the index number of the error value #DIV/0!</paragraph>
+<paragraph id="hd_id9842206115046" role="heading" level="4" xml-lang="en-US">More advanced way</paragraph>
+<paragraph id="par_id90121141327448" role="paragraph" xml-lang="en-US">If in division A1 by A2, A2 can turn to zero, you can handle the situation as follows:</paragraph>
+<paragraph id="par_id16083887218317" role="paragraph" xml-lang="en-US"><item type="input">=IF(ISERROR(A1/A2);IF(ERROR.TYPE(A1/A2)=2;"the denominator can't be equal to zero");A1/A2)</item></paragraph>
+<paragraph id="par_id12475201719494" role="paragraph" xml-lang="en-US">The ISERROR function returns TRUE or FALSE depending on whether there is an error or not. If the error takes place, the function IF addresses to the second argument, if there is no error, it returns the result of the division. The second argument checks the index number representing the specific Error type, and if it is equal to 2, it returns the specified text "the denominator can't be zero" or 0 otherwise. Thus, clear text would signify the division by zero, the result of the division would appear when the division is successful, or if there is, for example, an error of another type, zero would be returned.</paragraph>
+<paragraph id="par_id26251175451270" role="warning" xml-lang="en-US">If the ERROR.TYPE function is used as condition of the IF function and the ERROR.TYPE returns #N/A, the IF function returns #N/A as well. Use ISERROR to avoid it as shown in the example above.</paragraph>
+<section id="relatedtopics">
+<paragraph id="par_id352953529535295" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060104.xhp#iserror">ISERROR</link>, <link href="text/scalc/01/04060104.xhp#na">NA</link>, <link href="text/scalc/01/04060104.xhp#Section4">IF</link></paragraph>
+<paragraph id="par_id312932390024933" role="paragraph" localize="false" xml-lang="en-US"><link href="text/scalc/05/02140000.xhp" name="Error codes">Error codes</link></paragraph>
+</section>
+</body>
+
+</helpdocument>
\ No newline at end of file
More information about the Libreoffice-commits
mailing list