Create new content > sheetnode shows no spreadsheet functionality

Below the input format section, you should see a spreadsheet as in the module's screenshot.

Did you try the 5.x version and did it work there?

Are you sure you successfully installed the SocialCalc files and patches?

If you're using Firefox, can you please download the Firebug add-on (https://addons.mozilla.org/en-US/firefox/addon/1843) and let me know if you see an error on the bottom-right section of your browser window?

Thanks for your help.

Please rename the folders SocialCalc to socialcalc and Images to images (all lowercase). That's what the module expects. It might not make a difference if your host is running Windows, but better be safe than sorry :-)

Also, if you installed Firebug: does the browser status bar on the lower-right corner show JavaScript errors? If so, what do they say?

Okay let's debug the page together:

* Is your jquery.js version = 1.2.6 ?

* In Firebug > Script tab, do the following files show:
formatnumber2.js
formula1.js
socialcalc-3.js
socialcalcconstants.js
socialcalcspreadsheetcontrol.js
socialcalctableeditor.js
sheetnode.js
"
* Does the page source (View > Page Source) contain a script such as the following:

jQuery.extend(Drupal.settings, { [..] "sheetnode": { "value": "", "imagePrefix": "http://.../sites/all/modules/sheetnode/socialcalc/images/sc", "element": "sheetview", "editMode": true } });

* Does the page source contain a

  $(document).ready(function() {
    Drupal.sheetnode.startUp();
  });

Okay let's debug the page together:

* Is your jquery.js version = 1.2.6 ?

* In Firebug > Script tab, do the following files show:
formatnumber2.js
formula1.js
socialcalc-3.js
socialcalcconstants.js
socialcalcspreadsheetcontrol.js
socialcalctableeditor.js
sheetnode.js
"
* Does the page source (View > Page Source) contain a script such as the following:

jQuery.extend(Drupal.settings, { [..] "sheetnode": { "value": "", "imagePrefix": "http://.../sites/all/modules/sheetnode/socialcalc/images/sc", "element": "sheetview", "editMode": true } });

* Does the page source contain a div whose id=sheetview and class=sheetview? Does this div contain a script like this one:

  $(document).ready(function() {
    Drupal.sheetnode.startUp();
  });

* In Firebug > DOM tab, is there an object called SocialCalc?

* In Firebug > HTML tab, is there a div whose id="te_endcapv" inside the body? Is the div whose id="sheetview" populated with another nameless div, itself containing 6 divs?

Thanks for your patience and help :-)

Happily marking as closed :-)

Hello there!
I have the same problem that the fellow RegW used to have.
I´ve applied all the patches with tortoise, and added all missing images.

* Is your jquery.js version = 1.2.6 ?
How do I know that?

* In Firebug > Script tab, do the following files show:
formatnumber2.js
formula1.js
socialcalc-3.js
socialcalcconstants.js
socialcalcspreadsheetcontrol.js
socialcalctableeditor.js
sheetnode.js
"

yes

* Does the page source (View > Page Source) contain a script such as the following:
jQuery.extend(Drupal.settings, { [..] "sheetnode": { "value": "", "imagePrefix": "http://.../sites/all/modules/sheetnode/socialcalc/images/sc", "element": "sheetview", "editMode": true } });

no

* Does the page source contain a whose id=sheetview and class=sheetview?
no

Does this div contain a script like this one:
  $(document).ready(function() {
    Drupal.sheetnode.startUp();
  });

yes

* In Firebug > DOM tab, is there an object called SocialCalc?
yes

* In Firebug > HTML tab, is there a div whose id="te_endcapv" inside the body? Is the div whose id="sheetview" populated with another nameless div, itself containing 6 divs?
no

Besides that, I´ve attached the list of errors that the page show.
I really hope you can help me out :)
Thank you!!

Rosamunda

Concerning the points where you didn't say yes:
* jQuery version: the file misc/jquery.js has a header with the version number. Open it with a text editor and check the version.
* jQuery.extend line: what does your page contain instead?
* You said "no" to a div with id="sheetview" and class="sheetview". However, you said "yes" to the script that calls startUp(). So the div is not there but the script is there?
* As for the "te_endcapv" div, the code has changed since this issue was closed so it is no longer in the same place. Let's not worry about that for now.

Your errors seem to show that the main sheet object is not created in sheetnode.js. We'll work on this issue once we make sure the prerequisites above are fixed.

When I entered again on the firebug addon, just to search for the jquery.extend thing, this is the error that appears:

Firebug's log limit has been reached. %S entries not shown.		Preferences	 
SocialCalc.Constants is undefined
socialcalctableeditor.js?I()()socialca...itor.js?I (línea 3391)
[Break on this error] offsetX: SocialCalc.Constants.Tooltip... modifyable version to allow positioning
socialca...itor.js?I (línea 3391)
SocialCalc.Constants is undefined
startUp()()sheetnode.js?I (línea 58)
(?)()()2 (línea 83)
(?)()()jquery.j...e3Q%3D%3D (línea 1)
(?)()()jquery.j...e3Q%3D%3D (línea 1)
(?)()(function () { return a.call(this, D); },function () { return a.call(this, D); },function () { return a.call(this, D); }, function(), undefined)jquery.j...e3Q%3D%3D (línea 1)
(?)()()jquery.j...e3Q%3D%3D (línea 1)
[Break on this error] SocialCalc.Constants.defaultImagePrefi...= Drupal.settings.sheetnode.imagePrefix;
sheetnode.js?I (línea 58)
this.sheet is undefined
resize()()sheetnode.js?I (línea 84)
(?)()()sheetnode.js?I (línea 115)
(?)()(Object originalEvent=Event resize type=resize)jquery.j...e3Q%3D%3D (línea 1)
(?)()()jquery.j...e3Q%3D%3D (línea 1)
[Break on this error] if (this.sheet.SizeSSDiv()) {

Yes, the jQuery version is 1.2.6

About the "id="sheetview" and class="sheetview" issue, I´ve looked for that line inside the node view page source, and the edit page source, and didn´t appeared.

Thank you very much for your help!!!!

Rosamunda

* You didn't answer about jQuery.extend. You should find that line in the HTML source page of the browser. What does it say?

* Open http://localhost/aplicacion_web/sites/all/modules/sheetnode/socialcalc/s.... Do you see the spreadsheet?

* In sheetnode.js, add the line

window.console.log(this.sheet);

at the very end of the Drupal.sheetnode.startUp() function. When you refresh the page, the Firebug console tab should show

Object parentNode=div#sheetview.sheetview

and you can click that line to examine the object. Is that the case?

I´m sorry this is what appears in the source page now:

<script type="text/javascript">
<!--//--><![CDATA[//><!--
jQuery.extend(Drupal.settings, { "basePath": "/aplicacion_web/", "sheetnode": { "value": "", "imagePrefix": "http://localhost/aplicacion_web/sites/all/modules/sheetnode/socialcalc/images/sc", "element": "sheetview", "editMode": false } });
//--><!]]>
</script>

I´ve attached what appears when I open http://..../ssctrltest1.html

About the sheetnode.js file, now it looks like this:

Drupal.sheetnode.startUp = function() {
  SocialCalc.Constants.defaultImagePrefix = Drupal.settings.sheetnode.imagePrefix;
  SocialCalc.Constants.defaultCommentStyle = "background-repeat:no-repeat;background-position:top right;background-image:url("+ Drupal.settings.sheetnode.imagePrefix +"-commentbg.gif);"
  SocialCalc.Constants.defaultCommentClass = "tooltip";
  SocialCalc.Constants.TCendcapClass = 
  SocialCalc.Constants.TCpanesliderClass = 
  SocialCalc.Constants.TClessbuttonClass = 
  SocialCalc.Constants.TCmorebuttonClass = 
  SocialCalc.Constants.TCscrollareaClass = 
  SocialCalc.Constants.TCthumbClass = "absolute";

  this.sheet = new SocialCalc.SpreadsheetControl();
  if (!Drupal.settings.sheetnode.editMode) {
    this.sheet.tabbackground="display:none;";
    this.sheet.toolbarbackground="display:none;";
  }
  
  this.sheet.ParseSheetSave(Drupal.settings.sheetnode.value);
  this.sheet.FullRefreshAndRender();
  this.sheet.InitializeSpreadsheetControl(Drupal.settings.sheetnode.element, Drupal.settings.sheetnode.editMode ? 700 : 0);
  this.sheet.currentTab = this.sheet.tabnums.edit;

  Drupal.sheetnode.focusSetup();
  Drupal.sheetnode.functionsSetup();
}
window.console.log(this.sheet);

Now this line does show up:
<div class="sheetview" id="sheetview">

The console tab shows only this (after refreshing and reinstalling the module using Devel):

Firebug's log limit has been reached. %S entries not shown.		Preferences	 
SocialCalc.Constants is undefined
socialcalctableeditor.js?I()()socialca...itor.js?I (línea 3391)
[Break on this error] offsetX: SocialCalc.Constants.Tooltip... modifyable version to allow positioning
socialca...itor.js?I (línea 3391)
SocialCalc.Constants is undefined
startUp()()sheetnode.js?I (línea 58)
(?)()()3 (línea 83)
(?)()()jquery.j...e3Q%3D%3D (línea 1)
(?)()()jquery.j...e3Q%3D%3D (línea 1)
(?)()(function () { return a.call(this, D); },function () { return a.call(this, D); },function () { return a.call(this, D); }, function(), undefined)jquery.j...e3Q%3D%3D (línea 1)
(?)()()jquery.j...e3Q%3D%3D (línea 1)
[Break on this error] SocialCalc.Constants.defaultImagePrefi...= Drupal.settings.sheetnode.imagePrefix;

Again, many, many thanks for your help!!!

Rosamunda

sorry, forgot the attachment... :)

Well, now we know that the plain SocialCalc test page doesn't even show... So we should concentrate on making ssctrltest1.html work before proceeding with the module.

* In the folder sheetnode/socialcalc, please do the following:

svn revert --recursive .

This will revert the socialcalc code to its original state before the patches. Then, try to open ssctrltest1.html again and let me know if Firebug displays any error.

* Alternatively, if you can post your Drupal site on the Internet, I'd be happy to check what's wrong.

Closed unless anyone minds.

Hi, I'm having a similar issue.
The test of socialcalc works.
However, the spreadsheet does not show on the create spreadsheet page, nor on a simple view.

* Is your jquery.js version = 1.2.6 ? Yes

* In Firebug > Script tab, do the following files show:
formatnumber2.js Yes
formula1.js Yes
socialcalc-3.js No
socialcalcconstants.js Yes
socialcalcspreadsheetcontrol.js No
socialcalctableeditor.js No
sheetnode.js No
In addition I have socialcalcpopup.js
"
* Does the page source (View > Page Source) contain a script such as the following:
jQuery.extend(Drupal.settings, { [..] "sheetnode": { "value": "", "imagePrefix": "http://.../sites/all/modules/sheetnode/socialcalc/images/sc", "element": "sheetview", "editMode": true } });
I also have DHTML menu, so there's a line first for that, but the section about sheetnode says:
"sheetnode": { "value": "", "imagePrefix": "http://localhost/strategy/sites/all/modules/sheetnode/socialcalc/images/sc-", "element": "sheetview", "sheetsave": "edit-sheetsave", "editMode": true }

* Does the page source contain a div whose id=sheetview and class=sheetview? Does this div contain a script like this one:
$(document).ready(function() {
Drupal.sheetnode.startUp();
}); It says Drupal.sheetnode.start()

* In Firebug > DOM tab, is there an object called SocialCalc? Yes

* In Firebug > HTML tab, is there a div whose id="te_endcapv" inside the body?No
Is the div whose id="sheetview" populated with another nameless div, itself containing 6 divs? No, it contains the script shown above (sheetnode.start()). There are some hidden divs called 'edit-sheetsave', 'edit-sheetnode-nodeform-token' and 'edit-sheetnode-nodeform'. They are not inside of sheetview. I do get the save as template option.

Additionally I get the following error in Firebug:

 this.spreadsheet is undefined
 if (this.spreadsheet.SizeSSDiv()) {

and this.spreadsheet = new SocialCalc.SpreadsheetControl();
both from sheetnode.js (lines 168 & 135)..

My folders are named correctly (lowercase). I have applied the patch using cygwin. I'm using windows Vista/Wamp 2.
*edit* I tried turning off DHTML menu but it didn't fix it. * end edit *

Any help is appreciated!

@pimousse, can you confirm that you still get this with the latest dev release?

I cannot get it to work with IE. It does display in FireFox.
Any suggestion?

I just tested the latest dev version with IE8 and it works. Did you follow the installation instructions? Specifically, did you apply the needed patch?

Thanks for the prompt response. Actually, now it finally did its magic and is displaying the spreadsheet in IE8 too. Could it be a Drupal cache issue? I should have tried to update it after fixing the install issues.
Now on to the additional modules.
I am using cpanel, and i am not sure at all how to install properly (or find out if they are already installed) on our server:
Java 6 JRE, PHP/Javabridge, Apache POI 3.6. Any recommandation or link?
Thanks

If you don't have SSH access to your host, then it's up to the host admin to setup Java 6 and PHP/Java Bridge for you. I'm not familiar with CPanel unfortunately. Apache POI is just a library that needs to be extracted somewhere on the server (e.g. inside the sheetnode module folder).

Thanks