diff options
Diffstat (limited to 'source/text/scalc/01/04060109.xhp')
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index ef8d5bd5eb..95e3d87911 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -50,7 +50,7 @@ <paragraph xml-lang="en-US" id="par_id102720080230153" role="paragraph">In INDIRECT, the parameter is appended as the second parameter.</paragraph> <paragraph xml-lang="en-US" id="par_id102720080230151" role="paragraph">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> <paragraph xml-lang="en-US" id="par_id1027200802301556" role="paragraph">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> - <paragraph xml-lang="en-US" id="par_id1027200802301521" role="paragraph">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> + <paragraph xml-lang="en-US" id="par_id1027200802301521" role="paragraph">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> <paragraph xml-lang="en-US" id="par_id1027200802301650" role="paragraph">When storing a document in ODF 1.0/1.1 format, if ADDRESS functions have a fourth parameter, that parameter will be removed.</paragraph> <paragraph xml-lang="en-US" id="par_id102720080230162" role="note">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> <paragraph xml-lang="en-US" id="par_id1027200802301756" role="note">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> |