aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorPJ Fanning <fanningpj@apache.org>2023-01-10 20:10:25 +0000
committerPJ Fanning <fanningpj@apache.org>2023-01-10 20:10:25 +0000
commit786af03e67eb20b8e9f5b34c3d214814033d7cbc (patch)
tree76677ceb72c13aef03272a6cf1c1d27174c16afb
parentc7822f687a46896315aeaeb9a01e801419f7ce48 (diff)
downloadpoi-786af03e67eb20b8e9f5b34c3d214814033d7cbc.tar.gz
poi-786af03e67eb20b8e9f5b34c3d214814033d7cbc.zip
add test case
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1906561 13f79535-47bb-0310-9956-ffa450edef68
-rw-r--r--poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFCell.java26
1 files changed, 26 insertions, 0 deletions
diff --git a/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFCell.java b/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFCell.java
index 920f455b5a..b4ea25eddc 100644
--- a/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFCell.java
+++ b/poi/src/test/java/org/apache/poi/hssf/usermodel/TestHSSFCell.java
@@ -30,12 +30,14 @@ import java.util.Date;
import java.util.List;
import java.util.ListIterator;
+import org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream;
import org.apache.poi.hssf.HSSFITestDataProvider;
import org.apache.poi.hssf.HSSFTestDataSamples;
import org.apache.poi.hssf.model.InternalSheet;
import org.apache.poi.hssf.record.DBCellRecord;
import org.apache.poi.hssf.record.FormulaRecord;
import org.apache.poi.hssf.record.StringRecord;
+import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.BaseTestCell;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellType;
@@ -415,4 +417,28 @@ final class TestHSSFCell extends BaseTestCell {
assertThrows(IllegalStateException.class, cell::getErrorCellValue);
}
}
+
+ @Test
+ void setFillForegroundColor() throws IOException {
+ try (
+ HSSFWorkbook wb = new HSSFWorkbook();
+ UnsynchronizedByteArrayOutputStream bos = new UnsynchronizedByteArrayOutputStream()
+ ) {
+ Cell cell = wb.createSheet().createRow(0).createCell(0);
+ HSSFCellStyle cellStyle = wb.createCellStyle();
+ HSSFPalette palette = wb.getCustomPalette();
+ palette.setColorAtIndex((short) 1, (byte) 60, (byte) 120, (byte) 216);
+ HSSFColor color = palette.findSimilarColor(60, 120, 216);
+ cellStyle.setFillForegroundColor(color);
+ cell.setCellStyle(cellStyle);
+ assertEquals(color, cellStyle.getFillForegroundColorColor());
+ wb.write(bos);
+
+ try (HSSFWorkbook wb2 = new HSSFWorkbook(bos.toInputStream())) {
+ HSSFSheet sheet = wb2.getSheetAt(0);
+ HSSFCellStyle savedStyle = sheet.getRow(0).getCell(0).getCellStyle();
+ assertEquals(color, savedStyle.getFillForegroundColorColor());
+ }
+ }
+ }
}