[web2py] Re: contrib spreadsheet enhancement

[Alan Etkin]

The app is uploaded in the issues page 
http://code.google.com/p/web2py/issues/detail?id=860#c1

-- 

[web2py] Re: contrib spreadsheet enhancement

[Massimo Di Pierro]

yes. please. thank you.

On Thursday, 21 June 2012 11:45:03 UTC-5, Alan Etkin wrote:
>
> El jueves, 21 de junio de 2012 11:12:34 UTC-3, Massimo Di Pierro escribió:
>>
>> Love the new features. Do you have a patch yet?
>>
>> Mind one thing. Normally spreadsheets are rectangular. In web2py the 
>> spreadsheet is a set of cells with names. They do not have to be displayed 
>> in a rectangular shape. They do not necessarily have rows and cols. 
>> Different cells for the same sheet may be displayed in different pages.
>>
>> So even if some of the new features will only assume for rectangular 
>> spreadsheet, do not assume it is rectangular.
>>
>> massimo
>>
>  
> I sent the patch to web2py issues.
>
> About rectangular display, the default output is a DIV helper that 
> contains a rectangular table. Perhaps there's need of more methods or 
> options for other formats or custom diagrams/output. Anyway, the Sheet 
> class supports accessing cells by key. That way it is possible to build 
> other output formats by retrieving the class instance data.
>
> I can post the prototype with the examples if someone wants to test for 
> backwards compatibility or other issues.
>

-- 

[web2py] Re: contrib spreadsheet enhancement

[Alan Etkin]

El jueves, 21 de junio de 2012 11:12:34 UTC-3, Massimo Di Pierro escribió:
>
> Love the new features. Do you have a patch yet?
>
> Mind one thing. Normally spreadsheets are rectangular. In web2py the 
> spreadsheet is a set of cells with names. They do not have to be displayed 
> in a rectangular shape. They do not necessarily have rows and cols. 
> Different cells for the same sheet may be displayed in different pages.
>
> So even if some of the new features will only assume for rectangular 
> spreadsheet, do not assume it is rectangular.
>
> massimo
>
 
I sent the patch to web2py issues.

About rectangular display, the default output is a DIV helper that contains 
a rectangular table. Perhaps there's need of more methods or options for 
other formats or custom diagrams/output. Anyway, the Sheet class supports 
accessing cells by key. That way it is possible to build other output 
formats by retrieving the class instance data.

I can post the prototype with the examples if someone wants to test for 
backwards compatibility or other issues.

-- 

[web2py] Re: contrib spreadsheet enhancement

[Massimo Di Pierro]

Love the new features. Do you have a patch yet?

Mind one thing. Normally spreadsheets are rectangular. In web2py the 
spreadsheet is a set of cells with names. They do not have to be displayed 
in a rectangular shape. They do not necessarily have rows and cols. 
Different cells for the same sheet may be displayed in different pages.

So even if some of the new features will only assume for rectangular 
spreadsheet, do not assume it is rectangular.

massimo



On Thursday, 21 June 2012 07:28:55 UTC-5, Alan Etkin wrote:
>
> Screenshots showing the new features
>
>
> https://picasaweb.google.com/101593372917288717692/NewSpreadsheetFeaturesProposal?authuser=0&feat=directlink
>
> They were tested with the last stable version and the submitted patch.
>
>

-- 

[web2py] Re: contrib spreadsheet enhancement

[Alan Etkin]

Screenshots showing the new features

https://picasaweb.google.com/101593372917288717692/NewSpreadsheetFeaturesProposal?authuser=0&feat=directlink

They were tested with the last stable version and the submitted patch.

-- 

[web2py] Re: contrib spreadsheet enhancement

[Alan Etkin]

I can't figure how to implement signed urls in that module. Data 
syncronization features are configured passing url arguments (which I think 
leaves using signed urls and verification to the rest of the application 
code, outside of spreadsheet.py).

El viernes, 15 de junio de 2012 13:25:06 UTC-3, Massimo Di Pierro escribió:
>
> Sounds good. No suggestions. Except that this module predates signed URLs 
> and should now take advantage of them.
>
> I added some extra features:
-Sheet class accepts a Rows object for creating the spreadsheet and stores 
client-side table modifications for sending bulk db update commands from 
the spreadsheet page
-row(), colum() and matrix() methods for adding sets of cells.

This needs further tests and refinement. Will send the patch to the issues 
page when it's ready.

[web2py] Re: contrib spreadsheet enhancement

[Massimo Di Pierro]

Sounds good. No suggestions. Except that this module predates signed URLs 
and should now take advantage of them.

On Friday, 15 June 2012 07:16:40 UTC-5, Alan Etkin wrote:
>
> I am trying to use contrib/spreadsheet.py with the project 
> Pyodelgradebooks. I think that the module 
> could be improved with this 
> functionality:
>
>
>- Support _attribute arguments like in helper constructors in .cell() 
>and Sheet.__init___() mainly for setting css options.
>- .row() and perhaps .column() methods for adding cell sequences. 
>.row() would support _attribute also for configuring the html tr elements.
>- default _class and _id attributes for the sheet's xml html.
>- optionally return the spreadsheet as a div helper instance
>
>
> Would these changes follow the module design? In case they are, is there 
> any naming convention for the css style that should be observed (any 
> written convention)?
>
> Another approach for handling the spreadsheet html output attibutes is 
> converting to a TAG instance and setting each instance options, but with 
> the module enhancements that step would not be mandatory. I'd like to know 
> also if there is another way of styling I'm missing that would be 
> appropiate for this case (or in general).
>
> Thanks
>
>