I did an analysis of the xsb files in poi-ooxml-lite (latest 5.1.1-SNAPSHOT 
versus 5.0.0) and we have no xsbs that were in 5.0.0 but are missing now. We 
have 166 extra ones in 5.1.1-SNAPSHOT.


org/apache/poi/schemas/ooxml/system/ooxml/ctanchorlocked31type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctattre117type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctbottompageborderde82type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcalendartyped1d0type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcellwatch3dectype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcellwatches531atype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcnf1397type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcolumns51d5type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcomplexd4a9type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcontrol997ctype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcontrols75fftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctctrlprea05type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcustomproperties584dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcustompropertybfeftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcustomsheetview59d2type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcustomsheetviewsc069type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcustomworkbookview31d9type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcustomworkbookviewse942type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctcustomxmlpr4b8atype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctd1938type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctdatabinding9077type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctdataconsolidate941etype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctdocgride8b4type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctdpr2596type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctdpt255etype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctednpropsd887type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cteffectextent9724type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctextension1f1etype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctextensionlist8d5ctype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctffname7b3dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctfftextinput3155type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctfilerecoveryprf05ctype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctfilesharing5c9ftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctfileversion559btype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctframepr12a3type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctftnposd254type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctftnprops2df8type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctfunctiongroupsbfd5type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cthandoutmasteridlist5b95type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cthandoutmasteridlistentryad8dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctholesize0f3btype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctinteger255c19etype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctlock201dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctm3f8ftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctmc923ctype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctmcpr6d9atype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctmcs4b1ftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctmpr122dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctmr7ccdtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctnumrestart261ftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctoleobjecte5c0type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctolesizea368type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctomathargcb13type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctpageborderd76dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctpagebordersa4datype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctpagemar92a3type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctpagenumber7570type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctpagesz2d12type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctpapersource8aabtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctpararprchange986etype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctpararproriginal7dadtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctphoneticrun2b2atype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctplaceholder117ftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctposh7fabtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctposv63ddtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctprotectedrange7078type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctprotectedranges7e83type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctr386atype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctrprchangeeaeetype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctrproriginal302dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctsdtcomboboxdb52type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctsdtdatedfa1type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctsdtdatemappingtype5fb1type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctsdtdropdownlist5880type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctsdtlistitem705etype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctsdttext0a82type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctsecttype7cebtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctsheetbackgroundpictureaf1atype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctsortconditionc4fctype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctsortstatea372type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctssubfdc5type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctssubpr1ae3type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cttbllooka235type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cttbloverlap231ftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cttblppra134type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cttcmar23c3type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cttext8965type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cttextdirection0940type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cttextunderlinefillfollowtext8011type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctthicknessf632type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/cttoppageborder3c02type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctwebpublishing4646type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctwrapbc3btype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctwrapnonec43dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctwrapsquare2678type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ctxalignd265type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/dataobjectformattype44eetype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/identifiertype2cb7type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/objectidentifiertype2f56type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/oleobjectbaccdoctype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/oleobjectelement.xsb

org/apache/poi/schemas/ooxml/system/ooxml/signaturepolicyidtype0ca1type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/signaturevaluetype58cctype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/signeddataobjectpropertiestype19a6type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/sigpolicyqualifierslisttype3266type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stblipcompressionb216type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stbookmarkidseed9d13type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stcalendartype8cd2type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stcnfcfa7type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stconnectortypecbd0type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stdatetimee41dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stdepthpercent1b6atype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stdirectionc043type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stdisplacedbycustomxml72d4type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stdocgrid1cc4type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stdvaspect8de3type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stedgrp6bdctype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/steditas85aatype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stffname852dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stfillmethoda592type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stfilltype382btype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stftnposdc44type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/sthanchord885type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/sthint8a31type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stholesize912btype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/sthpercentdbcftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/sthralignfb04type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stinteger2550f8etype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stlocke60dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stobjects5c63type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stoledrawaspect00adtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stoletype716btype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stoverlap7d4ftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stpageborderdisplay731btype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stpanosedb3etype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stphonetictype4f93type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stpositionoffseta433type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stprinterror4934type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stprooferr6bf7type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/strefmodee5a5type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/strelfromh72aatype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/strelfromv56dctype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/strestartnumber11aatype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/strubyalignb1f7type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stsdtdatemappingtype01a1type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stsectionmark2010type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stshadowtype8b48type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stsheetviewtype988dtype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stshorthexnumber9170type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stslidesizetypeb7f3type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/ststrokearrowtype7b4ftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/sttbloverlapb50ftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/sttextdirectionf150type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/sttextnonnegativepointbac6type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/sttimeperiodef07type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stucharhexnumber4efftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stupdatelinksfb3ftype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stvanchora5b7type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stvisibility762btype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stwrap3f4etype.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stwraptext4a98type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stwraptype9ca5type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stxalign8127type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/stxmlname13f2type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/styalign3606type.xsb

org/apache/poi/schemas/ooxml/system/ooxml/validationdatatype2c11type.xsb






On Saturday 11 September 2021, 07:46:50 IST, Andreas Beeker 
<kiwiwi...@apache.org> wrote: 





Hi Pj,

in the integration tests POIXMLDocumentHandler::cursorRecursive can be used to 
recurse through the main document of a format - currently only used for XSSF 
and XWPF (I thought it would be also used for XSLF). Additionally there's the 
test-data/integration directory, which I've used to put documents with missing 
xmlbeans types in.

The ooxml-lite task should be executed after poi-ooxml:test and 
poi-integration:test - I thought, I have handled that.

So if the missing XmlBeans types are in the main document of an .xlsx/.docx, it 
should be enough to put them in test-data/integration.

Btw. I changed a few dependency (e.g. using gradle capabilities for optional 
stuff) and struggle with gradle again - it might take another few days until it 
is working correctly.

Andi



On 10.09.21 10:51, PJ Fanning wrote:
> What do we think is the best way to get the missing xsbs added to 
> poi-ooxml-lite? Maybe, adding more files to test-data dir and adding tests 
> that read them is the best solution? I suppose these tests will need to be in 
> poi-ooxml because that is the project that generates the poi-ooxml-lite 
> report.
>
>
>
>
>
>
> On Sunday 5 September 2021, 19:34:37 IST, Dominik Stadler 
> <dominik.stad...@gmx.at> wrote:
>
>
>
>
>
> Preliminary results of the test-run are at
>
>    - 5.0.0-RC2 to 5.1.0-RC1
>    
><http://people.apache.org/~centic/poi_regression/reports/index500RC2to510RC1.html>
>    - 5.1.0-RC1-All
>    
><http://people.apache.org/~centic/poi_regression/reportsAll/index500RC2to510RC1.html>
>
> We now run 3.5mio documents, 200k more than in the previous runs.
>
> There are 88124 failures compared to 5.0.0 due to missing ".xsb" files in
> poi-ooxml-lite, e.g. ctsdtrow2f71type and others.
>
> Also a few other failures, NPEs, NotImplementedException, ..., some may
> trigger now because new functionality triggers them now, a few are because
> commons-math3 was not up-to-date in the test-driver.
>
> Dominik.
>
>
> On Sat, Sep 4, 2021 at 1:00 PM Dominik Stadler <dominik.stad...@gmx.at>
> wrote:
>
>> Hi,
>>
>> I started the test-suite today and hopefully can report on it before
>> voting ends.
>>
>> Dominik.
>>
>> On Sat, Sep 4, 2021 at 1:10 AM PJ Fanning <fannin...@yahoo.com.invalid>
>> wrote:
>>
>>> Thanks Andi for prepping the RC.
>>>
>>> Have we run the test suite with the large number of test files to see if
>>> the results are ok?
>>>
>>>
>>>
>>>
>>>
>>> On Friday 3 September 2021, 23:40:08 IST, Andreas Beeker <
>>> kiwiwi...@apache.org> wrote:
>>>
>>>
>>>
>>>
>>>
>>> Hi *,
>>>
>>> I've prepared artifacts for the release of Apache POI 5.1.0 (RC1).
>>>
>>> The most notable changes in this release are:
>>>
>>> * upgrade dependencies: XmlBeans 5.0.1, Batik 1.14, BouncyCastle 1.69,
>>> Commons-Compress 1.21, ...
>>> * switching build to Gradle - Ant build is not supported anymore [#65206]
>>> * XSLFTable::addRow functionality reverted to pre-5.0.0 [github-221]
>>> * XSSFDrawing - import chart from other drawing [#63901]
>>> * Support for Excel functions IFS, SWITCH, TEXTJOIN, IFNA, MAXIFS,
>>> MINIFS, AVERAGEIFS
>>> * Fix SVG-related image rendering
>>>
>>> https://dist.apache.org/repos/dist/dev/poi/5.1.0-RC1/
>>>
>>> Things to check:
>>> According to Stackoverflow there were some problems with JPMS and
>>> XmlBeans -
>>> so maybe check for potential problems there.
>>>
>>> Please vote to release the artifacts.
>>> The vote keeps open until 2021-09-10.
>>> Planned release announcement date is Saturday, 2021-09-11.
>>>
>>> Here is my +1
>>>
>>> The SVN repo is open again.
>>>
>>> Andi
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
>>> For additional commands, e-mail: dev-h...@poi.apache.org

>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
>>> For additional commands, e-mail: dev-h...@poi.apache.org
>>>
>>>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
> For additional commands, e-mail: dev-h...@poi.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

Reply via email to