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
Found a useful summary about for generating XLSX files
http://stackoverflow.com/questions/6055430/how-to-create-xlsx-file-without-using-any-excel-library-php/18820405#18820405
On 8/13/15, H. Hirzel hannes.hir...@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?
TabularXLSXExportTesttestExport7
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.
Answering my own question:
Another value for t is
t=inlineStr
row r=1
c r=A1 t=inlineStr
istabcdefghijklmnopqrstuvwxyz 1234567890/t/is
/c
/row
So for the export I will ignore the construction of a file
sharedStrings.xml
at the moment.
On 8/13/15, H. Hirzel hannes.hir...@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
v0/v
/c
/row
row r=5 customFormat=false ht=79.85 hidden=false
http://ss3.gemtalksystems.com/ss/Tabular/Tabular-HannesHirzel.52.mcz
47 test run, 37 passes.
Currently I have a fixed string
TabularXSLXExportsharedStrings_xml
^'?xml version=1.0 encoding=UTF-8 standalone=yes?
sst xmlns=http://schemas.openxmlformats.org/spreadsheetml/2006/main;
count=1
The attribute t=s of a cell c seems to indicate that the content has
to be interpreted as a shared string.
XLSXImporterresolveSharedStrings
Replace shared strings pointers to real strings
workbook worksheets do:[:worksheet|
worksheet cells do:[:cell|
Hi,
Look at TabularCellextractFromXml: to have some hint about the standard
values of the parameters.
Don't hesitate to put some comments in the code with the discoveries you made.
Vincent
-Message d'origine-
De : Pharo-users
On 8/13/15, Blondeau Vincent vincent.blond...@worldline.com wrote:
Hello,
As preface, I would like to announce that I created a job for the project on
Jenkins: https://ci.inria.fr/pharo-contribution/job/Tabular/. This you can
check all your tests are green.
Excellent!
Hello,
As preface, I would like to announce that I created a job for the project on
Jenkins: https://ci.inria.fr/pharo-contribution/job/Tabular/. This you can
check all your tests are green.
I think the access to an empty cell should be nil.
To answer generally to all the other questions,
On Thu, Aug 13, 2015 at 10:37 PM, Blondeau Vincent
vincent.blond...@worldline.com wrote:
-Message d'origine-
De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] De la
part
de H. Hirzel
Envoyé : jeudi 13 août 2015 15:06
À : Any
Indeed that is better idea!
Thanks Ben,
Vincent
-Message d'origine-
De : Pharo-users [mailto:pharo-users-boun...@lists.pharo.org] De la part de Ben
Coman
Envoyé : jeudi 13 août 2015 19:13
À : Any question about pharo is welcome
Objet : Re: [Pharo-users] Tabular: XLSX import
On Thu,
Magma is a very valuable tools!
I have no idea of the complexity to deal with that. For example we have
trait in Pharo, I guess it have implication.
Hilaire
Le 14/08/2015 00:15, Pablo R. Digonzelli a écrit :
FYI. Is it interesting for pharo comunity migrate magma from squeak to pharo?.
Anyone
On 8/13/15, Blondeau Vincent vincent.blond...@worldline.com wrote:
Hi,
Look at TabularCellextractFromXml: to have some hint about the standard
values of the parameters.
I factores out self extractDataFromXml: aXMLElement.
extractFromXml: aXMLElement
self style: (aXMLElement
Found the information on page 1600 of
http://standards.iso.org/ittf/PubliclyAvailableStandards/c061750_ISO_IEC_29500-1_2012.zip
18.3.1.4
c (Cell)
On 8/14/15, H. Hirzel hannes.hir...@gmail.com wrote:
On 8/13/15, Blondeau Vincent vincent.blond...@worldline.com wrote:
Hi,
Look at
16 matches
Mail list logo