See
<https://ci-builds.apache.org/job/POI/job/POI-DSL-old-Xerces/111/display/redirect?page=changes>
Changes:
[PJ Fanning] [bug-66052] update changes
[PJ Fanning] [bug-66052] add test
[PJ Fanning] try to fix HSSF tests
[PJ Fanning] remove ignoreInvalidColors param
[PJ Fanning] try to fix tests
[PJ Fanning] javadoc issues
[PJ Fanning] add param that allows invalid colors to be ignored
[PJ Fanning] try to fix tests - disabling 2 that need investigation
[PJ Fanning] try to fix tests - disabling 2 that need investigation
[PJ Fanning] javadoc issues
[PJ Fanning] javadoc issues
[PJ Fanning] throw exception if wrong Color class is used
[PJ Fanning] [bug-66052] apply cell style fixes supplied by Axel Richter
[PJ Fanning] log4j 2.18.0
[PJ Fanning] log4j 2.18.0
------------------------------------------
[...truncated 516.54 KB...]
[echo] package org.apache.poi.xssf;
[echo]
[echo] import
org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream;
[echo] import org.apache.poi.ss.usermodel.*;
[echo] import org.apache.poi.ss.util.CellRangeAddress;
[echo] import org.apache.poi.ss.util.PropertyTemplate;
[echo] import org.apache.poi.xssf.usermodel.*;
[echo] import org.apache.commons.codec.binary.Hex;
[echo] import org.junit.jupiter.api.Test;
[echo]
[echo] import static org.junit.jupiter.api.Assertions.assertEquals;
[echo] import static org.junit.jupiter.api.Assertions.assertFalse;
[echo]
[echo] class TestSSUtilVsXSSFColor {
[echo]
[echo] @Test
[echo] void testXSSFCellStyle() throws Exception {
[echo]
[echo] try (
[echo] XSSFWorkbook workbook = new XSSFWorkbook();
[echo] UnsynchronizedByteArrayOutputStream bos = new
UnsynchronizedByteArrayOutputStream()
[echo] ) {
[echo] XSSFCellStyle cellStyle = workbook.createCellStyle();
[echo] final String rgbS = "ffff00";
[echo] final byte[] rgbB = Hex.decodeHex(rgbS);
[echo] IndexedColorMap colorMap =
workbook.getStylesSource().getIndexedColors();
[echo] XSSFColor color = new XSSFColor(rgbB, colorMap);
[echo] cellStyle.setFillForegroundColor(color);
[echo]
cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
[echo]
[echo] final int startDataRow = 6; // row 7 (index 0-based)
[echo] final int endDataRow = 11; // row 12 (index 0-based)
[echo] final int startDataColumn = 1; // column B (index
0-based)
[echo] final int endDataColumn = 10; // column K (index
0-based)
[echo]
[echo] Sheet sheet = workbook.createSheet();
[echo]
[echo] for (int r = startDataRow; r <= endDataRow; r++) {
[echo] Row row = sheet.createRow(r);
[echo] for (int c = startDataColumn; c <= endDataColumn;
c++) {
[echo] Cell cell = row.createCell(c);
[echo]
cell.setCellValue(cell.getAddress().formatAsString());
[echo] cell.setCellStyle(cellStyle);
[echo] }
[echo] }
[echo]
[echo] PropertyTemplate propertyTemplate = new
PropertyTemplate();
[echo] propertyTemplate.drawBorders(new
CellRangeAddress(startDataRow, endDataRow, startDataColumn, endDataColumn),
[echo] BorderStyle.MEDIUM, BorderExtent.ALL);
[echo]
[echo]
[echo] =====================================================
[echo] == File:
<https://ci-builds.apache.org/job/POI/job/POI-DSL-old-Xerces/ws/poi-ooxml-full/src/main/xmlschema/org/apache/poi/schemas/dml-drawing.xsd>
[echo] =====================================================
[echo] <xsd:schema
targetNamespace="http://schemas.microsoft.com/office/drawing/2008/diagram";
[echo] elementFormDefault="qualified"
[echo] attributeFormDefault="unqualified"
[echo] xmlns:xsd="http://www.w3.org/2001/XMLSchema";
[echo]
xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main";
[echo]
xmlns:d="http://schemas.openxmlformats.org/drawingml/2006/diagram";
[echo]
xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships";
[echo]
xmlns="http://schemas.microsoft.com/office/drawing/2008/diagram";>
[echo]
[echo] <xsd:import
namespace="http://schemas.openxmlformats.org/drawingml/2006/main";
[echo] schemaLocation="dml-main.xsd"/>
[echo] <xsd:import schemaLocation="dml-diagram.xsd"
namespace="http://schemas.openxmlformats.org/drawingml/2006/diagram"/>
[echo] <xsd:import
namespace="http://schemas.openxmlformats.org/officeDocument/2006/relationships";
[echo] schemaLocation="shared-relationshipReference.xsd"/>
[echo] <xsd:import
namespace="http://schemas.openxmlformats.org/officeDocument/2006/sharedTypes";
[echo] schemaLocation="shared-commonSimpleTypes.xsd"/>
[echo]
[echo] <xsd:complexType name="CT_ShapeNonVisual">
[echo] <xsd:sequence>
[echo] <xsd:element name="cNvPr"
type="a:CT_NonVisualDrawingProps" minOccurs="1" maxOccurs="1"/>
[echo] <xsd:element name="cNvSpPr"
type="a:CT_NonVisualDrawingShapeProps" minOccurs="1" maxOccurs="1"/>
[echo] </xsd:sequence>
[echo] </xsd:complexType>
[echo] <xsd:complexType name="CT_Shape">
[echo] <xsd:sequence>
[echo] <xsd:element name="nvSpPr" type="CT_ShapeNonVisual"
minOccurs="1" maxOccurs="1"/>
[echo] <xsd:element name="spPr" type="a:CT_ShapeProperties"
minOccurs="1" maxOccurs="1"/>
[echo] <xsd:element name="style" type="a:CT_ShapeStyle"
minOccurs="0" maxOccurs="1"/>
[echo] <xsd:element name="txBody" type="a:CT_TextBody"
minOccurs="0" maxOccurs="1"/>
[echo] <xsd:element name="txXfrm" type="a:CT_Transform2D"
minOccurs="0" maxOccurs="1"/>
[echo] <xsd:element name="extLst"
type="a:CT_OfficeArtExtensionList" minOccurs="0" maxOccurs="1"/>
[echo] </xsd:sequence>
[echo] <xsd:attribute name="modelId" type="d:ST_ModelId"
use="required"/>
[echo] </xsd:complexType>
[echo] <xsd:complexType name="CT_GroupShapeNonVisual">
[echo] <xsd:sequence>
[echo] <xsd:element name="cNvPr"
type="a:CT_NonVisualDrawingProps" minOccurs="1" maxOccurs="1"/>
[echo] <xsd:element name="cNvGrpSpPr"
type="a:CT_NonVisualGroupDrawingShapeProps" minOccurs="1" maxOccurs="1"/>
[echo] </xsd:sequence>
[echo] </xsd:complexType>
[echo] <xsd:complexType name="CT_GroupShape">
[echo] <xsd:sequence>
[echo] <xsd:element name="nvGrpSpPr"
type="CT_GroupShapeNonVisual" minOccurs="1" maxOccurs="1"/>
[echo] <xsd:element name="grpSpPr"
type="a:CT_GroupShapeProperties" minOccurs="1" maxOccurs="1"/>
[echo] <xsd:choice minOccurs="0" maxOccurs="unbounded">
[echo] <xsd:element name="sp" type="CT_Shape"/>
[echo] <xsd:element name="grpSp" type="CT_GroupShape"/>
[echo] </xsd:choice>
[echo] <xsd:element name="extLst"
type="a:CT_OfficeArtExtensionList" minOccurs="0" maxOccurs="1"/>
[echo] </xsd:sequence>
[echo]
[echo] =====================================================
[echo] == File:
<https://ci-builds.apache.org/job/POI/job/POI-DSL-old-Xerces/ws/poi-ooxml-full/src/main/xmlschema/org/apache/poi/schemas/word12.xsd>
[echo] =====================================================
[echo] <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema";
[echo]
xmlns:w06="http://schemas.openxmlformats.org/wordprocessingml/2006/main";
[echo]
xmlns:od06st="http://schemas.openxmlformats.org/officeDocument/2006/sharedTypes";
[echo] elementFormDefault="qualified"
attributeFormDefault="qualified" blockDefault="#all"
[echo]
xmlns="http://schemas.microsoft.com/office/word/2012/wordml";
[echo]
targetNamespace="http://schemas.microsoft.com/office/word/2012/wordml";>
[echo] <xsd:import id="w12"
namespace="http://schemas.microsoft.com/office/word/2012/wordml";
schemaLocation="word12.xsd"/>
[echo] <xsd:element name="color" type="w06:CT_Color"/>
[echo] <xsd:simpleType name="ST_SdtAppearance">
[echo] <xsd:restriction base="xsd:string">
[echo] <xsd:enumeration value="boundingBox"/>
[echo] <xsd:enumeration value="tags"/>
[echo] <xsd:enumeration value="hidden"/>
[echo] </xsd:restriction>
[echo] </xsd:simpleType>
[echo] <xsd:element name="dataBinding" type="w06:CT_DataBinding"/>
[echo] <xsd:complexType name="CT_SdtAppearance">
[echo] <xsd:attribute name="val" type="ST_SdtAppearance"/>
[echo] </xsd:complexType>
[echo] <xsd:element name="appearance" type="CT_SdtAppearance"/>
[echo] <xsd:complexType name="CT_CommentsEx">
[echo] <xsd:sequence>
[echo] <xsd:element name="commentEx" type="CT_CommentEx"
minOccurs="0" maxOccurs="unbounded"/>
[echo] </xsd:sequence>
[echo] </xsd:complexType>
[echo] <xsd:complexType name="CT_CommentEx">
[echo] <xsd:attribute name="paraId" type="w06:ST_LongHexNumber"
use="required"/>
[echo] <xsd:attribute name="paraIdParent"
type="w06:ST_LongHexNumber" use="optional"/>
[echo] <xsd:attribute name="done" type="od06st:ST_OnOff"
use="optional"/>
[echo] </xsd:complexType>
[echo] <xsd:element name="commentsEx" type="CT_CommentsEx"/>
[echo] <xsd:complexType name="CT_People">
[echo] <xsd:sequence>
[echo] <xsd:element name="person" type="CT_Person"
minOccurs="0" maxOccurs="unbounded"/>
[echo] </xsd:sequence>
[echo] </xsd:complexType>
[echo] <xsd:complexType name="CT_PresenceInfo">
[echo] <xsd:attribute name="providerId" type="xsd:string"
use="required"/>
[echo] <xsd:attribute name="userId" type="xsd:string"
use="required"/>
[echo] </xsd:complexType>
[echo] <xsd:complexType name="CT_Person">
[echo] <xsd:sequence>
[echo] <xsd:element name="presenceInfo" type="CT_PresenceInfo"
minOccurs="0" maxOccurs="1"/>
[echo] </xsd:sequence>
[echo] <xsd:attribute name="author" type="od06st:ST_String"
use="required"/>
[echo] </xsd:complexType>
[echo] <xsd:element name="people" type="CT_People"/>
[echo] <xsd:complexType name="CT_SdtRepeatedSection">
[echo] <xsd:sequence>
[echo] <xsd:element name="sectionTitle" type="w06:CT_String"
minOccurs="0"/>
[echo]
[echo] =====================================================
[echo] == File:
<https://ci-builds.apache.org/job/POI/job/POI-DSL-old-Xerces/ws/poi-ooxml-full/src/main/xmlschema/org/apache/poi/schemas/xlThreadedComments.xsd>
[echo] =====================================================
[echo] <xsd:schema
targetNamespace="http://schemas.microsoft.com/office/spreadsheetml/2018/threadedcomments";
[echo] elementFormDefault="qualified"
[echo] xmlns:xsd="http://www.w3.org/2001/XMLSchema";
[echo]
xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main";
[echo]
xmlns:od06st="http://schemas.openxmlformats.org/officeDocument/2006/sharedTypes";
[echo]
xmlns="http://schemas.microsoft.com/office/spreadsheetml/2018/threadedcomments";>
[echo] <!--
[echo] <xsd:import
namespace="http://schemas.openxmlformats.org/spreadsheetml/2006/main";
schemaLocation="xlbasictypes.xsd"/>
[echo] <xsd:import
namespace="http://schemas.openxmlformats.org/spreadsheetml/2006/main";
schemaLocation="xlsst.xsd"/>
[echo] -->
[echo] <xsd:import
namespace="http://schemas.microsoft.com/office/spreadsheetml/2020/threadedcomments2";
schemaLocation="xlThreadedComments2.xsd"/>
[echo] <xsd:element name="personList" type="CT_PersonList"/>
[echo] <xsd:complexType name="CT_PersonList">
[echo] <xsd:sequence>
[echo] <xsd:element name="person" type="CT_Person"
minOccurs="0" maxOccurs="unbounded"/>
[echo] <xsd:element name="extLst" type="x:CT_ExtensionList"
minOccurs="0" maxOccurs="1"/>
[echo] </xsd:sequence>
[echo] </xsd:complexType>
[echo] <xsd:complexType name="CT_Person">
[echo] <xsd:sequence>
[echo] <xsd:element name="extLst" type="x:CT_ExtensionList"
minOccurs="0" maxOccurs="1"/>
[echo] </xsd:sequence>
[echo] <xsd:attribute name="displayName" type="od06st:ST_Xstring"
use="required"/>
[echo] <xsd:attribute name="id" type="od06st:ST_Guid"
use="required"/>
[echo] <xsd:attribute name="userId" type="od06st:ST_Xstring"
use="optional"/>
[echo] <xsd:attribute name="providerId" type="od06st:ST_Xstring"
use="optional"/>
[echo] </xsd:complexType>
[echo] <xsd:element name="ThreadedComments"
type="CT_ThreadedComments"/>
[echo] <xsd:complexType name="CT_ThreadedComments">
[echo] <xsd:sequence>
[echo] <xsd:element name="threadedComment"
type="CT_ThreadedComment" minOccurs="0" maxOccurs="unbounded"/>
[echo] <xsd:element name="extLst" type="x:CT_ExtensionList"
minOccurs="0" maxOccurs="1"/>
[echo] </xsd:sequence>
[echo] </xsd:complexType>
[echo] <xsd:complexType name="CT_ThreadedComment">
[echo] <xsd:sequence>
[echo] <xsd:element name="text" type="od06st:ST_Xstring"
minOccurs="0" maxOccurs="1"/>
[echo] <xsd:element name="mentions"
type="CT_ThreadedCommentMentions" minOccurs="0" maxOccurs="1"/>
[echo] <xsd:element name="extLst" minOccurs="0" maxOccurs="1"/>
[echo] </xsd:sequence>
[echo] <xsd:attribute name="ref" type="x:ST_Ref" use="optional"/>
[echo] <xsd:attribute name="dT" type="xsd:dateTime"
use="optional"/>
[echo] <xsd:attribute name="personId" type="od06st:ST_Guid"
use="required"/>
[echo] <xsd:attribute name="id" type="od06st:ST_Guid"
use="required"/>
[echo] <xsd:attribute name="parentId" type="od06st:ST_Guid"
use="optional"/>
[echo] <xsd:attribute name="done" type="xsd:boolean"
use="optional"/>
[echo] </xsd:complexType>
[echo] <xsd:complexType name="CT_ThreadedCommentMentions">
[echo] <xsd:sequence>
[echo] <xsd:element name="mention" type="CT_Mention"
minOccurs="0" maxOccurs="unbounded"/>
[echo]
[echo] =====================================================
[echo] == File:
<https://ci-builds.apache.org/job/POI/job/POI-DSL-old-Xerces/ws/poi-ooxml-full/src/main/xmlschema/org/apache/poi/schemas/xlThreadedComments2.xsd>
[echo] =====================================================
[echo] <xsd:schema
xmlns="http://schemas.microsoft.com/office/spreadsheetml/2020/threadedcomments2";
[echo]
targetNamespace="http://schemas.microsoft.com/office/spreadsheetml/2020/threadedcomments2";
[echo] elementFormDefault="qualified"
xmlns:xsd="http://www.w3.org/2001/XMLSchema";
[echo]
xmlns:od06st="http://schemas.openxmlformats.org/officeDocument/2006/sharedTypes";
[echo]
xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main";>
[echo] <xsd:complexType name="CT_ThreadedComments2Ext">
[echo] <xsd:sequence>
[echo] <xsd:element name="checksum" type="xsd:unsignedInt"
minOccurs="1" maxOccurs="1"/>
[echo] <xsd:sequence>
[echo] <xsd:element name="hyperlink"
type="CT_CommentHyperlink" minOccurs="0" maxOccurs="unbounded"/>
[echo] </xsd:sequence>
[echo] </xsd:sequence>
[echo] </xsd:complexType>
[echo] <xsd:complexType name="CT_CommentHyperlink">
[echo] <xsd:sequence>
[echo] <xsd:element name="extLst" type="x:CT_ExtensionList"
minOccurs="0" maxOccurs="1"/>
[echo] </xsd:sequence>
[echo] <xsd:attribute name="startIndex" type="xsd:unsignedInt"
use="required"/>
[echo] <xsd:attribute name="length" type="xsd:unsignedInt"
use="required"/>
[echo] <xsd:attribute name="url" type="od06st:ST_Xstring"
use="required"/>
[echo] </xsd:complexType>
[echo] </xsd:schema>
BUILD FAILED
<https://ci-builds.apache.org/job/POI/job/POI-DSL-old-Xerces/ws/build.xml>:2494:
condition satisfied
Total time: 40 minutes 18 seconds
Build step 'Invoke Ant' marked build as failure
[SpotBugs] Skipping execution of recorder since overall result is 'FAILURE'
Archiving artifacts
[Fast Archiver] Compressed 300.40 MB of artifacts by 57.0% relative to #109
Recording test results
[Checks API] No suitable checks publisher found.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
