fix sheets created directly from wiki SHEET plugin within wiki pages for managing tables visually

• Usability
• Feature request

Spreadsheets can be created directly through wiki SHEET plugin directly within wiki pages. this allows managing big tables visually, as well as having the data ready for producing graphs, etc. (see documentation for tikisheets at doc.tw.o, if needed)

However, when you create a sheet through a call to the SHEET plugin from the wiki page itself, there are 3 issues which need to be fixed:

1. you need to know the id you want to assign it to,
2. after that, tiki-sheets.php doesn't list it (even if the sheet is really created, and you can import data to it, and show it at the wiki pages, etc.).
3. the sheet is not shown with the right css

Even if we have wysiwyg option available, I still think that is worth improving tiki sheets usability to be used directly from wiki pages, once those 3 previous issues are fixed.

Updated on Feb. 2, 2011, using trunk (7svn)

1. Steps to reproduce the first issue
   1. Edit a wiki page
   2. Use the plugin helper to create a new sheet in that page. And since it's a new sheet, it doesn't have a sheetId yet, so that you leave all fields empty in the plugin helper for the pluginsheet
      this will add this type of code in your wiki page:
      

      {sheet}

   3. Save the wiki page
      you will see an empty sheet shown in place at that wiki page, with the button at the bottom to allow the user to "edit it" (so far, so good)
   4. Once you click in the edit sheet button, you end up in some url like this one:
      http://localhost/tiki7trunk/tiki-view_sheets.php?sheetId=&parse=edit
      which produces a WSOD (blank page).
      • In my case, I guess that this url should have been:
        http://localhost/tiki7trunk/tiki-view_sheets.php?sheetId=2&parse=edit
        since I had only one sheet previously created, with sheetId 1, so that the next one should be 2. However, this new url is still producing WSOD for me. (tiki caches cleared, just in case, repeated this step, and same WSOD)

The expected behavior is that the user is the user would be editing a blank new sheet with the url:
http://localhost/tiki7trunk/tiki-view_sheets.php?sheetId=2&parse=edit

and when the user saves that sheet, the new sheetId 2 exists, and the user is either sent back to the wiki page where he clicked at the button "edit sheet" (preferable option) or either sent to the corresponding tiki view sheet 2.

This bug has been demonstrated on show2.tiki.org

Please demonstrate your bug on show2.tiki.org