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
-~----------~----~----~----~------~----~------~--~---
