Shared Spreadsheet

Spreadsheet
#1

Hello,

What is the best way to update automatically an shared spreadsheet ?

  1. User 1 access to Spreadsheet A

  2. User 2 access to Spreadsheet A

  3. User 3 access to Spreadsheet B

  4. User 4 access to Spreadsheet A

  5. User 2 start editing the cell B1 of Spreadsheet A

  6. System lock the cell B1 of Spreadsheet A for User 1 and User 4

  7. User 2 validate the cell B1 of Spreadsheet A with the value “ABC”

  8. System save the cell B1 of Spreadsheet A in database

  9. System send cell B1 value “ABC” of Spreadsheet A to User 1 and User 4

  10. System unlock cell B1 of Spreadsheet A for User 1 and User 4

What is the best way to do step 6, 9 and 10 ?

I can use PHP Websockets but i’ve noticed that there’s no Javascript API for updating cells.

Thanks for your answer.

JC

#2

Hi,
unfortunately there is no way to implement live-updates in spreadsheet for now.

#3

I’ve finally found out how initiate / update cell with javascript :

dhx_sh.grid.cells(2,2).setValue(123456);

and for global update I can use that :

dhx_sh.refresh(dhx_sh.serialize_settings(),false);

It will resolve Step 9 of my need if I use PHP Websockets. I think that live updates are now possible, i’ll working on it.

JC

#4

Good work!

#5

Dactar, did you succeed with liveupdate in spreadsheet? Or anybody had chance to make it? Please answer, it is very important for group work in spreadsheet, otherwise it is not useful at all.
Thanks