Sheet references do not support un-clean URLs [#1386114]

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

Comment #1

infojunkie

Vancouver

CreditAttribution: infojunkie commented 4 January 2012 at 20:56

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?

Comment #2

rapport CreditAttribution: rapport commented 8 January 2012 at 07:52

Assigned:

rapport

» Unassigned

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-urlencoded
sheetname	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.

Comment #3

rapport CreditAttribution: rapport commented 8 January 2012 at 17:27

Title:

Sheet references do not support un-clean URLs

» Error: Unknown line type '<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> when referencing cells in other sheetnodes

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.

Comment #4

infojunkie

Vancouver

CreditAttribution: infojunkie commented 8 January 2012 at 16:40

Title:

Error: Unknown line type '<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> when referencing cells in other sheetnodes

» Sheet references do not support un-clean URLs

Thanks for the info. I will work on making sheet referencing compatible with un-clean URLs.

Comment #5

Ramya Nallu CreditAttribution: Ramya Nallu commented 13 December 2012 at 09:35

Title:	Error: Unknown line type '<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> when referencing cells in other sheetnodes	» I keep getting the "Sheet unavailable" when referencing from an external sheet
Version:	6.x-1.5	» 7.x-1.x-dev
Component:	User interface	» Views
Assigned:	Unassigned	» Ramya Nallu
Priority:	Normal	» Critical
Status:	Active	» Needs review

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 test1 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:
"Sheet unavailable: test"

Comment #6

infojunkie

Vancouver

CreditAttribution: infojunkie commented 13 December 2012 at 17:40

Title:	I keep getting the "Sheet unavailable" when referencing from an external sheet	» Sheet references do not support un-clean URLs
Component:	Views	» Core
Assigned:	Ramya Nallu	» Unassigned
Priority:	Critical	» Normal