How to show sheetnode results

I'm not sure whether the data you want to display is static or dynamic.

Assuming it's static, you just need to create a sheetnode that you can format. When you edit a sheetnode, select a range of cells that you want to format, then click "Format" in the sheet's toolbar. When done formatting, click "Save to: " to go back to editing the sheet.

It seems I don't understand your question. What do you mean by Drupal page?

A sheetnode is displayed on a page, which is the page of a node of type Sheetnode created via node/add/sheetnode (Create content > Sheetnode). Were you able to do that?

If you want to create your own page (of type Page for example), then you need to include a bunch of Javascript files. Refer to sheetnode.module to see how.

Hi

Am having trouble creating a spreadsheet. Have installed views and sheetnode.

In View I Add a new view. (a node titled 'spreadsheet')
style to spreadsheet.
Then get message in red box "Display "Defaults" uses fields but there are none defined for it or all are excluded."
So add "node-title" as field.
Then get message saying "Preview not supported"

Create a page display and am told a url is required.

Enter a url and save the session but when I select 'view-page' the page cannot be found.

I have not been able to find the option "Update default display" to use the default Spreadsheet settings
following the selction of 'spreadsheet' as a style for the view.

Can anyone tell me where I am going wrong with this.

Regards,

Peter

Peter,

Can you confirm that Sheetnode is working correctly? Are you able to Create content > Sheetnode and see the spreadsheet displayed on-screen?

If so, then make sure that your view works on a page with the "Unformatted" style first. When it does, change the style to "Spreadsheet" and in the style options (gear icon next to the style), uncheck the option "Use template". A default spreadsheet should be generated for you when you visit the view page.

Hi

It appears that Sheetnode is not working, I get "Sheetnode Medication Box has been created" but apart from the Title "Medication Box" there is nothing else on the page.

See :- http://www.alphadaughters.com/?q=node/19

Re:- make sure that your view works on a page with the "Unformatted" style first. When it does, change the style to "Spreadsheet" and in the style options (gear icon next to the style), uncheck the option "Use template". A default spreadsheet should be generated for you when you visit the view page.

The view worked in unformatted style on the http://www.alphadaughters.com/?q=node/19 page but when I changed format to spreadsheet I got the "Spreadsheet previewing is not supported yet" message and the page looked the same as the unformatted version.

Regards,

Peter

Peter,

You might be confusing 2 different things: nodes and views. The first refers to a single piece of content, while the second refers to a list of nodes. Which one are you trying to create?

The link you inserted here points to a node, not a view. The node whose nid=19 to be precise. When you clicked Create content > Sheetnode, did you see a spreadsheet then? Did you save the node? I am asking because the internal value of the spreadsheet (encoded in Javascript in the page you sent) is empty.

Kratib

I actually created http://www.alphadaughters.com/?q=node/19 using Create content > Sheetnode but did not see spreadsheet when I did so.

Peter

I tried to access the SocialCalc Javascript file: http://www.alphadaughters.com/modules/sheetnode/socialcalc/socialcalc-3.js but got a page not found error. Are you sure that you properly installed SocialCalc inside the Sheetnode module?

Hi,
I'm having the same problem:
1.When I'm creating new spreadsheet (Create content > Sheetnode) I don't see the spreadsheet in the page. only links to xsl & xslx files to download…
2.When I'm creating spreadsheet view like it say in the QUICK HOWTO, the page show empty (I can see the page if the style set to "Unformatted" ).

Any solution?

You need to make sure that the socialcalc folder is properly installed inside the sheetnode module folder, as I advised just above (comment #10). Does that apply to you?

I install it exactly like it said in the sheetnood page:

• Download the latest SocialCalc
• Extract the downloaded tarball to sheetnood folder and rename the extracted folder to socialcalc.
• Apply the socialcalc.patch.

What need to happened when I go to: http://localhost/mysite/modules/sheetnode/socialcalc/socialcalc-3.js ?

Now I'm getting a file download message that ask me "if I want to open or save this file". If I click open, nothing happened…

shaynl:
The fact that the Javascript file is there is good enough for now. Please look at this issue and follow the troubleshooting steps.

I'm so excited!! It's finally working!! :-)
Somehow jquery.js was deleted from the misc folder…I copy it back from a backup and now it's working. Thanks!

Great!