Spreadsheet/joomla


#1

Hello,

i have downloaded the Spreadsheet plugin for joomla 1.5, installed it, and enabled the plugin,
when i create a new article with the [[spreadsheet]], nothing shows up in my article, just blank/white space, am i missing something for the code to work properly.

Thank you


#2

just to show you what it does,



#3

Hi,
does any JavaScript error occur?
Could you provide link to your page with spreadsheet?


#4

unfortunatly this is an internal site. i get a few errors, the second screen shot(with 3 errors), is with the plugin enabled, and the first screenshot with 1 error, is what i get when i disable the plugin.

when i look at the log files from php, nothing shows up in there as errors




#5

Hi,
please, provide page source code from IE. The most interesting peace of code is spreadsheet initialization. I guess there is some error in it.


#6

Great thank you, here is the Source From IE8

[code]

#trans{width:100px;}
				</div>
			</div>
		</div>

		<div id="tabarea">
			<div id="tabarea_l">
				<div id="tabarea_r">
					<div id="tabmenu">
					<table cellpadding="0" cellspacing="0" class="pill">
						<tr>
							<td class="pill_l">&nbsp;</td>
							<td class="pill_m">
							<div id="pillmenu">
								<ul class="menu"><li class="item4"><a href="/joom/index.php?option=com_content&amp;view=category&amp;layout=blog&amp;id=5&amp;Itemid=4"><span>Company Information</span></a></li><li class="item70"><a href="/joom/index.php?option=com_content&amp;view=frontpage&amp;Itemid=70"><span>Home</span></a></li><li class="item108"><a href="https://intranet.canaccede.com"><span>Debt Next</span></a></li><li class="item112"><a href="https://support.canaccede.com" target="_blank"><span>Debt Next AFSI</span></a></li></ul>
							</div>
							</td>
							<td class="pill_r">&nbsp;</td>
						</tr>
						</table>
					</div>
				</div>
			</div>
		</div>

		<div id="search">
			
		</div>

		<div id="pathway">
			
		</div>

		<div class="clr"></div>

		<div id="whitebox">
			<div id="whitebox_t">
				<div id="whitebox_tl">
					<div id="whitebox_tr"></div>
				</div>
			</div>

			<div id="whitebox_m">
				<div id="area">
								

					<div id="leftcolumn">
														<div class="module">
		<div>
			<div>
				<div>
										<script language="JavaScript" type= "text/javascript" src="http://aeox/joom/modules/mod_bookmarkus/bookmark_us.js"></script><img src="http://aeox/joom/modules/mod_bookmarkus/bookmark_site.gif" align="absmiddle" alt="" />&nbsp;<script type="text/javascript"> displayLink("1","http://aeox/joom/","","Bookmark Website"); </script>

User Options

<a href="#" id="sideBarTab"><img src="http://aeox/joom/modules/mod_samilogin/images/slide-button.gif" alt="sideBar" title="sideBar" /></a>

<div id="sideBarContents" style="width:0px;">
	<div id="sideBarContentsInner">

Username

	<input id="modlgn_username" type="text" name="username" class="inputbox" alt="username" size="18" />
</p>
<p id="form-login-password">
	<label for="modlgn_passwd">Password</label>

	<input id="modlgn_passwd" type="password" name="passwd" class="inputbox" size="18" alt="password" />
</p>
	<p id="form-login-remember">
	<label for="modlgn_remember">Remember Me</label>
	<input id="modlgn_remember" type="checkbox" name="remember" class="inputbox" value="yes" alt="Remember Me" />
</p>
	<input type="submit" name="Submit" class="button" value="Login" />
</fieldset>
<ul>
	<li>
		<a href="/joom/index.php?option=com_user&amp;view=reset">
		Forgot Your Password ?</a>
	</li>
	<li>
		<a href="/joom/index.php?option=com_user&amp;view=remind">
		Forgot Your Username</a>
	</li>
		</ul>
<input type="hidden" name="option" value="com_user" />
<input type="hidden" name="task" value="login" />
<input type="hidden" name="return" value="L2pvb20vaW5kZXgucGhw" />
<input type="hidden" name="6c997d6f51e9d7daf2cd3b9a8456861a" value="1" /></form>
											</div>

											<div id="maincolumn">
												
						<table class="nopad">
							<tr valign="top">
								<td>
									<div class="componentheading">
</div>
	</tr>
test1111
Written by Administrator   
Friday, 13 April 2012 08:06 AM

Last Updated on Friday, 13 April 2012 08:22 AM
 

 

 

LunchLearn

 

Friday April 20th Lunch And Learn

Aeox will be providing a lunch


 

 

When Submitting a Support Ticket

 

 

When submitting a support ticket is is important to include as much information as possible in order to receive a resolution within the specified time frame.

 

Important Info To Include:  -Error Messages, Screen Shots

                                      -Time And Date(if submitting later).

 


 

 

Good Afternoon,

 

Welcome to Aeox

Please Bare With Us As We Develop The Site.

 

 Quote Of The Day

Last night I lay in bed looking up at the stars in the sky and I thought to myself, where the heck is the ceiling.

 

 

 

 

 

Latest KnowledgeBase Articles

 

 
								</td>
																</tr>
						</table>

					</div>
					<div class="clr"></div>
				</div>
				<div class="clr"></div>
			</div>

			<div id="whitebox_b">
				<div id="whitebox_bl">
					<div id="whitebox_br"></div>
				</div>
			</div>
		</div>

		<div id="footerspacer"></div>
	</div>

	<div id="footer">
		<div id="footer_l">
			<div id="footer_r">
				<p id="syndicate">
					
				</p>
									</p>
			</div>
		</div>
	</div>
</div>
[/code]

#7

Hi,
bug is confirmed.
To fix it you have to open file plugins/content/spreadsheet/spreadsheet_common.php
and modify it like here:

		if ($this->get('first_time')) {
			$init .= "dhtmlxEvent(window, 'load', onload_func_{$uid});";
			$this->set('first_time', false);
		} else
			$init .= "onload_func_{$uid}();";

The last line here was changed, it should fix initializing second spreadsheet.


#8

GREAT, i will try that and report news tonight, thank you so much.

the second spreadsheet, i c’ant even get the first one working, even with the change of the code. still blank, like before
and how often is the downloadable package updated?


#9

Try to press F12 in IE, in opened debugger select tab Script and Console (in right panel).
There should be a little more information about error.
If to press on it then line which cause error should be opened. Could you provide code which caused errors?


#10

ok, i did as requested and here is a screenshot of what i get.



#11

oops forgot to attach, here it is


#12

Hi,
try to modify spreadsheet_data.php file like here:

		if ($this->get('first_time')) {
			$init .= "dhtmlxEvent(window, 'load', onload_func_{$uid});\n";
			$this->set('first_time', false);
		} else
			$init .= "onload_func_{$uid}();\n";

Still doesn’t work?


#13

do you mean to add this to Spreadsheet_common.php, i edit my spreadsheet_data.php but dont see anything close to what i should be editing


#14

Hi,
no, such code should present in spreadsheet_data.php, it’s at the end of method get_spreadsheet_client(), isn’t it?


#15

Hello. I am also having this issue, running a Joomla 2.5.4 site and getting a blank screen when viewing the spreadsheet through my Joomla site. I have the following error: Uncaught ReferenceError: dhtmlxEvent is not defined. I made the change to spreadsheet_common.php described two posts above as I also did not see any similar code in spreadsheet_data.php, nor did I see the reference to “client” code as mentioned in the post above.

Can someone tell me if there was a resolve to this topic, and if so, what it was? Did the code changes mentioned work for you all?

Thank You.


#16

Hi,
could you provide link to your spreadsheet page?
By the way, you were right guys, this code located in spreadsheet_common.php, sorry.


#17

Hi, I went into my site and did a bit of tweaking - got rid of a couple extensions that I thought might be causing conflicts and that we weren’t really using anymore anyway, and then uninstalled and reinstalled the spreadsheet extension and made the modifications to the code again as outlined in the previous post. I am no longer receiving the error message that I got before, and in fact am receiving no error messages at all (yay!). However, I am also still not seeing the spreadsheet, the page is still blank, so not complete success.

I can share a link to the page where the spreadsheet can be found on our site as you requested, but it is in a private area of our site so I would have to give you a login/password. I am happy to do so if that is okay with you, just let me know how you would like that information sent to you.

Thank you,
Angela


#18

Hi,
please, send me login/password in a private message.


#19

I have submitted the details via private message as requested.

Thank You!
Angela


#20

Hi,
please, open file plugins/content/spreadsheet/spreadsheet.php and modify it like here:

protected function get_url() {
	$baseurl = $_SERVER['SERVER_NAME'];
	$baseurl .= (strrpos($baseurl, '/') === strlen($baseurl) - 1) ? '' : '/';
	return "http://".$baseurl."plugins/content/spreadsheet/";
}

For some reasons script detects not correct url to spreadsheet sources.