source/text/scalc/01/12030000.xhp | 6 +++ source/text/scalc/guide/database_sort.xhp | 28 +++++++++--------- source/text/scalc/guide/mark_cells.xhp | 46 +++++++++++++++--------------- source/text/scalc/guide/sorted_list.xhp | 30 ++++++------------- source/text/shared/02/12010000.xhp | 26 ++++++++++++++++ source/text/shared/02/12020000.xhp | 10 +++++- 6 files changed, 86 insertions(+), 60 deletions(-)
New commits: commit 632d38b60f5169e1ab2651d52667f7415c7d3800 Author: Olivier Hallot <[email protected]> AuthorDate: Fri Aug 1 10:53:31 2025 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Mon Aug 4 13:37:42 2025 +0200 tdf#167442 Precision on sorting blocks of cells. Special thanks to iavs.leroy@--- for the qualification. Change-Id: If96ca6b944161d0734d89078923a0547e0de9623 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/188773 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/source/text/scalc/01/12030000.xhp b/source/text/scalc/01/12030000.xhp index 7e64f3f089..8910019d63 100644 --- a/source/text/scalc/01/12030000.xhp +++ b/source/text/scalc/01/12030000.xhp @@ -29,7 +29,7 @@ <body> <bookmark branch="hid/.uno:DataSort" id="bm_id3150084" localize="false"/> <section id="sortheader"> -<h1 id="hd_id3150275"><link href="text/scalc/01/12030000.xhp">Sort</link></h1> + <h1 id="hd_id3150275"><variable id="h1"><link href="text/scalc/01/12030000.xhp">Sort</link></variable></h1> <paragraph role="paragraph" id="par_id3155922"><variable id="sorttext"><ahelp hid=".uno:DataSort">Sorts the selected rows according to the conditions that you specify.</ahelp> </variable> $[officename] automatically recognizes and selects database ranges.</paragraph> </section> @@ -40,5 +40,9 @@ <embed href="text/scalc/01/12030100.xhp#sort_criteria"/> <embed href="text/scalc/01/12030200.xhp#options"/> <embed href="text/shared/00/00000001.xhp#reset"/> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id191754055500754" localize="false"><embedvar href="text/shared/02/12010000.xhp#h1" markup="ignore"/></paragraph> + <paragraph role="paragraph" id="par_id661754055505532" localize="false"><embedvar href="text/shared/02/12020000.xhp#h1" markup="ignore"/></paragraph> +</section> </body> </helpdocument> diff --git a/source/text/scalc/guide/database_sort.xhp b/source/text/scalc/guide/database_sort.xhp index 55c4d45268..84154a2a1c 100644 --- a/source/text/scalc/guide/database_sort.xhp +++ b/source/text/scalc/guide/database_sort.xhp @@ -21,38 +21,38 @@ <meta> <topic id="textscalcguidedatabase_sortxml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Sorting Data </title> + <title id="tit">Sorting Data </title> <filename>/text/scalc/guide/database_sort.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3150767"><bookmark_value>database ranges; sorting</bookmark_value> - <bookmark_value>sorting; database ranges</bookmark_value> - <bookmark_value>data;sorting in databases</bookmark_value> +<bookmark branch="index" id="bm_id3150767"> +<bookmark_value>database ranges; sorting</bookmark_value> +<bookmark_value>sorting; database ranges</bookmark_value> +<bookmark_value>data;sorting in databases</bookmark_value> </bookmark> -<paragraph xml-lang="en-US" id="hd_id3150767" role="heading" level="1"><variable id="database_sort"><link href="text/scalc/guide/database_sort.xhp">Sorting Data</link> -</variable></paragraph> +<h1 id="hd_id3150767"><variable id="database_sort"><link href="text/scalc/guide/database_sort.xhp">Sorting Data</link></variable></h1> <list type="ordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3145751" role="listitem">Click in a database range.</paragraph> - <paragraph xml-lang="en-US" id="par_id121020081121549" role="listitem">If you select a range of cells, only these cells will get sorted. If you just click one cell without selecting, then the whole database range will get sorted.</paragraph> + <paragraph id="par_id3145751" role="listitem">Click in a database range.</paragraph> + <paragraph id="par_id121020081121549" role="listitem">If you select a range of cells, only these cells will get sorted. If you just click one cell without selecting, then the whole database range will get sorted.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN10635" role="listitem">Choose <item type="menuitem">Data - Sort</item>.</paragraph> - <paragraph xml-lang="en-US" id="par_id121020081121547" role="listitem">The range of cells that will get sorted is shown in inverted colors.</paragraph> + <paragraph id="par_idN10635" role="listitem">Choose <item type="menuitem">Data - Sort</item>.</paragraph> + <paragraph id="par_id121020081121547" role="listitem">The range of cells that will get sorted is shown in inverted colors.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN10645" role="listitem">Select the <link href="text/scalc/01/12030200.xhp">sort options</link> that you want.</paragraph> + <paragraph id="par_idN10645" role="listitem">Select the <link href="text/scalc/01/12030200.xhp">sort options</link> that you want.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_idN1063D" role="listitem">Click <emph>OK</emph>.</paragraph> + <paragraph id="par_idN1063D" role="listitem">Click <emph>OK</emph>.</paragraph> </listitem> </list> <section id="relatedtopics"> <embed href="text/scalc/guide/database_define.xhp#database_define"/> <embed href="text/scalc/guide/database_filter.xhp#database_filter"/> <embed href="text/scalc/guide/sorted_list.xhp#sorted_list"/> - <paragraph xml-lang="en-US" id="par_id1846980" role="paragraph"><link href="https://wiki.documentfoundation.org/Documentation/How_Tos/Defining_a_Data_Range";>Wiki page about defining a data range</link></paragraph> + <paragraph id="par_id1846980" role="paragraph"><link href="https://wiki.documentfoundation.org/Documentation/How_Tos/Defining_a_Data_Range";>Wiki page about defining a data range</link></paragraph> </section> </body> -</helpdocument> \ No newline at end of file +</helpdocument> diff --git a/source/text/scalc/guide/mark_cells.xhp b/source/text/scalc/guide/mark_cells.xhp index 80487bb28a..d98c3b7541 100644 --- a/source/text/scalc/guide/mark_cells.xhp +++ b/source/text/scalc/guide/mark_cells.xhp @@ -22,83 +22,83 @@ <meta> <topic id="textscalcguidemark_cellsxml" indexer="include" status="PUBLISH"> - <title xml-lang="en-US" id="tit">Selecting Multiple Cells</title> + <title id="tit">Selecting Multiple Cells</title> <filename>/text/scalc/guide/mark_cells.xhp</filename> </topic> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3153361"><bookmark_value>cells; selecting</bookmark_value> +<bookmark branch="index" id="bm_id3153361"><bookmark_value>cells; selecting</bookmark_value> <bookmark_value>marking cells</bookmark_value> <bookmark_value>selecting;cells</bookmark_value> <bookmark_value>multiple cells selection</bookmark_value> <bookmark_value>selection modes in spreadsheets</bookmark_value> <bookmark_value>tables; selecting ranges</bookmark_value> </bookmark><comment>mw changed "selection modes..."</comment> -<paragraph xml-lang="en-US" id="hd_id3153361" role="heading" level="1"><variable id="mark_cells"><link href="text/scalc/guide/mark_cells.xhp">Selecting Multiple Cells</link> -</variable></paragraph> +<h1 id="hd_id3153361"><variable id="mark_cells"><link href="text/scalc/guide/mark_cells.xhp">Selecting Multiple Cells</link></variable></h1> <h2 id="hd_id3145272">Select a rectangular range</h2> - <paragraph xml-lang="en-US" id="par_id3149261" role="paragraph">With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range.</paragraph> + <paragraph id="par_id3149261" role="paragraph">With the mouse button pressed, drag from one corner to the diagonally opposed corner of the range.</paragraph> <h2 id="hd_id3151119">Mark a single cell</h2> - <paragraph xml-lang="en-US" id="par_id3146975" role="paragraph">Do one of the following:</paragraph> + <paragraph id="par_id3146975" role="paragraph">Do one of the following:</paragraph> <list type="unordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3163710" role="listitem">Click, then Shift-click the cell.</paragraph> + <paragraph id="par_id3163710" role="listitem">Click, then Shift-click the cell.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id3149959" role="listitem">Pressing the mouse button, drag a range across two cells, do not release the mouse button, and then drag back to the first cell. Release the mouse button. You can now move the individual cell by drag and drop.</paragraph> + <paragraph id="par_id3149959" role="listitem">Pressing the mouse button, drag a range across two cells, do not release the mouse button, and then drag back to the first cell. Release the mouse button. You can now move the individual cell by drag and drop.</paragraph> </listitem> </list> <h2 id="hd_id3154942">Select various dispersed cells</h2> - <paragraph xml-lang="en-US" id="par_id1001200901072060" role="paragraph">Do one of the following:</paragraph> + <paragraph id="par_id1001200901072060" role="paragraph">Do one of the following:</paragraph> <list type="unordered"> <listitem> - <paragraph xml-lang="en-US" id="par_id3156284" role="paragraph">Mark at least one cell. Then while pressing <switchinline select="sys"><caseinline select="MAC">Command + <paragraph id="par_id3156284" role="paragraph">Mark at least one cell. Then while pressing <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>, click each of the additional cells.</paragraph> </listitem> <listitem> - <paragraph xml-lang="en-US" id="par_id1001200901072023" role="paragraph">Click the STD / EXT / ADD area in the status bar until it shows ADD. Now click all cells that you want to select.</paragraph> + <paragraph id="par_id1001200901072023" role="paragraph">Click the STD / EXT / ADD area in the status bar until it shows ADD. Now click all cells that you want to select.</paragraph> </listitem> </list> <h2 id="hd_id3146971">Switch marking mode</h2> - <paragraph xml-lang="en-US" id="par_id3155064" role="paragraph">On the status bar, click the box with the legend STD / EXT / ADD to switch the marking mode:</paragraph> + <paragraph id="par_id3155064" role="paragraph">On the status bar, click the box with the legend STD / EXT / ADD to switch the marking mode:</paragraph> <table id="tbl_id3145643"> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3159264" role="paragraph">Field contents</paragraph> + <paragraph id="par_id3159264" role="tablehead">Field contents</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3155337" role="paragraph">Effect of clicking the mouse</paragraph> + <paragraph id="par_id3155337" role="tablehead">Effect of clicking the mouse</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3149568" role="paragraph">STD</paragraph> + <paragraph id="par_id3149568" role="tablecontent">STD</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3148486" role="paragraph">A mouse click selects the cell you have clicked on. Unmarks all marked cells.</paragraph> + <paragraph id="par_id3148486" role="tablecontent">A mouse click selects the cell you have clicked on. Unmarks all marked cells.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150090" role="paragraph">EXT</paragraph> + <paragraph id="par_id3150090" role="tablecontent">EXT</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3150305" role="paragraph">A mouse click marks a rectangular range from the current cell to the cell you clicked. Alternatively, Shift-click a cell.</paragraph> + <paragraph id="par_id3150305" role="tablecontent">A mouse click marks a rectangular range from the current cell to the cell you clicked. Alternatively, Shift-click a cell.</paragraph> </tablecell> </tablerow> <tablerow> <tablecell> - <paragraph xml-lang="en-US" id="par_id3145587" role="paragraph">ADD</paragraph> + <paragraph id="par_id3145587" role="tablecontent">ADD</paragraph> </tablecell> <tablecell> - <paragraph xml-lang="en-US" id="par_id3154368" role="paragraph">A mouse click in a cell adds it to the already marked cells. A mouse click in a marked cell unmarks it. Alternatively, <switchinline select="sys"><caseinline select="MAC">Command + <paragraph id="par_id3154368" role="tablecontent">A mouse click in a cell adds it to the already marked cells. A mouse click in a marked cell unmarks it. Alternatively, <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>-click the cells.</paragraph> </tablecell> </tablerow> </table> - + <h2 id="hd_id651754050551864">Quick selection of a cell block</h2> + <paragraph role="paragraph" id="par_id61754050643440">To select a rectangular block of cells surrounded by empty cells, place the cursor inside the block and press <keycode>Ctrl + A</keycode>.</paragraph> <section id="relatedtopics"> - <paragraph xml-lang="en-US" id="par_id3154487" role="paragraph"><link href="text/scalc/main0208.xhp">Status bar</link></paragraph> + <paragraph id="par_id3154487" role="paragraph"><link href="text/scalc/main0208.xhp">Status bar</link></paragraph> </section> </body> -</helpdocument> \ No newline at end of file +</helpdocument> diff --git a/source/text/scalc/guide/sorted_list.xhp b/source/text/scalc/guide/sorted_list.xhp index 2729ca94d5..7eeb4fee2a 100644 --- a/source/text/scalc/guide/sorted_list.xhp +++ b/source/text/scalc/guide/sorted_list.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,20 +16,15 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textscalcguidesorted_listxml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Applying Sort Lists</title> +<title id="tit">Applying Sort Lists</title> <filename>/text/scalc/guide/sorted_list.xhp</filename> </topic> </meta> <body> - - - -<bookmark xml-lang="en-US" branch="index" id="bm_id3150870"><bookmark_value>filling;customized lists</bookmark_value> +<bookmark branch="index" id="bm_id3150870"><bookmark_value>filling;customized lists</bookmark_value> <bookmark_value>sort lists;applying</bookmark_value> <bookmark_value>defining;sort lists</bookmark_value> <bookmark_value>geometric lists</bookmark_value> @@ -42,17 +34,15 @@ <bookmark_value>customized lists</bookmark_value> </bookmark> <comment>mw deleted "applying;"</comment> - <paragraph xml-lang="en-US" id="hd_id3150870" role="heading" level="1"><variable id="sorted_list"><link href="text/scalc/guide/sorted_list.xhp">Applying Sort Lists</link> -</variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3159154" role="paragraph">Sort lists allow you to type one piece of information in a cell, then drag it to fill in a consecutive list of items.</paragraph> - <paragraph xml-lang="en-US" id="par_id3148645" role="paragraph">For example, enter the text "Jan" or "January" in an empty cell. Select the cell and click the mouse on the lower right corner of the cell border. Then drag the selected cell a few cells to the right or downwards. When you release the mouse button, the highlighted cells will be filled with the names of the months.</paragraph> - <paragraph xml-lang="en-US" id="par_id2367931" role="paragraph">Hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> if you do not want to fill the cells with different values.</paragraph> - <paragraph xml-lang="en-US" id="par_id3152577" role="paragraph">The predefined series can be found under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Sort Lists</emph>. You can also create your own lists of text strings tailored to your needs, such as a list of your company's branch offices. When you use the information in these lists later (for example, as headings), just enter the first name in the list and expand the entry by dragging it with your mouse.</paragraph> + <h1 id="hd_id3150870"><variable id="sorted_list"><link href="text/scalc/guide/sorted_list.xhp">Applying Sort Lists</link> +</variable></h1> + <paragraph id="par_id3159154" role="paragraph">Sort lists allow you to type one piece of information in a cell, then drag it to fill in a consecutive list of items.</paragraph> + <paragraph id="par_id3148645" role="paragraph">For example, enter the text "Jan" or "January" in an empty cell. Select the cell and click the mouse on the lower right corner of the cell border. Then drag the selected cell a few cells to the right or downwards. When you release the mouse button, the highlighted cells will be filled with the names of the months.</paragraph> + <paragraph id="par_id2367931" role="paragraph">Hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> if you do not want to fill the cells with different values.</paragraph> + <paragraph id="par_id3152577" role="paragraph">The predefined series can be found under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Sort Lists</emph>. You can also create your own lists of text strings tailored to your needs, such as a list of your company's branch offices. When you use the information in these lists later (for example, as headings), just enter the first name in the list and expand the entry by dragging it with your mouse.</paragraph> <section id="relatedtopics"> - <embed href="text/scalc/guide/calc_series.xhp#calc_series"/> - <paragraph xml-lang="en-US" id="par_id3147434" role="paragraph"><link href="text/shared/optionen/01060400.xhp">Sort lists</link></paragraph> - + <paragraph id="par_id3147434" role="paragraph"><link href="text/shared/optionen/01060400.xhp">Sort lists</link></paragraph> </section> </body> </helpdocument> diff --git a/source/text/shared/02/12010000.xhp b/source/text/shared/02/12010000.xhp index fed4ac7ad7..04d36f601b 100644 --- a/source/text/shared/02/12010000.xhp +++ b/source/text/shared/02/12010000.xhp @@ -25,8 +25,11 @@ </meta> <body> <bookmark branch="hid/.uno:SortAscending" id="bm_id1196545" localize="false"/> +<bookmark branch="index" id="bm_id111754010692151"> +<bookmark_value>sort;ascending</bookmark_value> +</bookmark> <section id="sortascending"> -<h1 id="hd_id3152594"><link href="text/shared/02/12010000.xhp">Sort Ascending</link></h1> + <h1 id="hd_id3152594"><variable id="h1"><link href="text/shared/02/12010000.xhp">Sort Ascending</link></variable></h1> <paragraph role="paragraph" id="par_id3150693"><ahelp hid=".">Sorts the data of the selected field or cell range in ascending order. </ahelp>Text fields are sorted alphabetically, numerical fields are sorted by number.<comment>UFI: Help ID .uno:Sortup is found in text/sdatabase/11090000.xhp so I deleted it here</comment></paragraph> </section> <section id="howtoget"> @@ -36,5 +39,26 @@ </variable></paragraph> <paragraph role="paragraph" id="par_id3150504"><variable id="dialogsortieren">To sort more than one data field, choose <emph>Data - Sort</emph>, then choose the <link href="text/shared/02/12100100.xhp">Sort Criteria</link> tab, where you can combine several sort criteria. </variable></paragraph> + +<section id="calcblock"> + <switch select="appl"> + <case select="CALC"> + <h2 id="hd_id31754054294817">Sorting a block of cells in %PRODUCTNAME Calc</h2> + <paragraph role="paragraph" id="par_id981754054305241">A block of cells is a rectangular range of cells surrounded by empty cells.</paragraph> + <paragraph role="paragraph" id="par_id91754054310945">%PRODUCTNAME Calc automatically identifies a block of cells for sorting. Place the cursor within the block, and the sorting will take place accordingly.</paragraph> + + <paragraph role="paragraph" id="par_id391754054316931">If all the cells in the first row of a block are text cells, this row is assumed to be the header. The sorting will then be performed from the second row to the last row of the block, except if all the block cells are text cells.</paragraph> + + <paragraph role="paragraph" id="par_id521754054328577">However, if any cell in the first row contains a numerical value, or all the block cells are text cells, the first row will not be considered a header, and sorting will be applied to the entire block.</paragraph> + + <paragraph role="paragraph" id="par_id691754054333553">The sorting is applied to the selected column or the first column of the block.</paragraph> + <paragraph role="paragraph" id="par_id961754054338368">If the selected column is inside the block, %PRODUCTNAME Calc prompts to extend the sorting to the adjacent columns.</paragraph> + </case> + </switch> +</section> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id291754055358278" localize="false"><embedvar href="text/shared/02/12020000.xhp#h1" markup="ignore"/></paragraph> + <paragraph role="paragraph" id="par_id291756055358278" localize="false"><embedvar href="text/scalc/01/12030000.xhp#h1" markup="ignore"/></paragraph> +</section> </body> </helpdocument> diff --git a/source/text/shared/02/12020000.xhp b/source/text/shared/02/12020000.xhp index f0282d7b8a..d39dd44a65 100644 --- a/source/text/shared/02/12020000.xhp +++ b/source/text/shared/02/12020000.xhp @@ -24,9 +24,12 @@ </topic> </meta> <body> +<bookmark branch="index" id="bm_id111754010692151"> +<bookmark_value>sort;descending</bookmark_value> +</bookmark> <bookmark branch="hid/.uno:SortDescending" id="bm_id1104741" localize="false"/> <section id="sortdescending"> -<h1 id="hd_id3154689"><link href="text/shared/02/12020000.xhp">Sort Descending</link></h1> +<h1 id="hd_id3154689"><variable id="h1"><link href="text/shared/02/12020000.xhp">Sort Descending</link></variable></h1> <paragraph role="paragraph" id="par_id3149987"><ahelp hid=".uno:SortDown">Sorts the data of the selected field or cell range in descending order.</ahelp> Text fields are sorted alphabetically, number fields are sorted by number.</paragraph> </section> <section id="howtoget"> @@ -34,5 +37,10 @@ </section> <embed href="text/shared/02/12010000.xhp#selektionsortieren"/> <embed href="text/shared/02/12010000.xhp#dialogsortieren"/> +<embed href="text/shared/02/12010000.xhp#calcblock"/> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id291754055358278" localize="false"><embedvar href="text/shared/02/12010000.xhp#h1" markup="ignore"/></paragraph> + <paragraph role="paragraph" id="par_id291854055358278" localize="false"><embedvar href="text/scalc/01/12030000.xhp#h1" markup="ignore"/></paragraph> +</section> </body> </helpdocument>
