[Libreoffice-commits] help.git: source/text

[Libreoffice Gerrit user]

 source/text/scalc/01/04060109.xhp |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit f6f00dd19eb27c293d147262a18329df60aa6bab
Author:     Mike Kaganski <mike.kaganski at collabora.com>
AuthorDate: Tue Jul 24 03:26:09 2018 +0200
Commit:     Olivier Hallot <olivier.hallot at 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.hallot at 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>