dhtmlxSpreadsheet problem to get started

Suite and Optimus Suite 5
#21

Well, this makes sense :blush:

Thank you! I will try this the day after tomorrow, when I have access to the ftp. But if is a “user rights” issue, this should do the trick :slight_smile:

#22

That worked Renee, thanks!

In the file plugins/content/spreadsheet/spreadsheet_data.php I modified this last code:

$conn = new GridCellConnector($res, $db_prefix);
if (!isset($available_to[$usertype]) || $available_to[$usertype] == false)
$conn->set_read_only(false); // Changed from true to false
$conn->render();

#23

I’m glad I was able to help.

Kind regards
Renee (from the Netherlands)

#24

Hi lafox,

I think I did similar thing before when playing with the dhtmlxSpreadsheet.

I used dhtlmxTabbar and attached a different page to each tab content, like this:

[code]var b = mainLayout.cells(‘b’);
sheetTabbar = b.attachTabbar();

sheetTabbar.addTab(‘sheet1Tab’,‘Sheet 1’,’’);
var sheet1Tab = sheetTabbar.cells(‘sheet1Tab’);
sheetTabbar.setTabActive(‘sheet1Tab’);
sheetTabbar.enableTabCloseButton(true);
sheet1Tab.attachURL(‘sheet1.php’);

sheetTabbar.addTab(‘sheet2Tab’,‘Sheet 2’,’’);
var sheet2Tab = sheetTabbar.cells(‘sheet2Tab’);
sheetTabbar.enableTabCloseButton(true);
sheet2Tab.attachURL(‘sheet2.php’); [/code]

I hope this helps!

#25

Hello Adam

Thank you, it gets better and better!
dit you add the text in:
/plugins/content/spreadsheet/spreadsheet_data.php

#26

Hi lafox.
You may paste the follow code to paste two spreadsheets at the same page:

First price is here:

[[spreadsheet?&width=600px&height=400px&id=first_price]]
<br>some text is here<br>
Second price is here<br>
[[spreadsheet?&width=600px&height=400px&id=second_price]]
#27

By the way, good work, guys!

#28

Grrrrrr. my website is hacked.
I have to repair the damage, i will get back to this topic
(may take a wile) but i will report my findings

#29

Hi

I did what you said up and i have this

[code]Array
(
[Super Users] => 1
[superadministrator] => 1
[administrator] => 1
[manager] => 1
)
Array
(
)

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

what can be wrong ?

thank you in advance

#30

Somehow i managed to get it working but i miss excel, pdf and settings button.
Is there some parameter for those?
thanks

#31

Hi david_b,
please, make sure that width of spreadsheet is enough to show all buttons in header.
Usually this problem appears when width is small.

#32

hi
width is 600 and i tryed with 800 also but the same. it has space for the buttons
i attached a print screen

table.png1026×672 17.1 KB

#33

Could you provide me link to your page with spreadsheet?

#34

i sent you a pm
thanks a lot

#35

Hi,
I logged in, but for some reasons I see spreadsheet in readonly mode (only export to PDF and Excel buttons).

#36

i checked again and have all rights
what i did was to go to site, login with user and pass and click on test table and i see excactly what i uploaded here

do you want to try one more time?

#37

Now I have access.
Please, try to set the width of spreadsheet 30 pixels more.
It will fix a problem with export buttons.

#38

I set it from 600 to 700 and you are right, i see export buttons and also settings button
thanks a lot for your time