Template:Get cell

Template documentation[view] [edit] [history] [purge]

This template uses Lua:

Module:Get cell

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

Usage

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

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

This template gets the content of a specified table cell.

Template parameters[Edit template data]
This template prefers inline formatting of parameters.
Parameter		Description	Type	Status
Cell	`1`	Cell reference Example A1, B2, D7	String	required
Table	`2`	ID of the table where the cell can be found Example population-table	String	required
Page	`3`	Title or ID of the page where the cell can be found Default Current page	Page name	optional

Template:Get cell

Contents

Usage

Example

Template data

See also