source/text/scalc/00/00000412.xhp | 61 ++++++++++++++++++++++++++++++++++++-- source/text/scalc/01/12010000.xhp | 3 + source/text/scalc/01/12020000.xhp | 20 ++++++------ source/text/scalc/01/12100000.xhp | 12 +++---- 4 files changed, 76 insertions(+), 20 deletions(-)
New commits: commit 414d3e7a7b14469df61c49ea030563c2b4093264 Author: Olivier Hallot <[email protected]> AuthorDate: Wed Dec 27 08:39:03 2023 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Wed Dec 27 13:59:49 2023 +0100 tdf#155876 UI cmds Calc-Sheet menu (37) + Data menu for Calc, DD ranges. + refactoring Change-Id: I467b4c0b654874ca8356908a0c6fb75175f579bf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/161369 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/00/00000412.xhp b/source/text/scalc/00/00000412.xhp index fe209cb6dd..0fb0988003 100644 --- a/source/text/scalc/00/00000412.xhp +++ b/source/text/scalc/00/00000412.xhp @@ -28,8 +28,44 @@ <h1 id="hd_id3145136">Data Menu</h1> <paragraph role="paragraph" id="par_id8366954"><variable id="text2columns">Choose <emph>Data - Text to Columns</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3147399"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3145345"><variable id="dbrba">Choose <emph>Data - Select Range</emph>.</variable></paragraph> + + <section id="definerange"> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id3147399"><variable id="dbrbf">Choose <emph>Data - Define Range</emph>.</variable></paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id491703673711439">Choose <menuitem>Data</menuitem> - <menuitem>Define Range</menuitem>.</paragraph> + <paragraph role="paragraph" id="par_id321703673716748">On the <menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose <menuitem>Define Range</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <table id="tab_id651703673736936"> + <tablerow> + <tablecell> + <paragraph id="par_id691703673736937" role="paragraph"><image src="cmd/lc_definedbname.svg" id="img_id841703673736938" width="1cm" height="1cm"><alt id="alt_id221703673736939">Icon Define Range</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id131703673736941" role="paragraph">Define Range</paragraph> + </tablecell> + </tablerow> + </table> + </section> + + <section id="selectrange"> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id3145345"><variable id="dbrba">Choose <emph>Data - Select Range</emph>.</variable></paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id621703673870509">Choose <menuitem>Data</menuitem> - <menuitem>Define Range</menuitem>.</paragraph> + <paragraph role="paragraph" id="par_id261703673873605">On the <menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose <menuitem>Define Range</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <table id="tab_id671703673891812"> + <tablerow> + <tablecell> + <paragraph id="par_id651703673891813" role="paragraph"><image src="cmd/lc_selectdb.svg" id="img_id1001703673891814" width="1cm" height="1cm"><alt id="alt_id291703673891815">Icon Select Range</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id71703673891816" role="paragraph">Select Range</paragraph> + </tablecell> + </tablerow> + </table> + </section> <section id="sort"> <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> @@ -282,7 +318,26 @@ </section> <paragraph role="paragraph" id="par_id3153294"><variable id="dndpak">Choose <emph>Data - Pivot Table - Refresh</emph>.</variable></paragraph> <paragraph role="paragraph" id="par_id3151344"><variable id="dndploe">Choose <emph>Data - Pivot Table - Delete</emph>.</variable></paragraph> - <paragraph role="paragraph" id="par_id3150397"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>.</variable></paragraph> + + <section id="refreshrange"> + <embed href="text/shared/00/00000004.xhp#from_menu_bar"/> + <paragraph role="paragraph" id="par_id3150397"><variable id="dndakt">Choose <emph>Data - Refresh Range</emph>.</variable></paragraph> + <embed href="text/shared/00/00000004.xhp#from_tabUI"/> + <paragraph role="paragraph" id="par_id101703676224446">Choose <menuitem>Data - Refresh Range</menuitem>.</paragraph> + <paragraph role="paragraph" id="par_id151703676230661">On the <menuitem>Data</menuitem> menu of the <menuitem>Data</menuitem> tab, choose <menuitem>Refresh Range</menuitem>.</paragraph> + <embed href="text/shared/00/00000004.xhp#from_toolbars"/> + <table id="tab_id801703676243671"> + <tablerow> + <tablecell> + <paragraph id="par_id121703676243672" role="paragraph"><image src="cmd/lc_dataarearefresh.svg" id="img_id321703676243673" width="1cm" height="1cm"><alt id="alt_id371703676243674">Icon Refresh Range</alt></image></paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id11703676243676" role="paragraph">Refresh Range</paragraph> + </tablecell> + </tablerow> + </table> + </section> + <paragraph role="paragraph" id="par_idN10B8F"><variable id="grouping">Choose <emph>Data - Group and Outline - Group</emph>.</variable></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/12010000.xhp b/source/text/scalc/01/12010000.xhp index 4c934c2799..5c8e76d85b 100644 --- a/source/text/scalc/01/12010000.xhp +++ b/source/text/scalc/01/12010000.xhp @@ -30,6 +30,7 @@ <bookmark branch="hid/.uno:DefineDBName" id="bm_id6632476" localize="false"/> <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/DefineDatabaseRangeDialog" id="bm_id3147335" localize="false"/> <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/@@nowidget@@" id="bm_id3147335" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-DefineDBName" id="bm_id631703673605853" localize="false"/> <section id="defineDBrangeheader"> <h1 id="hd_id3157909"><link href="text/scalc/01/12010000.xhp">Define Range</link></h1> <paragraph role="paragraph" id="par_id3155922"><variable id="bereichtext"><ahelp hid=".uno:DefineDBName">Defines a database range based on the selected cells in your sheet.</ahelp></variable></paragraph> @@ -37,7 +38,7 @@ <note id="par_id3149456">You can only select a rectangular cell range.</note> <section id="howtoget"> -<embed href="text/scalc/00/00000412.xhp#dbrbf"/> +<embed href="text/scalc/00/00000412.xhp#definerange"/> </section> <bookmark branch="hid/modules/scalc/ui/definedatabaserangedialog/entry" id="bm_id3150868" localize="false"/> <h2 id="hd_id3156422">Name</h2> diff --git a/source/text/scalc/01/12020000.xhp b/source/text/scalc/01/12020000.xhp index 3449b2992a..5c3c243cde 100644 --- a/source/text/scalc/01/12020000.xhp +++ b/source/text/scalc/01/12020000.xhp @@ -19,7 +19,7 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc0112020000xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Select Database Range</title> +<title id="tit">Select Database Range</title> <filename>/text/scalc/01/12020000.xhp</filename> </topic> <history> @@ -27,22 +27,22 @@ </history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3145068"><bookmark_value>databases; selecting (Calc)</bookmark_value> +<bookmark branch="index" id="bm_id3145068"><bookmark_value>databases; selecting (Calc)</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/.uno:SelectDB" id="bm_id2131630" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/SelectRangeDialog" id="bm_id3148946" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/@@nowidget@@" id="bm_id3148946" localize="false"/> - +<bookmark branch="hid/.uno:SelectDB" id="bm_id2131630" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/selectrange/SelectRangeDialog" id="bm_id3148946" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/selectrange/@@nowidget@@" id="bm_id3148946" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/notebookbar/MenuData-Select" id="bm_id801703674098588" localize="false"/> <section id="selectDBheader"> <h1 id="hd_id3145068"><link href="text/scalc/01/12020000.xhp">Select Range</link></h1> -<paragraph role="paragraph" id="par_id3149655" xml-lang="en-US"><variable id="bereichwaehlen"><ahelp hid=".uno:SelectDB">Selects a database range that you defined under <link href="text/scalc/01/12010000.xhp">Data - Define Range</link>.</ahelp></variable></paragraph> +<paragraph role="paragraph" id="par_id3149655"><variable id="bereichwaehlen"><ahelp hid=".uno:SelectDB">Selects a database range that you defined under <link href="text/scalc/01/12010000.xhp">Data - Define Range</link>.</ahelp></variable></paragraph> </section> <section id="howtoget"> - <embed href="text/scalc/00/00000412.xhp#dbrba"/> + <embed href="text/scalc/00/00000412.xhp#selectrange"/> </section> -<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/selectrange/treeview" id="bm_id3125865" localize="false"/> +<bookmark branch="hid/modules/scalc/ui/selectrange/treeview" id="bm_id3125865" localize="false"/> <h2 id="hd_id3153192">Ranges</h2> -<paragraph role="paragraph" id="par_id3154684" xml-lang="en-US"><ahelp hid="modules/scalc/ui/selectrange/treeview">Lists the available database ranges. To select a database range, click its name, and then click <emph>OK</emph>.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3154684"><ahelp hid="modules/scalc/ui/selectrange/treeview">Lists the available database ranges. To select a database range, click its name, and then click <emph>OK</emph>.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/scalc/01/12100000.xhp b/source/text/scalc/01/12100000.xhp index 3865aaedfe..8cbc267695 100644 --- a/source/text/scalc/01/12100000.xhp +++ b/source/text/scalc/01/12100000.xhp @@ -19,7 +19,7 @@ <helpdocument version="1.0"> <meta> <topic id="textscalc0112100000xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Refresh Range</title> +<title id="tit">Refresh Range</title> <filename>/text/scalc/01/12100000.xhp</filename> </topic> <history> @@ -27,15 +27,15 @@ </history> </meta> <body> - <bookmark xml-lang="en-US" branch="index" id="bm_id3153662"><bookmark_value>database ranges; refreshing</bookmark_value></bookmark> -<bookmark branch="hid/.uno:DataReImport" xml-lang="en-US" id="bm_id3153880" localize="false"/> -<bookmark branch="hid/.uno:DataAreaRefresh" xml-lang="en-US" id="bm_id3149166" localize="false"/> + <bookmark branch="index" id="bm_id3153662"><bookmark_value>database ranges; refreshing</bookmark_value></bookmark> +<bookmark branch="hid/.uno:DataReImport" id="bm_id3153880" localize="false"/> +<bookmark branch="hid/.uno:DataAreaRefresh" id="bm_id3149166" localize="false"/> <section id="refreshrangehead"> <h1 id="hd_id3153662"><link href="text/scalc/01/12100000.xhp">Refresh Range</link></h1> - <paragraph role="paragraph" id="par_id3153088" xml-lang="en-US"><variable id="aktualisieren"><ahelp hid=".">Updates a data range that was inserted from an external database. The data in the sheet is updated to match the data in the external database.</ahelp></variable></paragraph> + <paragraph role="paragraph" id="par_id3153088"><variable id="aktualisieren"><ahelp hid=".">Updates a data range that was inserted from an external database. The data in the sheet is updated to match the data in the external database.</ahelp></variable></paragraph> </section> <section id="howtoget"> - <embed href="text/scalc/00/00000412.xhp#dndakt"/> + <embed href="text/scalc/00/00000412.xhp#refreshrange"/> </section> </body> </helpdocument>
