Jump to:
| Project: | Sheetnode |
| Version: | 6.x-1.5 |
| Component: | User interface |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
Drupal Version: 6.22
Sheetnode Version: 6.x-1.5 and 6.x-1.x-dev (tried both)
Hello,
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.
I tried this with Safari, Firefox and Opera on MacOS (Lion and Snow Leopard) and with Firefox on Linux on different computers. Unfortunately I have no Windows computer around to try.
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 appears. It seems to work very well there.
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.
Update:
I just realised that I accidentally assigned this issue to myself. Of course it should be "none".
Thanks in advance for your help.
Comments
#1
This sounds like the referenced spreadsheet is not being found. Can you please confirm by using Firebug and watching the Net tab for a call to "sheetnode/load". What is the response to this call?
#2
Thanks for your answer, infojunkie.
I tried with Firebug and this was the response to the "sheetnode/load" call:
(I replaced the proxy name with "proxy.name" and the host name with "host.name.com")
"Header" tab:
Answer-Header Show source
Date Sun, 08 Jan 2012 07:04:57 GMT
Server Apache
Vary Accept-Encoding
Content-Encoding gzip
Content-Length 234
Content-Type text/html; charset=iso-8859-1
X-Cache MISS from proxy.name
Via 1.0 proxy.name (squid/3.1.16)
Connection keep-alive
Request-Header Show source
Host host.name.com
User-Agent Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:8.0.1) Gecko/20100101 Firefox/8.0.1
Accept */*
Accept-Language de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
Accept-Encoding gzip, deflate
Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.7
Proxy-Connection keep-alive
Content-Type application/x-www-form-urlencoded; charset=UTF-8
X-Requested-With XMLHttpRequest
Referer http://host.name.com/?q=node/add/sheetnode
Content-Length 14
Cookie SESS879614c8959f7b43fcc4ade5f1944b2b=807f9653eb52ba30796a83c0841c1aae; has_js=1
Pragma no-cache
Cache-Control no-cache
"Post" tab:
Parameter application/x-www-form-urlencodedsheetname test
Source
sheetname=test
"Answer" tab
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"><html><head>
<title>404 Not Found</title>
</head><body>
<h1>Not Found</h1>
<p>The requested URL /sheetnode/load was not found on this server.</p>
<hr>
<address>Apache Server at host.name.com Port 80</address>
</body></html>
My Firebug is in German. I replaced the headers with English where they were in German.
Seems that you are right. Now I can see, where the error message comes from.
In the mean time I was able to try from a Windows computer and from a computer outside our network, with another/no proxy. No change.
I would be really glad if you could help me fix this.
Thanks a lot in advance and regards.
#3
It seems I could fix this issue.
I found out by accident, that clean URLs were not turned on in my Drupal installation. They could not be turned on because I could not use the standard .htaccess that comes with Drupal 6.22 on my server as it resulted in a server error. I searched the Internet and found a .htaccess file that worked with my server. Then I replaced the standard .htaccess with the other and could turn on clean URLs. I turned on clean URLs and now the referencing of other sheetnodes works!
Thank you infojunkie for pointing me in the right direction.
Regards.
#4
Thanks for the info. I will work on making sheet referencing compatible with un-clean URLs.