Talk:Spreadsheet Tricks

Wiki table markup summary

{\|	table start, required
\|+	table caption, optional; only between table start and table row
\|-	table row, optional on first row—wiki engine assumes the first row
!	table header cell, optional. Consecutive table header cells may be added on same line separated by double marks (`!!`) or start on new lines, each with its own single mark (`!`).
\|	table data cell, optional. Consecutive table data cells may be added on same line separated by double marks (`\|\|`) or start on new lines, each with its own single mark (`\|`).
\|}	table end, required

The above marks must start on a new line except the double || and !! for optionally adding consecutive cells to a line. However, blank spaces at the beginning of a line are ignored.
XHTML attributes. Each mark, except table end, optionally accepts one or more XHTML attributes. Attributes must be on the same line as the mark. Separate attributes from each other with a single space.
- Cells and caption (| or ||, ! or !!, and |+) hold content. So separate any attributes from content with a single pipe (|). Cell content may follow on same line or on following lines.
- Table and row marks ({| and |-) do not directly hold content. Do not add pipe (|) after their optional attributes. If you erroneously add a pipe after attributes for the table mark or row mark the parser will delete it and your final attribute if it was touching the erroneous pipe!
Content may (a) follow its cell mark on the same line after any optional XHTML attributes or (b) on lines below the cell mark. Content that uses wiki markup that itself needs to start on a new line, such as lists, headings, or nested tables, must be on its own new line.
- Pipe character as content. To insert a pipe (|) character into a table, use the <nowiki>|</nowiki> escaping markup.

Table Caption (Top)
	A	B	C	D	E
1	Header 1	Header 2	Header 3	Header 4	Header 5
2	1	77	4	7	10
3	2	12	5	8	11
4	3	24	6	9	12
5	Formula Example: Array Formula: The formulas shown above are array formulas. After typing an array formula into the formula bar, finish by pressing `CTRL+Shift+Enter` (PC) or `CMND+Shift+Enter` (Mac). Please Note: The formula bar indicates that this is an array formula by enclosing it in curly braces `{ }`. Do not type these yourself. They disappear whenever you edit the formula, making it necessary to press `CTRL+Shift+Enter` (PC) or `CMND+Shift+Enter` (Mac) whenever you edit the formula. The curly braces `{ }` in the examples shown above are displayed only to show what the formula looks like as it appears in the formula bar. Source: text and,numbers in same cell, sum of numbers ?

You type

You get

{| class="wikitable"
|+ style="color:#e76700;"|''Top Caption''
|-
|Orange
|Apple
|-
|Bread
|Pie
|-
|Butter
|Ice cream 
|}

You type

You get

{| class="wikitable"
|+ style="caption-side:bottom; color:#e76700;"|''Bottom Caption''
|-
|Orange
|Apple
|-
|Bread
|Pie
|-
|Butter
|Ice cream 
|}

You type

You get

{| class="wikitable"
|+ style="caption-side:left; color:#e76700;"|''Left Caption''
|-
|Orange
|Apple
|-
|Bread
|Pie
|-
|Butter
|Ice cream 
|}

You type

You get

{| class="wikitable"
|+ style="caption-side:right; color:#e76700;"|''Right Caption''
|-
|Orange
|Apple
|-
|Bread
|Pie
|-
|Butter
|Ice cream 
|}