Edit Tables
From Planipedia
Creating tables within your Planipages can be very useful for categorizing and presenting a large amount of data. While Planipedia requires that you follow a specific method to add and edit a table, if you follow the steps below, it is really quite simple.
Contents |
Creating a New Table
Click the Insert Table button at the end of the Edit toolbar. Doing so will produce the following basic table:
Then change the sample text with the text and data to be used for your table.
Adding More Rows
If the three rows in the basic table are not enough, you can manually add in more rows. To start a new table row, type a vertical bar and a hyphen on its own line: "|-". Each table cell in that row will start on the next line, starting with a bar.
becomes...
| header 1 | header 2 | header 3 |
|---|---|---|
| row 1, cell 1 | row 1, cell 2 | row 1, cell 3 |
| row 2, cell 1 | row 2, cell 2 | row 2, cell 3 |
| row 3, cell 1 | row 3, cell 2 | row 3, cell 3 |
Adding Columns
To add columns on to the table, enter "| row 1, cell x" in the line beneath the last table line with data for a given row, and above the table line "|-" separating the rows.
changes to... 
To have this appear column appear consistently across all rows, ensure that you "| row x, cell x" before all "|-" lines in the table.
Formatting Row and Column Headers
If you want your row and columns headings to appear more distinct from the main content of the table, use an "!" exclamation mark instead of the "|" vertical line. Usually you would do this for the entire first column and top row of a table, meaning you would normally use ! instead of | for all table lines in between the first and second "|-", and all table lines that are one line below any "|-".
So your edited table would look something like this:
and when saved would become...
| row header 1 | row header 2 | row header 3 |
|---|---|---|
| column header 1 | row 1, cell 2 | row 1, cell 3 |
| column header 2 | row 2, cell 2 | row 2, cell 3 |
| column header 3 | row 3, cell 2 | row 3, cell 3 |
Excel to Planipedia
If you wish to display information contained in an Excel Spreadsheet in a Planipedia page, go to http://excel2wiki.net. If you copy the cells of your Excel spreadsheet, paste in the box provided on the website and click "Submit Query", your excel spreadsheet data will automatically be converted into Wiki or Planipedia style.
You would then copy the converted output data from excel2wiki.net and paste it in the edit tab of the page to which you are adding the information. Saving your Planipage will then display your excel spreadsheet in an appropriate format.
Note: Doing this will not preserve any equations used within your spreadsheet, only the resulting information.
