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.hir...@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, Юрий Мироненко <assargad...@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.blond...@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-boun...@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.hir...@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 <steph...@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, Юрий Мироненко <assargad...@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.blond...@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-boun...@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
>>> >>>>> <esteba...@gmail.com>:
>>> >>>>>
>>> >>>>> Hi,
>>> >>>>>
>>> >>>>>
>>> >>>>>
>>> >>>>> it would be sooo cool to have a configuration in the catalog…
>>> >>>>>
>>> >>>>>
>>> >>>>>
>>> >>>>> Esteban
>>> >>>>>
>>> >>>>>
>>> >>>>>
>>> >>>>> On 01 Aug 2015, at 20:58, Юрий Мироненко <assargad...@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.
>>> >>>>>
>>> >>>
>>> >>
>>> >>
>>> >>
>>> >
>>>
>>>
>>>
>>>
>>
>
