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 <hannes.hir...@gmail.com> wrote: > On 8/11/15, Peter Uhnák <i.uh...@gmail.com> 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. >
