We are working on a project with a few folks that is in a dreaded excel sheet. We've settled on our structures and are now thinking about doing some wider collaboration in a wiki. What is the current level of support for tables and b) when a user clicks into the edit page, can the table frames show so they don't have to widdgetpiggety through the wiki table code? (Does that make any sense.)
Hi, Nancy :-)
There are two ways to do tables. You can separate items with vertical bars, like this.
| Breakfast | Milk, cereal |
| Lunch | Tuna sandwich |
| Dinner | Broiled salmon |
Or you can paste from Excel, and preface the content with "tsv:", like this:
tsv:
Breakfast Milk, cereal
Lunch Tuna sandwich
Dinner Broiled salmon
You can't yet edit table content directly, per your suggestion.
^^^^Liz's practice table| Date | Time | Room(s) Used | Name of Event |
| Sept 27 2004 | 12pm -3pm | KER 202 | Center for Governmental Studies Executive Meeting |
Ed- i'm still not sure what i'm doing wrong..... Liz
Liz - there was an extra space at the end of the first line. (Our table software will be fixed to ignore that space, but for now please don't put it in.) I changed to correct it...
contributed by Liz Harmon on Sep 16 3:04pm
Thanks Ed!
contributed by Liz Harmon on Sep 17 8:12am
I've found the tsv: trick to be helpful for transferring info for wiki reading purposes only. When other people need to edit these Tab Separated Values in the wiki, it is too easy for someone to delete a tab and mess up the table. Therefore I use the following import technique to create the data with the | character:
1. In excel, create a blank column that will hold the data for export.
2. In the first cell of the new column, enter the following formula that will concatenate all the cells you want with the | characters. In this example, I have a table with four columns to export:
="| "&A1&" | "&B1&" | "&C1&" | "&D1&" |"
3. Copy this cell formula down to all the rows you wish to export
4. Highlight your new export column, copy it, and then paste into the SocialText editing window
5. Bold the approprite column headings by hand in the wiki editor if necessary
6. Now, other users can easily add or modify table values because the | clearly separates values
contributed by Andy Stack on Aug 17 12:47pm
Page Last Updated: Aug 17 12:49pm by Andy Stack