summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorRafael Lima <rafael.palma.lima@gmail.com>2021-10-02 00:02:21 +0200
committerIlmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>2021-10-04 16:11:14 +0200
commit60ed9a0af0790ab7c7ed13149d6f1da200b2470a (patch)
tree3bae64764dd4615391ec2fb6db0a65d3f09a95e5
parentf49393db3d21f7de379b589c253eb4eb6252cba9 (diff)
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.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/01/12040000.xhp43
-rw-r--r--source/text/scalc/01/live_data_stream.xhp40
-rw-r--r--source/text/scalc/main0112.xhp61
3 files changed, 66 insertions, 78 deletions
diff --git a/source/text/scalc/01/12040000.xhp b/source/text/scalc/01/12040000.xhp
index 01cecc8c05..0d4ceb0d4d 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 545a166b50..fa9fe9e2db 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 ae1960cf14..64fb5bb643 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>