Pharo-users

By thread

pharo-users@lists.pharo.org

August 2015

68 participants
450 messages

Re: [Pharo-users] Tabular: XLSX import

by H. Hirzel

The attribute t="s" of a cell c seems to indicate that the content has to be interpreted as a shared string. XLSXImporter>>resolveSharedStrings "Replace shared strings pointers to real strings" workbook worksheets do:[:worksheet| worksheet cells do:[:cell| ((cell attributeAt: #xlsx:t) = 's') ifTrue:[cell data: (sharedStrings at: (cell data asNumber + 1))] "XLSX uses 0-based arrays" ] ] On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: > For the shared strings in sheet1.xml for example > > <c r="A1" s="1" t="s"> > > what do the attributes s and t stand for? > > > <row r="1" customFormat="false" ht="35.05" hidden="false" > customHeight="false" outlineLevel="0" collapsed="false"> > <c r="A1" s="1" t="s"> > <v>0</v> > </c> > </row> > > <row r="5" customFormat="false" ht="79.85" hidden="false" > customHeight="false" outlineLevel="0" collapsed="false"> > <c r="B5" s="1" t="s"> > <v>1</v> > </c> > </row> > > > On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.52.mcz >> 47 test run, 37 passes. >> >> >> Currently I have a fixed string >> >> TabularXSLXExport>>sharedStrings_xml >> ^'<?xml version="1.0" encoding="UTF-8" standalone="yes"?> >> <sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" >> count="1" uniqueCount="1"> >> <si><t> </t></si> >> </sst>'. >> >> How far can I safely ignore constructing a proper xl/sharedStrings.xml >> in the archive? >> >> >> >> On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>> Found a useful summary about for generating XLSX files >>> >>> http://stackoverflow.com/questions/6055430/how-to-create-xlsx-file-without-… >>> >>> On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.50.mcz >>>> >>>> Another question is about the >>>> >>>> #colspan: property of a cell >>>> >>>> >>>> (wsheet cells at: 1 @ 1) colspan: 1. >>>> >>>> actually makes cell A1 span 2 columns. >>>> >>>> Is this OK according to the standard? >>>> >>>> >>>> >>>> >>>> TabularXLSXExportTest>>testExport7 >>>> >>>> | wbk wsheet | >>>> wbk := TabularWorkbook new. >>>> self assert: (wbk worksheets isEmpty). >>>> >>>> wsheet := TabularWorksheet new. >>>> wsheet >>>> at: 1 @ 1 putData: 'aaa'; >>>> at: 3 @ 1 putData: 'ccc'. >>>> (wsheet cells at: 1 @ 1) colspan: 1. >>>> >>>> wbk worksheets add: wsheet. >>>> TabularXSLXExport workbook: wbk fileName: fname7. >>>> >>>> "manual inspection shows that the exported file is fine" >>>> "But is the colspan command fine? Add a colspan test to TabularCell" >>>> >>>> >>>> On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>>>> Hello Jurij and Vincent >>>>> >>>>> I am working on extending the export function (export of several >>>>> worksheets). >>>>> >>>>> For this I am adding some more tests currently and I'd like to have >>>>> your feedback on some of the basic functions regarding initial values. >>>>> >>>>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.49.mcz >>>>> (41 tests run, 32 passes) >>>>> >>>>> in particular on class TabularWorksheetTest (3 tests) >>>>> >>>>> We have for example >>>>> >>>>> >>>>> Test which passes >>>>> >>>>> testCellsReadingEmptyCell0 >>>>> "accessing a cell without data" >>>>> >>>>> ws col: 1 row: 1 putData: 11. >>>>> ws col: 2 row: 1 putData: 21. >>>>> >>>>> self assert: (ws col: 1 row: 1) data equals: 11. >>>>> self assert: (ws col: 2 row: 1) data equals: 21. >>>>> >>>>> self assert: ((ws col: 3 row: 1) isNil). "Is this OK to have >>>>> nil returned?" >>>>> >>>>> >>>>> >>>>> Test which does not pass >>>>> >>>>> testCellsReadingEmptyCell >>>>> >>>>> self assert: ((ws col: 100 row: 100) data =''). >>>>> >>>>> "probably should return an empty string" >>>>> >>>>> >>>>> Comments of others are invited as well. >>>>> >>>>> -- Hannes >>>>> >>>>> On 8/9/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>>>>> If your are using at least Pharo 4.0, you can use the catalog browser >>>>>> to >>>>>> load the ConfigurationOfTabular directly. >>>>>> >>>>>> You have only publish it for MetaRepoForPharo50, so it didn't work >>>>>> for >>>>>> Pharo 4. >>>>>> BUt, thanks to your explanations, I just have published in >>>>>> MetaRepoForPharo40 as well - works like charm! >>>>>> >>>>>> 2015-08-08 12:45 GMT+03:00 Vincent BLONDEAU < >>>>>> vincent.blondeau(a)polytech-lille.net>: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> I added the dependencies to PharoExtras/XMLWriter and XMLParser. >>>>>>> I didn't add the dependencies before because I used Tabular with >>>>>>> Moose, >>>>>>> and Moose already loads these dependencies... >>>>>>> >>>>>>> Now it should work. I created the new 0.2 release with the required >>>>>>> dependencies. >>>>>>> >>>>>>> By the way, I used Versionner to create the configuration. I don't >>>>>>> know >>>>>>> if >>>>>>> there is a documentation but there is a video: >>>>>>> https://www.youtube.com/watch?v=cFRJDuWL-Q0 >>>>>>> >>>>>>> It is a very fast tool to manage your projects! >>>>>>> >>>>>>> If your are using at least Pharo 4.0, you can use the catalog >>>>>>> browser >>>>>>> to >>>>>>> load the ConfigurationOfTabular directly. >>>>>>> >>>>>>> Best, >>>>>>> Vincent >>>>>>> >>>>>>> -----Message d'origine----- >>>>>>> De : Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] De la >>>>>>> part >>>>>>> de H. Hirzel >>>>>>> EnvoyÃ© : samedi 8 aoÃ»t 2015 10:34 >>>>>>> Ã : Any question about pharo is welcome >>>>>>> Objet : Re: [Pharo-users] Tabular: XLSX import >>>>>>> >>>>>>> If I do >>>>>>> >>>>>>> ConfigurationOfXMLWriter load >>>>>>> >>>>>>> then >>>>>>> >>>>>>> TabularExperimentalExport writeTestFile >>>>>>> >>>>>>> is fine generating an Excel file. >>>>>>> >>>>>>> >>>>>>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.27.mcz >>>>>>> >>>>>>> I am currently exploring the code and trying to figure out how it >>>>>>> works. >>>>>>> >>>>>>> --Hannes >>>>>>> >>>>>>> On 8/8/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>>>>>> > I understand that Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ asks how to construct his >>>>>>> > ConfigurationOfTabular file >>>>>>> > >>>>>>> > http://ss3.gemtalksystems.com/ss/Tabular.html >>>>>>> > >>>>>>> > So I pointed him to the Pharo By Examples book 2 Chapter 9 >>>>>>> > Managing >>>>>>> > Projects with Metacello >>>>>>> > >>>>>>> > >>>>>>> > The Tabular project needs a XMLWriter class. I assume the regular >>>>>>> > pharoExtras is fine. I do not know. >>>>>>> > >>>>>>> > I am just looking at the code to see how the reading and writing >>>>>>> > of >>>>>>> > MSOffice files, Excel in this particular case, is done so far. >>>>>>> > >>>>>>> > For reading a TabularSAXParser is included in the package. >>>>>>> > Probably >>>>>>> > not necessary. >>>>>>> > >>>>>>> > I moved it out here >>>>>>> > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.26.mcz >>>>>>> > >>>>>>> > Hannes >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > On 8/8/15, stepharo <stepharo(a)free.fr> wrote: >>>>>>> >> >>>>>>> >> >>>>>>> >> Le 8/8/15 09:11, H. Hirzel a Ã©crit : >>>>>>> >>> What about >>>>>>> >>> http://rmod.lille.inria.fr/deepIntoPharo/index.html >>>>>>> >>> >>>>>>> >>> p. 163 depending on a project without Metacello description p. >>>>>>> >>> 164, >>>>>>> >>> depending on a project with a Metacello configuration >>>>>>> >>> >>>>>>> >>> In the mean time just a note that Tabular needs XMLParser and >>>>>>> >>> XMLWriter packages on >>>>>>> >>> http://ss3.gemtalksystems.com/ss/Tabular.html. >>>>>>> >> >>>>>>> >> are you implying that there is no expression of dependencies and >>>>>>> >> that >>>>>>> >> in addition it depend on a different XML Parser/Writer than >>>>>>> >> pharoExtras ones? >>>>>>> >> >>>>>>> >> Stef >>>>>>> >>> >>>>>>> >>> Some class comments are welcome as well :-) >>>>>>> >>> >>>>>>> >>> I understand that I can read Excel files and that you just >>>>>>> >>> started >>>>>>> >>> to check out how to write them? >>>>>>> >>> >>>>>>> >>> --Hannes >>>>>>> >>> >>>>>>> >>> On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>>>>>> >>>> Thank you Vincent. >>>>>>> >>>> Some things is much clearer for me now. >>>>>>> >>>> >>>>>>> >>>> *It's shame on me that I lost all this Metacello progress, >>>>>>> >>>> especially taking into account I was on the ESUG conference >>>>>>> >>>> where >>>>>>> >>>> it was presented. >>>>>>> >>>> It >>>>>>> >>>> was my only conference unfortunately.* >>>>>>> >>>> >>>>>>> >>>> I see that you already started this job: you added >>>>>>> >>>> ConfigurationOfTabular. >>>>>>> >>>> What I really want to do with this configuration: add >>>>>>> >>>> dependencies >>>>>>> >>>> to XMLParser and XMLWriter packages. Can you help with this, >>>>>>> >>>> please? >>>>>>> >>>> >>>>>>> >>>> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >>>>>>> >>>> <vincent.blondeau(a)worldline.com> >>>>>>> >>>> : >>>>>>> >>>> >>>>>>> >>>>> Hi, >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> To add a configuration in the catalog, first you should have a >>>>>>> >>>>> configuration for your project. You can create it with the >>>>>>> >>>>> versionner if needed. >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> Second, you have to add some methods adding meta-description >>>>>>> >>>>> to >>>>>>> >>>>> your project. The versionner do it for you: in the >>>>>>> >>>>> configuration >>>>>>> >>>>> list, select your project, do a right click and select add >>>>>>> >>>>> catalog >>>>>>> >>>>> methods. >>>>>>> >>>>> >>>>>>> >>>>> It creates all the mandatory methods for the catalog. You now >>>>>>> >>>>> have >>>>>>> >>>>> to fill them (look at the class side of the configuration). >>>>>>> >>>>> >>>>>>> >>>>> Finally, commit your configuration on your repo and on the >>>>>>> >>>>> MetaRepoForPharo30/40/50 depending where your project is >>>>>>> >>>>> working. >>>>>>> >>>>> >>>>>>> >>>>> The link is here: >>>>>>> >>>>> http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> Once published, your project will be in the catalog in the >>>>>>> >>>>> image >>>>>>> >>>>> (Tools>catalog browser) and on the web >>>>>>> >>>>> http://catalog.pharo.org/. >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> Tell me if you need help to do it, >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> Cheers, >>>>>>> >>>>> >>>>>>> >>>>> Vincent >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> *De :* Pharo-users >>>>>>> >>>>> [mailto:pharo-users-bounces@lists.pharo.org] >>>>>>> >>>>> *De la part de* ???? ????????? >>>>>>> >>>>> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 *Ã :* Any question about >>>>>>> >>>>> pharo is welcome *Objet :* Re: [Pharo-users] Tabular: XLSX >>>>>>> >>>>> import >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> It looks like I need some guidance to understand contemporary >>>>>>> >>>>> packaging/deployment/versioning system. I know it exists, but >>>>>>> >>>>> I >>>>>>> >>>>> don't know details. Can you kick me in the right direction? >>>>>>> >>>>> Maybe >>>>>>> >>>>> some link? >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano >>>>>>> >>>>> <estebanlm(a)gmail.com>: >>>>>>> >>>>> >>>>>>> >>>>> Hi, >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> it would be sooo cool to have a configuration in the catalogâ¦ >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> Esteban >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ >>>>>>> >>>>> <assargaddon(a)gmail.com> >>>>>>> >>>>> wrote: >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> Hello. >>>>>>> >>>>> >>>>>>> >>>>> Some time ago I announced Tabular >>>>>>> >>>>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort >>>>>>> >>>>> to >>>>>>> >>>>> make a tool for spreadsheets import/export. >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> This is short notice: Vincent Blondeau have added XLSX import >>>>>>> >>>>> functionality! >>>>>>> >>>>> It's also mostly proof-of-concept now, but even at this stage >>>>>>> >>>>> it's >>>>>>> >>>>> quite usable. >>>>>>> >>>>> >>>>>>> >>>>> Thanks, Vincent! >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> >>>>>>> >>>>> ------------------------------ >>>>>>> >>>>> >>>>>>> >>>>> Ce message et les piÃ¨ces jointes sont confidentiels et >>>>>>> >>>>> rÃ©servÃ©s >>>>>>> >>>>> Ã >>>>>>> >>>>> l'usage exclusif de ses destinataires. Il peut Ã©galement Ãªtre >>>>>>> >>>>> protÃ©gÃ© par le secret professionnel. Si vous recevez ce >>>>>>> >>>>> message >>>>>>> >>>>> par erreur, merci d'en avertir immÃ©diatement l'expÃ©diteur et >>>>>>> >>>>> de >>>>>>> >>>>> le >>>>>>> >>>>> dÃ©truire. L'intÃ©gritÃ© du message ne pouvant Ãªtre assurÃ©e sur >>>>>>> >>>>> Internet, la responsabilitÃ© de Worldline ne pourra Ãªtre >>>>>>> >>>>> recherchÃ©e >>>>>>> >>>>> quant au contenu de ce message. Bien que les meilleurs efforts >>>>>>> >>>>> soient faits pour maintenir cette transmission exempte de tout >>>>>>> >>>>> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >>>>>>> >>>>> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage >>>>>>> >>>>> rÃ©sultant d'un virus transmis. >>>>>>> >>>>> >>>>>>> >>>>> This e-mail and the documents attached are confidential and >>>>>>> >>>>> intended solely for the addressee; it may also be privileged. >>>>>>> >>>>> If >>>>>>> >>>>> you receive this e-mail in error, please notify the sender >>>>>>> >>>>> immediately and destroy it. >>>>>>> >>>>> As >>>>>>> >>>>> its integrity cannot be secured on the Internet, the Worldline >>>>>>> >>>>> liability cannot be triggered for the message content. >>>>>>> >>>>> Although >>>>>>> >>>>> the sender endeavours to maintain a computer virus-free >>>>>>> >>>>> network, >>>>>>> >>>>> the sender does not warrant that this transmission is >>>>>>> >>>>> virus-free >>>>>>> >>>>> and will not be liable for any damages resulting from any >>>>>>> >>>>> virus >>>>>>> >>>>> transmitted. >>>>>>> >>>>> >>>>>>> >>> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> > >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >> >

Aug. 13, 2015

Re: [Pharo-users] Tabular: XLSX import

by H. Hirzel

For the shared strings in sheet1.xml for example <c r="A1" s="1" t="s"> what do the attributes s and t stand for? <row r="1" customFormat="false" ht="35.05" hidden="false" customHeight="false" outlineLevel="0" collapsed="false"> <c r="A1" s="1" t="s"> <v>0</v> </c> </row> <row r="5" customFormat="false" ht="79.85" hidden="false" customHeight="false" outlineLevel="0" collapsed="false"> <c r="B5" s="1" t="s"> <v>1</v> </c> </row> On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.52.mcz > 47 test run, 37 passes. > > > Currently I have a fixed string > > TabularXSLXExport>>sharedStrings_xml > ^'<?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" > count="1" uniqueCount="1"> > <si><t> </t></si> > </sst>'. > > How far can I safely ignore constructing a proper xl/sharedStrings.xml > in the archive? > > > > On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >> Found a useful summary about for generating XLSX files >> >> http://stackoverflow.com/questions/6055430/how-to-create-xlsx-file-without-… >> >> On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.50.mcz >>> >>> Another question is about the >>> >>> #colspan: property of a cell >>> >>> >>> (wsheet cells at: 1 @ 1) colspan: 1. >>> >>> actually makes cell A1 span 2 columns. >>> >>> Is this OK according to the standard? >>> >>> >>> >>> >>> TabularXLSXExportTest>>testExport7 >>> >>> | wbk wsheet | >>> wbk := TabularWorkbook new. >>> self assert: (wbk worksheets isEmpty). >>> >>> wsheet := TabularWorksheet new. >>> wsheet >>> at: 1 @ 1 putData: 'aaa'; >>> at: 3 @ 1 putData: 'ccc'. >>> (wsheet cells at: 1 @ 1) colspan: 1. >>> >>> wbk worksheets add: wsheet. >>> TabularXSLXExport workbook: wbk fileName: fname7. >>> >>> "manual inspection shows that the exported file is fine" >>> "But is the colspan command fine? Add a colspan test to TabularCell" >>> >>> >>> On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>>> Hello Jurij and Vincent >>>> >>>> I am working on extending the export function (export of several >>>> worksheets). >>>> >>>> For this I am adding some more tests currently and I'd like to have >>>> your feedback on some of the basic functions regarding initial values. >>>> >>>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.49.mcz >>>> (41 tests run, 32 passes) >>>> >>>> in particular on class TabularWorksheetTest (3 tests) >>>> >>>> We have for example >>>> >>>> >>>> Test which passes >>>> >>>> testCellsReadingEmptyCell0 >>>> "accessing a cell without data" >>>> >>>> ws col: 1 row: 1 putData: 11. >>>> ws col: 2 row: 1 putData: 21. >>>> >>>> self assert: (ws col: 1 row: 1) data equals: 11. >>>> self assert: (ws col: 2 row: 1) data equals: 21. >>>> >>>> self assert: ((ws col: 3 row: 1) isNil). "Is this OK to have >>>> nil returned?" >>>> >>>> >>>> >>>> Test which does not pass >>>> >>>> testCellsReadingEmptyCell >>>> >>>> self assert: ((ws col: 100 row: 100) data =''). >>>> >>>> "probably should return an empty string" >>>> >>>> >>>> Comments of others are invited as well. >>>> >>>> -- Hannes >>>> >>>> On 8/9/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>>>> If your are using at least Pharo 4.0, you can use the catalog browser >>>>> to >>>>> load the ConfigurationOfTabular directly. >>>>> >>>>> You have only publish it for MetaRepoForPharo50, so it didn't work for >>>>> Pharo 4. >>>>> BUt, thanks to your explanations, I just have published in >>>>> MetaRepoForPharo40 as well - works like charm! >>>>> >>>>> 2015-08-08 12:45 GMT+03:00 Vincent BLONDEAU < >>>>> vincent.blondeau(a)polytech-lille.net>: >>>>> >>>>>> Hi, >>>>>> >>>>>> I added the dependencies to PharoExtras/XMLWriter and XMLParser. >>>>>> I didn't add the dependencies before because I used Tabular with >>>>>> Moose, >>>>>> and Moose already loads these dependencies... >>>>>> >>>>>> Now it should work. I created the new 0.2 release with the required >>>>>> dependencies. >>>>>> >>>>>> By the way, I used Versionner to create the configuration. I don't >>>>>> know >>>>>> if >>>>>> there is a documentation but there is a video: >>>>>> https://www.youtube.com/watch?v=cFRJDuWL-Q0 >>>>>> >>>>>> It is a very fast tool to manage your projects! >>>>>> >>>>>> If your are using at least Pharo 4.0, you can use the catalog browser >>>>>> to >>>>>> load the ConfigurationOfTabular directly. >>>>>> >>>>>> Best, >>>>>> Vincent >>>>>> >>>>>> -----Message d'origine----- >>>>>> De : Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] De la >>>>>> part >>>>>> de H. Hirzel >>>>>> EnvoyÃ© : samedi 8 aoÃ»t 2015 10:34 >>>>>> Ã : Any question about pharo is welcome >>>>>> Objet : Re: [Pharo-users] Tabular: XLSX import >>>>>> >>>>>> If I do >>>>>> >>>>>> ConfigurationOfXMLWriter load >>>>>> >>>>>> then >>>>>> >>>>>> TabularExperimentalExport writeTestFile >>>>>> >>>>>> is fine generating an Excel file. >>>>>> >>>>>> >>>>>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.27.mcz >>>>>> >>>>>> I am currently exploring the code and trying to figure out how it >>>>>> works. >>>>>> >>>>>> --Hannes >>>>>> >>>>>> On 8/8/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>>>>> > I understand that Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ asks how to construct his >>>>>> > ConfigurationOfTabular file >>>>>> > >>>>>> > http://ss3.gemtalksystems.com/ss/Tabular.html >>>>>> > >>>>>> > So I pointed him to the Pharo By Examples book 2 Chapter 9 Managing >>>>>> > Projects with Metacello >>>>>> > >>>>>> > >>>>>> > The Tabular project needs a XMLWriter class. I assume the regular >>>>>> > pharoExtras is fine. I do not know. >>>>>> > >>>>>> > I am just looking at the code to see how the reading and writing of >>>>>> > MSOffice files, Excel in this particular case, is done so far. >>>>>> > >>>>>> > For reading a TabularSAXParser is included in the package. Probably >>>>>> > not necessary. >>>>>> > >>>>>> > I moved it out here >>>>>> > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.26.mcz >>>>>> > >>>>>> > Hannes >>>>>> > >>>>>> > >>>>>> > >>>>>> > On 8/8/15, stepharo <stepharo(a)free.fr> wrote: >>>>>> >> >>>>>> >> >>>>>> >> Le 8/8/15 09:11, H. Hirzel a Ã©crit : >>>>>> >>> What about >>>>>> >>> http://rmod.lille.inria.fr/deepIntoPharo/index.html >>>>>> >>> >>>>>> >>> p. 163 depending on a project without Metacello description p. >>>>>> >>> 164, >>>>>> >>> depending on a project with a Metacello configuration >>>>>> >>> >>>>>> >>> In the mean time just a note that Tabular needs XMLParser and >>>>>> >>> XMLWriter packages on >>>>>> >>> http://ss3.gemtalksystems.com/ss/Tabular.html. >>>>>> >> >>>>>> >> are you implying that there is no expression of dependencies and >>>>>> >> that >>>>>> >> in addition it depend on a different XML Parser/Writer than >>>>>> >> pharoExtras ones? >>>>>> >> >>>>>> >> Stef >>>>>> >>> >>>>>> >>> Some class comments are welcome as well :-) >>>>>> >>> >>>>>> >>> I understand that I can read Excel files and that you just >>>>>> >>> started >>>>>> >>> to check out how to write them? >>>>>> >>> >>>>>> >>> --Hannes >>>>>> >>> >>>>>> >>> On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>>>>> >>>> Thank you Vincent. >>>>>> >>>> Some things is much clearer for me now. >>>>>> >>>> >>>>>> >>>> *It's shame on me that I lost all this Metacello progress, >>>>>> >>>> especially taking into account I was on the ESUG conference >>>>>> >>>> where >>>>>> >>>> it was presented. >>>>>> >>>> It >>>>>> >>>> was my only conference unfortunately.* >>>>>> >>>> >>>>>> >>>> I see that you already started this job: you added >>>>>> >>>> ConfigurationOfTabular. >>>>>> >>>> What I really want to do with this configuration: add >>>>>> >>>> dependencies >>>>>> >>>> to XMLParser and XMLWriter packages. Can you help with this, >>>>>> >>>> please? >>>>>> >>>> >>>>>> >>>> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >>>>>> >>>> <vincent.blondeau(a)worldline.com> >>>>>> >>>> : >>>>>> >>>> >>>>>> >>>>> Hi, >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> To add a configuration in the catalog, first you should have a >>>>>> >>>>> configuration for your project. You can create it with the >>>>>> >>>>> versionner if needed. >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> Second, you have to add some methods adding meta-description to >>>>>> >>>>> your project. The versionner do it for you: in the >>>>>> >>>>> configuration >>>>>> >>>>> list, select your project, do a right click and select add >>>>>> >>>>> catalog >>>>>> >>>>> methods. >>>>>> >>>>> >>>>>> >>>>> It creates all the mandatory methods for the catalog. You now >>>>>> >>>>> have >>>>>> >>>>> to fill them (look at the class side of the configuration). >>>>>> >>>>> >>>>>> >>>>> Finally, commit your configuration on your repo and on the >>>>>> >>>>> MetaRepoForPharo30/40/50 depending where your project is >>>>>> >>>>> working. >>>>>> >>>>> >>>>>> >>>>> The link is here: >>>>>> >>>>> http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> Once published, your project will be in the catalog in the >>>>>> >>>>> image >>>>>> >>>>> (Tools>catalog browser) and on the web >>>>>> >>>>> http://catalog.pharo.org/. >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> Tell me if you need help to do it, >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> Cheers, >>>>>> >>>>> >>>>>> >>>>> Vincent >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> *De :* Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] >>>>>> >>>>> *De la part de* ???? ????????? >>>>>> >>>>> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 *Ã :* Any question about >>>>>> >>>>> pharo is welcome *Objet :* Re: [Pharo-users] Tabular: XLSX >>>>>> >>>>> import >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> It looks like I need some guidance to understand contemporary >>>>>> >>>>> packaging/deployment/versioning system. I know it exists, but I >>>>>> >>>>> don't know details. Can you kick me in the right direction? >>>>>> >>>>> Maybe >>>>>> >>>>> some link? >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano >>>>>> >>>>> <estebanlm(a)gmail.com>: >>>>>> >>>>> >>>>>> >>>>> Hi, >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> it would be sooo cool to have a configuration in the catalogâ¦ >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> Esteban >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ >>>>>> >>>>> <assargaddon(a)gmail.com> >>>>>> >>>>> wrote: >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> Hello. >>>>>> >>>>> >>>>>> >>>>> Some time ago I announced Tabular >>>>>> >>>>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to >>>>>> >>>>> make a tool for spreadsheets import/export. >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> This is short notice: Vincent Blondeau have added XLSX import >>>>>> >>>>> functionality! >>>>>> >>>>> It's also mostly proof-of-concept now, but even at this stage >>>>>> >>>>> it's >>>>>> >>>>> quite usable. >>>>>> >>>>> >>>>>> >>>>> Thanks, Vincent! >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> >>>>>> >>>>> ------------------------------ >>>>>> >>>>> >>>>>> >>>>> Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s >>>>>> >>>>> Ã >>>>>> >>>>> l'usage exclusif de ses destinataires. Il peut Ã©galement Ãªtre >>>>>> >>>>> protÃ©gÃ© par le secret professionnel. Si vous recevez ce message >>>>>> >>>>> par erreur, merci d'en avertir immÃ©diatement l'expÃ©diteur et de >>>>>> >>>>> le >>>>>> >>>>> dÃ©truire. L'intÃ©gritÃ© du message ne pouvant Ãªtre assurÃ©e sur >>>>>> >>>>> Internet, la responsabilitÃ© de Worldline ne pourra Ãªtre >>>>>> >>>>> recherchÃ©e >>>>>> >>>>> quant au contenu de ce message. Bien que les meilleurs efforts >>>>>> >>>>> soient faits pour maintenir cette transmission exempte de tout >>>>>> >>>>> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >>>>>> >>>>> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage >>>>>> >>>>> rÃ©sultant d'un virus transmis. >>>>>> >>>>> >>>>>> >>>>> This e-mail and the documents attached are confidential and >>>>>> >>>>> intended solely for the addressee; it may also be privileged. >>>>>> >>>>> If >>>>>> >>>>> you receive this e-mail in error, please notify the sender >>>>>> >>>>> immediately and destroy it. >>>>>> >>>>> As >>>>>> >>>>> its integrity cannot be secured on the Internet, the Worldline >>>>>> >>>>> liability cannot be triggered for the message content. Although >>>>>> >>>>> the sender endeavours to maintain a computer virus-free >>>>>> >>>>> network, >>>>>> >>>>> the sender does not warrant that this transmission is >>>>>> >>>>> virus-free >>>>>> >>>>> and will not be liable for any damages resulting from any virus >>>>>> >>>>> transmitted. >>>>>> >>>>> >>>>>> >>> >>>>>> >> >>>>>> >> >>>>>> >> >>>>>> > >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >

Aug. 13, 2015

Re: [Pharo-users] Tabular: XLSX import

by H. Hirzel

http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.52.mcz 47 test run, 37 passes. Currently I have a fixed string TabularXSLXExport>>sharedStrings_xml ^'<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="1" uniqueCount="1"> <si><t> </t></si> </sst>'. How far can I safely ignore constructing a proper xl/sharedStrings.xml in the archive? On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: > Found a useful summary about for generating XLSX files > > http://stackoverflow.com/questions/6055430/how-to-create-xlsx-file-without-… > > On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.50.mcz >> >> Another question is about the >> >> #colspan: property of a cell >> >> >> (wsheet cells at: 1 @ 1) colspan: 1. >> >> actually makes cell A1 span 2 columns. >> >> Is this OK according to the standard? >> >> >> >> >> TabularXLSXExportTest>>testExport7 >> >> | wbk wsheet | >> wbk := TabularWorkbook new. >> self assert: (wbk worksheets isEmpty). >> >> wsheet := TabularWorksheet new. >> wsheet >> at: 1 @ 1 putData: 'aaa'; >> at: 3 @ 1 putData: 'ccc'. >> (wsheet cells at: 1 @ 1) colspan: 1. >> >> wbk worksheets add: wsheet. >> TabularXSLXExport workbook: wbk fileName: fname7. >> >> "manual inspection shows that the exported file is fine" >> "But is the colspan command fine? Add a colspan test to TabularCell" >> >> >> On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>> Hello Jurij and Vincent >>> >>> I am working on extending the export function (export of several >>> worksheets). >>> >>> For this I am adding some more tests currently and I'd like to have >>> your feedback on some of the basic functions regarding initial values. >>> >>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.49.mcz >>> (41 tests run, 32 passes) >>> >>> in particular on class TabularWorksheetTest (3 tests) >>> >>> We have for example >>> >>> >>> Test which passes >>> >>> testCellsReadingEmptyCell0 >>> "accessing a cell without data" >>> >>> ws col: 1 row: 1 putData: 11. >>> ws col: 2 row: 1 putData: 21. >>> >>> self assert: (ws col: 1 row: 1) data equals: 11. >>> self assert: (ws col: 2 row: 1) data equals: 21. >>> >>> self assert: ((ws col: 3 row: 1) isNil). "Is this OK to have >>> nil returned?" >>> >>> >>> >>> Test which does not pass >>> >>> testCellsReadingEmptyCell >>> >>> self assert: ((ws col: 100 row: 100) data =''). >>> >>> "probably should return an empty string" >>> >>> >>> Comments of others are invited as well. >>> >>> -- Hannes >>> >>> On 8/9/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>>> If your are using at least Pharo 4.0, you can use the catalog browser >>>> to >>>> load the ConfigurationOfTabular directly. >>>> >>>> You have only publish it for MetaRepoForPharo50, so it didn't work for >>>> Pharo 4. >>>> BUt, thanks to your explanations, I just have published in >>>> MetaRepoForPharo40 as well - works like charm! >>>> >>>> 2015-08-08 12:45 GMT+03:00 Vincent BLONDEAU < >>>> vincent.blondeau(a)polytech-lille.net>: >>>> >>>>> Hi, >>>>> >>>>> I added the dependencies to PharoExtras/XMLWriter and XMLParser. >>>>> I didn't add the dependencies before because I used Tabular with >>>>> Moose, >>>>> and Moose already loads these dependencies... >>>>> >>>>> Now it should work. I created the new 0.2 release with the required >>>>> dependencies. >>>>> >>>>> By the way, I used Versionner to create the configuration. I don't >>>>> know >>>>> if >>>>> there is a documentation but there is a video: >>>>> https://www.youtube.com/watch?v=cFRJDuWL-Q0 >>>>> >>>>> It is a very fast tool to manage your projects! >>>>> >>>>> If your are using at least Pharo 4.0, you can use the catalog browser >>>>> to >>>>> load the ConfigurationOfTabular directly. >>>>> >>>>> Best, >>>>> Vincent >>>>> >>>>> -----Message d'origine----- >>>>> De : Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] De la >>>>> part >>>>> de H. Hirzel >>>>> EnvoyÃ© : samedi 8 aoÃ»t 2015 10:34 >>>>> Ã : Any question about pharo is welcome >>>>> Objet : Re: [Pharo-users] Tabular: XLSX import >>>>> >>>>> If I do >>>>> >>>>> ConfigurationOfXMLWriter load >>>>> >>>>> then >>>>> >>>>> TabularExperimentalExport writeTestFile >>>>> >>>>> is fine generating an Excel file. >>>>> >>>>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.27.mcz >>>>> >>>>> I am currently exploring the code and trying to figure out how it >>>>> works. >>>>> >>>>> --Hannes >>>>> >>>>> On 8/8/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>>>> > I understand that Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ asks how to construct his >>>>> > ConfigurationOfTabular file >>>>> > >>>>> > http://ss3.gemtalksystems.com/ss/Tabular.html >>>>> > >>>>> > So I pointed him to the Pharo By Examples book 2 Chapter 9 Managing >>>>> > Projects with Metacello >>>>> > >>>>> > >>>>> > The Tabular project needs a XMLWriter class. I assume the regular >>>>> > pharoExtras is fine. I do not know. >>>>> > >>>>> > I am just looking at the code to see how the reading and writing of >>>>> > MSOffice files, Excel in this particular case, is done so far. >>>>> > >>>>> > For reading a TabularSAXParser is included in the package. Probably >>>>> > not necessary. >>>>> > >>>>> > I moved it out here >>>>> > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.26.mcz >>>>> > >>>>> > Hannes >>>>> > >>>>> > >>>>> > >>>>> > On 8/8/15, stepharo <stepharo(a)free.fr> wrote: >>>>> >> >>>>> >> >>>>> >> Le 8/8/15 09:11, H. Hirzel a Ã©crit : >>>>> >>> What about >>>>> >>> http://rmod.lille.inria.fr/deepIntoPharo/index.html >>>>> >>> >>>>> >>> p. 163 depending on a project without Metacello description p. >>>>> >>> 164, >>>>> >>> depending on a project with a Metacello configuration >>>>> >>> >>>>> >>> In the mean time just a note that Tabular needs XMLParser and >>>>> >>> XMLWriter packages on >>>>> >>> http://ss3.gemtalksystems.com/ss/Tabular.html. >>>>> >> >>>>> >> are you implying that there is no expression of dependencies and >>>>> >> that >>>>> >> in addition it depend on a different XML Parser/Writer than >>>>> >> pharoExtras ones? >>>>> >> >>>>> >> Stef >>>>> >>> >>>>> >>> Some class comments are welcome as well :-) >>>>> >>> >>>>> >>> I understand that I can read Excel files and that you just started >>>>> >>> to check out how to write them? >>>>> >>> >>>>> >>> --Hannes >>>>> >>> >>>>> >>> On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>>>> >>>> Thank you Vincent. >>>>> >>>> Some things is much clearer for me now. >>>>> >>>> >>>>> >>>> *It's shame on me that I lost all this Metacello progress, >>>>> >>>> especially taking into account I was on the ESUG conference where >>>>> >>>> it was presented. >>>>> >>>> It >>>>> >>>> was my only conference unfortunately.* >>>>> >>>> >>>>> >>>> I see that you already started this job: you added >>>>> >>>> ConfigurationOfTabular. >>>>> >>>> What I really want to do with this configuration: add >>>>> >>>> dependencies >>>>> >>>> to XMLParser and XMLWriter packages. Can you help with this, >>>>> >>>> please? >>>>> >>>> >>>>> >>>> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >>>>> >>>> <vincent.blondeau(a)worldline.com> >>>>> >>>> : >>>>> >>>> >>>>> >>>>> Hi, >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> To add a configuration in the catalog, first you should have a >>>>> >>>>> configuration for your project. You can create it with the >>>>> >>>>> versionner if needed. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Second, you have to add some methods adding meta-description to >>>>> >>>>> your project. The versionner do it for you: in the configuration >>>>> >>>>> list, select your project, do a right click and select add >>>>> >>>>> catalog >>>>> >>>>> methods. >>>>> >>>>> >>>>> >>>>> It creates all the mandatory methods for the catalog. You now >>>>> >>>>> have >>>>> >>>>> to fill them (look at the class side of the configuration). >>>>> >>>>> >>>>> >>>>> Finally, commit your configuration on your repo and on the >>>>> >>>>> MetaRepoForPharo30/40/50 depending where your project is >>>>> >>>>> working. >>>>> >>>>> >>>>> >>>>> The link is here: >>>>> >>>>> http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Once published, your project will be in the catalog in the image >>>>> >>>>> (Tools>catalog browser) and on the web >>>>> >>>>> http://catalog.pharo.org/. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Tell me if you need help to do it, >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Cheers, >>>>> >>>>> >>>>> >>>>> Vincent >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> *De :* Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] >>>>> >>>>> *De la part de* ???? ????????? >>>>> >>>>> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 *Ã :* Any question about >>>>> >>>>> pharo is welcome *Objet :* Re: [Pharo-users] Tabular: XLSX >>>>> >>>>> import >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> It looks like I need some guidance to understand contemporary >>>>> >>>>> packaging/deployment/versioning system. I know it exists, but I >>>>> >>>>> don't know details. Can you kick me in the right direction? >>>>> >>>>> Maybe >>>>> >>>>> some link? >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano >>>>> >>>>> <estebanlm(a)gmail.com>: >>>>> >>>>> >>>>> >>>>> Hi, >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> it would be sooo cool to have a configuration in the catalogâ¦ >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Esteban >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> >>>>> >>>>> wrote: >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Hello. >>>>> >>>>> >>>>> >>>>> Some time ago I announced Tabular >>>>> >>>>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to >>>>> >>>>> make a tool for spreadsheets import/export. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> This is short notice: Vincent Blondeau have added XLSX import >>>>> >>>>> functionality! >>>>> >>>>> It's also mostly proof-of-concept now, but even at this stage >>>>> >>>>> it's >>>>> >>>>> quite usable. >>>>> >>>>> >>>>> >>>>> Thanks, Vincent! >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> ------------------------------ >>>>> >>>>> >>>>> >>>>> Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s >>>>> >>>>> Ã >>>>> >>>>> l'usage exclusif de ses destinataires. Il peut Ã©galement Ãªtre >>>>> >>>>> protÃ©gÃ© par le secret professionnel. Si vous recevez ce message >>>>> >>>>> par erreur, merci d'en avertir immÃ©diatement l'expÃ©diteur et de >>>>> >>>>> le >>>>> >>>>> dÃ©truire. L'intÃ©gritÃ© du message ne pouvant Ãªtre assurÃ©e sur >>>>> >>>>> Internet, la responsabilitÃ© de Worldline ne pourra Ãªtre >>>>> >>>>> recherchÃ©e >>>>> >>>>> quant au contenu de ce message. Bien que les meilleurs efforts >>>>> >>>>> soient faits pour maintenir cette transmission exempte de tout >>>>> >>>>> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >>>>> >>>>> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage >>>>> >>>>> rÃ©sultant d'un virus transmis. >>>>> >>>>> >>>>> >>>>> This e-mail and the documents attached are confidential and >>>>> >>>>> intended solely for the addressee; it may also be privileged. If >>>>> >>>>> you receive this e-mail in error, please notify the sender >>>>> >>>>> immediately and destroy it. >>>>> >>>>> As >>>>> >>>>> its integrity cannot be secured on the Internet, the Worldline >>>>> >>>>> liability cannot be triggered for the message content. Although >>>>> >>>>> the sender endeavours to maintain a computer virus-free network, >>>>> >>>>> the sender does not warrant that this transmission is virus-free >>>>> >>>>> and will not be liable for any damages resulting from any virus >>>>> >>>>> transmitted. >>>>> >>>>> >>>>> >>> >>>>> >> >>>>> >> >>>>> >> >>>>> > >>>>> >>>>> >>>>> >>>>> >>>> >>> >> >

Aug. 13, 2015

Re: [Pharo-users] Tabular: XLSX import

by H. Hirzel

Found a useful summary about for generating XLSX files http://stackoverflow.com/questions/6055430/how-to-create-xlsx-file-without-… On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.50.mcz > > Another question is about the > > #colspan: property of a cell > > > (wsheet cells at: 1 @ 1) colspan: 1. > > actually makes cell A1 span 2 columns. > > Is this OK according to the standard? > > > > > TabularXLSXExportTest>>testExport7 > > | wbk wsheet | > wbk := TabularWorkbook new. > self assert: (wbk worksheets isEmpty). > > wsheet := TabularWorksheet new. > wsheet > at: 1 @ 1 putData: 'aaa'; > at: 3 @ 1 putData: 'ccc'. > (wsheet cells at: 1 @ 1) colspan: 1. > > wbk worksheets add: wsheet. > TabularXSLXExport workbook: wbk fileName: fname7. > > "manual inspection shows that the exported file is fine" > "But is the colspan command fine? Add a colspan test to TabularCell" > > > On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >> Hello Jurij and Vincent >> >> I am working on extending the export function (export of several >> worksheets). >> >> For this I am adding some more tests currently and I'd like to have >> your feedback on some of the basic functions regarding initial values. >> >> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.49.mcz >> (41 tests run, 32 passes) >> >> in particular on class TabularWorksheetTest (3 tests) >> >> We have for example >> >> >> Test which passes >> >> testCellsReadingEmptyCell0 >> "accessing a cell without data" >> >> ws col: 1 row: 1 putData: 11. >> ws col: 2 row: 1 putData: 21. >> >> self assert: (ws col: 1 row: 1) data equals: 11. >> self assert: (ws col: 2 row: 1) data equals: 21. >> >> self assert: ((ws col: 3 row: 1) isNil). "Is this OK to have >> nil returned?" >> >> >> >> Test which does not pass >> >> testCellsReadingEmptyCell >> >> self assert: ((ws col: 100 row: 100) data =''). >> >> "probably should return an empty string" >> >> >> Comments of others are invited as well. >> >> -- Hannes >> >> On 8/9/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>> If your are using at least Pharo 4.0, you can use the catalog browser to >>> load the ConfigurationOfTabular directly. >>> >>> You have only publish it for MetaRepoForPharo50, so it didn't work for >>> Pharo 4. >>> BUt, thanks to your explanations, I just have published in >>> MetaRepoForPharo40 as well - works like charm! >>> >>> 2015-08-08 12:45 GMT+03:00 Vincent BLONDEAU < >>> vincent.blondeau(a)polytech-lille.net>: >>> >>>> Hi, >>>> >>>> I added the dependencies to PharoExtras/XMLWriter and XMLParser. >>>> I didn't add the dependencies before because I used Tabular with Moose, >>>> and Moose already loads these dependencies... >>>> >>>> Now it should work. I created the new 0.2 release with the required >>>> dependencies. >>>> >>>> By the way, I used Versionner to create the configuration. I don't know >>>> if >>>> there is a documentation but there is a video: >>>> https://www.youtube.com/watch?v=cFRJDuWL-Q0 >>>> >>>> It is a very fast tool to manage your projects! >>>> >>>> If your are using at least Pharo 4.0, you can use the catalog browser >>>> to >>>> load the ConfigurationOfTabular directly. >>>> >>>> Best, >>>> Vincent >>>> >>>> -----Message d'origine----- >>>> De : Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] De la >>>> part >>>> de H. Hirzel >>>> EnvoyÃ© : samedi 8 aoÃ»t 2015 10:34 >>>> Ã : Any question about pharo is welcome >>>> Objet : Re: [Pharo-users] Tabular: XLSX import >>>> >>>> If I do >>>> >>>> ConfigurationOfXMLWriter load >>>> >>>> then >>>> >>>> TabularExperimentalExport writeTestFile >>>> >>>> is fine generating an Excel file. >>>> >>>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.27.mcz >>>> >>>> I am currently exploring the code and trying to figure out how it >>>> works. >>>> >>>> --Hannes >>>> >>>> On 8/8/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>>> > I understand that Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ asks how to construct his >>>> > ConfigurationOfTabular file >>>> > >>>> > http://ss3.gemtalksystems.com/ss/Tabular.html >>>> > >>>> > So I pointed him to the Pharo By Examples book 2 Chapter 9 Managing >>>> > Projects with Metacello >>>> > >>>> > >>>> > The Tabular project needs a XMLWriter class. I assume the regular >>>> > pharoExtras is fine. I do not know. >>>> > >>>> > I am just looking at the code to see how the reading and writing of >>>> > MSOffice files, Excel in this particular case, is done so far. >>>> > >>>> > For reading a TabularSAXParser is included in the package. Probably >>>> > not necessary. >>>> > >>>> > I moved it out here >>>> > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.26.mcz >>>> > >>>> > Hannes >>>> > >>>> > >>>> > >>>> > On 8/8/15, stepharo <stepharo(a)free.fr> wrote: >>>> >> >>>> >> >>>> >> Le 8/8/15 09:11, H. Hirzel a Ã©crit : >>>> >>> What about >>>> >>> http://rmod.lille.inria.fr/deepIntoPharo/index.html >>>> >>> >>>> >>> p. 163 depending on a project without Metacello description p. 164, >>>> >>> depending on a project with a Metacello configuration >>>> >>> >>>> >>> In the mean time just a note that Tabular needs XMLParser and >>>> >>> XMLWriter packages on >>>> >>> http://ss3.gemtalksystems.com/ss/Tabular.html. >>>> >> >>>> >> are you implying that there is no expression of dependencies and >>>> >> that >>>> >> in addition it depend on a different XML Parser/Writer than >>>> >> pharoExtras ones? >>>> >> >>>> >> Stef >>>> >>> >>>> >>> Some class comments are welcome as well :-) >>>> >>> >>>> >>> I understand that I can read Excel files and that you just started >>>> >>> to check out how to write them? >>>> >>> >>>> >>> --Hannes >>>> >>> >>>> >>> On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>>> >>>> Thank you Vincent. >>>> >>>> Some things is much clearer for me now. >>>> >>>> >>>> >>>> *It's shame on me that I lost all this Metacello progress, >>>> >>>> especially taking into account I was on the ESUG conference where >>>> >>>> it was presented. >>>> >>>> It >>>> >>>> was my only conference unfortunately.* >>>> >>>> >>>> >>>> I see that you already started this job: you added >>>> >>>> ConfigurationOfTabular. >>>> >>>> What I really want to do with this configuration: add dependencies >>>> >>>> to XMLParser and XMLWriter packages. Can you help with this, >>>> >>>> please? >>>> >>>> >>>> >>>> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >>>> >>>> <vincent.blondeau(a)worldline.com> >>>> >>>> : >>>> >>>> >>>> >>>>> Hi, >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> To add a configuration in the catalog, first you should have a >>>> >>>>> configuration for your project. You can create it with the >>>> >>>>> versionner if needed. >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> Second, you have to add some methods adding meta-description to >>>> >>>>> your project. The versionner do it for you: in the configuration >>>> >>>>> list, select your project, do a right click and select add >>>> >>>>> catalog >>>> >>>>> methods. >>>> >>>>> >>>> >>>>> It creates all the mandatory methods for the catalog. You now >>>> >>>>> have >>>> >>>>> to fill them (look at the class side of the configuration). >>>> >>>>> >>>> >>>>> Finally, commit your configuration on your repo and on the >>>> >>>>> MetaRepoForPharo30/40/50 depending where your project is working. >>>> >>>>> >>>> >>>>> The link is here: >>>> >>>>> http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> Once published, your project will be in the catalog in the image >>>> >>>>> (Tools>catalog browser) and on the web http://catalog.pharo.org/. >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> Tell me if you need help to do it, >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> Cheers, >>>> >>>>> >>>> >>>>> Vincent >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> *De :* Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] >>>> >>>>> *De la part de* ???? ????????? >>>> >>>>> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 *Ã :* Any question about >>>> >>>>> pharo is welcome *Objet :* Re: [Pharo-users] Tabular: XLSX import >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> It looks like I need some guidance to understand contemporary >>>> >>>>> packaging/deployment/versioning system. I know it exists, but I >>>> >>>>> don't know details. Can you kick me in the right direction? Maybe >>>> >>>>> some link? >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano >>>> >>>>> <estebanlm(a)gmail.com>: >>>> >>>>> >>>> >>>>> Hi, >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> it would be sooo cool to have a configuration in the catalogâ¦ >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> Esteban >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> >>>> >>>>> wrote: >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> Hello. >>>> >>>>> >>>> >>>>> Some time ago I announced Tabular >>>> >>>>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to >>>> >>>>> make a tool for spreadsheets import/export. >>>> >>>>> >>>> >>>>> >>>> >>>>> This is short notice: Vincent Blondeau have added XLSX import >>>> >>>>> functionality! >>>> >>>>> It's also mostly proof-of-concept now, but even at this stage >>>> >>>>> it's >>>> >>>>> quite usable. >>>> >>>>> >>>> >>>>> Thanks, Vincent! >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> >>>> >>>>> ------------------------------ >>>> >>>>> >>>> >>>>> Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s Ã >>>> >>>>> l'usage exclusif de ses destinataires. Il peut Ã©galement Ãªtre >>>> >>>>> protÃ©gÃ© par le secret professionnel. Si vous recevez ce message >>>> >>>>> par erreur, merci d'en avertir immÃ©diatement l'expÃ©diteur et de >>>> >>>>> le >>>> >>>>> dÃ©truire. L'intÃ©gritÃ© du message ne pouvant Ãªtre assurÃ©e sur >>>> >>>>> Internet, la responsabilitÃ© de Worldline ne pourra Ãªtre >>>> >>>>> recherchÃ©e >>>> >>>>> quant au contenu de ce message. Bien que les meilleurs efforts >>>> >>>>> soient faits pour maintenir cette transmission exempte de tout >>>> >>>>> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >>>> >>>>> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage >>>> >>>>> rÃ©sultant d'un virus transmis. >>>> >>>>> >>>> >>>>> This e-mail and the documents attached are confidential and >>>> >>>>> intended solely for the addressee; it may also be privileged. If >>>> >>>>> you receive this e-mail in error, please notify the sender >>>> >>>>> immediately and destroy it. >>>> >>>>> As >>>> >>>>> its integrity cannot be secured on the Internet, the Worldline >>>> >>>>> liability cannot be triggered for the message content. Although >>>> >>>>> the sender endeavours to maintain a computer virus-free network, >>>> >>>>> the sender does not warrant that this transmission is virus-free >>>> >>>>> and will not be liable for any damages resulting from any virus >>>> >>>>> transmitted. >>>> >>>>> >>>> >>> >>>> >> >>>> >> >>>> >> >>>> > >>>> >>>> >>>> >>>> >>> >> >

Aug. 13, 2015

Re: [Pharo-users] Spreadsheet editor

by H. 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 <hannes.hirzel(a)gmail.com> wrote: > On 8/11/15, Peter UhnÃ¡k <i.uhnak(a)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. >

Aug. 13, 2015

Re: [Pharo-users] Tabular: XLSX import

by H. Hirzel

http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.50.mcz Another question is about the #colspan: property of a cell (wsheet cells at: 1 @ 1) colspan: 1. actually makes cell A1 span 2 columns. Is this OK according to the standard? TabularXLSXExportTest>>testExport7 | wbk wsheet | wbk := TabularWorkbook new. self assert: (wbk worksheets isEmpty). wsheet := TabularWorksheet new. wsheet at: 1 @ 1 putData: 'aaa'; at: 3 @ 1 putData: 'ccc'. (wsheet cells at: 1 @ 1) colspan: 1. wbk worksheets add: wsheet. TabularXSLXExport workbook: wbk fileName: fname7. "manual inspection shows that the exported file is fine" "But is the colspan command fine? Add a colspan test to TabularCell" On 8/13/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: > Hello Jurij and Vincent > > I am working on extending the export function (export of several > worksheets). > > For this I am adding some more tests currently and I'd like to have > your feedback on some of the basic functions regarding initial values. > > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.49.mcz > (41 tests run, 32 passes) > > in particular on class TabularWorksheetTest (3 tests) > > We have for example > > > Test which passes > > testCellsReadingEmptyCell0 > "accessing a cell without data" > > ws col: 1 row: 1 putData: 11. > ws col: 2 row: 1 putData: 21. > > self assert: (ws col: 1 row: 1) data equals: 11. > self assert: (ws col: 2 row: 1) data equals: 21. > > self assert: ((ws col: 3 row: 1) isNil). "Is this OK to have > nil returned?" > > > > Test which does not pass > > testCellsReadingEmptyCell > > self assert: ((ws col: 100 row: 100) data =''). > > "probably should return an empty string" > > > Comments of others are invited as well. > > -- Hannes > > On 8/9/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >> If your are using at least Pharo 4.0, you can use the catalog browser to >> load the ConfigurationOfTabular directly. >> >> You have only publish it for MetaRepoForPharo50, so it didn't work for >> Pharo 4. >> BUt, thanks to your explanations, I just have published in >> MetaRepoForPharo40 as well - works like charm! >> >> 2015-08-08 12:45 GMT+03:00 Vincent BLONDEAU < >> vincent.blondeau(a)polytech-lille.net>: >> >>> Hi, >>> >>> I added the dependencies to PharoExtras/XMLWriter and XMLParser. >>> I didn't add the dependencies before because I used Tabular with Moose, >>> and Moose already loads these dependencies... >>> >>> Now it should work. I created the new 0.2 release with the required >>> dependencies. >>> >>> By the way, I used Versionner to create the configuration. I don't know >>> if >>> there is a documentation but there is a video: >>> https://www.youtube.com/watch?v=cFRJDuWL-Q0 >>> >>> It is a very fast tool to manage your projects! >>> >>> If your are using at least Pharo 4.0, you can use the catalog browser to >>> load the ConfigurationOfTabular directly. >>> >>> Best, >>> Vincent >>> >>> -----Message d'origine----- >>> De : Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] De la part >>> de H. Hirzel >>> EnvoyÃ© : samedi 8 aoÃ»t 2015 10:34 >>> Ã : Any question about pharo is welcome >>> Objet : Re: [Pharo-users] Tabular: XLSX import >>> >>> If I do >>> >>> ConfigurationOfXMLWriter load >>> >>> then >>> >>> TabularExperimentalExport writeTestFile >>> >>> is fine generating an Excel file. >>> >>> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.27.mcz >>> >>> I am currently exploring the code and trying to figure out how it works. >>> >>> --Hannes >>> >>> On 8/8/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >>> > I understand that Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ asks how to construct his >>> > ConfigurationOfTabular file >>> > >>> > http://ss3.gemtalksystems.com/ss/Tabular.html >>> > >>> > So I pointed him to the Pharo By Examples book 2 Chapter 9 Managing >>> > Projects with Metacello >>> > >>> > >>> > The Tabular project needs a XMLWriter class. I assume the regular >>> > pharoExtras is fine. I do not know. >>> > >>> > I am just looking at the code to see how the reading and writing of >>> > MSOffice files, Excel in this particular case, is done so far. >>> > >>> > For reading a TabularSAXParser is included in the package. Probably >>> > not necessary. >>> > >>> > I moved it out here >>> > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.26.mcz >>> > >>> > Hannes >>> > >>> > >>> > >>> > On 8/8/15, stepharo <stepharo(a)free.fr> wrote: >>> >> >>> >> >>> >> Le 8/8/15 09:11, H. Hirzel a Ã©crit : >>> >>> What about >>> >>> http://rmod.lille.inria.fr/deepIntoPharo/index.html >>> >>> >>> >>> p. 163 depending on a project without Metacello description p. 164, >>> >>> depending on a project with a Metacello configuration >>> >>> >>> >>> In the mean time just a note that Tabular needs XMLParser and >>> >>> XMLWriter packages on http://ss3.gemtalksystems.com/ss/Tabular.html. >>> >> >>> >> are you implying that there is no expression of dependencies and that >>> >> in addition it depend on a different XML Parser/Writer than >>> >> pharoExtras ones? >>> >> >>> >> Stef >>> >>> >>> >>> Some class comments are welcome as well :-) >>> >>> >>> >>> I understand that I can read Excel files and that you just started >>> >>> to check out how to write them? >>> >>> >>> >>> --Hannes >>> >>> >>> >>> On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >>> >>>> Thank you Vincent. >>> >>>> Some things is much clearer for me now. >>> >>>> >>> >>>> *It's shame on me that I lost all this Metacello progress, >>> >>>> especially taking into account I was on the ESUG conference where >>> >>>> it was presented. >>> >>>> It >>> >>>> was my only conference unfortunately.* >>> >>>> >>> >>>> I see that you already started this job: you added >>> >>>> ConfigurationOfTabular. >>> >>>> What I really want to do with this configuration: add dependencies >>> >>>> to XMLParser and XMLWriter packages. Can you help with this, >>> >>>> please? >>> >>>> >>> >>>> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >>> >>>> <vincent.blondeau(a)worldline.com> >>> >>>> : >>> >>>> >>> >>>>> Hi, >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> To add a configuration in the catalog, first you should have a >>> >>>>> configuration for your project. You can create it with the >>> >>>>> versionner if needed. >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> Second, you have to add some methods adding meta-description to >>> >>>>> your project. The versionner do it for you: in the configuration >>> >>>>> list, select your project, do a right click and select add catalog >>> >>>>> methods. >>> >>>>> >>> >>>>> It creates all the mandatory methods for the catalog. You now have >>> >>>>> to fill them (look at the class side of the configuration). >>> >>>>> >>> >>>>> Finally, commit your configuration on your repo and on the >>> >>>>> MetaRepoForPharo30/40/50 depending where your project is working. >>> >>>>> >>> >>>>> The link is here: >>> >>>>> http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> Once published, your project will be in the catalog in the image >>> >>>>> (Tools>catalog browser) and on the web http://catalog.pharo.org/. >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> Tell me if you need help to do it, >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> Cheers, >>> >>>>> >>> >>>>> Vincent >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> *De :* Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] >>> >>>>> *De la part de* ???? ????????? >>> >>>>> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 *Ã :* Any question about >>> >>>>> pharo is welcome *Objet :* Re: [Pharo-users] Tabular: XLSX import >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> It looks like I need some guidance to understand contemporary >>> >>>>> packaging/deployment/versioning system. I know it exists, but I >>> >>>>> don't know details. Can you kick me in the right direction? Maybe >>> >>>>> some link? >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano >>> >>>>> <estebanlm(a)gmail.com>: >>> >>>>> >>> >>>>> Hi, >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> it would be sooo cool to have a configuration in the catalogâ¦ >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> Esteban >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> >>> >>>>> wrote: >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> Hello. >>> >>>>> >>> >>>>> Some time ago I announced Tabular >>> >>>>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to >>> >>>>> make a tool for spreadsheets import/export. >>> >>>>> >>> >>>>> >>> >>>>> This is short notice: Vincent Blondeau have added XLSX import >>> >>>>> functionality! >>> >>>>> It's also mostly proof-of-concept now, but even at this stage it's >>> >>>>> quite usable. >>> >>>>> >>> >>>>> Thanks, Vincent! >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> >>> >>>>> ------------------------------ >>> >>>>> >>> >>>>> Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s Ã >>> >>>>> l'usage exclusif de ses destinataires. Il peut Ã©galement Ãªtre >>> >>>>> protÃ©gÃ© par le secret professionnel. Si vous recevez ce message >>> >>>>> par erreur, merci d'en avertir immÃ©diatement l'expÃ©diteur et de le >>> >>>>> dÃ©truire. L'intÃ©gritÃ© du message ne pouvant Ãªtre assurÃ©e sur >>> >>>>> Internet, la responsabilitÃ© de Worldline ne pourra Ãªtre recherchÃ©e >>> >>>>> quant au contenu de ce message. Bien que les meilleurs efforts >>> >>>>> soient faits pour maintenir cette transmission exempte de tout >>> >>>>> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >>> >>>>> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage >>> >>>>> rÃ©sultant d'un virus transmis. >>> >>>>> >>> >>>>> This e-mail and the documents attached are confidential and >>> >>>>> intended solely for the addressee; it may also be privileged. If >>> >>>>> you receive this e-mail in error, please notify the sender >>> >>>>> immediately and destroy it. >>> >>>>> As >>> >>>>> its integrity cannot be secured on the Internet, the Worldline >>> >>>>> liability cannot be triggered for the message content. Although >>> >>>>> the sender endeavours to maintain a computer virus-free network, >>> >>>>> the sender does not warrant that this transmission is virus-free >>> >>>>> and will not be liable for any damages resulting from any virus >>> >>>>> transmitted. >>> >>>>> >>> >>> >>> >> >>> >> >>> >> >>> > >>> >>> >>> >>> >> >

Aug. 13, 2015

Re: [Pharo-users] Tabular: XLSX import

by H. Hirzel

Hello Jurij and Vincent I am working on extending the export function (export of several worksheets). For this I am adding some more tests currently and I'd like to have your feedback on some of the basic functions regarding initial values. http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.49.mcz (41 tests run, 32 passes) in particular on class TabularWorksheetTest (3 tests) We have for example Test which passes testCellsReadingEmptyCell0 "accessing a cell without data" ws col: 1 row: 1 putData: 11. ws col: 2 row: 1 putData: 21. self assert: (ws col: 1 row: 1) data equals: 11. self assert: (ws col: 2 row: 1) data equals: 21. self assert: ((ws col: 3 row: 1) isNil). "Is this OK to have nil returned?" Test which does not pass testCellsReadingEmptyCell self assert: ((ws col: 100 row: 100) data =''). "probably should return an empty string" Comments of others are invited as well. -- Hannes On 8/9/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: > If your are using at least Pharo 4.0, you can use the catalog browser to > load the ConfigurationOfTabular directly. > > You have only publish it for MetaRepoForPharo50, so it didn't work for > Pharo 4. > BUt, thanks to your explanations, I just have published in > MetaRepoForPharo40 as well - works like charm! > > 2015-08-08 12:45 GMT+03:00 Vincent BLONDEAU < > vincent.blondeau(a)polytech-lille.net>: > >> Hi, >> >> I added the dependencies to PharoExtras/XMLWriter and XMLParser. >> I didn't add the dependencies before because I used Tabular with Moose, >> and Moose already loads these dependencies... >> >> Now it should work. I created the new 0.2 release with the required >> dependencies. >> >> By the way, I used Versionner to create the configuration. I don't know >> if >> there is a documentation but there is a video: >> https://www.youtube.com/watch?v=cFRJDuWL-Q0 >> >> It is a very fast tool to manage your projects! >> >> If your are using at least Pharo 4.0, you can use the catalog browser to >> load the ConfigurationOfTabular directly. >> >> Best, >> Vincent >> >> -----Message d'origine----- >> De : Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] De la part >> de H. Hirzel >> EnvoyÃ© : samedi 8 aoÃ»t 2015 10:34 >> Ã : Any question about pharo is welcome >> Objet : Re: [Pharo-users] Tabular: XLSX import >> >> If I do >> >> ConfigurationOfXMLWriter load >> >> then >> >> TabularExperimentalExport writeTestFile >> >> is fine generating an Excel file. >> >> http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.27.mcz >> >> I am currently exploring the code and trying to figure out how it works. >> >> --Hannes >> >> On 8/8/15, H. Hirzel <hannes.hirzel(a)gmail.com> wrote: >> > I understand that Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ asks how to construct his >> > ConfigurationOfTabular file >> > >> > http://ss3.gemtalksystems.com/ss/Tabular.html >> > >> > So I pointed him to the Pharo By Examples book 2 Chapter 9 Managing >> > Projects with Metacello >> > >> > >> > The Tabular project needs a XMLWriter class. I assume the regular >> > pharoExtras is fine. I do not know. >> > >> > I am just looking at the code to see how the reading and writing of >> > MSOffice files, Excel in this particular case, is done so far. >> > >> > For reading a TabularSAXParser is included in the package. Probably >> > not necessary. >> > >> > I moved it out here >> > http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.26.mcz >> > >> > Hannes >> > >> > >> > >> > On 8/8/15, stepharo <stepharo(a)free.fr> wrote: >> >> >> >> >> >> Le 8/8/15 09:11, H. Hirzel a Ã©crit : >> >>> What about >> >>> http://rmod.lille.inria.fr/deepIntoPharo/index.html >> >>> >> >>> p. 163 depending on a project without Metacello description p. 164, >> >>> depending on a project with a Metacello configuration >> >>> >> >>> In the mean time just a note that Tabular needs XMLParser and >> >>> XMLWriter packages on http://ss3.gemtalksystems.com/ss/Tabular.html. >> >> >> >> are you implying that there is no expression of dependencies and that >> >> in addition it depend on a different XML Parser/Writer than >> >> pharoExtras ones? >> >> >> >> Stef >> >>> >> >>> Some class comments are welcome as well :-) >> >>> >> >>> I understand that I can read Excel files and that you just started >> >>> to check out how to write them? >> >>> >> >>> --Hannes >> >>> >> >>> On 8/4/15, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> wrote: >> >>>> Thank you Vincent. >> >>>> Some things is much clearer for me now. >> >>>> >> >>>> *It's shame on me that I lost all this Metacello progress, >> >>>> especially taking into account I was on the ESUG conference where >> >>>> it was presented. >> >>>> It >> >>>> was my only conference unfortunately.* >> >>>> >> >>>> I see that you already started this job: you added >> >>>> ConfigurationOfTabular. >> >>>> What I really want to do with this configuration: add dependencies >> >>>> to XMLParser and XMLWriter packages. Can you help with this, please? >> >>>> >> >>>> 2015-08-04 17:19 GMT+03:00 Blondeau Vincent >> >>>> <vincent.blondeau(a)worldline.com> >> >>>> : >> >>>> >> >>>>> Hi, >> >>>>> >> >>>>> >> >>>>> >> >>>>> To add a configuration in the catalog, first you should have a >> >>>>> configuration for your project. You can create it with the >> >>>>> versionner if needed. >> >>>>> >> >>>>> >> >>>>> >> >>>>> Second, you have to add some methods adding meta-description to >> >>>>> your project. The versionner do it for you: in the configuration >> >>>>> list, select your project, do a right click and select add catalog >> >>>>> methods. >> >>>>> >> >>>>> It creates all the mandatory methods for the catalog. You now have >> >>>>> to fill them (look at the class side of the configuration). >> >>>>> >> >>>>> Finally, commit your configuration on your repo and on the >> >>>>> MetaRepoForPharo30/40/50 depending where your project is working. >> >>>>> >> >>>>> The link is here: >> >>>>> http://smalltalkhub.com/#!/~Pharo/MetaRepoForPharo50 >> >>>>> >> >>>>> >> >>>>> >> >>>>> Once published, your project will be in the catalog in the image >> >>>>> (Tools>catalog browser) and on the web http://catalog.pharo.org/. >> >>>>> >> >>>>> >> >>>>> >> >>>>> Tell me if you need help to do it, >> >>>>> >> >>>>> >> >>>>> >> >>>>> Cheers, >> >>>>> >> >>>>> Vincent >> >>>>> >> >>>>> >> >>>>> >> >>>>> *De :* Pharo-users [mailto:pharo-users-bounces@lists.pharo.org] >> >>>>> *De la part de* ???? ????????? >> >>>>> *EnvoyÃ© :* dimanche 2 aoÃ»t 2015 10:25 *Ã :* Any question about >> >>>>> pharo is welcome *Objet :* Re: [Pharo-users] Tabular: XLSX import >> >>>>> >> >>>>> >> >>>>> >> >>>>> It looks like I need some guidance to understand contemporary >> >>>>> packaging/deployment/versioning system. I know it exists, but I >> >>>>> don't know details. Can you kick me in the right direction? Maybe >> >>>>> some link? >> >>>>> >> >>>>> >> >>>>> >> >>>>> 2015-08-02 11:21 GMT+03:00 Esteban Lorenzano <estebanlm(a)gmail.com>: >> >>>>> >> >>>>> Hi, >> >>>>> >> >>>>> >> >>>>> >> >>>>> it would be sooo cool to have a configuration in the catalogâ¦ >> >>>>> >> >>>>> >> >>>>> >> >>>>> Esteban >> >>>>> >> >>>>> >> >>>>> >> >>>>> On 01 Aug 2015, at 20:58, Ð®ÑÐ¸Ð¹ ÐÐ¸ÑÐ¾Ð½ÐµÐ½ÐºÐ¾ <assargaddon(a)gmail.com> >> >>>>> wrote: >> >>>>> >> >>>>> >> >>>>> >> >>>>> Hello. >> >>>>> >> >>>>> Some time ago I announced Tabular >> >>>>> <http://ss3.gemtalksystems.com/ss/Tabular.html>, some effort to >> >>>>> make a tool for spreadsheets import/export. >> >>>>> >> >>>>> >> >>>>> This is short notice: Vincent Blondeau have added XLSX import >> >>>>> functionality! >> >>>>> It's also mostly proof-of-concept now, but even at this stage it's >> >>>>> quite usable. >> >>>>> >> >>>>> Thanks, Vincent! >> >>>>> >> >>>>> >> >>>>> >> >>>>> >> >>>>> >> >>>>> ------------------------------ >> >>>>> >> >>>>> Ce message et les piÃ¨ces jointes sont confidentiels et rÃ©servÃ©s Ã >> >>>>> l'usage exclusif de ses destinataires. Il peut Ã©galement Ãªtre >> >>>>> protÃ©gÃ© par le secret professionnel. Si vous recevez ce message >> >>>>> par erreur, merci d'en avertir immÃ©diatement l'expÃ©diteur et de le >> >>>>> dÃ©truire. L'intÃ©gritÃ© du message ne pouvant Ãªtre assurÃ©e sur >> >>>>> Internet, la responsabilitÃ© de Worldline ne pourra Ãªtre recherchÃ©e >> >>>>> quant au contenu de ce message. Bien que les meilleurs efforts >> >>>>> soient faits pour maintenir cette transmission exempte de tout >> >>>>> virus, l'expÃ©diteur ne donne aucune garantie Ã cet Ã©gard et sa >> >>>>> responsabilitÃ© ne saurait Ãªtre recherchÃ©e pour tout dommage >> >>>>> rÃ©sultant d'un virus transmis. >> >>>>> >> >>>>> This e-mail and the documents attached are confidential and >> >>>>> intended solely for the addressee; it may also be privileged. If >> >>>>> you receive this e-mail in error, please notify the sender >> >>>>> immediately and destroy it. >> >>>>> As >> >>>>> its integrity cannot be secured on the Internet, the Worldline >> >>>>> liability cannot be triggered for the message content. Although >> >>>>> the sender endeavours to maintain a computer virus-free network, >> >>>>> the sender does not warrant that this transmission is virus-free >> >>>>> and will not be liable for any damages resulting from any virus >> >>>>> transmitted. >> >>>>> >> >>> >> >> >> >> >> >> >> > >> >> >> >> >

Aug. 13, 2015

Spec TreeModel

by Thomas Heniart

Hi, I'm using TreeModel>>beCheckList and I wanted to know if it is possible to dissociate the checkbox and label. More precisely, what I want is changing state by clicking on the checkbox only Is it possible ? Cheers, Thomas

Aug. 12, 2015

Re: [Pharo-users] UUIDs

by Ben Coman

On Wed, Aug 12, 2015 at 6:38 PM, Sean P. DeNigris <sean(a)clipperadams.com> wrote: > Ben Coman wrote >> Unless your requirements *specifically* need identical files to be >> maintained as duplicates, I would strongly consider using something >> content based like MD5 or SHA > > Interesting... There should not be any duplicates. What's the advantage over > UUID? > This... "move to another OS and continue generating [file-ids] with another VM? " An sha-hash intrinsically represents THE content (it is *always* the same no matter who/where/how its calculated), whereas a UUID is a randomly generated label assigned to the content. also, depending on use-case, it may facilitate... * easy to verify whether the file contents have changed. * periodic checking of backups/restores for file corruption (including by external tools without reference to indexes maintained by your Application Image. * facilitate revision control, if you come across a file whose filename doesn't match its contents-sha-hash, then you know its ancestor content by its current file-id. And for my own use case "some day".... I know have many duplicate files scattered amongst many adhoc backups. For example, over ten years several cycles of upgrading to a new PC where the quick-safe path taken was to copy the old PC hard drive to a subfolder on the new PC hard drive, but the old hard went into a box now with a dozen friends, plus duplication of many old small backups media (floppy, ZIP-Media, tape) that it wold help to consolidate onto several of todays large media. cheers -ben

Aug. 12, 2015

Re: [Pharo-users] UUIDs

by Sean P. DeNigris

Ben Coman wrote > Unless your requirements *specifically* need identical files to be > maintained as duplicates, I would strongly consider using something > content based like MD5 or SHA Interesting... There should not be any duplicates. What's the advantage over UUID? ----- Cheers, Sean -- View this message in context: http://forum.world.st/UUIDs-tp4842189p4842284.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.

Aug. 12, 2015

← Newer
1
...
20
21
22
23
24
25
26
...
45
Older →

Jump to page: