Insert a table
In VisualEditor, choose "Insert > Tables" to insert a table in a page:
After entering the rows and columns, an empty table appears with the edit menu:
When the mouse rests on a symbol, the respective function is displayed.
Double-click in the cells to insert text:
Merge rows and columns
To merge a row or column, select the cells in a row or in a column. The inspector will show a "Merge" button. Click it to merge the cells. The same button is called "Unmerge" if you want to separate connected cells.
Table properties
In the menu item Properties, there are numerous settings to adjust the functionality and presentation of the table:
| Property | Description |
|---|---|
| Table width | The total width can be set here as a percentage of the available page width, for example to 100%. |
| Table style | Here you can load different style sheets for the table. |
| Exportable | Adds a context menu to the table that allows you to save the table in xlsx or csv format. The context menu can be activated by right-clicking. Exportable tables are identified by a yellow background when hovering over them. The yellow color can be removed globally by wiki administrators. The following three lines can be added to the global stylesheet MediaWiki:Common.css:/* Removal of yellow highlight color of exportable tables */
#mw-content-text table.bs-et-highlight {background-color: transparent!important;}
#mw-content-text table.bs-et-highlight.wikitable {background-color: #f8f9fa!important;
|
| Filterable | Adds a filter function to the columns of the table. |
| Sticky header | For long tables, the table header remains visible when scrolling the page. |
| Caption | Shows a header above the table:
After disabling the header, it is lost and must be reentered when re-enabled. |
| Sortable | In the first row, a sort function is displayed:
The current sorting is shown in the title bar. Only one of the two sort arrows will appear in the sorted column. |
| Collapsible | The table can be hidden on the page via a text link. |
| Collapsed initially | If the "Collapsible" property is active, this determines whether the table is visible or hidden when the wiki page is loaded. T |
Table styles
The following style sheets can be selected in the Table Style menu. Click on a picture to start the gallery:
-
No table style -
Standard -
Content -
Content (black) -
Content (blue) -
Content (darkblue) -
Cusco Sky -
Casablanca -
Greyscale -
Greyscale (narrow)
Sorting special data formats
If a column should consider special data types when sorting (e.g., date, number), this can be specified in the column header cell's class attribute. Note that a header cell is defined using "!".{| class="wikitable sortable"
|+
! class="number" |Col A
|-
|1
|-
|2
|-
|30
|-
|11
|-
|5
|}
| Col A |
|---|
| 1 |
| 2 |
| 30 |
| 11 |
| 5 |
Possible values are:
- string
- integer
- number
- date
Using existing tables
- Tables can also be inserted as a csv file on a page (just drag the CSV file onto the page in edit mode)
- Complex tables can alternatively be attached to the page as an xlsx file.
Related info
