source/text/scalc/01/04060109.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit f6f00dd19eb27c293d147262a18329df60aa6bab
Author: Mike Kaganski <mike.kagan...@collabora.com>
AuthorDate: Tue Jul 24 03:26:09 2018 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Aug 16 23:56:33 2018 +0200
Fix excel syntax description
Change-Id: Iaaf38a33373eb910785a4a5d1fc45649523726e9
Reviewed-on: https://gerrit.libreoffice.org/57897
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060109.xhp
b/source/text/scalc/01/04060109.xhp
index e5a72c21d..cffee7eb8 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
