From dev-return-39587-archive-asf-public=cust-asf.ponee.io@poi.apache.org Fri Feb 16 13:40:51 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id E872D180647 for ; Fri, 16 Feb 2018 13:40:49 +0100 (CET) Received: (qmail 4461 invoked by uid 500); 16 Feb 2018 12:40:49 -0000 Mailing-List: contact dev-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Developers List" Delivered-To: mailing list dev@poi.apache.org Received: (qmail 4446 invoked by uid 99); 16 Feb 2018 12:40:48 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Feb 2018 12:40:48 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id CBB95C0412 for ; Fri, 16 Feb 2018 12:40:47 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.01 X-Spam-Level: X-Spam-Status: No, score=-0.01 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, KAM_NUMSUBJECT=0.5, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 7XE18WiDhiRZ for ; Fri, 16 Feb 2018 12:40:44 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id F28CD5F520 for ; Fri, 16 Feb 2018 12:40:43 +0000 (UTC) Received: from jenkins-master.apache.org (unknown [62.210.60.235]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 00D3BE00A6 for ; Fri, 16 Feb 2018 12:40:43 +0000 (UTC) Received: from jenkins-master.apache.org (localhost [127.0.0.1]) by jenkins-master.apache.org (ASF Mail Server at jenkins-master.apache.org) with ESMTP id E3D15A004D for ; Fri, 16 Feb 2018 12:40:39 +0000 (UTC) Date: Fri, 16 Feb 2018 12:40:36 +0000 (UTC) From: Apache Jenkins Server To: dev@poi.apache.org Message-ID: <371691985.154.1518784836994.JavaMail.jenkins@jenkins-master.apache.org> Subject: Build failed in Jenkins: POI-DSL-Windows-1.8 #134 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Instance-Identity: MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAkqVKZPv7YyHBB3FvWfV7XQehwe/Ga3aadzSNknt8g382X3uN8A3SOQ+Ixq9HxS+ZlN6XR4TECySmSRy2JN5Rx8svxAD0TjtSF9LuU98dD+LniNDP7Lq6gvRFuJhbMHoS0nuTizDZLsK4X8TW5MyV9w+jFbdoZfRE5O/Mse0fkOeL5uoIS/3Vvu/W+x9QSjDkB7CaU56bPFlQjqqJBl3Cn9r34CkXQZYnLb/NjW4vcpw0+TgMUAPTIVEr5BTPZRshz19g7huwg3zANT5HBIZnzV4hsVY9w4JHkceFdKi/ibNnjPjsFs9pm0HSGJ/RDxjIvSTYT02eH4+m1RAYaj2E9QIDAQAB X-Jenkins-Job: POI-DSL-Windows-1.8 X-Jenkins-Result: FAILURE See Changes: [nick] Unit test to try to reproduce bug #62108 (currenly works though...) [nick] Update the groovy example [nick] Add some write/change code as well for Groovy [nick] Commit examples from the JVM Languages page ------------------------------------------ [...truncated 593.54 KB...] [zip] Building zip: [tar] Building tar: [zip] Building zip: [tar] Building tar: [echo] Creating Maven POMs maven-poms: [copy] Copying 6 files to [echo] Maven POMs are located in [echo] Use ant dist-nexus to deploy the artifacts in the remote repository [echo] Distribution located in [echo] Use "ant dist-checksum" to create md5/sha1/sha512 checksums and GPG signatures findbugs: [get] Destination already exists (skipping): [unzip] Expanding: into [findbugs] Executing findbugs FindBugsTask from ant task [findbugs] Running FindBugs... [findbugs] Warnings generated: 47 [findbugs] Calculating exit code... [findbugs] Setting 'bugs found' flag (1) [findbugs] Exit code set to: 1 [findbugs] Java Result: 1 [findbugs] Output saved to build/findbugs.xml [xslt] Transforming into [xslt] Processing to [xslt] Loading stylesheet jar: release-notes: [copy] Copying 1 file to rat-check: [mkdir] Created dir: [echo] [echo] ***************************************************** [echo] Summary [echo] ------- [echo] Generated at: 2018-02-16T12:39:54+00:00 [echo] [echo] Notes: 1 [echo] Binaries: 120 [echo] Archives: 0 [echo] Standards: 3762 [echo] [echo] Apache Licensed: 3757 [echo] Generated Documents: 0 [echo] [echo] JavaDocs are generated, thus a license header is optional. [echo] Generated files do not require license headers. [echo] [echo] 5 Unknown Licenses [echo] [echo] ***************************************************** [echo] [echo] Files with unapproved licenses: [echo] [echo] f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/clojure/SpreadSheetDemo.clj [echo] f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/SpreadSheetDemo.groovy [echo] f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/build.gradle [echo] f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/XSSFMain.scala [echo] f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/build.sbt [echo] [echo] ***************************************************** [echo] [echo] ***************************************************** [echo] Files with Apache License headers will be marked AL [echo] Binary files (which do not require any license headers) will be marked B [echo] Compressed archives will be marked A [echo] Notices, licenses etc. will be marked N [echo] !????? f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/clojure/SpreadSheetDemo.clj [echo] !????? f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/SpreadSheetDemo.groovy [echo] !????? f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/build.gradle [echo] !????? f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/XSSFMain.scala [echo] !????? f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/build.sbt [echo] [echo] ***************************************************** [echo] [echo] Printing headers for text files without a valid license header... [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/clojure/SpreadSheetDemo.clj [echo] ===================================================== [echo] (ns poi.core [echo] (:gen-class) [echo] (:use [clojure.java.io :only [input-stream]]) [echo] (:import [org.apache.poi.ss.usermodel WorkbookFactory DataFormatter])) [echo] [echo] [echo] (defn sheets [wb] (map #(.getSheetAt wb %1) (range 0 (.getNumberOfSheets wb)))) [echo] [echo] (defn print-all [wb] [echo] (let [df (DataFormatter.)] [echo] (doseq [sheet (sheets wb)] [echo] (doseq [row (seq sheet)] [echo] (doseq [cell (seq row)] [echo] (println (.formatAsString (.getAddress cell)) ": " (.formatCellValue df cell))))))) [echo] [echo] (defn -main [& args] [echo] (when-let [name (first args)] [echo] (let [wb (WorkbookFactory/create (input-stream name))] [echo] (print-all wb)))) [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/SpreadSheetDemo.groovy [echo] ===================================================== [echo] import org.apache.poi.ss.usermodel.* [echo] import org.apache.poi.ss.util.* [echo] import java.io.File [echo] [echo] if (args.length == 0) { [echo] println "Use:" [echo] println " SpreadSheetDemo [output-file]" [echo] return 1 [echo] } [echo] [echo] File f = new File(args[0]) [echo] DataFormatter formatter = new DataFormatter() [echo] WorkbookFactory.create(f,null,true).withCloseable { workbook -> [echo] println "Has ${workbook.getNumberOfSheets()} sheets" [echo] [echo] // Dump the contents of the spreadsheet [echo] (0.. [echo] println "Sheet ${sheetNum} is called ${workbook.getSheetName(sheetNum)}" [echo] [echo] def sheet = workbook.getSheetAt(sheetNum) [echo] sheet.each { row -> [echo] def nonEmptyCells = row.grep { c -> c.getCellType() != Cell.CELL_TYPE_BLANK } [echo] println " Row ${row.getRowNum()} has ${nonEmptyCells.size()} non-empty cells:" [echo] nonEmptyCells.each { c -> [echo] def cRef = [c] as CellReference [echo] println " * ${cRef.formatAsString()} = ${formatter.formatCellValue(c)}" [echo] } [echo] } [echo] } [echo] [echo] // Add two new sheets and populate [echo] CellStyle headerStyle = makeHeaderStyle(workbook) [echo] Sheet ns1 = workbook.createSheet("Generated 1") [echo] exportHeader(ns1, headerStyle, null, ["ID","Title","Num"] as String[]) [echo] ns1.createRow(1).createCell(0).setCellValue("TODO - Populate with data") [echo] [echo] Sheet ns2 = workbook.createSheet("Generated 2") [echo] exportHeader(ns2, headerStyle, "This is a demo sheet", [echo] ["ID","Title","Date","Author","Num"] as String[]) [echo] ns2.createRow(2).createCell(0).setCellValue(1) [echo] ns2.createRow(3).createCell(0).setCellValue(4) [echo] ns2.createRow(4).createCell(0).setCellValue(1) [echo] [echo] // Save [echo] File output = File.createTempFile("output-", (f.getName() =~ /(\.\w+$)/)[0][0]) [echo] output.withOutputStream { os -> workbook.write(os) } [echo] println "Saved as ${output}" [echo] } [echo] [echo] CellStyle makeHeaderStyle(Workbook wb) { [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/groovy/build.gradle [echo] ===================================================== [echo] // Add the POI core and OOXML support dependencies into your gradle build, [echo] // along with all of Groovy so it can run as a standalone script [echo] apply plugin: 'groovy' [echo] repositories { [echo] mavenCentral() [echo] } [echo] dependencies { [echo] compile 'org.codehaus.groovy:groovy-all:2.4.13' [echo] compile 'org.apache.poi:poi:3.17' [echo] compile 'org.apache.poi:poi-ooxml:3.17' [echo] } [echo] [echo] // Our files are in the current directory [echo] sourceSets { [echo] main { groovy { srcDirs = ['.'] } } [echo] } [echo] [echo] // Run out read demo by default [echo] tasks.withType(JavaExec) { [echo] classpath = sourceSets.main.runtimeClasspath [echo] } [echo] task runScript(type: JavaExec) { [echo] main = "SpreadSheetDemo" [echo] args = ["../../../test-data/spreadsheet/Simple.xls"] [echo] } [echo] defaultTasks 'runScript' [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/XSSFMain.scala [echo] ===================================================== [echo] // Import the required classes [echo] import org.apache.poi.ss.usermodel.{WorkbookFactory, DataFormatter} [echo] import java.io.{File, FileOutputStream} [echo] [echo] object XSSFMain extends App { [echo] [echo] // Automatically convert Java collections to Scala equivalents [echo] import scala.collection.JavaConversions._ [echo] [echo] // Read the contents of the workbook [echo] val workbook = WorkbookFactory.create(new File("SampleSS.xlsx")) [echo] val formatter = new DataFormatter() [echo] for { [echo] // Iterate and print the sheets [echo] (sheet, i) <- workbook.zipWithIndex [echo] _ = println(s"Sheet $i of ${workbook.getNumberOfSheets}: ${sheet.getSheetName}") [echo] [echo] // Iterate and print the rows [echo] row <- sheet [echo] _ = println(s"\tRow ${row.getRowNum}") [echo] [echo] // Iterate and print the cells [echo] cell <- row [echo] } { [echo] println(s"\t\t${cell.getCellAddress}: ${formatter.formatCellValue(cell)}") [echo] } [echo] [echo] // Add a sheet to the workbook [echo] val sheet = workbook.createSheet("new sheet") [echo] val row = sheet.createRow(7) [echo] val cell = row.createCell(42) [echo] cell.setAsActiveCell() [echo] cell.setCellValue("The answer to life, the universe, and everything") [echo] [echo] // Save the updated workbook as a new file [echo] val fos = new FileOutputStream("SampleSS-updated.xlsx") [echo] workbook.write(fos) [echo] workbook.close() [echo] } [echo] [echo] ===================================================== [echo] == File: f:/jenkins/jenkins-slave/workspace/POI-DSL-Windows-1.8/src/examples/scala/build.sbt [echo] ===================================================== [echo] // Add the POI core and OOXML support dependencies into your build.sbt [echo] libraryDependencies ++= Seq( [echo] "org.apache.poi" % "poi" % "3.17", [echo] "org.apache.poi" % "poi-ooxml" % "3.17", [echo] "org.apache.poi" % "poi-ooxml-schemas" "3.17", [echo] ) BUILD FAILED :2088: condition satisfied Total time: 21 minutes 6 seconds Build step 'Invoke Ant' marked build as failure Skipping publisher since build result is FAILURE Archiving artifacts [Fast Archiver] Compressed 235.91 MB of artifacts by 54.9% relative to #133 Skipping publisher since build result is FAILURE Recording test results --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org For additional commands, e-mail: dev-help@poi.apache.org