CargoAdmin, Bureaucrats, Moderators (CommentStreams), fileuploaders, Interface administrators, newuser, Push subscription managers, Suppressors, Administrators
14,662
edits
Help:Table: Difference between revisions
m
Text replacement - "Saintapedia" to "USApedia"
m (Text replacement - "Saintapedia" to "USApedia") |
m (Text replacement - "Saintapedia" to "USApedia") |
||
| Line 539: | Line 539: | ||
</pre> | </pre> | ||
All of these formatting options should be used sparingly. Tables in crazy colors are hard to read and affect the [[Accessibility]] of the | All of these formatting options should be used sparingly. Tables in crazy colors are hard to read and affect the [[Accessibility]] of the USApedia page. | ||
===Hidden comments=== | ===Hidden comments=== | ||
| Line 781: | Line 781: | ||
== Color templates == | == Color templates == | ||
There is a series of colors that can be added to a table with whatever text you desire. The [[Help:Enhanced editor|Enhanced editor]] needs to be used to add these template. Please always consider [[ | There is a series of colors that can be added to a table with whatever text you desire. The [[Help:Enhanced editor|Enhanced editor]] needs to be used to add these template. Please always consider [[USApedia:Accessibility]] when using colors. See {{W|article=Template:Yes}} for even more color options. | ||
=== Green, yellow, and red === | === Green, yellow, and red === | ||
| Line 868: | Line 868: | ||
== Importing and exporting tables== | == Importing and exporting tables== | ||
=== Wiki table editor === | === Wiki table editor === | ||
At http://wikitable.eu5.org/, there is a wiki table editor where you can paste your table code into the box at the top, and see the results underneath, and then you can click in any of the cells in the table underneath to edit the contents of those cells, and the changes will be reflected in your code at the top. When you are done, you can copy the code from the top back into | At http://wikitable.eu5.org/, there is a wiki table editor where you can paste your table code into the box at the top, and see the results underneath, and then you can click in any of the cells in the table underneath to edit the contents of those cells, and the changes will be reflected in your code at the top. When you are done, you can copy the code from the top back into USApedia. | ||
Notes: | Notes: | ||
| Line 874: | Line 874: | ||
** Cell content lines (starting with {{code|{{!}}}}) are indented underneath the new row {{code|{{!}}-}} lines | ** Cell content lines (starting with {{code|{{!}}}}) are indented underneath the new row {{code|{{!}}-}} lines | ||
** Where multiple cells are specified on the same line (separated by {{code|{{!}}{{!}}}}), they will be moved to separate lines | ** Where multiple cells are specified on the same line (separated by {{code|{{!}}{{!}}}}), they will be moved to separate lines | ||
* A new row {{code|{{!}}-}} line is '''''required''''' before the first row in the table, even though it is optional in | * A new row {{code|{{!}}-}} line is '''''required''''' before the first row in the table, even though it is optional in USApedia | ||
** If the initial new row line is missing, the contents of the first row will generally be lost when the wiki table editor reformats the code | ** If the initial new row line is missing, the contents of the first row will generally be lost when the wiki table editor reformats the code | ||
* The site does not understand table caption {{code|{{!}}+}} lines | * The site does not understand table caption {{code|{{!}}+}} lines | ||
| Line 881: | Line 881: | ||
Wiki tables can be exported to Microsoft Word and Excel by direct cutting-and-pasting. | Wiki tables can be exported to Microsoft Word and Excel by direct cutting-and-pasting. | ||
* [[External hyperlinks]] will be preserved | * [[External hyperlinks]] will be preserved | ||
* [[Internal hyperlinks]] (to | * [[Internal hyperlinks]] (to USApedia) will also be preserved. To remove them, see [http://office.microsoft.com/en-us/excel-help/remove-a-hyperlink-HP005199697.aspx this guidance from Microsoft]. | ||
=== Importing from Microsoft Excel === | === Importing from Microsoft Excel === | ||
It is possible to import a table from [[Microsoft Excel]] using the [http://excel2wiki.net/ Copy and Paste Excel-to-Wiki Converter]. This simple tool to converts excel information to wiki text. Once you copy the wiki text from the tool, you can paste it into | It is possible to import a table from [[Microsoft Excel]] using the [http://excel2wiki.net/ Copy and Paste Excel-to-Wiki Converter]. This simple tool to converts excel information to wiki text. Once you copy the wiki text from the tool, you can paste it into USApedia in edit mode. Some formatting may need to be done after the conversion. | ||
== External Links == | == External Links == | ||