Re: [Pharo-users] Spreadsheet editor
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 TabularWorksheetshowWithGlamour | 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 ]) TabularWorksheetshowWithSpec | 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.
Re: [Pharo-users] Spreadsheet editor
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 i.uh...@gmail.com 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
Re: [Pharo-users] Spreadsheet editor
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 TabularWorksheetshowWithGlamour | 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 ]) TabularWorksheetshowWithSpec | 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.
