source/text/scalc/00/00000412.xhp | 17 +++++++++++
source/text/scalc/01/xml_source.xhp | 52 ++++++++++++++++++------------------
2 files changed, 43 insertions(+), 26 deletions(-)
New commits:
commit 4ff59004ff1d7506eebad27eed13c9d55419cacd
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Wed Jan 3 20:15:55 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Jan 4 01:02:38 2024 +0100
tdf#155876 UI cmds Calc-Sheet menu (44)
+ Data menu for Calc, XML source commands
+ refactoring
Change-Id: I76779f586dc7819fcd7258a8307862fb35201636
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/161603
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/00/00000412.xhp
b/source/text/scalc/00/00000412.xhp
index 4358786cd2..4f3afdd43e 100644
--- a/source/text/scalc/00/00000412.xhp
+++ b/source/text/scalc/00/00000412.xhp
@@ -512,5 +512,22 @@
</tablerow>
</table>
</section>
+ <section id="xml_source">
+ <embed href="text/shared/00/00000004.xhp#from_menu_bar"/>
+ <paragraph id="par_id111704323472652" role="paragraph">Choose
<menuitem>Data - XML Source</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_tabUI"/>
+ <paragraph role="paragraph" id="par_id641704323374235">Choose
<menuitem>Data - XML Source</menuitem>.</paragraph>
+ <embed href="text/shared/00/00000004.xhp#from_toolbars"/>
+ <table id="tab_id751704323411478">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id821704323411479"
role="paragraph"><image src="cmd/lc_managexmlsource.svg"
id="img_id431704323411480" width="1cm" height="1cm"><alt
id="alt_id871704323411481">Icon XML Source</alt></image></paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id341704323411483" role="paragraph">XML
Source</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+ </section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/xml_source.xhp
b/source/text/scalc/01/xml_source.xhp
index c37f919dfa..005333a3eb 100644
--- a/source/text/scalc/01/xml_source.xhp
+++ b/source/text/scalc/01/xml_source.xhp
@@ -20,61 +20,61 @@
<meta>
<topic id="textscalc01xml_sourcexml" indexer="include"
status="PUBLISH">
- <title id="tit" xml-lang="en-US">XML Data</title>
+ <title id="tit">XML Data</title>
<filename>/text/scalc/01/xml_source.xhp</filename>
</topic>
</meta>
- <body>
-
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/xmlsourcedialog/XMLSourceDialog"
id="bm_id240920171033409926" localize="false"/>
- <bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/xmlsourcedialog/@@nowidget@@"
id="bm_id240920171033409926" localize="false"/>
- <bookmark xml-lang="en-US" branch="index" id="bm_id240920171018528200">
- <bookmark_value>XML Source;load XML data in
spreadsheets</bookmark_value>
- </bookmark>
- <section id="xml_source">
- <h1 id="hd_id240920171003006302"><link
href="text/scalc/01/xml_source.xhp">XML Source</link></h1>
- <paragraph id="par_id240920171003293400" role="paragraph"
xml-lang="en-US"><ahelp hid=".">Import XML data in a
spreadsheet.</ahelp></paragraph>
- </section>
- <paragraph role="paragraph" id="par_id861521496523519"
xml-lang="en-US">The XML Source feature allows to import data from arbitrarily
structured XML content into cells in an existing spreadsheet document. It
allows XML content to be imported either partially or in full, depending on the
structure of the XML content and the map definitions that the user defines. The
user can specify multiple non-overlapping sub-structures to be mapped to
different cell positions within the same document. The user can import either
element contents, attribute values or both.</paragraph>
+<body>
+<bookmark branch="hid/.uno:ManageXMLSource" id="bm_id521704323249559"
localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/xmlsourcedialog/XMLSourceDialog"
id="bm_id240920171033409926" localize="false"/>
+<bookmark branch="hid/modules/scalc/ui/xmlsourcedialog/@@nowidget@@"
id="bm_id240920171033409926" localize="false"/>
+<bookmark branch="index" id="bm_id240920171018528200">
+<bookmark_value>XML Source;load XML data in spreadsheets</bookmark_value>
+</bookmark>
+<section id="xml_source">
+ <h1 id="hd_id240920171003006302"><link
href="text/scalc/01/xml_source.xhp">XML Source</link></h1>
+ <paragraph id="par_id240920171003293400" role="paragraph"><ahelp
hid=".">Import XML data in a spreadsheet.</ahelp></paragraph>
+</section>
+<paragraph role="paragraph" id="par_id861521496523519">The XML Source feature
allows to import data from arbitrarily structured XML content into cells in an
existing spreadsheet document. It allows XML content to be imported either
partially or in full, depending on the structure of the XML content and the map
definitions that the user defines. The user can specify multiple
non-overlapping sub-structures to be mapped to different cell positions within
the same document. The user can import either element contents, attribute
values or both.</paragraph>
<section id="howtoget">
- <paragraph id="par_id240920171007389295" role="paragraph"
xml-lang="en-US">Choose <item type="menuitem">Data - XML
Source</item>.</paragraph>
+ <embed href="text/scalc/00/00000412.xhp#xml_source"/>
</section>
<h2 id="hd_id801521494731764">XML Source Dialog</h2>
<embed href="text/shared/06/sc_screenshots.xhp#xmlsource"/>
- <paragraph role="paragraph" id="par_id291521494762812"
xml-lang="en-US">The dialog consists of four parts.</paragraph>
+ <paragraph role="paragraph" id="par_id291521494762812">The dialog consists
of four parts.</paragraph>
<h3 id="hd_id601521494755603">Source file</h3>
- <paragraph role="paragraph" id="par_id161521494769832"
xml-lang="en-US">This lets you specify the path to the XML file that you wish
to import into your document.</paragraph>
+ <paragraph role="paragraph" id="par_id161521494769832">This lets you
specify the path to the XML file that you wish to import into your
document.</paragraph>
<h3 id="hd_id491521494788029">Map to Document</h3>
- <paragraph role="paragraph" id="par_id211521494776007"
xml-lang="en-US">This pane shows the structure of the source XML content as a
tree. This is initially empty, and gets populated when you specify the source
file.</paragraph>
+ <paragraph role="paragraph" id="par_id211521494776007">This pane shows the
structure of the source XML content as a tree. This is initially empty, and
gets populated when you specify the source file.</paragraph>
- <paragraph role="paragraph" id="par_id161521494796604"
xml-lang="en-US">Each element in the tree can be one of three types:</paragraph>
+ <paragraph role="paragraph" id="par_id161521494796604">Each element in the
tree can be one of three types:</paragraph>
<list type="unordered">
<listitem>
- <paragraph id="par_id931521494810426" role="listitem"
xml-lang="en-US">attribute, represented by the symbol <emph>@</emph></paragraph>
+ <paragraph id="par_id931521494810426" role="listitem">attribute,
represented by the symbol <emph>@</emph></paragraph>
</listitem>
<listitem>
- <paragraph id="par_id521521494825665" role="listitem"
xml-lang="en-US">single non-recurring element, represented by the symbol
<emph></></emph>, and</paragraph>
+ <paragraph id="par_id521521494825665" role="listitem">single
non-recurring element, represented by the symbol <emph></></emph>,
and</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id691521494844848" role="listitem"
xml-lang="en-US">recurring element, represented by the symbol
<emph><//></emph>.</paragraph>
+ <paragraph id="par_id691521494844848" role="listitem">recurring
element, represented by the symbol <emph><//></emph>.</paragraph>
</listitem>
</list>
- <paragraph role="paragraph" id="par_id451521494864514" xml-lang="en-US">A
non-recurring element is an element that can only occur once under the same
parent. It is mapped to a single cell in the document.</paragraph>
+ <paragraph role="paragraph" id="par_id451521494864514">A non-recurring
element is an element that can only occur once under the same parent. It is
mapped to a single cell in the document.</paragraph>
- <paragraph role="paragraph" id="par_id361521494872103" xml-lang="en-US">A
recurring element is an element that can appear multiple times under the same
parent. It serves as an enclosing parent of a single record entry of multiple
record entries. These entries are imported into a range those height equals the
number of entries plus one additional header row.</paragraph>
+ <paragraph role="paragraph" id="par_id361521494872103">A recurring element
is an element that can appear multiple times under the same parent. It serves
as an enclosing parent of a single record entry of multiple record entries.
These entries are imported into a range those height equals the number of
entries plus one additional header row.</paragraph>
<h3 id="hd_id581521494885433">Mapped cell</h3>
- <paragraph role="paragraph" id="par_id661521494897796"
xml-lang="en-US">This field specifies the position of a cell in the document
that an element or an attribute is linked to. If it is a non-recurring element
or an attribute, it simply points to the cell where the value of the linked
element/attribute will get imported. If it is a recurring element, it points to
the top-left cell of the range where the whole record entries plus header will
get imported.</paragraph>
+ <paragraph role="paragraph" id="par_id661521494897796">This field
specifies the position of a cell in the document that an element or an
attribute is linked to. If it is a non-recurring element or an attribute, it
simply points to the cell where the value of the linked element/attribute will
get imported. If it is a recurring element, it points to the top-left cell of
the range where the whole record entries plus header will get
imported.</paragraph>
<h3 id="hd_id151521553082338">Import</h3>
- <paragraph role="paragraph" id="par_id131521553077261"
xml-lang="en-US">Pressing the Import button starts the import process based on
the link definitions that the user has provided. Once the import finishes, the
dialog will close.</paragraph>
+ <paragraph role="paragraph" id="par_id131521553077261">Pressing the Import
button starts the import process based on the link definitions that the user
has provided. Once the import finishes, the dialog will close.</paragraph>
<section id="relatedtopics">
- <paragraph id="par_id240920171007419799" role="paragraph"
xml-lang="en-US"><link
href="https://wiki.documentfoundation.org/Development/Calc/XMLSource";
target="_blank">Wiki page on XML Source</link></paragraph>
+ <paragraph id="par_id240920171007419799" role="paragraph"><link
href="https://wiki.documentfoundation.org/Development/Calc/XMLSource";
target="_blank">Wiki page on XML Source</link></paragraph>
</section>
</body>
