spreadsheet:followed installation and yet no display on page

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 :cry:

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

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.

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? :cry:

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

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

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]

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?

Hi,

it’s works!!!

thanks a lot radyno!
:smiley:

Hi,
unfortunely there is a new problem :confused: … 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?

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)?

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! :slight_smile:

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

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

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 .

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.

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>

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

}</p>

which is incorrect.

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.

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.