pjfanning/excel-streaming-reader: Gradle dynamic versioning breaks due to excel-streaming-reader:3.6.0-SNAPSHOT:20220228.103836-2

[Andreas Reichel]

Greetings.

We use Gradle's dynamic version feature and define:

        // https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml
        implementation 'org.apache.poi:poi-ooxml:5.+'

        // 
https://mvnrepository.com/artifact/com.github.pjfanning/excel-streaming-reader
        implementation 'com.github.pjfanning:excel-streaming-reader:3.+'

This broke since:

com.github.pjfanning:excel-streaming-reader:3.6.0-
SNAPSHOT:20220228.103836-2 (which depends on an
unreleased 
https://oss.sonatype.org/content/repositories/snapshots/org/apache/poi/poi-ooxml/5.2.1/poi-ooxml-5.2.1.pom).

We worked around by rejecting SNAPSHOTS of excel-streaming-reader:

    configurations.all {
        resolutionStrategy.componentSelection {
                        all { ComponentSelection selection ->
                                if (selection.candidate.group == 
'com.github.pjfanning' && selection.candidate.version.endsWith("-SNAPSHOT")){
                                        selection.reject("Rejecting changing 
version (SNAPSHOT)'")
                                }
                        }
                }
    }

Two suggestions:

a) maybe synchronise the Version numbers of Stream Reader with POI
b) maybe public Snapshots of the Stream Reader on the same repository
as POI snapshots

Rationale:

We can't depend on POI Snapshots as this library is massive and can
break APIs (while many other smaller libraries provide important fixes
as SNAPSHOT only).

Cheers
Andreas