Spreadsheet editor

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Spreadsheet editor

Peter Uhnak
Hi,

since there has been talk about Tabular/DOCX,
is there any project aimed at actually editing tables/spreadsheets inside Pharo?

There's Spreadsheet by Torsten, but that seems to be an abandoned proof-of-concept.

Peter
Reply | Threaded
Open this post in threaded view
|

Re: Spreadsheet editor

S Krish

Should try an ActiveX / Open Office embedded in Pharo if the whole capability of spreadsheets is required from Pharo.



On Tue, Aug 11, 2015 at 10:15 PM, Peter Uhnák <[hidden email]> wrote:
Hi,

since there has been talk about Tabular/DOCX,
is there any project aimed at actually editing tables/spreadsheets inside Pharo?

There's Spreadsheet by Torsten, but that seems to be an abandoned proof-of-concept.

Peter

Reply | Threaded
Open this post in threaded view
|

Re: Spreadsheet editor

Hannes Hirzel
In reply to this post by Peter Uhnak
On 8/11/15, Peter Uhnák <[hidden email]> wrote:
> Hi,
>
> since there has been talk about Tabular/DOCX,

http://ss3.gemtalksystems.com/ss/Tabular.html

> is there any project aimed at actually editing tables/spreadsheets inside
> Pharo?
>
> There's Spreadsheet by Torsten, but that seems to be an abandoned
> proof-of-concept.
>
> Peter
>

There is a start at using Glamour and Spec to view the tables in Tabular.

http://ss3.gemtalksystems.com/ss/Tabular.html

I have not tried it out yet. Needs a Glamour specialist to have a look.
Not sure about editing.

NeoCSV style import works ; limited export works.

Currently I am focused on getting roundtrip Import / Export of XLSX
files working for a slightly extended subset of the features. (cell
attributes, in particular 'font size, word wrap and column width
attributes')

To have a display of it would be great.

--Hannes


TabularWorksheet>>showWithGlamour
        | wrapper matrix table |
        matrix := self cellsAsMatrix.
        wrapper := GLMWrapper new.
        wrapper
                show: [ :a |
                        table := a table.
                        1 to: matrix columnCount do: [ :i | table column: i asString
evaluated: [ :col | col at: i ] width: 50 ] ].
        wrapper openOn: ((1 to: matrix rowCount) collect: [ :i | matrix atRow: i ])




TabularWorksheet>>showWithSpec
        | matrix tree specCols |
        matrix := self cellsAsMatrix.
        tree := TreeModel new.
        specCols := (1 to: matrix columnCount)
                collect: [ :i |
                        TreeColumnModel new
                                displayBlock: [ :node | (node content at: i) asString ];
                                headerLabel: i asString;
                                yourself ].
        tree columns: specCols.
        tree roots: ((1 to: matrix rowCount) collect: [ :i | matrix atRow: i ]).
        tree openWithSpec.

Reply | Threaded
Open this post in threaded view
|

Re: Spreadsheet editor

Hannes Hirzel
I think the priority at the moment is to get the non-GUI operations
working fine.

Export currently only works for one sheet and more tests are needed,
see other thread.

Excel and LibreOffice Calc  are the spreadsheet editors! The focus is
to get Pharo interacting nicely with this ubiquitous data format .....

Simple cases are fine but we need more.



On 8/11/15, H. Hirzel <[hidden email]> wrote:

> On 8/11/15, Peter Uhnák <[hidden email]> wrote:
>> Hi,
>>
>> since there has been talk about Tabular/DOCX,
>
> http://ss3.gemtalksystems.com/ss/Tabular.html
>
>> is there any project aimed at actually editing tables/spreadsheets inside
>> Pharo?
>>
>> There's Spreadsheet by Torsten, but that seems to be an abandoned
>> proof-of-concept.
>>
>> Peter
>>
>
> There is a start at using Glamour and Spec to view the tables in Tabular.
>
> http://ss3.gemtalksystems.com/ss/Tabular.html
>
> I have not tried it out yet. Needs a Glamour specialist to have a look.
> Not sure about editing.
>
> NeoCSV style import works ; limited export works.
>
> Currently I am focused on getting roundtrip Import / Export of XLSX
> files working for a slightly extended subset of the features. (cell
> attributes, in particular 'font size, word wrap and column width
> attributes')
>
> To have a display of it would be great.
>
> --Hannes
>
>
> TabularWorksheet>>showWithGlamour
> | wrapper matrix table |
> matrix := self cellsAsMatrix.
> wrapper := GLMWrapper new.
> wrapper
> show: [ :a |
> table := a table.
> 1 to: matrix columnCount do: [ :i | table column: i asString
> evaluated: [ :col | col at: i ] width: 50 ] ].
> wrapper openOn: ((1 to: matrix rowCount) collect: [ :i | matrix atRow: i
> ])
>
>
>
>
> TabularWorksheet>>showWithSpec
> | matrix tree specCols |
> matrix := self cellsAsMatrix.
> tree := TreeModel new.
> specCols := (1 to: matrix columnCount)
> collect: [ :i |
> TreeColumnModel new
> displayBlock: [ :node | (node content at: i) asString ];
> headerLabel: i asString;
> yourself ].
> tree columns: specCols.
> tree roots: ((1 to: matrix rowCount) collect: [ :i | matrix atRow: i ]).
> tree openWithSpec.
>