Sheetnode templates

Thanks for your feedback!

Sheetnode templates are on the roadmap.

Regarding the doco, no we're mostly on our own. It would be great to undertake some documentation! The formula syntax is close to Excel :-)

Please specify one or more use cases for the templates. Initially, I was thinking of a way to save a sheet as a template while editing, then show the list of saved templates in the sheetnode creation form.

For the documentation, let's open a separate issue where you can ask me for specific features and I provide the raw information that you can verify and organize.

Template support implemented in latest dev. This is how it works:
* When editing a sheetnode, you can specify a template name under which to save the current sheet.
* A new Create Content menu item called "Sheetnode import from template" lets you choose a template to start from.
* You will need to run update.php and clear the cache.

Please try it (12 hours from now) and let me know!

I would like to try sheetnode, but I cannot figure out how to apply the patch, which is the first step. My drupal site is hosted at dreamhost.

What I have done so far is downloaded the latest SocialCalc tarball, and extracted the downloaded tarball and renamed the extracted folder to socialcalc. Thereafter I uploaded the folder socialcalc to dreamhost. In addition, I also uploaded socialcalc.patch.

Next, I logged into my dreamhost account using ssh and attempted to patch, but received some error messages.

I have never applied a patch before. What should I do exactly? Do I put folder socialcalc in the sheet node module folder and then patch? Please note that I have read the documentation for applying a patch at http://drupal.org/patch/apply, but the instructions are a bit over my head.

The socialcalc folder should be inside sheetnode. Make sure the file socialcalc.patch is in sheetnode as well. Then, in an SSH session, do the following:

cd /your/path/to/sheetnode
patch -p0 < socialcalc.patch

That should do it!

PS. Technically, the patch might not even be necessary unless your Drupal theme has a specific feature that throws SocialCalc off. Sheetnode might run very well without it.

kratib, thanks very much. The patch was successful. I am now able to create a spreadsheet, enter some data, and save it as content. However, when I view the content from the frontpage, the spreadsheet is not visible unless I click on the heading of the content, and the spreadsheet becomes visible for editing.

Is there a way to keep the spreadsheet visible? I didn't install the PHP/Java Bridge. I'm guessing that must be necessary.

@ayakey, forgot to tell you last time: please don't change the title or topic of an issue. If what you want to ask is different than what's being said on the thread, then you have to open a new ticket. Otherwise it's called "thread hijacking" and that's not a good thing :-)

Now concerning your question, sheetnode is designed to *not* show the spreadsheet in teaser mode, which is what you see on the front page. It has nothing to do with PHP/Java Bridge.