Spreadsheet plugin for joomla not working

Spreadsheet
#1

I have installed the spreadsheet plugin in my joomla site. The problem is the spreadsheet shows up without any menu bar or edit button just only export to excel and pdf buttons appearing.

Please anyone could help.

#2

Hi,
only Super Users, Administrators and Managers can edit events. Please, make sure that you’re logged in at fron-end, not only in back-end.
You may alter list of user groups who can edit data in file plugins/content/spreadsheet/spreadsheet_data.php:

$available_to = Array(
	'Super Users' => true,
	'superadministrator' => true,
	'administrator' => true,
	'manager' => true
);
#3

I have done all, but no effect. All I get is this

spreadsheet.jpg744×335 27 KB

Also can you advise how to populate the spreadsheet with data. I suppose it is copy paste or is there any other way also.

Thank you

#4

Hi,
please, try to modify the same file 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();

It should output two arrays - the first one is a list of current user groups.
The second array is a list of user groups who can edit data. So make sure that at least one user group from the first array presents in the second array.

We don’t provide any export tools or something like this, so the best way would be to use copy-paste.

#5

Thank you so much for your time. I have replaced the code with your suggested code. Now spreadsheet is not showing at all.

I am not sure I understand this very well

“It should output two arrays - the first one is a list of current user groups.
The second array is a list of user groups who can edit data. So make sure that at least one user group from the first array presents in the second array.”

can u further explain this. Thank you very much in advance.

#6

Sorry, forget to tell - you should open in browser the follow link:
yoursite/plugins/content/spreadsheet/spreadsheet_data.php?sheet=1
replace yoursite with your site name and 1 with your spreadsheet id.

Some more details about access rights:
Each user in joomla has a list of user groups.
Spreadsheet has a list of enabled user groups. Each user who has a user group from this enabled list can edit data.
For example:
enabled list of user groups:

$available_to = Array(
	'Super Users' => true,
	'superadministrator' => true,
	'administrator' => true,
	'manager' => true
);

Super Users, superadministrator, administrator, manager.

Let’s take user who is in user group ‘editor’. This user group is not in array $available_to, so this user can’t edit ssheet data.
But if user has user groups ‘editor’ and ‘manager’ then he can change data of ssheet, because ‘manager’ is in $available_to.

List of usergroups is in variable $usergroups.
Does it make sense?

#7

I ran through this and only one array prints for me.

#8

Could you detect which one of them - $usergroups or $available_to?