04060104.xhp (a5e397f5) 04060104.xhp (a3a36028)
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
3
4<!--***********************************************************
4<!--***********************************************************
5 *
5 *
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information
9 * regarding copyright ownership. The ASF licenses this file
10 * to you under the Apache License, Version 2.0 (the
11 * "License"); you may not use this file except in compliance
12 * with the License. You may obtain a copy of the License at
6 * Licensed to the Apache Software Foundation (ASF) under one
7 * or more contributor license agreements. See the NOTICE file
8 * distributed with this work for additional information
9 * regarding copyright ownership. The ASF licenses this file
10 * to you under the Apache License, Version 2.0 (the
11 * "License"); you may not use this file except in compliance
12 * with the License. You may obtain a copy of the License at
13 *
13 *
14 * http://www.apache.org/licenses/LICENSE-2.0
14 * http://www.apache.org/licenses/LICENSE-2.0
15 *
15 *
16 * Unless required by applicable law or agreed to in writing,
17 * software distributed under the License is distributed on an
18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19 * KIND, either express or implied. See the License for the
20 * specific language governing permissions and limitations
21 * under the License.
16 * Unless required by applicable law or agreed to in writing,
17 * software distributed under the License is distributed on an
18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
19 * KIND, either express or implied. See the License for the
20 * specific language governing permissions and limitations
21 * under the License.
22 *
22 *
23 ***********************************************************-->
24
25
23 ***********************************************************-->
24
25
26
27
26
28<meta>
29<topic id="textscalc0104060104xml" indexer="include">
30<title id="tit" xml-lang="en-US">Information Functions</title>
31<filename>/text/scalc/01/04060104.xhp</filename>
32</topic>
33</meta>
34<body>
35<bookmark xml-lang="en-US" branch="index" id="bm_id3147247"><bookmark_value>information functions</bookmark_value>
36<bookmark_value>Function Wizard; information</bookmark_value>
37<bookmark_value>functions; information functions</bookmark_value>
38</bookmark>
39<paragraph role="heading" id="hd_id3147247" xml-lang="en-US" level="1" l10n="U" oldref="1">Information Functions</paragraph>
27<meta>
28<topic id="textscalc0104060104xml" indexer="include">
29<title id="tit" xml-lang="en-US">Information Functions</title>
30<filename>/text/scalc/01/04060104.xhp</filename>
31</topic>
32</meta>
33<body>
34<bookmark xml-lang="en-US" branch="index" id="bm_id3147247"><bookmark_value>information functions</bookmark_value>
35<bookmark_value>Function Wizard; information</bookmark_value>
36<bookmark_value>functions; information functions</bookmark_value>
37</bookmark>
38<paragraph role="heading" id="hd_id3147247" xml-lang="en-US" level="1" l10n="U" oldref="1">Information Functions</paragraph>
40<paragraph role="paragraph" id="par_id3147499" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="informationtext">This category contains the <emph>Information</emph> functions.
39<paragraph role="paragraph" id="par_id3147499" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="informationtext">This category contains the <emph>Information</emph> functions.
41</variable></paragraph>
42<section id="howtoget">
43<embed href="text/scalc/00/00000404.xhp#eikain"/>
44</section>
45<paragraph role="paragraph" id="par_id3159128" xml-lang="en-US" l10n="U" oldref="3">The data in the following table serves as the basis for some of the examples in the function descriptions:</paragraph>
46<table id="tbl_id3157876">
47<tablerow>
48<tablecell>

--- 202 unchanged lines hidden (view full) ---

251</tablerow>
252</table>
253
254<paragraph role="note" id="par_id1161534" xml-lang="en-US" l10n="NEW">Other spreadsheet applications may accept localized values for the <item type="literal">Type</item> parameter, but %PRODUCTNAME Calc will only accept the English values.</paragraph>
255<paragraph role="heading" id="hd_id5459456" xml-lang="en-US" level="3" l10n="NEW">Example</paragraph>
256<paragraph role="paragraph" id="par_id3994567" xml-lang="en-US" l10n="NEW">
257<item type="input">=INFO("release")</item> returns the product release number of the %PRODUCTNAME in use.<comment>Do not translate "release"</comment></paragraph>
258<paragraph role="paragraph" id="par_id2873622" xml-lang="en-US" l10n="NEW">
40</variable></paragraph>
41<section id="howtoget">
42<embed href="text/scalc/00/00000404.xhp#eikain"/>
43</section>
44<paragraph role="paragraph" id="par_id3159128" xml-lang="en-US" l10n="U" oldref="3">The data in the following table serves as the basis for some of the examples in the function descriptions:</paragraph>
45<table id="tbl_id3157876">
46<tablerow>
47<tablecell>

--- 202 unchanged lines hidden (view full) ---

250</tablerow>
251</table>
252
253<paragraph role="note" id="par_id1161534" xml-lang="en-US" l10n="NEW">Other spreadsheet applications may accept localized values for the <item type="literal">Type</item> parameter, but %PRODUCTNAME Calc will only accept the English values.</paragraph>
254<paragraph role="heading" id="hd_id5459456" xml-lang="en-US" level="3" l10n="NEW">Example</paragraph>
255<paragraph role="paragraph" id="par_id3994567" xml-lang="en-US" l10n="NEW">
256<item type="input">=INFO("release")</item> returns the product release number of the %PRODUCTNAME in use.<comment>Do not translate "release"</comment></paragraph>
257<paragraph role="paragraph" id="par_id2873622" xml-lang="en-US" l10n="NEW">
259<item type="input">=INFO(D5)</item> with cell <item type="literal">D5</item> containing a text string <item type="literal">system</item> returns the operation system type.<comment>Do not translate the hlp_literal system</comment></paragraph>
258<item type="input">=INFO(D5)</item> with cell <item type="literal">D5</item> containing a text string <item type="literal">system</item> returns the operating system type.<comment>Do not translate the hlp_literal system</comment></paragraph>
260</section>
261<section id="current">
262<bookmark xml-lang="en-US" branch="index" id="bm_id3155625"><bookmark_value>CURRENT function</bookmark_value>
263</bookmark>
264<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AKTUELL" id="bm_id3145295" localize="false"/>
265<paragraph role="heading" id="hd_id3155625" xml-lang="en-US" level="2" l10n="U" oldref="30">CURRENT</paragraph>
266<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>
267<paragraph role="heading" id="hd_id3148880" xml-lang="en-US" level="3" l10n="U" oldref="32">Syntax</paragraph>

--- 491 unchanged lines hidden --- 		259</section>
260<section id="current">
261<bookmark xml-lang="en-US" branch="index" id="bm_id3155625"><bookmark_value>CURRENT function</bookmark_value>
262</bookmark>
263<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_AKTUELL" id="bm_id3145295" localize="false"/>
264<paragraph role="heading" id="hd_id3155625" xml-lang="en-US" level="2" l10n="U" oldref="30">CURRENT</paragraph>
265<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>
266<paragraph role="heading" id="hd_id3148880" xml-lang="en-US" level="3" l10n="U" oldref="32">Syntax</paragraph>

--- 491 unchanged lines hidden ---