At this time you cannot do select/option. You would have to register an onfocus event that opens a popup and when you select a value it copies it in the cell and informs the sever. Doable in about 10 lines of code but a bit tricky. If you do it let me know.
On Jul 4, 8:31 am, Hans <johann.scheibelho...@easytouch-edv.com> wrote: > very nice! > > how can a cell be made a drop down selection with values from db ? > > On Jul 3, 10:48 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > with that looks like this:http://www.web2py.com/examples/spreadsheet > > > On Jul 3, 3:40 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > sheet['cell_name'].size=4 # is the default. You will have to change it > > > for every cell or change it in sheet.py > > > Here is a much better index html that makes it look more like Excel: > > > > {{extend 'layout.html'}} > > > > <style> > > > /* > > > > the code in this page is here just to provide an example > > > none of the css markup and script is required for the sheet to > > > function > > > it is required to make it look good and can be further customized > > > > */ > > > .sheet td { > > > text-align: left; > > > vertical-align: top; > > > padding: 0 0 0 0; > > > border: 0 0 0 0; > > > spacing: 0 0 0 0;} > > > > .sheet input { > > > border: 0;} > > > > td.colhead, td.rowhead { > > > background-color: #bbbbbb; > > > padding-left: 5px; > > > padding-right: 5px;} > > > > td.rowhead { > > > width: 30px; > > > text-align: right;} > > > > </style> > > > > <form> > > > <div class="sheet"> > > > <table> > > > <tr> > > > <td class="colhead" id="selected_cell"></td> > > > <td colspan="{{=sheet.cols}}"> > > > <input readonly id="formula" size="{{=6*sheet.cols}}px"/> > > > </td> > > > </tr> > > > <tr> > > > <td class="colhead"></td> > > > {{for c in xrange(sheet.cols):}} > > > <td class="colhead">c{{=c}}</td> > > > {{pass}} > > > </tr> > > > {{for r in xrange(sheet.rows):}} > > > <tr> > > > <td class="rowhead">r{{=r}}</td> > > > {{for c in xrange(sheet.cols):}} > > > <td class="cells"> > > > {{=XML(sheet.nodes['r%sc%s'%(r,c)].xml())}} > > > </td> > > > {{pass}} > > > </tr> > > > {{pass}} > > > </table> > > > </div> > > > </form> > > > > <script> > > > function update_formula(t) { > > > if(t) { > > > jQuery('#selected_cell').html(jQuery(t).attr('id')); > > > jQuery('#formula').val(jQuery(t).val()); > > > } else { > > > jQuery('#selected_cell').html(''); > > > jQuery('#formula').val(''); > > > } > > > }; > > > jQuery('.cells input').focus(function(){update_formula(this);}); > > > jQuery('.cells input').keyup(function(){update_formula(this);}); > > > jQuery('.cells input').blur(function(){update_formula(null);}); > > > </script> > > > > On Jul 3, 2:47 pm, Hans <johann.scheibelho...@easytouch-edv.com> > > > wrote: > > > > > great stuff massimo!!! > > > > > how can the size of the cells be adjusted? Basically I want wider > > > > cells. > > > > > Thanks, > > > > Hans > > > > > On Jul 3, 4:16 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > > Do you need to embed an ajax spreadsheet in you app. Now you have it: > > > > > >http://www.vimeo.com/5432441http://www.web2py.com/appliances/default/... > > > > > > Please let know about bugs > > > > > > Massimo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
