spreadsheet:followed installation and yet no display on page

ibaanassociation · March 6, 2012, 9:14am

hello everybody,
i just add the spreadsheet plugin for wordpress and active. so what will i do in the page editor? where will i get the id? sorry im not computer expert. i followed the documentation in plain simple and no display

ibaanassociation · March 6, 2012, 9:20am

i forgot something to add. i uploaded spreadsheet in the wp-content/plugin folder. is that right?

radyno · March 7, 2012, 9:15am

Hi,
here is documentation about using plugin for Wordpress:
docs.dhtmlx.com/doku.php?id=dhtm … _wordpress

Please, use wordpress plugins installer, it will locate plugin at correct place (wp-content/plugins/spreadsheet/).
After that you have to add placeholder to page. Provided doc describes how to do it.

ibaanassociation · March 7, 2012, 7:16pm

hi radyno,
actually plug-in is installed correctly. and when i put the marker [[spreadsheet]] in a new page nothing showup except white space in a box. did i miss something?

martuelas · June 4, 2012, 10:19am

I have the same problem.
I’m trying to install the plugin in a localhost wordpress installation but when i put shortcode i see an empty page. in the code of the page there is the spreadsheet

but it’s empty.
I had read the faq and the installation page.
i also tried to put this code in the header.php file of my theme but doesn’t work.

[code]

[/code] Anyone can help me? thanks

radyno · June 4, 2012, 1:40pm

Hi,
does any JavaScript error occur?
Could you provide link to this page?

martuelas · June 5, 2012, 10:20am

these are the errors in the page

[code]onload_func is not defined

…t><div id=‘spreadsheet_box_131036’ style='width: 600px; height: 400px; backgroun…

$(".multi-sidebar").tabs is not a function

$(’.multi-sidebar’).tabs();[/code]

radyno · June 6, 2012, 8:14am

Hi,
please, open file wp-content/plugins/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}();";

If still doesn’t work, could you provide link to spreadsheet page?

martuelas · June 6, 2012, 3:25pm

Hi,

it’s works!!!

thanks a lot radyno!

martuelas · June 7, 2012, 3:03pm

Hi,
unfortunely there is a new problem … in my pc the spreadsheet is visible and works in the page but in all others pc (it’s a little intranet) the page in empty…
this is the error:

dhtmlxSpreadsheet is not defined dhx_sh = new dhtmlxSpreadsheet ({

can you help me?

radyno · June 8, 2012, 8:55am

Hi,
does any error occur?
Can file http:// domain/wp-content/plugins/spreadsheet/codebase/spreadsheet.php?load=js be accessed from remote pc (replace domain in url with your own)?

martuelas · June 21, 2012, 2:24pm

i found the error
i wrote

http://localhost/wp-content/plugins/spreadsheet/codebase/spreadsheet.php?load=js

in header.php file

and was

http://servertech/wp-content/plugins/spreadsheet/codebase/spreadsheet.php?load=js

thanks!

normawhite · August 1, 2012, 6:27pm

Hi
I read about spreadsheet and chart: they sound great, but I am not starting out well. I am using Joomla. I followed the Joomla plugin guide: downloaded and enabled spreadsheet. Entered the simple [[spreadsheet]] and a few variants of the other example in an article and see nothing (empty space), not even an empty spreadsheet. I am logged on to both front and backend as administrator. The height of the empty space changes when I change the height parameter.
How do I get over this hurdle?
BTW when I search the forum for joomla, or joomla/spreadsheet, nothing is returned.
Thanks in advance
Norma

radyno · August 2, 2012, 9:19am

Hi,
does any javascript error occur when page is loaded?
Could you provide link to your page with spreadsheet?

Xenophane · January 18, 2013, 11:20am

I am seeing the same issue in Wordpress 3.5 and version 2.0 of the spreadsheet software

I installed the plugin and tried to put [[spreadsheet]] on a blank page, the page is just displaying as blank, if I try to put more parameters on like Window Size, the blank space is expanding.

This is what I get in the error file:
[18-Jan-2013 10:50:11 UTC] WordPress database error Table ‘edelliis_wpxxxxxxx.wp_data’ doesn’t exist for query SELECT * FROM wp_data made by require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(’/plugins/dhtmlxspreadsheet/spreadsheet.php’), sh_load_dump

[18-Jan-2013 10:50:11 UTC] WordPress database error Duplicate entry ‘demo_sheet’ for key ‘PRIMARY’ for query INSERT INTO wp_dhx_sheet VALUES (‘demo_sheet’, null, null, ‘any_key’, null) made by require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(’/plugins/dhtmlxspreadsheet/spreadsheet.php’), sh_load_dump

The link to the test page is http:// stotXedelliisbergXdk/tested/
replace X with .

radyno · January 21, 2013, 11:59am

Hi,
have a look at code generated by spreadsheet plugin (you may see it in page html code):

<script>var dhx_sh;
function onload_func_467294() {
	window.setTimeout(function() {
		var cfg = {
	sheet: '1',
	dhx_rel_path: 'http://stot.edelliisberg.dk/wp-content/plugins/dhtmlxspreadsheet/codebase/',
	parent: 'spreadsheet_box_467294',
	load: 'http://stot.edelliisberg.dk/wp-content/plugins/dhtmlxspreadsheet/spreadsheet_data.php',
	save: 'http://stot.edelliisberg.dk/wp-content/plugins/dhtmlxspreadsheet/spreadsheet_data.php',
skin: 'dhx_skyblue',
math: false,
autowidth: false,
autoheight: true
}

dhx_sh = new dhtmlxSpreadSheet({
			load: cfg.load,
			save: cfg.save,
			parent: cfg.parent,
			autowidth: cfg.autowidth,
			autoheight: cfg.autoheight,
			skin: cfg.skin,
			math: cfg.math,
			icons_path: cfg['dhx_rel_path'] + 'imgs/icons/',
			image_path: cfg['dhx_rel_path'] + 'imgs/'
		});
		dhx_sh.load(cfg.sheet||'1', cfg.key||null);
	}, 1);
}
onload_func_467294();</script><div id='spreadsheet_box_467294' style='width: 100%; height: auto; background-color:white;'></div>

while it must be like this:

<script src='http://sitename/wp-content/plugins/dhtmlxspreadsheet/codebase/spreadsheet.php?load=js' type='text/javascript' charset='utf-8'></script>
<link rel='stylesheet' href='http://sitename/wp-content/plugins/dhtmlxspreadsheet/codebase/dhtmlx_core.css' type='text/css' charset='utf-8'>
<link rel='stylesheet' href='http://sitename/wp-content/plugins/dhtmlxspreadsheet/codebase/dhtmlxspreadsheet.css' type='text/css' charset='utf-8'>
<link rel='stylesheet' href='http://sitename/wp-content/plugins/dhtmlxspreadsheet/codebase/dhtmlxgrid_reset.css' type='text/css' charset='utf-8'>
<script>var dhx_sh;
function onload_func_544836() {
	window.setTimeout(function() {
		var cfg = {
	sheet: '2',
	dhx_rel_path: 'http://192.168.1.70/spreadsheet/wp/wp1/wordpress/wp-content/plugins/dhtmlxspreadsheet/codebase/',
	parent: 'spreadsheet_box_544836',
	load: 'http://192.168.1.70/spreadsheet/wp/wp1/wordpress/wp-content/plugins/dhtmlxspreadsheet/spreadsheet_data.php',
	save: 'http://192.168.1.70/spreadsheet/wp/wp1/wordpress/wp-content/plugins/dhtmlxspreadsheet/spreadsheet_data.php',
skin: 'dhx_skyblue',
math: false,
autowidth: false,
autoheight: true
}

dhx_sh = new dhtmlxSpreadSheet({
			load: cfg.load,
			save: cfg.save,
			parent: cfg.parent,
			autowidth: cfg.autowidth,
			autoheight: cfg.autoheight,
			skin: cfg.skin,
			math: cfg.math,
			icons_path: cfg['dhx_rel_path'] + 'imgs/icons/',
			image_path: cfg['dhx_rel_path'] + 'imgs/'
		});
		dhx_sh.load(cfg.sheet||'1', cfg.key||null);
	}, 1);
}
dhtmlxEvent(window, 'load', onload_func_544836);</script><div id='spreadsheet_box_544836' style='width: 100%; height: auto; background-color:white;'></div>

There aren’t including js/css spreadsheet files. I guess some other plugin may cut them.

jab1x · February 10, 2013, 7:38pm

I am experiencing the same issue (Wordpress 3.5 and version 2.0 of the spreadsheet software). I installed the software. Then I placed the spreadsheet into my post using the following shortcode

[[spreadsheet?&width=600px&id=1&height=400px&color_scheme=salad&math=true]]. A blank area is displayed.
Kindly reply to this request. This plugin seems to be perfect for my site, I just need to get it working. Thank you.
Here is the html code from my page.

<div class="entry">
<p><script src='http://martin2014.techbizpartner.com/wp-content/plugins/spreadsheet/codebase/spreadsheet.php?load=js' type='text/javascript' charset='utf-8'></script></p>
<link rel='stylesheet' href='http://martin2014.techbizpartner.com/wp-content/plugins/spreadsheet/codebase/dhtmlx_core.css' type='text/css' charset='utf-8'>
<link rel='stylesheet' href='http://martin2014.techbizpartner.com/wp-content/plugins/spreadsheet/codebase/dhtmlxspreadsheet.css' type='text/css' charset='utf-8'>
<link rel='stylesheet' href='http://martin2014.techbizpartner.com/wp-content/plugins/spreadsheet/codebase/dhtmlxgrid_reset.css' type='text/css' charset='utf-8'>
<link rel='stylesheet' href='http://martin2014.techbizpartner.com/wp-content/plugins/spreadsheet/skins/dhx_skyblue/salad/dhtmlx_custom.css' type='text/css' charset='utf-8'>
<script>var dhx_sh;
function onload_func_721927() {
	window.setTimeout(function() {
		var cfg = {
	sheet: '1',
	dhx_rel_path: 'http://martin2014.techbizpartner.com/wp-content/plugins/spreadsheet/codebase/',
	parent: 'spreadsheet_box_721927',
	load: 'http://martin2014.techbizpartner.com/wp-content/plugins/spreadsheet/spreadsheet_data.php',
	save: 'http://martin2014.techbizpartner.com/wp-content/plugins/spreadsheet/spreadsheet_data.php',
skin: 'dhx_skyblue',
math: true,
autowidth: false,
autoheight: false
}</p>
<p>dhx_sh = new dhtmlxSpreadSheet({
			load: cfg.load,
			save: cfg.save,
			parent: cfg.parent,
			autowidth: cfg.autowidth,
			autoheight: cfg.autoheight,
			skin: cfg.skin,
			math: cfg.math,
			icons_path: cfg['dhx_rel_path'] + 'imgs/icons/',
			image_path: cfg['dhx_rel_path'] + 'imgs/'
		});
		dhx_sh.load(cfg.sheet||'1', cfg.key||null);
	}, 1);
}
dhtmlxEvent(window, 'load', onload_func_721927);</script>
<div id='spreadsheet_box_721927' style='width: 600px; height: 400px; background-color:white;'></div>
					
					<div class="clearboth"></div>

radyno · February 11, 2013, 8:34am

Hi,
it looks like some plugin modifies code of spreadsheet at your site, because generated code includes the follow line:

}</p>

which is incorrect.

jab1x · February 12, 2013, 5:18am

Thanks. I see what you mean. Is there anything that I can do in spreadsheet/spreadsheet_common.php to remove the

and

? Or, how would I go about finding the code that is inserting these html tags? Any suggestions would be much appreciated because I really want to use this plugin. Thanks for your help.

radyno · February 12, 2013, 9:04am

Hi,
this tag was added already after spreadsheet code is generated, so there is no way to remove it during spreadsheet generating.
The easiest way would be to deactivate all plugins one-by-one and to check if spreadsheet works properly.