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: {{noprint|'''''Row numbers''' are static. Other columns are sortable. This allows ranking of any column.''}}
These templates work together and make table formatting fast:
Place template before table where the automatic row numbers are required. Add class static-row-numbers to the table wikitext, as in the following example. It adds an unsorted column of row numbers.
With wikitable and sortable
Name
Number
Another Number
A
10
1000
B
50
800
C
100
150
D
20
700
E
70
350
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers"
! Name !! Number !! Another Number
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|}
Usage with sortable
With sortable
Name
Number
Another Number
A
10
1000
B
50
800
C
100
150
D
20
700
E
70
350
{{Static row numbers}}
{| class="sortable static-row-numbers"
! Name !! Number !! Another Number
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|}
Usage with no other classes
While designed to provide a static row number for sortable tables, it can be used just to add an automatic row number to plain tables.
With no other classes
Name
Number
Another Number
A
10
1000
B
50
800
C
100
150
D
20
700
E
70
350
{{Static row numbers}}
{| class="static-row-numbers"
! Name !! Number !! Another Number
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|}
Using static-row-header-text to add a "No." column header
This adds a "No." as the row number column header. Add class=static-row-header-text to the top line of the table wikitext. It does not work with {{Static row numbers table}}.
With static-row-header-text to add a column header
Name
Number
Another Number
A
10
1000
B
50
800
C
100
150
D
20
700
E
70
350
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers static-row-header-text"
! Name !! Number !! Another Number
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|}
Using static-row-header-hash to add a hash ("#") column header
This adds a hash ("#") as the row number column header.
With static-row-header-hash to add a column header
Name
Number
Another Number
A
10
1000
B
50
800
C
100
150
D
20
700
E
70
350
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers static-row-header-hash"
! Name !! Number !! Another Number
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|}
Marking additional header and footer rows with static-row-header
The class static-row-header is added to additional header rows (other than the first one). It prevents those header rows from having row numbers. It also prevents them from being sorted. It is important to add this class for consistent appearance in different Wikipedia skins and views. It is necessary for correct numbering in the minerva skin on mobile view which renders HTML tables differently.
Marking additional header and footer rows with static-row-header
Name
Number
Another Number
(unit)
(per capita)
A
10
1000
B
50
800
C
100
150
D
20
700
E
70
350
Totals
250
3000
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers"
! Name !! Number !! Another Number
|- class="static-row-header"
! !! (unit) !! (per capita)
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|- class="static-row-header"
! Totals !! 250 !! 3000
|}
Marking footer or header rows that also contain data cells (non-header cells)
To prevent them from sorting class=sorttop or class=sortbottom must also be added.
Marking footer or header rows that also contain data cells (non-header cells)
Name
Number
Another Number
(unit)
(per capita)
A
10
1000
B
50
800
C
100
150
D
20
700
E
70
350
Totals
250
3000
{{Static row numbers}}
{| class="wikitable sortable static-row-numbers"
! Name !! Number !! Another Number
|- class="static-row-header"
! !! (unit) !! (per capita)
|-
| A || 10 || 1000
|-
| B || 50 || 800
|-
| C || 100 || 150
|-
| D || 20 || 700
|-
| E || 70 || 350
|- class="sortbottom static-row-header"
! Totals
|| 250 || 3000
|}
This works whether or not there is a header cell in the "totals" row. The row will not sort. The row will not have a row number. The row can be placed on the top or bottom. Use sorttop or sortbottom
White background for data cells
Add class=srn-white-background to the top line of the table wikitext. It can be used on tables with inline cell or row background colors. Neither are affected by this class.
