04060109.xhp (ab463e1e) 04060109.xhp (a3415cde)
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
4<!--***********************************************************
1<?xml version="1.0" encoding="UTF-8"?>
2<helpdocument version="1.0">
3
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
26
27
28<meta>
29 <topic id="textscalc0104060109xml" indexer="include">
30 <title xml-lang="en-US" id="tit">Spreadsheet Functions</title>

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

50<paragraph xml-lang="en-US" id="hd_id3146968" role="heading" level="2" l10n="U" oldref="3">ADDRESS</paragraph>
51 <paragraph xml-lang="en-US" id="par_id3155762" role="paragraph" l10n="CHG" oldref="4"><ahelp hid="HID_FUNC_ADRESSE">Returns a cell address (reference) as text, according to the specified row and column numbers.</ahelp> You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). You can also specify the name of the sheet.</paragraph>
52 <section id="r1c1">
53 <paragraph xml-lang="en-US" id="par_id1027200802301348" role="paragraph" l10n="NEW">For interoperability the ADDRESS and INDIRECT functions support an optional parameter to specify whether the R1C1 address notation instead of the usual A1 notation should be used.</paragraph>
54 <paragraph xml-lang="en-US" id="par_id1027200802301445" role="paragraph" l10n="NEW">In ADDRESS, the parameter is inserted as the fourth parameter, shifting the optional sheet name parameter to the fifth position.</paragraph>
55 <paragraph xml-lang="en-US" id="par_id102720080230153" role="paragraph" l10n="NEW">In INDIRECT, the parameter is appended as the second parameter.</paragraph>
56 <paragraph xml-lang="en-US" id="par_id102720080230151" role="paragraph" l10n="NEW">In both functions, if the argument is inserted with the value 0, then the R1C1 notation is used. If the argument is not given or has a value other than 0, then the A1 notation is used. </paragraph>
57 <paragraph xml-lang="en-US" id="par_id1027200802301556" role="paragraph" l10n="NEW">In case of R1C1 notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation.</paragraph>
23 ***********************************************************-->
24
25
26
27
28<meta>
29 <topic id="textscalc0104060109xml" indexer="include">
30 <title xml-lang="en-US" id="tit">Spreadsheet Functions</title>

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

50<paragraph xml-lang="en-US" id="hd_id3146968" role="heading" level="2" l10n="U" oldref="3">ADDRESS</paragraph>
51 <paragraph xml-lang="en-US" id="par_id3155762" role="paragraph" l10n="CHG" oldref="4"><ahelp hid="HID_FUNC_ADRESSE">Returns a cell address (reference) as text, according to the specified row and column numbers.</ahelp> You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). You can also specify the name of the sheet.</paragraph>
52 <section id="r1c1">
53 <paragraph xml-lang="en-US" id="par_id1027200802301348" role="paragraph" l10n="NEW">For interoperability the ADDRESS and INDIRECT functions support an optional parameter to specify whether the R1C1 address notation instead of the usual A1 notation should be used.</paragraph>
54 <paragraph xml-lang="en-US" id="par_id1027200802301445" role="paragraph" l10n="NEW">In ADDRESS, the parameter is inserted as the fourth parameter, shifting the optional sheet name parameter to the fifth position.</paragraph>
55 <paragraph xml-lang="en-US" id="par_id102720080230153" role="paragraph" l10n="NEW">In INDIRECT, the parameter is appended as the second parameter.</paragraph>
56 <paragraph xml-lang="en-US" id="par_id102720080230151" role="paragraph" l10n="NEW">In both functions, if the argument is inserted with the value 0, then the R1C1 notation is used. If the argument is not given or has a value other than 0, then the A1 notation is used. </paragraph>
57 <paragraph xml-lang="en-US" id="par_id1027200802301556" role="paragraph" l10n="NEW">In case of R1C1 notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation.</paragraph>
58 <paragraph xml-lang="en-US" id="par_id1027200802301521" role="paragraph" l10n="NEW">When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth paramater will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted.</paragraph>
58 <paragraph xml-lang="en-US" id="par_id1027200802301521" role="paragraph" l10n="NEW">When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth parameter will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted.</paragraph>
59 <paragraph xml-lang="en-US" id="par_id1027200802301650" role="paragraph" l10n="NEW">When storing a document in ODF 1.0/1.1 format, if ADDRESS functions have a fourth parameter, that parameter will be removed.</paragraph>
60 <paragraph xml-lang="en-US" id="par_id102720080230162" role="note" l10n="NEW">Do not save a spreadsheet in the old ODF 1.0/1.1 format if the ADDRESS function's new fourth parameter was used with a value of 0.</paragraph>
61 <paragraph xml-lang="en-US" id="par_id1027200802301756" role="note" l10n="NEW">The INDIRECT function is saved without conversion to ODF 1.0/1.1 format. If the second parameter was present, an older version of Calc will return an error for that function.</paragraph>
62 </section>
63 <paragraph xml-lang="en-US" id="hd_id3151196" role="heading" level="3" l10n="U" oldref="5">Syntax</paragraph>
64 <paragraph xml-lang="en-US" id="par_id3154707" role="code" l10n="U" oldref="6">ADDRESS(Row; Column; Abs; A1; "Sheet")</paragraph>
65 <paragraph xml-lang="en-US" id="par_id3147505" role="paragraph" l10n="U" oldref="7">
66 <emph>Row</emph> represents the row number for the cell reference</paragraph>

--- 555 unchanged lines hidden --- 		59 <paragraph xml-lang="en-US" id="par_id1027200802301650" role="paragraph" l10n="NEW">When storing a document in ODF 1.0/1.1 format, if ADDRESS functions have a fourth parameter, that parameter will be removed.</paragraph>
60 <paragraph xml-lang="en-US" id="par_id102720080230162" role="note" l10n="NEW">Do not save a spreadsheet in the old ODF 1.0/1.1 format if the ADDRESS function's new fourth parameter was used with a value of 0.</paragraph>
61 <paragraph xml-lang="en-US" id="par_id1027200802301756" role="note" l10n="NEW">The INDIRECT function is saved without conversion to ODF 1.0/1.1 format. If the second parameter was present, an older version of Calc will return an error for that function.</paragraph>
62 </section>
63 <paragraph xml-lang="en-US" id="hd_id3151196" role="heading" level="3" l10n="U" oldref="5">Syntax</paragraph>
64 <paragraph xml-lang="en-US" id="par_id3154707" role="code" l10n="U" oldref="6">ADDRESS(Row; Column; Abs; A1; "Sheet")</paragraph>
65 <paragraph xml-lang="en-US" id="par_id3147505" role="paragraph" l10n="U" oldref="7">
66 <emph>Row</emph> represents the row number for the cell reference</paragraph>

--- 555 unchanged lines hidden ---