30 Responses for "New feature: Spreadsheets on your wiki"

1. Michelle June 21st, 2007 at 1:01 pm

   This is great. The “insert table” function didn’t work very well and was kind of annoying. Thanks for adding this feature.

2. galiel June 21st, 2007 at 1:27 pm

   Editing in the spreadsheet works fine, but the top spreadsheet has a green field that talks about “Clicking on top tab for Files” - no tabs show up for me, nor two forms, just the single line edit buttons, similar to what you show above (Mac OS X 10.4.9/Firefox 2.0.0.4).

   When the plugin loads, I do see a second line of edit icons for a split second (no tabs though), but then it disappears.

3. Michael Brutsch June 22nd, 2007 at 7:05 am

   Looks nice. I’m guessing that, like the 30boxes calendar, there’s no way to link to my existing NumSum spreadsheet? Or a way to resize it? It’s really hard to use a big spreadsheet through the tiny viewport you have allocated.

4. Francisco June 22nd, 2007 at 3:31 pm

   Yeah, looks nice, I’m already using it. But here goes another complain regarding the size, we can’t edit it. It’s too small and editing the size directly on the template source doesn’t work either.

5. jerry June 23rd, 2007 at 3:41 am

   please support openoffice calc .ods as docs.google.com does
   and many standards for federal documents (and anyone wanting to archive over time)
   are requiring open standards…
   putting up pdfs would also be nice!

6. Lisa June 25th, 2007 at 6:26 pm

   This is a great feature!! I can see many uses for it within my classroom wiki, if only the viewing area were resizable - it is way too small for my purposes.
   I did have a lot of fun playing with it though! And still plan to use it in a smaller capacity…

7. Paul Helmick June 26th, 2007 at 12:13 pm

   Great feature..

   1) How can this be resized to be more useful?
   2) How do I copy/paste info in/out of this?

8. The Daily Peanut » Blog Archive » Latest features roundup: Spreadsheets, voice chat, event-planning, calendars, & video upload June 26th, 2007 at 2:14 pm

   [...] Spreadsheets directly on your wiki (more info here) [...]

9. steve June 26th, 2007 at 4:13 pm

   To copy/paste, I was able to double-click until the cursor showed up in the cell. Then copy/paste works.

10. Marc Freedman June 27th, 2007 at 12:16 pm

    This is an ok feature but basic. It know that’s based on NumSum. I’d like to be able to sort and set default sort on startup. Until I can do that, I won’t have any use for it.

11. Marc Freedman June 27th, 2007 at 12:23 pm

    Check that last comment. I do see the sort. It would be important as a wiki owner to have default settings so the spreadsheet is displayed as intended and not as another user left it. …. Another option and preferable is a web form where wiki visitors could enter data on one page and then go to another page to see that data displayed in a controllable format.

12. Clarissa June 28th, 2007 at 4:33 am

    You should mention that the “insert plugins” option isn’t available if you’re working in classic mode. It took me a while to figure out why I couldn’t find it.

13. Jeff June 28th, 2007 at 3:25 pm

    Nice first attempt. I agree with a lot of what’s been said above, especially:

    “I’d like to be able to sort and set default sort on startup.”

    I see the SORT feature, but I can’t seem to get it to work-I’d like to sort on the first column. HELP!!?

14. helena June 28th, 2007 at 3:36 pm

    YES, let’s have it immediately!!!

15. Paz Alonso June 29th, 2007 at 7:37 am

    ¿Podría recibir la información en español? Entiendo inglés pero no domino la informática. Informática en inglés es demasidado para mí. Gracias

16. Whitaker June 29th, 2007 at 11:18 am

    I followed instructions: “Edit Page� >> “Insert Plugins� >> “Productivity� and click Spreadsheet, but all i get is text . . . how do i specify the file to insert?

17. Dawn July 1st, 2007 at 6:43 am

    I created a new page for my spreadsheet. Is there any way to link to it from the home page?

18. Marc Freedman July 4th, 2007 at 10:39 pm

    When you check the Source code you can see that you can use an already existing NumSum spreadsheet.

    There are a two different issues.

    1. PBwiki limitations as compared to functions when accessing the spreadsheet direct at NumSum.

    When displayed in PBwiki users can’t copy cells, don’t have access to export, and can’t display the spreadsheet full screen. So I have to link to the spreadsheet on NumSum if users wants to do that, which most would if I used the spreadsheet.

    2. NumSum limitations.

    The follow limitations prevent me from using and recommending NumSum for the community-editable spreadsheet I’d like to create.

    > can’t select column and sort all rows
    > can’t select cells beyond current display (just a few rows/columns) and sort
    > owner can’t lock, password, or otherwise protect cells/rows/columns
    > no autosave (Google Spreadsheets has)
    > no default view on display (i.e. others can change view and save to the detriment of new viewers)
    > no version save and revert
    > no special or fixed index for default sort by initially entered rows (another user can sort and save, and original display of spreadsheet rows as entered cannot be recovered)

19. Laurel July 7th, 2007 at 9:27 am

    I need to know how to get it in my pbwiki. Help please!!!!!!

20. Laurel July 7th, 2007 at 9:27 am

    What I mean by “it” is the new features.

21. Andrew Brown July 10th, 2007 at 4:16 am

    Nice idea.
    All I get is a green box - no spread sheet.
    Do you ever answer these?

22. Mark July 15th, 2007 at 1:53 pm

    This is potentially a really great tool. We would like to use it as a global database that is editable. This way anyone can view or add to our fault log no matter where they are.

    2 Things that could make this much better:

    1) Ability to Lock the top row(s) so column titles can be seen while scrolling around.

    2) ABility to resize spreadsheet (larger is better). At the moment this small viewport is not very friendly when looking at larger spreadsheets.

23. Lynn July 18th, 2007 at 5:43 pm

    It’s great to have a spreadsheet — just what we needed — but is there some way to make the viewing area bigger?? Scrolling around within that little porthole is just not good. Tried changing some source code numbers that looked like they controlled the dimensions, but no luck.

24. Nadia B. Scott July 19th, 2007 at 10:13 pm

    I’d love to import an existing Excel spreadsheet but am not clear how to do it. Right now, I’ve attached it as a file…but that forces colleagues to download, make changes, then upload…they won’t have the patience…

    I tried adding the plug-in spreadsheet and that worked - got an empty pallette, but I’ve already added so much to my excel, not sure how to bring the data in - would rather use my excel doc…

    help?

    thanks so much.

    password for the site is ut

25. Andrew July 20th, 2007 at 8:12 am

    I cracked how to paste an existing excel spreadsheet into the plug in version but haven’t been able to save it, even though I get “saving” in a red box in the top right hand corner. When I move away from the page and return to it, a blank spreadsheet appears.

    Overall, I find the pbwiki platform terrific - keep up the good work.

26. Mark July 22nd, 2007 at 6:14 pm

    Could you integrate changes made in Wiki Spreadsheets into page History? Otherwise there is no way to revert to older versions if something goes wrong!

    This is evolving into a great and unique tool. Live Spreadsheet editing on a webpage. This is a powerful and much needed feature. Please keep up the good work on PBWiki, something this good HAS to catch on big… hope you are ready for it when it does!

27. dialogicity August 2nd, 2007 at 8:21 am

    I tried to insert a spreadsheet using the plug-in icon, but got to a box asking me to “describe the spreadsheet”. What does that mean? How do I describe a spreadsheet in a way that creates it on the wiki in an editable form? I can’t seem to copy and paste the file into the window, because it only seems to take text. I notice several others who have asked similar questions have not been answered.

28. Johnny September 7th, 2007 at 2:42 am

    I have managed to copy and past from MS Excel. The plugin only pastes the first 25 rows however. How can the default number of rows be increased without having to add them one-by-one? The latter option is unfeasible. And like the other bloggers, please make the plugin porthole bigger.

29. Linda June 3rd, 2008 at 9:46 am

    Is there any way to copy and paste formulae?

30. jason October 2nd, 2008 at 11:52 am

    would love to see the ability to freeze/lock a column — especially since the window is so small.