source/text/scalc/01/12040000.xhp | 43 +++++++++------------
source/text/scalc/01/live_data_stream.xhp | 40 +++++++------------
source/text/scalc/main0112.xhp | 61 +++++++++++++++---------------
3 files changed, 66 insertions(+), 78 deletions(-)
New commits:
commit 60ed9a0af0790ab7c7ed13149d6f1da200b2470a
Author: Rafael Lima <rafael.palma.l...@gmail.com>
AuthorDate: Sat Oct 2 00:02:21 2021 +0200
Commit: Ilmari Lauhakangas <ilmari.lauhakan...@libreoffice.org>
CommitDate: Mon Oct 4 16:11:14 2021 +0200
tdf#105601 Update Calc's Data menu documentation
This patch updates the names of items in the Data menu. It also removes
the link for Data Provider, which was previously removed in
24939a5b43b9fe889c3aace027c668666ff61987
The "Streams" page was also updated to inform that the feature is still
experimental.
Change-Id: Iccd6059e1c4f2203a3c64cc2b32c90eb281194dc
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122934
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/12040000.xhp
b/source/text/scalc/01/12040000.xhp
index 01cecc8c0..0d4ceb0d4 100644
--- a/source/text/scalc/01/12040000.xhp
+++ b/source/text/scalc/01/12040000.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,30 +17,28 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
<meta>
-<topic id="textscalc0112040000xml" indexer="include">
-<title id="tit" xml-lang="en-US">Filter</title>
-<filename>/text/scalc/01/12040000.xhp</filename>
-</topic>
+ <topic id="textscalc0112040000xml" indexer="include">
+ <title id="tit" xml-lang="en-US">More Filters</title>
+ <filename>/text/scalc/01/12040000.xhp</filename>
+ </topic>
</meta>
<body>
-<section id="filter">
-<bookmark xml-lang="en-US" branch="hid/.uno:FilterMenu"
id="bm_id102920080228246" localize="false"/>
-<h1 id="hd_id3150767"><link href="text/scalc/01/12040000.xhp"
name="Filter">Filters</link></h1>
-<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"><ahelp
hid=".">Shows commands to filter your data.</ahelp></paragraph>
-</section>
-<paragraph role="paragraph" id="par_id3146119" xml-lang="en-US">$[officename]
automatically recognizes predefined database ranges.</paragraph>
-<section id="howtoget">
-<embed href="text/scalc/00/00000412.xhp#dnftr"/>
-</section>
-<paragraph role="paragraph" id="par_id3153363" xml-lang="en-US">The following
filtering options are available:</paragraph>
-<h2 id="hd_id3153728"><link href="text/shared/02/12090000.xhp" name="Standard
filter">Standard filter</link></h2>
-<embed href="text/shared/02/12090000.xhp#standardfilter"/>
-<h2 id="hd_id3159153"><link href="text/scalc/01/12040300.xhp" name="Advanced
filter">Advanced filter</link></h2>
-<embed href="text/scalc/01/12040300.xhp#spezialfilter"/>
-<embed href="text/scalc/01/12040400.xhp#reset_filter"/>
-<embed href="text/scalc/01/12040500.xhp#autofilterausblenden"/>
+ <section id="filter">
+ <bookmark xml-lang="en-US" branch="hid/.uno:FilterMenu"
id="bm_id102920080228246" localize="false"/>
+ <h1 id="hd_id3150767"><link href="text/scalc/01/12040000.xhp"
name="Filter">More Filters</link></h1>
+ <paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"><ahelp
hid=".">Shows commands to filter your data.</ahelp></paragraph>
+ </section>
+ <section id="howtoget">
+ <embed href="text/scalc/00/00000412.xhp#dnftr"/>
+ </section>
+ <tip id="par_id911633127394220">%PRODUCTNAME automatically recognizes
predefined database ranges.</tip>
+ <paragraph role="paragraph" id="par_id3153363" xml-lang="en-US">The
following filtering options are available:</paragraph>
+ <h2 id="hd_id3153728"><link href="text/shared/02/12090000.xhp"
name="Standard filter">Standard filter</link></h2>
+ <embed href="text/shared/02/12090000.xhp#standardfilter"/>
+ <h2 id="hd_id3159153"><link href="text/scalc/01/12040300.xhp" name="Advanced
filter">Advanced filter</link></h2>
+ <embed href="text/scalc/01/12040300.xhp#spezialfilter"/>
+ <embed href="text/scalc/01/12040400.xhp#reset_filter"/>
+ <embed href="text/scalc/01/12040500.xhp#autofilterausblenden"/>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/live_data_stream.xhp
b/source/text/scalc/01/live_data_stream.xhp
index 545a166b5..fa9fe9e2d 100644
--- a/source/text/scalc/01/live_data_stream.xhp
+++ b/source/text/scalc/01/live_data_stream.xhp
@@ -17,37 +17,27 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
<meta>
<topic id="textscalc01live_data_streamxml">
<title id="tit" xml-lang="en-US">Live Data Stream</title>
<filename>/text/scalc/01/live_data_stream.xhp</filename>
</topic>
</meta>
-
<body>
-
-
-
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/datastreams/DataStreamDialog"
id="bm_id240920171033409926" localize="false"/>
-<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/datastreams/@@nowidget@@"
id="bm_id240920171033409926" localize="false"/>
-<bookmark xml-lang="en-US" branch="index" id="bm_id240920171018528200">
- <bookmark_value>Data Stream;Live data stream</bookmark_value>
-</bookmark>
-
-<section id="live_data_stream">
-<h1 id="hd_id240920171003006302"><link
href="text/scalc/01/live_data_stream.xhp">Live Data Stream</link></h1>
-<paragraph id="par_id240920171003293400" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Live data stream for
spreadsheets</ahelp></paragraph>
-</section>
-
-<section id="howtoget">
-<paragraph id="par_id240920171007389295" role="paragraph"
xml-lang="en-US">Menu <item type="menuitem">Data – Streams...</item></paragraph>
-</section>
-<embed href="text/shared/need_help.xhp#needhelp"/>
-
-<section id="relatedtopics">
-<paragraph id="par_id240920171007419799" role="paragraph"
xml-lang="en-US">Data streams</paragraph>
-</section>
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/datastreams/DataStreamDialog"
id="bm_id240920171033409926" localize="false"/>
+ <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/datastreams/@@nowidget@@"
id="bm_id240920171033409926" localize="false"/>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id240920171018528200">
+ <bookmark_value>Data Stream;Live data stream</bookmark_value>
+ <bookmark_value>Data Stream;Streams</bookmark_value>
+ </bookmark>
+ <section id="live_data_stream">
+ <h1 id="hd_id240920171003006302"><link
href="text/scalc/01/live_data_stream.xhp">Live Data Stream</link></h1>
+ <paragraph id="par_id240920171003293400" role="paragraph"><ahelp
hid="."><variable id="streams_desc">Create live data streams for
spreadsheets.</variable></ahelp></paragraph>
+ </section>
+ <section id="howtoget">
+ <paragraph id="par_id240920171007389295" role="paragraph">Menu
<menuitem>Data – Streams...</menuitem></paragraph>
+ </section>
+ <note id="par_id921633126951835">This is an experimental feature and is
disabled by default. To enable it, go to <menuitem>Tools - Options -
Advanced</menuitem> and check the option <emph>Enable experimental features
(may be unstable)</emph>.</note>
+ <embed href="text/shared/need_help.xhp#needhelp"/>
</body>
-
</helpdocument>
diff --git a/source/text/scalc/main0112.xhp b/source/text/scalc/main0112.xhp
index ae1960cf1..64fb5bb64 100644
--- a/source/text/scalc/main0112.xhp
+++ b/source/text/scalc/main0112.xhp
@@ -18,37 +18,38 @@
-->
<helpdocument version="1.0">
<meta>
-<topic id="textscalcmain0112xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Data</title>
-<filename>/text/scalc/main0112.xhp</filename>
-</topic>
+ <topic id="textscalcmain0112xml" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Data</title>
+ <filename>/text/scalc/main0112.xhp</filename>
+ </topic>
</meta>
<body>
-<section id="data">
-<bookmark xml-lang="en-US" branch="hid/.uno:DataMenu" id="bm_id9612414"
localize="false"/><h1 id="hd_id3153254"><link href="text/scalc/main0112.xhp"
name="Data">Data</link></h1>
-<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><ahelp
hid=".">Use the <emph>Data</emph> menu commands to edit the data in the current
sheet. You can define ranges, sort and filter the data, calculate results,
outline data, and create a pivot table.</ahelp></paragraph>
-</section>
-<embed href="text/scalc/01/12030000.xhp#sortheader"/>
-<embed href="text/shared/02/12010000.xhp#sortascending"/>
-<embed href="text/shared/02/12020000.xhp#sortdescending"/>
-<embed href="text/scalc/01/12040100.xhp#autofilter"/>
-<embed href="text/scalc/01/12040000.xhp#filter"/>
-<embed href="text/scalc/01/12010000.xhp#defineDBrangeheader"/>
-<embed href="text/scalc/01/12020000.xhp#selectDBheader"/>
-<embed href="text/scalc/01/12100000.xhp#refreshrangehead"/>
-<embed href="text/scalc/01/12090000.xhp#datenpilot"/>
-<embed href="text/scalc/01/calculate.xhp#calculateheader"/>
-<embed href="text/scalc/01/12120000.xhp#validityheader"/>
-<embed href="text/scalc/01/12050000.xhp#subtotalheader"/>
-<embed href="text/scalc/01/data_form.xhp#data_form"/>
-<embed href="text/scalc/01/live_data_stream.xhp#live_data_stream"/>
-<embed href="text/scalc/01/xml_source.xhp#xml_source"/>
-<embed href="text/scalc/01/data_provider.xhp#data_provider"/>
-<embed href="text/scalc/01/12060000.xhp#multopheader"/>
-<embed href="text/scalc/01/text2columns.xhp#t2cheader"/>
-<embed href="text/scalc/01/12070000.xhp#consolidateheader"/>
-<embed href="text/scalc/01/12080000.xhp#gliederung"/>
-<embed href="text/scalc/01/statistics.xhp#analysistoolpack"/>
-
+ <section id="data">
+ <bookmark xml-lang="en-US" branch="hid/.uno:DataMenu" id="bm_id9612414"
localize="false"/><h1 id="hd_id3153254"><link href="text/scalc/main0112.xhp"
name="Data">Data</link></h1>
+ <paragraph role="paragraph" id="par_id3147264" xml-lang="en-US"><ahelp
hid=".">Use the <emph>Data</emph> menu commands to edit the data in the current
sheet. You can define ranges, sort and filter the data, calculate results,
outline data, and create a pivot table.</ahelp></paragraph>
+ </section>
+ <embed href="text/scalc/01/12030000.xhp#sortheader"/>
+ <embed href="text/shared/02/12010000.xhp#sortascending"/>
+ <embed href="text/shared/02/12020000.xhp#sortdescending"/>
+ <embed href="text/scalc/01/12040100.xhp#autofilter"/>
+ <embed href="text/scalc/01/12040000.xhp#filter"/>
+ <embed href="text/scalc/01/12010000.xhp#defineDBrangeheader"/>
+ <embed href="text/scalc/01/12020000.xhp#selectDBheader"/>
+ <embed href="text/scalc/01/12100000.xhp#refreshrangehead"/>
+ <embed href="text/scalc/01/12090000.xhp#datenpilot"/>
+ <embed href="text/scalc/01/calculate.xhp#calculateheader"/>
+ <embed href="text/scalc/01/12120000.xhp#validityheader"/>
+ <embed href="text/scalc/01/12050000.xhp#subtotalheader"/>
+ <embed href="text/scalc/01/data_form.xhp#data_form"/>
+ <h2 id="hd_id231633127579389"><link
href="text/scalc/01/live_data_stream.xhp"
name="Streams_link">Streams</link></h2>
+ <paragraph role="paragraph" localize="false"
id="par_id251633128124869"><embedvar
href="text/scalc/01/live_data_stream.xhp#streams_desc"/></paragraph>
+ <embed href="text/scalc/01/xml_source.xhp#xml_source"/>
+ <comment>Data Provider temporarilly removed. Feature and help file not
finished yet.</comment>
+ <comment>Link is:
href="text/scalc/01/data_provider.xhp#data_provider"</comment>
+ <embed href="text/scalc/01/12060000.xhp#multopheader"/>
+ <embed href="text/scalc/01/text2columns.xhp#t2cheader"/>
+ <embed href="text/scalc/01/12070000.xhp#consolidateheader"/>
+ <embed href="text/scalc/01/12080000.xhp#gliederung"/>
+ <embed href="text/scalc/01/statistics.xhp#analysistoolpack"/>
</body>
</helpdocument>
