dhtmlxSpreadsheet problem to get started

Suite and Optimus Suite 5
#1

Hallo, i will introduse myself
My name is Renee And i am from The Netherlands (sorry for my bad English)

I hope someone can help me.
I am trying to get the dhtmlxSpreadsheet working on my joomla website. (version 2.5)
But i can not get it working.
I made the following actions.
*Downloaded Standard Edition v.1.0 en installed the joomla plugin
*activate the plugin
*made the database connection see the link below
(docs.dhtmlx.com/doku.php?id=dhtm … installing)

And if i understand correctly , i just need to make a new artikel with the text

and a spreadsheet wil be generated.

But nothing happens
if i try: [[spreadsheet]] a sheet will show, but i can not put information in the cell (read-only???)

What am i missing…

#2

Please, provide a demo link whit your working dhtmlxSpreadSheet where the issue can be reconstructed.

#3

Hello

I did remove the page on witch i was trying to install the spreatsheet.
but i have some screenshots

this is how it looks like when i just type [[spreadsheet]]
(picture named joomla-pluging-wrong)

jooml-pluging-wrong.jpg800×500 13.5 KB

it should look like this, so in understand.
(picture named joomla-good)

joomla_plugin-good.png800×542 204 KB

If i enter a script noting happens
(picture named zotoch)

zo toch.jpg1010×631 59.3 KB

if you want me to make a new page on my website, i will do that with
pleasure, i hope that the sollution will come

#4

Hi Renee,
please, make sure that you are logged in at front-end (Joomla has different login system for front-end and back-end so even if you’re logged in at back-end, you should log in at front-end too), because plugin provides ability to edit data only for superadministrators, administrators and managers. If still doesn’t work, please provide working link with access credentials, you may send it into private message.

#5

Hallo Thank you for offering me help.
I will send a private message with the log in frond-end:
-Registrated
-Administrator

#6

-Registrated
-author (not ministrator)

#7

Hi,
please, open file plugins/content/spreadsheet/spreadsheet_data.php, find the follow code:

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

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

and replace it with the follow:

$conn = new GridCellConnector($res, $db_prefix);
echo "<pre>";
print_r($available_to);
print_r($usergroups);
echo "</pre>";
if (!dhx_can($available_to, $usergroups))
	$conn->set_read_only(true);
$conn->render();

After that open in browser link yoursite/plugins/content/spreads … hp?sheet=1

It will output two arrays: the first with usergroups who can edit data in spreadsheet, the second is a list of all detected user groups. Please, make sure, that user groups present in $available_to array.

#8

Yes!!

I worked, thank you.
Wow i tried so many things. and finaly with your help, THANK YOU!

One more question, is it possible to add tabs (multible sheets) like in excel?

#9

Hi,
no, spreadsheet doesn’t support such feature for now, maybe it will be introduced in the future.

#10

Okay thank you.

But is it possible to add multiple diverent spreadsheets on one website?
I tried it on diverent new artikels, but than i get the same sheet on each
page (artikel)

#11

Hi,
yes, you may specify spreadsheet id for each spreadsheet short tag so it will be different sheets.
Here is details about configuring spreadsheets in Joomla:
docs.dhtmlx.com/doku.php?id=dhtm … the_plugin

#12

Okay thank you!!

I am happy that it works the way i want it to work
Once again thank you !!

Have a nice weekend.

Kind Regards
Renee

#13

Hello Radyno

I thougt i had the whole thing working but no…
I still can not get diverent spreadsheets on my website
The link you send me, i am sorry, but even when i translate it in google translate, i simply do not get it.

Is it to much to ask, if you can give me two different example script’s for two pages
so i have two diverent spreadsheets on my website?

Kind regards
Renee

#14

Yess. i got it!!!

It works the way i want it to work
Thank you for your help.

Kind regards
Renee

#15

Hi,

I have the same problem: like in the screenshot above, from lafox, I am not able to edit the spreadsheet. I also replaced the provided code in the file plugins/content/spreadsheet/spreadsheet_data.php.

What I get in the browser is only the first array:

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

and
Fatal error: Call to undefined function dhx_can() in /home/site/public_html/site/plugins/content/spreadsheet/spreadsheet_data.php on line 81

Could you help with this one? Is this why I cannot edit the spreadsheet?

#16

Sorry,

and this is what I get in the browser with the original version of the file plugins/content/spreadsheet/spreadsheet_data.php

{ “sheetid”: “1”, “config”: “”, “readonly”: true, “head”: [ ], “cells”: [ ] }

#17

Hello

I will try to help you,
you are using joomla?
if you at this in your artikel [[spreatsheet]] what happens?

If there is a spreadsheet, then i know how to help you

#18

Hi lafox,

thank you for your willing to help me :stuck_out_tongue:

I use Joomla, and when I add [[spreadsheet]] in my article, in the frontend I get indeed the spreadsheet, but I am not able to edit anything.
Just like in your image (picture named joomla-pluging-wrong): I can only export as Excel or Pdf.

I was thinking that maybe it’s a “user rights” issue, but I am the super user and still cannot edit the spreadsheet :frowning:

#19

and this is what I get in the browser with the original version of the file plugins/content/spreadsheet/spreadsheet_data.php

{ “sheetid”: “1”, “config”: “”, “readonly”: true, “head”: [ ], “cells”: [ ] }

this is your spreadsheet_data.php

Now make it so:
{ “sheetid”: “1”, “config”: “”, “readonly”: false, “head”: [ ], “cells”: [ ] }

#20

Now all vissiters in your website can use the spreatsheet