By rapport on

Dear community,

I'm having problems referencing cells in other sheetnodes using the Sheetnode module. I created a sheetnode "test" and entered some numbers in A1, B1, C1 and D1. Then I created another sheetnode and tried to reference the cells in the "test" sheetnode using ="test"!A1 or ="nid"!A1 etc. When I press Enter, an error message box appears saying:

Unknown line type '<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">.

Beneath the spreadsheet I see the message

A2 Calculating... Loading Sheet...: test.

After clicking OK on the error window, the sheetnode hangs and is broken. I can save it, but I can't delete the reference in the cell any more, and I can't enter data in other cells either. It is the same when I open the saved sheetnode. I have to delete it, because it is of no use any longer.

I tried this with Safari, Firefox and Opera on MacOS (Lion and Snow Leopard) and with Firefox on Linux on different computers. No Windows around to try, I'm afraid.

I even tried to remove the error text in the database and replace it with "clean" data, but when I do this, the sheet will no longer be displayed when I try to open it. If I put the error text back in the database, the sheetnode is displayed again, but again of no further use.

When I do the same thing on the Sheetnode Demo Page I see #N/A for a short time, then the data in the "test" sheet is entered. It seems to work very well there.

Did anybody else have this error? I searched for many days now, searched the Internet and read almost all postings containing "sheetnode" in this forum, but I could not find any hint. Could this be an issue of the PHP version or browser? I read that calculations in Sheetnode are processed by the browser, but you can configure it to have the calculations processed by the server. But that would not explain why I can reference cells in other spreadsheets on the Sheetnode Demo page... How can I configure Sheetnode in a way that calculations are done by the web server? Would that help perhaps?

I set up a web server at home with Linux and installed Drupal and Sheetnode there, tried with the same computers and browsers, still the same behavior: the error message appears and the spreadsheet hangs and is broken.

I use the Sheetnode module for a site with about 100 users. Each user has his own spreadsheet, can log on and enter his data. At the end of the year I need to sum up the data in the spreadsheets in a "Totals" spreadsheet, where I would like to reference the data in cells of the users' spreadsheets. All the spreadsheets have the same structure and are created from a Sheetnode template. Everything works nicely and I am really glad I found Drupal and the Sheetnode module. It works great for my purpose, and if I could resolve this issue with the reference of data in cells of other sheetnodes, I would really be in heaven!

Thanks in advance for your help.

⋅ Categories: Drupal 6.x

Comments

ejohnson’s picture

ejohnson commented

Sorry, if this post is no use to you. I haven't used this module before. I see you're new to posting on the forum. You might have better luck if you submit your problem as an "Issue" under the actual Sheetnode Module forum (ie. http://drupal.org/project/issues/sheetnode?text=&status=All) . Your problem my already be solved in there or the module developer may be able to help you out better. That module is unique and not overly popular, so you might not get much of a response in the general "Post Installation" forum.

You could also try the "Dev" version of that module, if you haven't already tried it ( http://drupal.org/project/sheetnode ). Maybe it's solved in that version of the module. You haven't indicated in your post what specific version of that module you are using.

Anyways, posting an issue in the specific module forum will probably get a better response.

rapport’s picture

rapport commented

Thank you, ejohnson, I will try posting there. I didn't think of the Sheetnode Module forum.
Regards :-)

rapport’s picture

rapport commented

Just to mark this closed:

With the help of the developer of the Sheetnode module I found the solution for this issue. Please look here:
http://drupal.org/node/1386114
Regards,
rapport