diff options
| author | Mike Kaganski <mike.kaganski@collabora.com> | 2018-07-24 03:26:09 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-08-16 23:56:33 +0200 |
| commit | f6f00dd19eb27c293d147262a18329df60aa6bab (patch) | |
| tree | 2462d51847e04b1f8bdef8aedf9d0ace90fcd61d /source/text/scalc | |
| parent | f0e9b27d338a12bb5c7631f3c935ba9969bd7db3 (diff) | |
Fix excel syntax description
Change-Id: Iaaf38a33373eb910785a4a5d1fc45649523726e9
Reviewed-on: https://gerrit.libreoffice.org/57897
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc')
| -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 e5a72c21d4..cffee7eb82 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -216,7 +216,7 @@ <emph>Ref</emph> represents a reference to a cell or an area (in text form) for which to return the contents.</paragraph> <paragraph xml-lang="en-US" id="par_id1027200802470312" role="paragraph"> <emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used.</paragraph> - <paragraph xml-lang="en-US" id="par_idN10CAE" role="note">If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT("filename!sheetname"&B1) is not converted into the Calc address in INDIRECT("filename.sheetname"&B1).<comment>UFI: for #i34465#</comment></paragraph> + <paragraph xml-lang="en-US" id="par_idN10CAE" role="note">If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT("[filename]sheetname!"&B1) is not converted into the Calc address in INDIRECT("filename#sheetname."&B1).<comment>UFI: for #i34465#</comment></paragraph> <paragraph xml-lang="en-US" id="hd_id3150389" role="heading" level="3">Example</paragraph> <paragraph xml-lang="en-US" id="par_id3150608" role="paragraph"> <item type="input">=INDIRECT(A1)</item> equals 100 if A1 contains C108 as a reference and cell C108 contains a value of <item type="input">100</item>.</paragraph> |