owc 11 spreadsheet client side events

[Abhilash]

hi,

I can get a spreadsheet (owc 11) on the webpage but i just can figure how to
attach events. For example i want to know when a cell changes in the
spreadsheet and take some appropriate actions. Is this possible and how?.
Any pointers will be helpful

Best regards,
Abhilash

 

[Alvin Bruney [MVP]]

there are two ways to respond to the event. both ways are thru scripting
because it is a client-side object.
vbscript

inside your html page
sp_sheetchange(sh,Target) where sp is the name of your spreadsheet -
given by its id. you must use the correct function prototype in order for it
to work. you can find the function signature in the help files.

javascript
inside your html page
<script language='javascript' for='sp'
event='SheetChange(Sh,Target)'>alert('hello, world!');</script>