summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKatarina Behrens <Katarina.Behrens@cib.de>2019-05-09 20:53:36 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2019-05-13 16:45:11 +0200
commit8ba1c1976c652b804a02267a8035606b10db2682 (patch)
treeeb4c2ea6aa394a73c62c79c3251699ff93804e9d
parent2f8fbb8c0aa867e8986a496820cf79d75a5d5ea1 (diff)
More detailed help of Calc's Sheet > Link to external data
Make it more clear there has to be at least 1 named range in Excel of Calc documents Change-Id: I782c4d2c10ee52320bfdf147652883f5e7b4751a Reviewed-on: https://gerrit.libreoffice.org/72076 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/01/04090000.xhp6
1 files changed, 3 insertions, 3 deletions
diff --git a/source/text/scalc/01/04090000.xhp b/source/text/scalc/01/04090000.xhp
index ef44299c14..618a926040 100644
--- a/source/text/scalc/01/04090000.xhp
+++ b/source/text/scalc/01/04090000.xhp
@@ -30,7 +30,7 @@
<section id="extdata">
<paragraph xml-lang="en-US" id="par_id3153361" role="paragraph" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/browse" id="bm_id3151041" localize="false"/>
-<paragraph xml-lang="en-US" id="par_id3153192" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/browse" visibility="hidden">Locate the file containing the data you want to insert.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="par_id3153192" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/browse" visibility="hidden">Open a file dialog to locate the file containing the data you want to insert.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/.uno:InsertExternalDataSource" id="bm_id3748965" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/ExternalDataDialog" id="bm_id3150441" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/@@nowidget@@" id="bm_id3150441" localize="false"/>
@@ -42,11 +42,11 @@
</section>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/url" id="bm_id3148577" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3146984" role="heading" level="2">URL of external data source.</paragraph>
-<paragraph xml-lang="en-US" id="par_id3145366" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/url">Enter the URL or the file name that contains the data that you want to insert, and then press Enter.</ahelp> Only then the URL will be requested from the network or file system.</paragraph>
+<paragraph xml-lang="en-US" id="par_id3145366" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/url">Enter the URL or the file name that contains the data that you want to insert, and then press Enter.</ahelp> Alternatively, click <emph>Browse</emph> button to select the file name from a file dialog that opens. Only then will the URL be requested from the network or file system.</paragraph>
<paragraph xml-lang="en-US" id="par_id621519313666202" role="note"><link href="text/shared/00/00000208.xhp" name="linkname">A dialog for CSV data import</link> appears when linking to external CSV file.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/ranges" id="bm_id3153876" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3145251" role="heading" level="2">Available tables/ranges</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147397" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/ranges">Select the table or the data range that you want to insert.</ahelp></paragraph>
+ <paragraph xml-lang="en-US" id="par_id3147397" role="paragraph"><ahelp hid="modules/scalc/ui/externaldata/ranges">Select the table or the data range that you want to insert.</ahelp> If the selected Calc or Excel document contains no named range, spreadsheet data cannot be inserted and <emph>OK</emph> button will remain inactive </paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/reload" id="bm_id3153418" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/externaldata/delay" id="bm_id3150718" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154492" role="heading" level="2">Update every</paragraph>