Ui sortable static at top of the list năm 2024
|
When browsing Wikipedia you may encounter tables that have been made . A sortable table is identified by the arrows in one or more of its header cells. Clicking them will cause the table rows to sort in ascending order based on the selected column. A second click on the same arrow will sort in descending order. A third click will restore the original order of the whole table. For example; a third click causes List of countries by intentional homicide rate to reset to its original order by subregion. Show
The actual sorting process will happen on your computer using client-side JavaScript. For this reason it is only possible to use this functionality if you have JavaScript enabled in your web browser. The sorting process is also dependent on your computer and the amount of data. Sorting a very large table on a slow computer may take a long time. Example[edit]This is an example of a small sortable table. Rendered result name data more data cats 273 53 dogs 65 8,492 mice 1,649 548 Wiki source {| class="wikitable sortable" |- ! name ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} [edit]Tables with more complex headers than before now sort correctly. For example: Rendered result name data columns data more data cats 273 53 dogs 65 8,492 mice 1,649 548 Wiki source {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} Using two or more header rows, the sort arrows are placed on the bottom header row by default. They can be placed a maximum of one row higher by setting {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 6 at the top of the bottom header row. Default column 1 column 2 3 7 1 3 2 4 {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} Using {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 6 column 1 column 2 3 7 1 3 2 4 {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} Tables with complex data rows[edit]Tables can have cells spanning multiple rows, using {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 8. (See ). The number of rows must be indicated with each use of rowspan. Before any sorting can be done, the rowspan setup must be correct. The wikitext must be correct. An incorrect rowspan organization can break sorting, cause weird table formatting, move data to the wrong column, etc. See examples below. When sorted all the rows are filled. Tables without rowspan are much easier to maintain by less experienced editors, and by editors who are stopping by only once to edit the table. Correct rowspan numbers and wikitext, with sorting in working order: Rendered result name data year cats 273 2013 dogs 65 2014 mice 1,649 Wiki source {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} Note that, after sorting, the rowspanning cells are cut into rows and their content is repeated (the year "2014" in the example). If the original order of a table is restored by clicking a third time on the same arrow, then the cells will remain repeated and not revert to the original rowspan. See example below. The wikitext is incorrect. Line 17 should not exist. Compare to correct table above. Result in this case is an added empty column. Rendered result name data year cats 273 2013 dogs 65 2014 mice 1,649 Wiki source {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 | |} Online table editors and rowspan[edit]There is an easy online wiki table editor here:
It makes it easy to edit the text and links in individual cells of a table. It is especially easy when there are no rowspans in the body of a table. See the previous section. Without rowspans it is easier to change the underlying framework of a table, and move stuff around. Once the wikitext framework is simpler, the online table editor is simpler too, because you don't have to edit the wikitext as much in order to edit the table. Secondary key[edit]If a column contains a value multiple times then sorting the column preserves the order of the rows within each subset that has the same value in that column (). Thus sorting based on a primary, secondary, tertiary, etc. key can be done by sorting the least-significant key first, etc. For example, to sort the table below on the Text column, then the Numbers column, first click on the "Numbers" column heading (the secondary sort key), then the "Text" column heading (the primary sort key). Another way to sort a table using multiple sort keys is to hold down the shift key while clicking on the column headings for the subsequent sort keys. For example, to sort the table below on the Text column, then the Numbers column, first click on the "Text" column heading (the primary sort key), then hold down the shift key and click on the "Numbers" column heading (the secondary sort key). There can be a problem if the Google translation gadget is enabled in (in browsing section). It may seem like shift-click secondary sorting is not working because of the delay due to the translation popup for the name in the column head. It is not a problem if the sorting icons are in a separate row. See {{sort row}}. There are many browser translation addons that work as well or better than the gadget. The gadget can be turned on and off from the "More" menu at the top of any page. Numbers Text More text 4 a row 1 5 a row 2 1 b row 3 1 a row 4 2 x row 5 2 a row 6 3 a row 7 3 z row 8 3 z row 9 3 z row 10 3 z row 11 25 z row 12 Bottom Numbers Text More text 4 a row 1 5 a row 2 1 b row 3 1 a row 4 2 x row 5 2 a row 6 3 a row 7 3 z row 8 3 z row 9 3 z row 10 3 z row 11 25 z row 12 Bottom Options for more columns in a narrow screen[edit][edit]Rendered result name data more data another column cats 273 53 1 dogs 65 8,492 2 mice 1,649 548 3 Wiki source {| class="wikitable sortable" |- ! {{vert header|stp=1|name}} ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} ! {{vert header|stp=1|another column}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} This template also works with headers that span rows or columns (using rowspan and colspan). Note that there is no vertical bar {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 between {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 0 and {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 1 Rendered result name data columns another column data more data cats 273 53 1 dogs 65 8,492 2 mice 1,649 548 3 Wiki source {| class="wikitable sortable" |- ! rowspan=2 {{vert header|stp=1|name}} ! colspan=2 {{vert header|data columns}} ! rowspan=2 {{vert header|stp=1|another column}} |- ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} Sorting buttons in a separate row[edit]Note: From an someone using a screen reader wrote: "It's still very readable with the empty/clickable row, it's just more annoying to have to go past blank cells; I know they can occur in other circumstances, too. Perhaps this is one of these cases where a minor accessibility improvement loses out for now to better display on screens." There is a Phabricator task T35249 asking that the default location of the sorting icon be below the header text. To make a table more compact in narrow screens, the sorting buttons can be put in an extra header row below the header cells containing text. The sorting button always ends up in the lowest header cell. Add a line break {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 2 or non-breaking space {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 3 in one of the empty header cells. Otherwise the sorting row will be very narrow. If you are using the {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 4 attribute, it must be added to the header cell with the sorting icon. The sorting buttons can be centered with {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 5 in each sorting cell. For comparison, this is only done for the rightmost sorting cell below. Here is the table followed by the wikitext for the header cells. Rendered result name data columns data more data cats 273 53 dogs 65 8,492 mice 1,649 548 Wiki source {| class="wikitable sortable"
|-
! rowspan=2 | name
! colspan=2 | data columns
|-
! data
! more data
|-
! Sorting row template[edit]Note: {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 6 must go in the header cell with the sorting icon. So it will not work with {{sorting row}}. For more info go there. The {{sorting row}} template can create a sorting row with centered sorting icons. Redirect: {{sort row}} {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 7 - Number is for the number of columns. name data columns data more data cats 273 53 dogs 65 8,492 mice 1,649 548 Since {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 6 will not work with {{sorting row}}, use this sort row instead: |-
! Note that {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 is in a sorting cell as it must be in the lowest header cell to work. The break To center the sort buttons: {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 0 Creating sortable tables[edit]Tables can be made sortable via client-side JavaScript by adding {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 0 to their top line. These tables need to be properly formatted, with the right number of cells. Additionally you need to make sure that the headers of your column are properly indicated in the wikicode. For this the {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 1 character is used in the table syntax. If you are using the Visual editor, you can open the properties dialog of a table and select the sortable option. Simple example[edit]This is the wikisource of the table in the first section and shows the typical way to enable table sorting: {| class="wikitable sortable" |- ! name ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} The {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 1 indicates cells that are header cells. In order for a table to be sortable, the first row(s) of a table need to be entirely made up out of these header cells. You can learn more about the basic table syntax by taking the Introduction to tables. Initial sort order of rows[edit]When users are first presented with a table, the rows will always appear in the same order as in the wikitext. If you want a table to appear sorted by a certain column, you must sort the wikitext itself in that order. This is usually done for the first column. The VisualEditor makes it easy to move individual table columns and rows around. For info about that, and also about putting a table in initial alphabetical order see . Restrictions and exclusions[edit]Tables can only click-to-sort vertically downwards (clicking on a topmost-column-name will cause the rows of the table to re-order themselves in their up-and-down positions). It is not possible to click-to-sort horizontally across (there is no way to click on a leftmost-row-cell so as to cause the columns of the table to re-order themselves in their left-to-right positions). Making selected columns unsortable[edit]If you want a specific column not to be sortable, specify {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 3 in the attributes of its header cell. If you have a sorting row then {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 3 must be in the header cell with the sorting icon. (When using {{vert header}}, disable column sorting by omitting {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 5 in that template, which overrides anything placed before it.) Wiki source {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 2 Rendered result Numbers Unsortable 1 This 2 Column 3 Is 4 Unsortable 5 See? Total: 15 Excluding final rows from sorting[edit]Sometimes it is helpful to exclude the last row of a table from the sorting process. There are two methods to achieve this. [edit]You want a repeat of the header at the bottom. You do this by using the {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 1 (exclamation mark) syntax for all cells in the last row of the table. This will be recognized as a footer and the row will not be part of the sorting. This footer makes it a complex table, and so scopes help accessibility via screen readers. Wiki source {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 3 Rendered result Header as footer example Name Surname Height John Smith 1.85 Ron Ray 1.89 Mario Bianchi 1.72 Name Surname Height This applies to all rows at the end of the table that are consecutive and fully made up out of header cells. Those rows will not sort. [edit]This can be achieved using {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 7 on the desired table row (line starting with {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 8). Wiki source {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 4 Rendered result Summation footer example Name Surname Height John Smith 1.85 Ron Ray 1.89 Mario Bianchi 1.72 Average: 1.82 This is a complex table due to the "Average" cell spanning 2 columns. "Average" is also the row heading for the last row. Using the {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 1 (exclamation mark) syntax with {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 | |} 0 causes the correct header HTML to be generated, which aids in accessibility, e.g., for those using screen readers. It is possible to keep multiple lines fixed at the bottom, as long as the lines are consecutive. If the "sortbottom" rows are not consecutive, then when the original order of a table is restored by clicking a third time on the same arrow then rows with {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 7 will remain at the bottom even if they were not originally at the bottom. Excluding top rows from sorting[edit]This works the same as above for plain (non-header) rows at the top. This can be achieved using {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 6 on the desired table row (line starting with {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 8). It is possible to keep multiple lines fixed at the top, as long as the lines are consecutive. Configuring the sorting[edit]By default, the system tries to guess the data type in each column. It does this by looking at the first five rows and evaluating their contents. This process works most of the time but can also easily get confused if you have inconsistent values or additional specifiers that the system doesn't know about. To avoid this ambiguity you can force a particular data type or override the value of a cell. Forcing a column to have a particular data type[edit]The {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 4 attribute can be added inside the header of a column to ensure that the cells underneath are all treated as a specified type of data. It must go in the header cell with the sorting icon. It will not work in a header cell without a sorting icon. For example; when there are two rows of headers, the bottom row will always have the sorting icons. The following (case-insensitive) values are valid for {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 | |} 5:
data-sort-type=text[edit]{| class="wikitable sortable" |- ! {{vert header|stp=1|name}} ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} ! {{vert header|stp=1|another column}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 5 uses alphabetical sorting of text, but numbers are sorted numerically within that alphabetical sorting. See natural sort order. For example: Without {| class="wikitable sortable" |- ! {{vert header|stp=1|name}} ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} ! {{vert header|stp=1|another column}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 5 in the header, the tablesorter gets confused by the numeric titles in the first few rows into treating the entire column as numeric. This results in it wrongly sorting the non-numeric titles as zero regardless of the alphabetical ordering of their text. Note that if a column without declared sort-type contains only numeric values within the first top 5 cells, but with a reference {| class="wikitable sortable" |- ! {{vert header|stp=1|name}} ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} ! {{vert header|stp=1|another column}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 7 immediately after the last digit of at least one number in those first 5 cells, this may cause the column to be sorted as text. This can be avoided by declaring a different sort type such as: {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 Default data type of a column[edit]If you do not specify a {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 | |} 5, the sort modes (the data types, which, in addition to the choice "ascending" or "descending", determine the sorting order) are as follows: date (see also below)
If more than one possible type matches, the first type in the above order is chosen. For example, "24-12-2007" matches as a date, so is not treated as a number. Formatting and markup tags are ignored when determining the matching type. The sort mode is determined by the first 5 non-blank rows below the header after loading the page. This can also change after deleting a row, or adding a column. Therefore, it is wise to make sure that every element matches the criterion for the required data type. Using a this can be done very conveniently. The method of making sure the sort mode of each column is as desired, is specify a {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 | |} 5, see . Specifying a sort key for a cell[edit]Sometimes the value of a cell is not correctly parsed or one wants to sort the row in a special way. (e.g. a cell containing 'John Doe' should actually be sorted as 'Doe' and not as 'John'). This can be easily achieved by using {| class="wikitable sortable" |- ! rowspan=2 {{vert header|stp=1|name}} ! colspan=2 {{vert header|data columns}} ! rowspan=2 {{vert header|stp=1|another column}} |- ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 4, like this: {| class="wikitable sortable" |- ! rowspan=2 {{vert header|stp=1|name}} ! colspan=2 {{vert header|data columns}} ! rowspan=2 {{vert header|stp=1|another column}} |- ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 5. Alternatively, you can set the {| class="wikitable sortable" |- ! rowspan=2 {{vert header|stp=1|name}} ! colspan=2 {{vert header|data columns}} ! rowspan=2 {{vert header|stp=1|another column}} |- ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 6 attribute. Wiki source {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 5 Rendered result Name and surname Height John Smith 1.85 Ian Ray 1.89 Zachary Bianchi 1.72 Average: 1.82 It is especially handy to sort military ranks in rank-seniority order. Wiki markup {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 6 This gives: Name and surname Rank John Smith Cpl Ian Ray Capt Zachary Bianchi 2 Lt See also . If you have a list where all the entries start with quotes ("), and you want to set a sort key for one of the entries, then you will need to use the HTML name or number for quotes at the beginning of that sort key. See too. Lists of song titles for example sometimes have each song title in quotes. So to sort by a particular word in a song title use one of these: {| class="wikitable sortable" |- ! rowspan=2 {{vert header|stp=1|name}} ! colspan=2 {{vert header|data columns}} ! rowspan=2 {{vert header|stp=1|another column}} |- ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 7 {| class="wikitable sortable" |- ! rowspan=2 {{vert header|stp=1|name}} ! colspan=2 {{vert header|data columns}} ! rowspan=2 {{vert header|stp=1|another column}} |- ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 8 Keeping some rows together[edit]{| class="wikitable sortable" |- ! rowspan=2 {{vert header|stp=1|name}} ! colspan=2 {{vert header|data columns}} ! rowspan=2 {{vert header|stp=1|another column}} |- ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 6 can be used to keep certain rows together. The specified order of these rows is preserved. An example is to keep "South Holland" immediately after "Netherlands", whatever the sort order or column: Rendered result Country/province Capital France Paris Netherlands Amsterdam South Holland The Hague Poland Warsaw UK London Wiki source {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 7 If you have rows that contain colspans, this might become a little difficult. You can also use the {| class="wikitable sortable"
|-
! rowspan=2 | name
! colspan=2 | data columns
|-
! data
! more data
|-
! 0 on a row; it will then always be below the row just above it in the table source, wherever that row may be sorted in the table. Rendered result Country Capital France Paris In Paris is the Eiffel Tower. UK London In the U.K. you cannot pay with euros, and you drive on the left. Germany Berlin Germany includes the former DDR. Wiki source {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 8 Examples of datatype auto detection. First 5 cells in a column[edit]The script sees what the first 5 cells in a column contain. The sorting mode becomes numeric if the first 5 cells contain a number only (comma and period used in number formatting are accepted as number). The numeric sorting order is maintained even when text is found in the cells that follow the 5th cell. 123,564,589.7e12 is in scientific notation and is treated as a number. An empty cell is treated as a non-number when sorting numerically. There is an empty cell initially at the bottom of each of the 2 tables just below. Datatype auto detection is inconsistent. It is always better to add a {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 | |} 5 to the column header. Sort order auto-detected as text 123,564,589.7e12 9 70 80 approx-80 abc 80 aaa 600 300,000,000 3,000,000 Sort order auto-detected as number 123,564,589.7e12 9 70 -80 600 80 approxabc 80 aaa 300,000,000 3,000,000 Single currency character, or single alphabetic character, does not currently change what the script determines via the first 5 cells in a column: Numerical order. currencies $ 9 $ 80 $ 70 $ 600 currencies € 9 € 80 € 70 € 600 currencies £ 9 £ 80 £ 70 £ 600 currencies ¥ 9 ¥ 80 ¥ 70 ¥ 600 Percentage sign does not change from determination as numerical order. Number combinations with minus or divide signs within them are still detected as numbers. Their numerical ordering though is determined by the number before the minus or divide sign. Percentage 7% 2 4 22 111 Number combinations 7-4 2 4 22/7 111 A plus sign in an empty cell among the first 5 cells breaks default numerical sorting. As does a plus sign after a number if it is in one of the first 5 cells in a column. Sort order auto-detected as text 400 40,000 + 60,000 20,000 6,000 5,000 Sort order auto-detected as text 400 40,000 300+ 60,000 20,000 6,000 5,000 Numerical sorting problems[edit]Note: See the section above about datatype auto detection via the first 5 cells in a column. Most of these problems can now be fixed by manually specifying the sort mode of a column by putting {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 in the column header. See the example tables above and below. See also and the section about forcing the sort mode of a column. To work {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 needs to be in the header cell that contains the sorting icon. In tables with multi-row headers, the sorting icon will be in the lowest header cells. References {| class="wikitable sortable" |- ! {{vert header|stp=1|name}} ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} ! {{vert header|stp=1|another column}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 7 after a number in any cell (including the first five cells) no longer break numerical sorting. Text breaks default numerical sorting if it is before or after a number in one of the first 5 cells in a column. A colon by itself (to signify no data, for example) in one of the first 5 cells in a column breaks numerical sorting. Even when using {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 in the column header, text in front of a number in any cell breaks numerical sorting of that cell. Text after a number is not a problem if the sort order of a column is specified by using {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9. Leading zeroes are not necessary for numerical sorting of a column. If it seems that way, then that means the column is being sorted alphabetically. Look in the first 5 cells for anything other than numbers, and correct those cells according to these rules. Better yet, add {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 to the column header. Later editing by other editors will not break numerical sorting. A dash, of any kind, in a blank cell in one of the first 5 cells in a column breaks default numerical sorting of a column. A dash in front of a number does not break numerical sorting. Dashes are allowed anywhere in cells if {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 is used in the column header. The {{N/A}} template in the first five cells of a column is inconsistent in its effect on automatic datatype detection. It is always better to specify a {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 | |} 5 in the column header. c. for circa[edit]"c." (circa, indicates "approximately") is often found in columns of numbers and dates. It often breaks sorting. The addition of {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 4 to the column header does not allow c. to be put in front of the number. Using the {{circa}} template fixes sorting when c. is in front of the number, but only if the |-
! 1 parameter is added to the template. See: Template:Circa/doc/sortable. |-
! 2 c. NUMBER Alternatively, c. can be put after the number. Or it can be moved to a different column. Numerical ranges[edit]Note: Most problems are fixed by adding {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 to the column header. It also prevents problems caused by later editing. A dash after a number no longer breaks default numerical sorting of a column. Therefore, a range (30–40) now works. A plus sign after a number breaks default numerical sorting if it is in one of the first 5 cells in a column. A plus sign in an otherwise empty cell breaks default numerical sorting of a column. That is if the cell is one of the first 5 cells in the column. You can also use 2 columns for a range if you want to sort by either the lower or upper range. If you want the upper range to sort best all cells need to be filled in with numbers. For example, you can use the same number in both the lower and upper range. You can also add a plus sign after the number in the upper range. The first set of tables below do not sort correctly, except for the lower range which has no complicating factors. Note that "400+" and "400 +" do not sort correctly in their columns. These tables do not have {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 in their column headers. One column Estimated attendance 400 + 40,000+ 200,000–400,000 400,000+ 60,000–350,000 40,000 40,000–50,000 20,000–100,000 10,000–100,000 6,000–7,000 5,000–10,000 One column Estimated attendance 400+ 40,000+ 200,000–400,000 400,000+ 60,000–350,000 40,000 40,000–50,000 20,000–100,000 10,000–100,000 6,000–7,000 5,000–10,000 Two columns Estimated attendance (lower) (upper) 400 400+ 40,000 40,000+ 200,000 400,000 400,000 + 60,000 350,000 40,000 40,000 50,000 20,000 100,000 10,000 100,000 6,000 7,000 5,000 10,000 {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9 has fixed the sorting in the tables below. Note the sorting of 400+ and 400 +. One column Estimated attendance 400 + 40,000+ 200,000–400,000 400,000+ 60,000–350,000 40,000 40,000–50,000 20,000–100,000 10,000–100,000 6,000–7,000 5,000–10,000 One column Estimated attendance 400+ 40,000+ 200,000–400,000 400,000+ 60,000–350,000 40,000 40,000–50,000 20,000–100,000 10,000–100,000 6,000–7,000 5,000–10,000 Two columns Estimated attendance (lower) (upper) 400 400+ 40,000 40,000+ 200,000 400,000 400,000 + 60,000 350,000 40,000 40,000 50,000 20,000 100,000 10,000 100,000 6,000 7,000 5,000 10,000 Date sorting problems[edit]The {{Date table sorting}} or {{dts}} template will work with any combination of years, months, days. See example here. See template documentation and section farther down for more info. Month names[edit]All sorting involving month names may fail for registered users who have changed the default language setting "en - English" at Special:Preferences (reported at phab:T126744). It affects relatively few users on the English Wikipedia and can be ignored. Year only[edit]Year sorting of a column works as long as the year is the first text in each cell in the column. Adding |-
! 6 to the column header does not change this. Text is OK after a year in a cell. "FY" (fiscal year), for example, should go after the year. References after the year are OK. Put "c." after the year, or use "est." after the year instead. A dash, of any kind, in a blank cell breaks year sorting of a column. Dashes after the year are OK. Unlike for numerical sorting the {{N/A}} template in any cell in a year column does not break year sorting of that column. If there are problems with year sorting check for any cells in the column with text or a dash (of any kind) as the first thing in a cell. Remove that text or dash, and the column should sort correctly. Year and month[edit]Date sorting does not work for columns with only the year before the month (no day). Adding |-
! 6 or |-
! 8 to the column header does not help. Click each column header a couple times in the tables below to see. Note the column headed |-
! 8 may sort correctly in some browsers, but it is not reliable. Year and month in numerical form (YYYY-MM) works with |-
! 8 (see relevant section farther down). Year and month 1999 Dec 1999 Jan 2004 May 2004 Aug Year and month 1999 December 1999 January 2004 May 2004 August Year and month |-
! 6 1999 Dec 1999 Jan 2004 May 2004 Aug Year and month |-
! 6 1999 December 1999 January 2004 May 2004 August Year and month {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 03 1999 December 1999 January 2004 May 2004 August Month and year[edit]Date sorting does not work for columns with only the month before the year (no day). Adding |-
! 6 to the column header does not help. Month and year Dec 1999 Jan 1999 May 2004 Aug 2004 Month and year December 1999 January 1999 May 2004 August 2004 Month and year |-
! 6 Dec 1999 Jan 1999 May 2004 Aug 2004 Month and year |-
! 6 December 1999 January 1999 May 2004 August 2004 Month, day, and year[edit]Sorting works correctly in all the tables below. Years before 100 (for example, year 99) break sorting. If a number for a day is missing, sorting is broken. Month, day, year Dec 5, 1999 Jan 7, 1999 May 14, 2004 Aug 4, 2004 Month, day, year December 5, 1999 January 7, 1999 May 14, 2004 August 4, 2004 Month, day, year |-
! 6 Dec 5, 1999 Jan 7, 1999 May 14, 2004 Aug 4, 2004 Month, day, year |-
! 6 December 5, 1999 January 7, 1999 May 14, 2004 August 4, 2004 Day, month, and year[edit]Sorting works correctly in all cases below. Years before 100 (for example, year 99) break sorting. If a number for a day is missing, sorting is broken. Day, month, year 5 Dec 1999 7 Jan 1999 14 May 2004 4 Aug 2004 Day, month, year 5 December 1999 7 January 1999 14 May 2004 4 August 2004 Day, month, year |-
! 6 5 Dec 1999 7 Jan 1999 14 May 2004 4 Aug 2004 Day, month, year |-
! 6 5 December 1999 7 January 1999 14 May 2004 4 August 2004 Year, month, day. Using words for months[edit]Sorting does not work for this date order. data-sort-type=date data-sort-type=isoDate The addition of any data-sort-type to the column header does not help. See examples below. Date no data-sort-type 2007 January 5 2007 February 12 2007 March 9 2007 April 1 2007 May 23 2007 June 29 Date data-sort-type=date 2007 January 5 2007 February 12 2007 March 9 2007 April 1 2007 May 23 2007 June 29 Date data-sort-type=isoDate 2007 January 5 2007 February 12 2007 March 9 2007 April 1 2007 May 23 2007 June 29 Year, month, day. Using numbers. ISO date YYYY-MM-DD[edit]See: ISO date. "±YYYY-MM-DD", with 1 to 4 digits for year "YYYY" from -9999 to 9999. Year by itself is fine. As is the year followed by just the month. Some stuff after the date is allowed. Such as references after the date. To save header space you can add a tooltip to the "Date" column header instead of "year, month, day" below it. See: Template:Tooltip. Tooltips have been added to the tables in this section. See section higher up: . Datatype auto detection is inconsistent. That is why ISO date sorting works best with |-
! 8 added to the column header. It also avoids problems when only one digit is used for the month or day. Leading zeros are no longer needed. All tables below have |-
! 8 added to the column headers. Remember to leave a space in the wikitext before years that are a negative number. Otherwise, {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 8 will be used as table formatting instead of {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 9. "c." stands for circa (approximately). "c." before the date breaks sorting in the first table. Using the {{circa}} template fixes sorting, but only if the |-
! 1 parameter is added to the template. See: Template:Circa/doc/sortable. See: . Date With "c." Sorting broken. -90 c. 90 90-7-13 90-12-5 1011-08-01[2] c. 207-11[1] Date "c." removed. Sorting works. -90 90 90-7-13 90-12-5 1011-08-1[2] 207-11[1] Date {{circa}} used. Sorting works. -90 c. 9090-7-13 90-12-5 1011-08-01[2] c. 207-11[1] {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 9 Adding BCE, CE, BC, etc. after the date does not break sorting. But adding AD before the date breaks sorting. Test additions before and after dates. Additions before the date are almost always a problem. Date BCE added after. Sorting works. -90 BCE c. 9090-7-13 90-12-5 1011-08-1[2] c. 207-11[1]Date AD added before. Sorting broken. -90 BCE AD c. 9090-7-13 90-12-5 1011-08-1[2] c. 207-11[1] Years BC are a problem[edit]Note. See also the section farther down about the date table sorting template. It has additional info about dealing with negative years (BC, BCE). From this version of List of reported UFO sightings. The "Antiquity" section has a table with some hidden notes. Adapted here: To sort the dates before AD 1000 you will need one of the following:
The date column it is referring to was pulled out of the larger table, simplified, and placed below. It is sorting correctly. Look at the wikitext to see the methods discussed in the hidden notes. {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 0 Date c. 1440 BC218 BC 76 BC 7 BCAD 65 AD 196 AD c. 740 Date table sorting template: Day and month, Many other date formats[edit]The simplest way to format sortable dates in a table is to use the {{Date table sorting}} template. A redirect: {{dts}} It can be used with many date formats mixed together. Note the many formats used here. See template documentation for more info. See example tables below. They all sort correctly. The wikitext for the first entry in each table in the first row is shown in the table header. Note: None of the table columns use the {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 19 modifier. Using {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 19 can sometimes break sorting when used with the template. Date (Day and month only) {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 214 Jan 28 Aug 3 Jan 29 Aug 14 Dec 1 Jan Date (Month and day only) {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 22January 4 August 28 January 3 August 29 December 14 January 1 Date (Month, day, year) {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 23April 27, 1990 August 8, 1989 February 3, 2006 October 4, 2006 November 1, 2004 January 11, 2004 {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 1 Dates. Various formatsJan 1980 Aug 1981 1992 August 28, 1993 April 27, 1990 August 8, 1989 Issues. Years BC, etc[edit]For years BC, {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 24 can be used for -0062-09-23 (62 BC): Simply subtract the year BC from 10,000.
Date sorting works by formatting dates so they can be sorted numerically. For example:
or
...for 21 July 2001. The {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 27 style can be used to hide a sortable numeric date before the displayed date. See wikitext of table just below. Alternatively, {{Date table sorting}} does this automatically, and is recommended in most cases. Displayed What is being sorted 2006-12-03 2006-12-03 0000-03-27 0000-03-27 December 2006 2006-12 April 64 BC !9936-04 -0099-07-13 !9900-07-13 -0062-09-23 !9937-09-23 -0062-10-08 !9937-10-08 -0001-12-21 !9998-12-21 2006-11-08 2006-11-08 0304-12-31 0304-12-31 2005-05-15 2005-05-15 You can use July 7, 2012 etc. to get sortable dates. Example, including one date with a different display format: Rendered result DateJanuary 7, 2012 May 7, 2012 4 July 2012 July 7, 2012 Wiki source {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 2 Before year 100. Any date format[edit]Note: This no longer seems to be working. Sorting can be done via the hidden {| class="wikitable sortable" |- ! rowspan=2 {{vert header|stp=1|name}} ! colspan=2 {{vert header|data columns}} ! rowspan=2 {{vert header|stp=1|another column}} |- ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 6 using the ISO date. Combined with |-
! 8 Note: The sorting wikitext is the same for the 2 tables below. Any date format can be shown to the readers. Date 5 Dec 111 7 Jan 35 5 Dec 207 111 BC 7 Jan 35 BC Dec 207 BC {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 3 The table below uses the same isoDate values for {| class="wikitable sortable" |- ! rowspan=2 {{vert header|stp=1|name}} ! colspan=2 {{vert header|data columns}} ! rowspan=2 {{vert header|stp=1|another column}} |- ! {{vert header|stp=1|data}} ! {{vert header|stp=1|more data}} |- | cats | 273 | 53 | 1 |- | dogs | 65 | 8,492 | 2 |- | mice | 1,649 | 548 | 3 |} 6 as the above table. But multiple formats are used for showing the dates to the reader. Date 5 Dec 111 7 January 35 Dec 5, 207 about 111 BC Jan 7, 35 BC December 207 BC {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 4 [edit]Adding color with the shorthand {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 31 property in a header may cause that column to lose its sorting button – see phab:T33755. Example with the "Name" header: Name Surname Height John Smith 1.85 Ron Ray 1.89 Mario Bianchi 1.72 Average: 1.82 Use the more specific {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 32 to make things work correctly. Example: {| class="wikitable sortable" |- ! column 1 ! column 2 |- ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 5 Produces this sortable table: Name Surname Height John Smith 1.85 Ron Ray 1.89 Mario Bianchi 1.72 Average: 1.82 Tips and tricks[edit]Padding[edit]Sometimes entries are padded on the left for alignment purposes. This can adversely affect how they are sorted. Non-breaking spaces[edit]The effect of left-padding with non-breaking space codes {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 3 which render as blank spaces, depends on the browser: in IE they are (unlike actual blank spaces) counted for sorting as leading blank spaces, so in a list of numbers with text (for which the alphabetic sorting mode applies) they could be used to equalize the number of characters before the explicit or implicit decimal separator. However, in Firefox they are ignored for the purpose of sorting. Sorting using {| class="wikitable sortable" |- ! column 1 ! column 2 |- class="sorttop" ! style="text-align:left;" | 3 ! style="text-align:left;" | 7 |- | 1 | 3 |- | 2 | 4 |} 3 works on IE but not on Firefox Name 100.3 FM Third 89.5 FM First 107.3 FM Fourth 95.3 FM Second See also . Padding with zeros[edit]Example:
Formatnum can be combined with padleft: Integer
Real
Controlling sorting and display[edit]Text undesired for sorting but needed for display:
Text undesired for display but needed for sorting:
Combining the two, we can have displayed text independent of text used for sorting, by fully hiding the latter, and fully putting the former in a separate column (in date sorting mode and numeric sorting mode) or in the same column after the hidden text (in alphabetic sorting). Fully putting the displayed text in a separate column may look ugly if it is not done consistently for a whole column, but only for elements that require this (e.g. if most entries in a column are single numbers, but some are ranges). Sorting with increase/decrease/steady templates[edit]Example Without key With key Apple To enable sorting of cells with Template:Increase, Template:Decrease or Template:Steady, add a sort key, e.g. {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 372, {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 381 or {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 39. To fix an existing table, use Search and replace (right icon in the Advanced toolbar) with Treat search string as a regular expression selected to do the following replacements: Search for Replace with {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 40 {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 41 {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 42 {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 43 {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 44 {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 45 Maintaining tables sorted alphabetically or by rank[edit]It used to be difficult to maintain tables in rank order, and to keep the numbering correct. That is no longer true. Template:Static row numbers renumbers the row numbers after every change in row order. And after every addition or deletion of rows. Putting a table in initial alphabetical order[edit]There are fast and slow ways to do this. Unfortunately, the Visual Editor does not have a fast way to quickly alphabetize a table. You can manually move rows around one at a time. Click on a cell in a row. Then click on the arrow that shows up at the left of the row. Then click on "move above" or "move below" as needed. If this is buggy or is not working, the rows can be moved around in the wikitext by cutting and pasting rows in the wikitext. A fast way is to launch free LibreOffice Calc, or another spreadsheet program. To see how go to . For more info see Commons:Convert tables and charts to wiki code or image files. There is another way to alphabetize a table, and it keeps all the styling and flag links that a spreadsheet may remove. One can use NoteTab Light (freeware version of NoteTab). But for this to work, all the wikitext for a row must be on one line. That means the cells in that row are separated by double bars {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 46. To alphabetize the list by the first column paste the table wikitext into a new NoteTab Light page. Select the rows you want to alphabetize. Then click on the "modify" menu, then "lines", then "sort", and then "ascending". That will put "A" at the top and "Z" at the bottom. Then put back {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 8 (wikitext for row) between each line. Do that via find-and-replace by replacing {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 48 with {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 49 {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 48 is the underlying text editor code for line breaks in NoteTab. {| class="wikitable sortable" |- ! name ! data ! year |- | cats | 273 | 2013 |- | dogs | 65 | rowspan=2 | 2014 |- | mice | 1,649 column 3 spanned by cell "2014"> |} 8 is the wikitext for a table row. If there are blank lines between the entries replace {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 52 with {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 49 Copy the wikitext and paste it back into the article. Save the page. Initial alphabetical sort versus initial sort by rank order[edit]It is a good idea to keep lists and tables in some kind of initial non-random sort order. It no longer matters what method you choose. Template:Static row numbers will maintain row numbering automatically no matter what changes you make to the row order. Removing an old rank column (1,2,3) from a table[edit]You can remove the rank column cells quickly. It is much easier now with the table editor in the VisualEditor. Click on the header in the column you want to delete. An arrow will show up at the top of the column. Click the arrow, and then "delete column". Then let Template:Static row numbers create the row number column. Auto-ranking or adding a row numbering column (1,2,3)[edit]There are Phabricator threads asking for a way to easily add static row numbers to tables. See phab:T42618. It supersedes phab:T42634. In the meantime there is Template:Static row numbers. It is easy to use now. It is a template to automatically add row numbers to sortable tables. The row numbers will not be sorted when columns of data are sorted. A possible note to add above a table: Row numbers are static. Other columns are sortable. This allows ranking of any column. See list of articles transcluding {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 54. See . It has some subtemplates that work with it. Go to {{static row numbers}} for more details. To see the template in use: List of U.S. states and territories by incarceration and correctional supervision rate. Note that {| class="wikitable sortable" |- ! rowspan=2 | name ! colspan=2 | data columns |- ! data ! more data |- | cats | 273 | 53 |- | dogs | 65 | 8,492 |- | mice | 1,649 | 548 |} 55 is selectively used to narrow columns with wordy header text without using breaks The selective use of max-width allows the state names to spread out, and stay on one row each if the screen is wide enough. This allows easier scanning down or across the rows. Yet when the screen becomes narrower and narrower, the state names will eventually wrap. This is good for cell phones. Use em unit settings instead of px. Em units expand in width as the font size is increased. Be sure to check both mobile and desktop views (links at bottom of page). Check to see that header rows aren't being given a row number. Also check that the max-width settings aren't too tight. Mobile view may need a slightly larger max-width setting for some columns. And different desktop browsers, and different settings for them, can make some max-width settings cause some column header text to overlap into the adjacent column. So it is usually good to add some extra em units to the max-width settings. Alphabetic sorting order[edit]data-sort-type:text - Sort the following table to see an example of the alphabetic sort order. Note that sorting is case-insensitive: the two-character entries such as A1 demonstrate that A and a are at the same position. Test ! " # $ % & ' ( ) * + , - . / 0 9 : ; < = > ? @ [ \ ] ^ _ ' A Z a z A1 Z1 a1 z1 { | } ~ — É é É1 é1 † Numerical sorting order examples[edit]data-sort-type:number - Sort the following table to see an example of the numerical sort order. mixed notations Test 1.4285714285714E+17 1000000000000000000 -1000000000000000000 .0000000000000000001 -.0000000000000000001 -1.4285714285714E+17 1.4285714285714E-13 -1.4285714285714E-13 89 123 456 788 89,123,456,789 14 -14 11 -12 (retrograde) 12 or 13 12 (?) c. 12 12 (approx.) ? 333 1e10 e 9 e 80 e 70 e 600 999e9 88e80 7e270 999e-9 88e-80 7e-270 -999e9 −999e9 -88e80 -7e270 -999e-9 -88e-80 -7e-270 e3 -e3 1e3 e9 e80 e270 6e11 8e11 See also[edit]
Notes[edit]Shorthand CSS properties allow several sub-properties to be set by a single property and "when values are omitted from a shorthand form, unless otherwise defined, each 'missing' sub-property is assigned its [default] value. This means that a shorthand property declaration always sets all of its sub-properties, even those that are not explicitly set. Carelessly used, this might result in inadvertently resetting some sub-properties." Certain required CSS background properties set on sortable table headers could be overruled by background rules stated on a per-table basis. |
