Jump to content

Template:Get cell/doc

From Wikipedia, the free encyclopedia

This template gets the content of a specified table cell. This is useful for making table cells whose value depend on others.

Usage

[edit]

To get the content of a table cell, first you need to give an id to the table (see #Example). Then use the following syntax:

{{Get cell| cell-reference | table-id }}

replacing "cell-reference" for A1, B2, D7, etc, and "table-id" for the id of the table (see #Example).

To get the content of a table cell in another page, use the optional third parameter, like so:

{{Get cell| cell-reference | table-id | page-name }}

replacing "page-name" for the name of the page where the table can be found.

Notes:

  • If the table you are designing is transcluded into another page, then the cell references will not work in the transcluding page unless you set the optional third parameter to the page where the cells can be found.
  • If the cell content is numeric, it will be automatically formatted into a plain number to simplify subsequent calculations (see #Example).

Example

[edit]

The following wikitext:

{| class="wikitable" id="population-table"
! Country
! Population
! Area
! Density
|-
| Argentina
| 45,773,884
| 2,796,427
| {{#expr: {{Get cell|B2|population-table}} / {{Get cell|B3|population-table}} round 0 }}
|-
| China
| 1,425,671,352
| 9,600,000
| {{#expr: {{Get cell|C2|population-table}} / {{Get cell|C3|population-table}} round 0 }}
|-
| United States
| 339,996,564
| 9,833,517
| {{#expr: {{Get cell|D2|population-table}} / {{Get cell|D3|population-table}} round 0 }}
|}

Will output the following table:

Country Population Area Density
Argentina 45,773,884 2,796,427 16
China 1,425,671,352 9,600,000 149
United States 339,996,564 9,833,517 35

Template data

[edit]

This template gets the content of a specified table cell.

Template parameters

This template prefers inline formatting of parameters.

ParameterDescriptionTypeStatus
Cell1

Cell reference

Example
A1, B2, D7
Stringrequired
Table2

ID of the table where the cell can be found

Example
population-table
Stringrequired
Page3

Title or ID of the page where the cell can be found

Default
Current page
Page nameoptional

See also

[edit]