diff options
author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-04-09 12:38:26 -0300 |
---|---|---|
committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-04-10 23:23:58 +0200 |
commit | c2b91a5c78e053498f5ff6a411c314e36eb4a859 (patch) | |
tree | a5bd0b19b25c4ca365d14bcd8565528e9abd88f0 /source/text | |
parent | af2fc2b7c1d2226ce628f60415fd384ffc75a342 (diff) |
Stick to translatable content and simplify.
* The example was locale dependent and was removed.
Change-Id: I1df47fb5ba18ca4874b8b681ffff88a6fa7514aa
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/165910
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text')
-rw-r--r-- | source/text/scalc/01/func_sortby.xhp | 150 |
1 files changed, 0 insertions, 150 deletions
diff --git a/source/text/scalc/01/func_sortby.xhp b/source/text/scalc/01/func_sortby.xhp index d22710928e..332005731a 100644 --- a/source/text/scalc/01/func_sortby.xhp +++ b/source/text/scalc/01/func_sortby.xhp @@ -30,158 +30,8 @@ <paragraph role="paragraph" id="par_id291711544460323"><emph>SortByRange1, SortByRange2,... </emph>: Range 1, range 2,... are the arrays or ranges to sort on.</paragraph> <paragraph role="paragraph" id="par_id501711544465886"><emph>SortOrder1, SortOrder2,...</emph> : Order 1, order 2,... are the orders to use for sorting. 1 for ascending, -1 for descending. Default is ascending.</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> -<section id="ex_func_average_table"> - <paragraph role="paragraph" id="hd_id2609201512474295">Consider the following table</paragraph> - <table id="table_averageif_example"> - <tablerow> - <tablecell> - </tablecell> - <tablecell> - <paragraph id="par_id2509201517430799" role="tablehead" localize="false">A</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id250920151743116" role="tablehead" localize="false">B</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2509201517431582" role="tablehead" localize="false">C</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id2509201517431967" role="tablehead" localize="false">1</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id18260631312423" role="tablecontent" localize="false">Product Name</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2509201517433075" role="tablecontent" localize="false">Sales</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2509201519383294" role="tablecontent" localize="false">Revenue</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id959660094035" role="tablehead" localize="false">2</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2855779586764" role="tablecontent" localize="false">pencil</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id110202156219769" role="tablecontent" localize="false">20</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id23281929326512" role="tablecontent" localize="false">65</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id2509201517432278" role="tablehead" localize="false">3</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id24967262611733" role="tablecontent" localize="false">pen</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2509201517433391" role="tablecontent" localize="false">35</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id250920151938352" role="tablecontent" localize="false">85</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id250920151743267" role="tablehead" localize="false">4</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id252542413030532" role="tablecontent" localize="false">notebook</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2509201517433781" role="tablecontent" localize="false">20</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2509201519383822" role="tablecontent" localize="false">190</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id2509201519371339" role="tablehead">5</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2509201519374677" role="tablecontent" localize="false">book</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2509201519373350" role="tablecontent" localize="false">17</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id2509201519384171" role="tablecontent" localize="false">180</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id591711556978009" role="tablehead" localize="false">6</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id491711556981497" role="tablecontent" localize="false">pencil-case</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id981711556984697" role="tablecontent">not</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id581711556987385" role="tablecontent">not</paragraph> - </tablecell> - </tablerow> - <tablerow> - <tablecell> - <paragraph id="par_id21711558790356" role="tablehead" localize="false">7</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id611711558792980" role="tablecontent" localize="false">pen</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id531711558796019" role="tablecontent" localize="false">10</paragraph> - </tablecell> - <tablecell> - <paragraph id="par_id1001711558799131" role="tablecontent" localize="false">45</paragraph> - </tablecell> - </tablerow> - </table> -</section> -<h4 id="hd_id751711480783220">Example with ascending order and descending order (for English locale)</h4> <paragraph role="paragraph" id="par_id131711466000482"><input>{=SORTBY(A2:C7,A2:A7,1,C2:C7,-1)}</input></paragraph> <paragraph role="paragraph" id="par_id471711472262161">Sort the range A2:C7 based on the first column in ascending order and third column in descending order.</paragraph> -<table id="result"> - <tablerow> - <tablecell><paragraph id="par_id131711562867138" role="paragraph" localize="false">book</paragraph></tablecell> - <tablecell><paragraph id="par_id191711562870330" role="paragraph" localize="false">17</paragraph></tablecell> - <tablecell><paragraph id="par_id541711562873250" role="paragraph" localize="false">180</paragraph></tablecell> - </tablerow> - <tablerow> - <tablecell><paragraph id="par_id711711562876682" role="paragraph" localize="false">notebook</paragraph></tablecell> - <tablecell><paragraph id="par_id751711562882018" role="paragraph" localize="false">20</paragraph></tablecell> - <tablecell><paragraph id="par_id731711562884834" role="paragraph" localize="false">190</paragraph></tablecell> - </tablerow> - <tablerow> - <tablecell><paragraph id="par_id411711562887786" role="paragraph" localize="false">pen</paragraph></tablecell> - <tablecell><paragraph id="par_id71711562890593" role="paragraph" localize="false">35</paragraph></tablecell> - <tablecell><paragraph id="par_id771711562894241" role="paragraph" localize="false">85</paragraph></tablecell> - </tablerow> - <tablerow> - <tablecell><paragraph id="par_id441711562897126" role="paragraph" localize="false">pen</paragraph></tablecell> - <tablecell><paragraph id="par_id481711562903505" role="paragraph" localize="false">10</paragraph></tablecell> - <tablecell><paragraph id="par_id761711562907000" role="paragraph" localize="false">45</paragraph></tablecell> - </tablerow> - <tablerow> - <tablecell><paragraph id="par_id271711562909933" role="paragraph" localize="false">pencil</paragraph></tablecell> - <tablecell><paragraph id="par_id591711562914472" role="paragraph" localize="false">20</paragraph></tablecell> - <tablecell><paragraph id="par_id781711562918184" role="paragraph" localize="false">65</paragraph></tablecell> - </tablerow> - <tablerow> - <tablecell><paragraph id="par_id441711562922161" role="paragraph" localize="false">pencil-case</paragraph></tablecell> - <tablecell><paragraph id="par_id981711562925887" role="paragraph" localize="false">not</paragraph></tablecell> - <tablecell><paragraph id="par_id361711562929239" role="paragraph" localize="false">not</paragraph></tablecell> - </tablerow> -</table> - <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/00/avail_release.xhp#24.8"/> <embed href="text/scalc/01/common_func.xhp#notODFF"/> |