summaryrefslogtreecommitdiff
path: root/helpcontent2/source/text/scalc/01/04060104.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060104.xhp')
-rw-r--r--[-rwxr-xr-x]helpcontent2/source/text/scalc/01/04060104.xhp38
1 files changed, 19 insertions, 19 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060104.xhp b/helpcontent2/source/text/scalc/01/04060104.xhp
index b800e2ad8f..c64b66534f 100755..100644
--- a/helpcontent2/source/text/scalc/01/04060104.xhp
+++ b/helpcontent2/source/text/scalc/01/04060104.xhp
@@ -200,7 +200,7 @@
<section id="info">
<bookmark xml-lang="en-US" branch="index" id="bm_id3691824"><bookmark_value>INFO function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_INFO" id="bm_id5369426" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_INFO" id="bm_id5369426" localize="false"/>
<paragraph role="heading" id="hd_id5787224" xml-lang="en-US" level="2" l10n="NEW">INFO</paragraph>
<paragraph role="paragraph" id="par_id1507309" xml-lang="en-US" l10n="NEW">Returns specific information about the current working environment. The function receives a single text argument and returns data depending on that parameter.</paragraph>
<paragraph role="heading" id="hd_id7693411" xml-lang="en-US" level="3" l10n="NEW">Syntax</paragraph>
@@ -267,7 +267,7 @@
<section id="current">
<bookmark xml-lang="en-US" branch="index" id="bm_id3155625"><bookmark_value>CURRENT function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_AKTUELL" id="bm_id3145295" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AKTUELL" id="bm_id3145295" localize="false"/>
<paragraph role="heading" id="hd_id3155625" xml-lang="en-US" level="2" l10n="U" oldref="30">CURRENT</paragraph>
<paragraph role="paragraph" id="par_id3157975" xml-lang="en-US" l10n="CHG" oldref="31"><ahelp hid="HID_FUNC_AKTUELL">This function returns the result to date of evaluating the formula of which it is a part (in other words the result as far as that evaluation has got). Its main use is together with the STYLE() function to apply selected styles to a cell depending on the cell contents.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3148880" xml-lang="en-US" level="3" l10n="U" oldref="32">Syntax</paragraph>
@@ -291,7 +291,7 @@
<bookmark_value>formula cells;displaying formulas in other cells</bookmark_value>
<bookmark_value>displaying;formulas at any position</bookmark_value>
</bookmark><comment>mw added "formula cells;" and "displaying;"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_FORMEL" id="bm_id3155373" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FORMEL" id="bm_id3155373" localize="false"/>
<paragraph role="heading" id="hd_id3150688" xml-lang="en-US" level="2" l10n="U" oldref="147">FORMULA</paragraph>
<paragraph role="paragraph" id="par_id3158417" xml-lang="en-US" l10n="CHG" oldref="148"><ahelp hid="HID_FUNC_FORMEL">Displays the formula of a formula cell as a text string.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3154954" xml-lang="en-US" level="3" l10n="U" oldref="149">Syntax</paragraph>
@@ -309,7 +309,7 @@
<bookmark_value>references;testing cell contents</bookmark_value>
<bookmark_value>cell contents;testing for references</bookmark_value>
</bookmark><comment>mw added "references;" and "cell contents;"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTBEZUG" id="bm_id3149774" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTBEZUG" id="bm_id3149774" localize="false"/>
<paragraph role="heading" id="hd_id3155409" xml-lang="en-US" level="2" l10n="U" oldref="37">ISREF</paragraph>
<paragraph role="paragraph" id="par_id3153723" xml-lang="en-US" l10n="CHG" oldref="38"><ahelp hid="HID_FUNC_ISTBEZUG">Tests if the argument is a reference.</ahelp> Returns TRUE if the argument is a reference, returns FALSE otherwise. When given a reference this function does not examine the value being referenced.<comment>i82565</comment></paragraph>
<embed href="text/shared/00/00000001.xhp#wahr"/>
@@ -333,7 +333,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3154812"><bookmark_value>ISERR function</bookmark_value>
<bookmark_value>error codes;controlling</bookmark_value>
</bookmark><comment>mw added "error codes,"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTFEHL" id="bm_id3145081" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTFEHL" id="bm_id3145081" localize="false"/>
<paragraph role="heading" id="hd_id3154812" xml-lang="en-US" level="2" l10n="U" oldref="45">ISERR</paragraph>
<paragraph role="paragraph" id="par_id3149282" xml-lang="en-US" l10n="CHG" oldref="46"><ahelp hid="HID_FUNC_ISTFEHL">Tests for error conditions, except the #N/A error value, and returns TRUE or FALSE.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#wahr"/>
@@ -351,7 +351,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3147081"><bookmark_value>ISERROR function</bookmark_value>
<bookmark_value>recognizing;general errors</bookmark_value>
</bookmark><comment>mw added "recognizing;"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTFEHLER" id="bm_id3145206" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTFEHLER" id="bm_id3145206" localize="false"/>
<paragraph role="heading" id="hd_id3147081" xml-lang="en-US" level="2" l10n="U" oldref="53">ISERROR</paragraph>
<paragraph role="paragraph" id="par_id3156316" xml-lang="en-US" l10n="CHG" oldref="54"><ahelp hid="HID_FUNC_ISTFEHLER">Tests for error conditions, including the #N/A error value, and returns TRUE or FALSE.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#wahr"/>
@@ -370,7 +370,7 @@
<bookmark_value>recognizing formula cells</bookmark_value>
<bookmark_value>formula cells;recognizing</bookmark_value>
</bookmark><comment>mw inserted "recognizing..." and "formula cells;"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTFORMEL" id="bm_id3154740" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTFORMEL" id="bm_id3154740" localize="false"/>
<paragraph role="heading" id="hd_id3153618" xml-lang="en-US" level="2" l10n="U" oldref="61">ISFORMULA</paragraph>
<paragraph role="paragraph" id="par_id3149138" xml-lang="en-US" l10n="U" oldref="62"><ahelp hid="HID_FUNC_ISTFORMEL">Returns TRUE if a cell is a formula cell.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#wahr"/>
@@ -385,7 +385,7 @@
<section id="iseven_add">
<bookmark xml-lang="en-US" branch="index" id="bm_id3149760"><bookmark_value>ISEVEN_ADD function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_ISEVEN" id="bm_id3146094" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ISEVEN" id="bm_id3146094" localize="false"/>
<paragraph role="heading" id="hd_id3149760" xml-lang="en-US" level="2" oldref="229">ISEVEN_ADD</paragraph>
<paragraph role="paragraph" id="par_id3147253" xml-lang="en-US" l10n="CHG" oldref="230"><ahelp hid="HID_AAI_FUNC_ISEVEN">Tests for even numbers. Returns 1 if the number divided by 2 returns a whole number.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
@@ -403,7 +403,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3154692"><bookmark_value>ISNONTEXT function</bookmark_value>
<bookmark_value>cell contents;no text</bookmark_value>
</bookmark><comment>mw added "cell contents;"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTKTEXT" id="bm_id3159342" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTKTEXT" id="bm_id3159342" localize="false"/>
<paragraph role="heading" id="hd_id3154692" xml-lang="en-US" level="2" l10n="U" oldref="68">ISNONTEXT</paragraph>
<paragraph role="paragraph" id="par_id3155330" xml-lang="en-US" l10n="U" oldref="69"><ahelp hid="HID_FUNC_ISTKTEXT">Tests if the cell contents are text or numbers, and returns FALSE if the contents are text.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id5719779" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns TRUE.</paragraph>
@@ -422,7 +422,7 @@
<bookmark_value>blank cell contents</bookmark_value>
<bookmark_value>empty cells; recognizing</bookmark_value>
</bookmark><comment>mw added "blank..." and "empty cells;"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTLEER" id="bm_id3148940" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTLEER" id="bm_id3148940" localize="false"/>
<paragraph role="heading" id="hd_id3159148" xml-lang="en-US" level="2" l10n="U" oldref="77">ISBLANK</paragraph>
<paragraph role="paragraph" id="par_id3148800" xml-lang="en-US" l10n="U" oldref="78"><ahelp hid="HID_FUNC_ISTLEER">Returns TRUE if the reference to a cell is blank.</ahelp> This function is used to determine if the content of a cell is empty. A cell with a formula inside is not empty. </paragraph>
<embed href="text/shared/00/00000001.xhp#wahr"/>
@@ -439,7 +439,7 @@
<bookmark_value>number formats;logical</bookmark_value>
<bookmark_value>logical number formats</bookmark_value>
</bookmark><comment>mw added "number formats;" and "logical..."</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTLOG" id="bm_id3158424" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTLOG" id="bm_id3158424" localize="false"/>
<paragraph role="heading" id="hd_id3155356" xml-lang="en-US" level="2" l10n="U" oldref="85">ISLOGICAL</paragraph>
<paragraph role="paragraph" id="par_id3148926" xml-lang="en-US" l10n="CHG" oldref="86"><ahelp hid="HID_FUNC_ISTLOG">Tests for a logical value (TRUE or FALSE).</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3541062" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns FALSE.</paragraph>
@@ -456,7 +456,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3153685"><bookmark_value>ISNA function</bookmark_value>
<bookmark_value>#N/A error;recognizing</bookmark_value>
</bookmark><comment>mw added "#N/A ..."</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTNV" id="bm_id3159273" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTNV" id="bm_id3159273" localize="false"/>
<paragraph role="heading" id="hd_id3153685" xml-lang="en-US" level="2" l10n="U" oldref="93">ISNA</paragraph>
<paragraph role="paragraph" id="par_id3149105" xml-lang="en-US" l10n="U" oldref="94"><ahelp hid="HID_FUNC_ISTNV">Returns TRUE if a cell contains the #N/A (value not available) error value.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id6018860" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns FALSE.</paragraph>
@@ -472,7 +472,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3149426"><bookmark_value>ISTEXT function</bookmark_value>
<bookmark_value>cell contents;text</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTTEXT" id="bm_id3148468" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTTEXT" id="bm_id3148468" localize="false"/>
<paragraph role="heading" id="hd_id3149426" xml-lang="en-US" level="2" l10n="U" oldref="101">ISTEXT</paragraph>
<paragraph role="paragraph" id="par_id3145368" xml-lang="en-US" l10n="U" oldref="102"><ahelp hid="HID_FUNC_ISTTEXT">Returns TRUE if the cell contents refer to text.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id6779686" xml-lang="en-US" l10n="NEW">If an error occurs, the function returns FALSE.</paragraph>
@@ -489,7 +489,7 @@
<section id="isodd_add">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153939"><bookmark_value>ISODD_ADD function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_ISODD" id="bm_id3149927" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_ISODD" id="bm_id3149927" localize="false"/>
<paragraph role="heading" id="hd_id3153939" xml-lang="en-US" level="2" oldref="236">ISODD_ADD</paragraph>
<paragraph role="paragraph" id="par_id3153538" xml-lang="en-US" l10n="U" oldref="237"><ahelp hid="HID_AAI_FUNC_ISODD">Returns TRUE (1) if the number does not return a whole number when divided by 2.</ahelp></paragraph>
<embed href="text/scalc/01/04060102.xhp#ADD_note"/>
@@ -505,7 +505,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3148688"><bookmark_value>ISNUMBER function</bookmark_value>
<bookmark_value>cell contents;numbers</bookmark_value>
</bookmark><comment>mw added "cell contents;"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ISTZAHL" id="bm_id3149587" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ISTZAHL" id="bm_id3149587" localize="false"/>
<paragraph role="heading" id="hd_id3148688" xml-lang="en-US" level="2" l10n="U" oldref="110">ISNUMBER</paragraph>
<paragraph role="paragraph" id="par_id3154618" xml-lang="en-US" l10n="U" oldref="111"><ahelp hid="HID_FUNC_ISTZAHL">Returns TRUE if the value refers to a number.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#wahr"/>
@@ -522,7 +522,7 @@
<section id="n">
<bookmark xml-lang="en-US" branch="index" id="bm_id3153694"><bookmark_value>N function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_N" id="bm_id3153786" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_N" id="bm_id3153786" localize="false"/>
<paragraph role="heading" id="hd_id3153694" xml-lang="en-US" level="2" l10n="U" oldref="119">N</paragraph>
<paragraph role="paragraph" id="par_id3150405" xml-lang="en-US" l10n="CHG" oldref="120"><ahelp hid="HID_FUNC_N">Returns the numeric value of the given parameter. Returns 0 if parameter is text, FALSE or #NA.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id9115573" xml-lang="en-US" l10n="NEW">If an error occurs, other than #NA, the function returns the error value.</paragraph>
@@ -545,7 +545,7 @@
<bookmark xml-lang="en-US" branch="index" id="bm_id3156275"><bookmark_value>NA function</bookmark_value>
<bookmark_value>#N/A error;assigning to a cell</bookmark_value>
</bookmark><comment>mw added "#N/A error;"</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_NV" id="bm_id3154569" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NV" id="bm_id3154569" localize="false"/>
<paragraph role="heading" id="hd_id3156275" xml-lang="en-US" level="2" l10n="U" oldref="129">NA</paragraph>
<paragraph role="paragraph" id="par_id3156161" xml-lang="en-US" l10n="U" oldref="130"><ahelp hid="HID_FUNC_NV">Returns the error value #N/A.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3147532" xml-lang="en-US" level="3" l10n="U" oldref="131">Syntax</paragraph>
@@ -557,7 +557,7 @@
<section id="type">
<bookmark xml-lang="en-US" branch="index" id="bm_id3151255"><bookmark_value>TYPE function</bookmark_value>
</bookmark>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_TYP" id="bm_id3146127" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TYP" id="bm_id3146127" localize="false"/>
<paragraph role="heading" id="hd_id3151255" xml-lang="en-US" level="2" l10n="U" oldref="136">TYPE</paragraph>
<paragraph role="paragraph" id="par_id3155900" xml-lang="en-US" l10n="U" oldref="137"><ahelp hid="HID_FUNC_TYP">Returns the type of value.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#wahr"/>
@@ -576,7 +576,7 @@
<bookmark_value>cell information</bookmark_value>
<bookmark_value>information on cells</bookmark_value>
</bookmark><comment>mw added two entries</comment>
-<bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZELLE" id="bm_id3159412" localize="false"/>
+<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZELLE" id="bm_id3159412" localize="false"/>
<paragraph role="heading" id="hd_id3155509" xml-lang="en-US" level="2" l10n="U" oldref="154">CELL</paragraph>
<paragraph role="paragraph" id="par_id3153196" xml-lang="en-US" l10n="U" oldref="155"><ahelp hid="HID_FUNC_ZELLE">Returns information on address, formatting or contents of a cell.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3149323" xml-lang="en-US" level="3" l10n="U" oldref="156">Syntax</paragraph>