spreadsheet for joomla not working

Spreadsheet
#1

I put in [[spreadsheet?&width=600px&height=250px&id=5&math=true]] on an article and have the plugin installed and published/activated and all I get is a blank area on the page…nothing there but a blank space of where the spreadsheet should be.

Any ideas?

#2

firebug shows these javascript errors:

SyntaxError: syntax error
[Break On This Error]

var h, i, j;

spread…load=js (line 7, col 16)

ReferenceError: dhtmlxEvent is not defined
[Break On This Error]

…c_173416);<div id=‘spreadsheet_box_173416’ style='width: 600px; height:…

#3

Hi,
could you provide link to the spreadsheet page?

#4

http://intranet.hbadesign.com/index.php?option=com_content&view=article&id=21

#5

Hi,
for some reasons spreadsheet sources url detected incorecctly.
Please, open file plugins/content/spreadsheet/spreadsheet_data.php, find method get_url and modify it like here:

	protected function get_url() {
		return "{url}";
		/*
		$path = str_replace("\\", "/", pathinfo(__FILE__, PATHINFO_DIRNAME));
		$root = $_SERVER['DOCUMENT_ROOT'];
		$baseurl = $_SERVER['SERVER_NAME'];
		$baseurl .= (strrpos($baseurl, '/') === strlen($baseurl) - 1) ? '' : '/';
		$url = "http://".$baseurl.str_replace($root, "", $path).'/';
		return $url;
		*/
	}

replace {url} with url to spreadsheet directory.

#6

Can the url be relative?

Also I found the get_url function code in spreadsheet.php not spreadsheet_data.php does that sound right?

#7

I used the full path and it’s working now, thank you!

#8

Okay, new problem, I can edit the worksheet…I am an administrator user on the joomla site, but can’t edit it.

#9

Hi,
could you provide me link to your spreadsheet and login/pass to edit them?
You may send it in a PM.

#10

Okay, PM sent.

#11

Hi,
do you use any specific plugins to control users?
Please, open file plugins/content/spreadsheet/spreadsheet_data.php

Modify its code like here:

$conn = new GridCellConnector($res, $db_prefix);

echo "<pre>";
print_r($usergroups);
print_r($available_to);
echo "</pre>";

if (!dhx_can($available_to, $usergroups))
	$conn->set_read_only(true);
$conn->render();

After that open in browser the follow link:
yoursite/plugins/content/spreadsheet/spreadsheet_data.php?sheet=5&dhx_math=true
Please, make sure that as minimal one user group from $usergroups array is included in $available_to array.

#12

This is what gets returned:

Array ( [superusers] => 1 [superadministrator] => 1 [administrator] => 1 [manager] => 1 )

#13

Hi,
which joomla version and spreadsheet plugin version do you use?

#14

Joomla 2.5.7
spreadsheet 1.0

I know 2 beta is out for spreadsheet, but I couldn’t install it, it failed when I tried to install it in joomla.

I might just set the read only to false and let all authenticated users to edit if I can’t get this figured out.

#15

Hi,
please, update file plugins/content/spreadsheet/spreadsheet_data.php from attachment - does it work for now?
spreadsheet_data.zip (1.45 KB)

#16

Yes it does, thank you! What was changed?

#17

Detecting current user groups was incorrect.