| public GetCellStyleAt ( short idx ) : ICellStyle | ||
| idx | short | |
| return | ICellStyle | |
public void GetCellStyleAt()
{
XSSFWorkbook workbook = new XSSFWorkbook();
try
{
short i = 0;
//get default style
ICellStyle cellStyleAt = workbook.GetCellStyleAt(i);
Assert.IsNotNull(cellStyleAt);
//get custom style
StylesTable styleSource = workbook.GetStylesSource();
XSSFCellStyle customStyle = new XSSFCellStyle(styleSource);
XSSFFont font = new XSSFFont();
font.FontName = ("Verdana");
customStyle.SetFont(font);
int x = styleSource.PutStyle(customStyle);
cellStyleAt = workbook.GetCellStyleAt((short)x);
Assert.IsNotNull(cellStyleAt);
}
finally
{
}
}
public void TestBug49702()
{
// First try with a new file
XSSFWorkbook wb = new XSSFWorkbook();
// Should have one style
Assert.AreEqual(1, wb.NumCellStyles);
wb.GetCellStyleAt((short)0);
try
{
wb.GetCellStyleAt((short)1);
Assert.Fail("Shouldn't be able to get style at 1 that doesn't exist");
}
catch (ArgumentOutOfRangeException) { }
// Add another one
ICellStyle cs = wb.CreateCellStyle();
cs.DataFormat = ((short)11);
// Re-check
Assert.AreEqual(2, wb.NumCellStyles);
wb.GetCellStyleAt((short)0);
wb.GetCellStyleAt((short)1);
try
{
wb.GetCellStyleAt((short)2);
Assert.Fail("Shouldn't be able to get style at 2 that doesn't exist");
}
catch (ArgumentOutOfRangeException) { }
// Save and reload
XSSFWorkbook nwb = (XSSFWorkbook)XSSFTestDataSamples.WriteOutAndReadBack(wb);
Assert.AreEqual(2, nwb.NumCellStyles);
nwb.GetCellStyleAt((short)0);
nwb.GetCellStyleAt((short)1);
try
{
nwb.GetCellStyleAt((short)2);
Assert.Fail("Shouldn't be able to Get style at 2 that doesn't exist");
}
catch (ArgumentOutOfRangeException) { }
// Now with an existing file
wb = XSSFTestDataSamples.OpenSampleWorkbook("sample.xlsx");
Assert.AreEqual(3, wb.NumCellStyles);
wb.GetCellStyleAt((short)0);
wb.GetCellStyleAt((short)1);
wb.GetCellStyleAt((short)2);
try
{
wb.GetCellStyleAt((short)3);
Assert.Fail("Shouldn't be able to Get style at 3 that doesn't exist");
}
catch (ArgumentOutOfRangeException) { }
}
public void Test58084()
{
IWorkbook reference = XSSFTestDataSamples.OpenSampleWorkbook("template.xlsx");
IWorkbook target = new XSSFWorkbook();
copyStyles(reference, target);
Assert.AreEqual(reference.NumCellStyles, target.NumCellStyles);
ISheet sheet = target.CreateSheet();
IRow row = sheet.CreateRow(0);
int col = 0;
for (short i = 1; i < target.NumCellStyles; i++)
{
ICell cell = row.CreateCell(col++);
cell.SetCellValue("Coucou" + i);
cell.CellStyle = (target.GetCellStyleAt(i));
}
/*OutputStream out = new FileOutputStream("C:\\temp\\58084.xlsx");
* target.write(out);
* out.close();*/
IWorkbook copy = XSSFTestDataSamples.WriteOutAndReadBack(target);
// previously this Assert.Failed because the border-element was not copied over
var xxx = copy.GetCellStyleAt((short)1).BorderBottom;
copy.Close();
target.Close();
reference.Close();
}
public void TestRGBColour()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("50299.xlsx");
// Check the CTColor is as expected
XSSFColor rgb3 = (XSSFColor)((XSSFCellStyle)wb.GetCellStyleAt((short)25)).FillForegroundXSSFColor;
Assert.AreEqual(false, rgb3.GetCTColor().IsSetIndexed());
Assert.AreEqual(0, rgb3.GetCTColor().indexed);
Assert.AreEqual(true, rgb3.GetCTColor().IsSetTint());
Assert.AreEqual(-0.34999, rgb3.GetCTColor().tint, 0.00001);
Assert.AreEqual(true, rgb3.GetCTColor().IsSetRgb());
Assert.AreEqual(3, rgb3.GetCTColor().GetRgb().Length);
// Now check the XSSFColor
Assert.AreEqual(0, rgb3.Indexed);
Assert.AreEqual(-0.34999, rgb3.Tint, 0.00001);
Assert.IsFalse(rgb3.HasAlpha);
Assert.IsTrue(rgb3.HasTint);
Assert.AreEqual("FFFFFFFF", rgb3.ARGBHex);
Assert.AreEqual(3, rgb3.RGB.Length);
Assert.AreEqual(255, rgb3.RGB[0]);
Assert.AreEqual(255, rgb3.RGB[1]);
Assert.AreEqual(255, rgb3.RGB[2]);
Assert.AreEqual(4, rgb3.ARGB.Length);
Assert.AreEqual(255, rgb3.ARGB[0]);
Assert.AreEqual(255, rgb3.ARGB[1]);
Assert.AreEqual(255, rgb3.ARGB[2]);
Assert.AreEqual(255, rgb3.ARGB[3]);
// Tint doesn't have the alpha
// tint = -0.34999
// 255 * (1 + tint) = 165 truncated
// or (byte) -91 (which is 165 - 256)
Assert.AreEqual(3, rgb3.GetRgbWithTint().Length);
Assert.AreEqual(-91, (sbyte)rgb3.GetRgbWithTint()[0]);
Assert.AreEqual(-91, (sbyte)rgb3.GetRgbWithTint()[1]);
Assert.AreEqual(-91, (sbyte)rgb3.GetRgbWithTint()[2]);
// Set the colour to black, will Get translated internally
// (Excel stores 3 colour white and black wrong!)
// Set the color to black (no theme).
rgb3.SetRgb(new byte[] { 0, 0, 0 });
Assert.AreEqual("FF000000", rgb3.ARGBHex);
Assert.AreEqual(0, rgb3.GetCTColor().GetRgb()[0]);
Assert.AreEqual(0, rgb3.GetCTColor().GetRgb()[1]);
Assert.AreEqual(0, rgb3.GetCTColor().GetRgb()[2]);
// Set another, is fine
rgb3.SetRgb(new byte[] { 16, 17, 18 });
Assert.IsFalse(rgb3.HasAlpha);
Assert.AreEqual("FF101112", rgb3.ARGBHex);
Assert.AreEqual(0x10, rgb3.GetCTColor().GetRgb()[0]);
Assert.AreEqual(0x11, rgb3.GetCTColor().GetRgb()[1]);
Assert.AreEqual(0x12, rgb3.GetCTColor().GetRgb()[2]);
}
public void TestRGBColour()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("50299.xlsx");
// Check the CTColor is as expected
XSSFColor rgb3 = (XSSFColor)((XSSFCellStyle)wb.GetCellStyleAt((short)25)).FillForegroundXSSFColor;
Assert.AreEqual(false, rgb3.GetCTColor().IsSetIndexed());
Assert.AreEqual(0, rgb3.GetCTColor().indexed);
Assert.AreEqual(true, rgb3.GetCTColor().IsSetTint());
Assert.AreEqual(-0.34999, rgb3.GetCTColor().tint, 0.00001);
Assert.AreEqual(true, rgb3.GetCTColor().IsSetRgb());
Assert.AreEqual(3, rgb3.GetCTColor().GetRgb().Length);
// Now check the XSSFColor
Assert.AreEqual(0, rgb3.Indexed);
Assert.AreEqual(-0.34999, rgb3.Tint, 0.00001);
Assert.AreEqual("FFFFFFFF", rgb3.GetARGBHex());
Assert.AreEqual(3, rgb3.GetRgb().Length);
Assert.AreEqual(255, rgb3.GetRgb()[0]);
Assert.AreEqual(255, rgb3.GetRgb()[1]);
Assert.AreEqual(255, rgb3.GetRgb()[2]);
Assert.AreEqual(4, rgb3.GetARgb().Length);
Assert.AreEqual(255, rgb3.GetARgb()[0]);
Assert.AreEqual(255, rgb3.GetARgb()[1]);
Assert.AreEqual(255, rgb3.GetARgb()[2]);
Assert.AreEqual(255, rgb3.GetARgb()[3]);
// Tint doesn't have the alpha
Assert.AreEqual(3, rgb3.GetRgbWithTint().Length);
Assert.AreEqual(0, rgb3.GetRgbWithTint()[0]);
Assert.AreEqual(0, rgb3.GetRgbWithTint()[1]);
Assert.AreEqual(0, rgb3.GetRgbWithTint()[2]);
// Set the colour to black, will Get translated internally
// (Excel stores 3 colour white and black wrong!)
rgb3.SetRgb(new byte[] { 255, 255, 255 });
Assert.AreEqual("FFFFFFFF", rgb3.GetARGBHex());
Assert.AreEqual(0, rgb3.GetCTColor().GetRgb()[0]);
Assert.AreEqual(0, rgb3.GetCTColor().GetRgb()[1]);
Assert.AreEqual(0, rgb3.GetCTColor().GetRgb()[2]);
// Set another, is fine
rgb3.SetRgb(new byte[] { 16, 17, 18 });
Assert.AreEqual("FF101112", rgb3.GetARGBHex());
Assert.AreEqual(0x10, rgb3.GetCTColor().GetRgb()[0]);
Assert.AreEqual(0x11, rgb3.GetCTColor().GetRgb()[1]);
Assert.AreEqual(0x12, rgb3.GetCTColor().GetRgb()[2]);
}
public void TestARGBColour()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("48779.xlsx");
// Check the CTColor is as expected
XSSFColor rgb4 = (XSSFColor)wb.GetCellStyleAt(1).FillForegroundColorColor;
Assert.AreEqual(false, rgb4.GetCTColor().IsSetIndexed());
Assert.AreEqual(0, rgb4.GetCTColor().indexed);
Assert.AreEqual(true, rgb4.GetCTColor().IsSetRgb());
Assert.AreEqual(4, rgb4.GetCTColor().GetRgb().Length);
// Now check the XSSFColor
Assert.AreEqual(0, rgb4.Indexed);
Assert.AreEqual(0.0, rgb4.Tint);
Assert.IsFalse(rgb4.HasTint);
Assert.IsTrue(rgb4.HasAlpha);
Assert.AreEqual("FFFF0000", rgb4.ARGBHex);
Assert.AreEqual(3, rgb4.RGB.Length);
Assert.AreEqual(255, rgb4.RGB[0]);
Assert.AreEqual(0, rgb4.RGB[1]);
Assert.AreEqual(0, rgb4.RGB[2]);
Assert.AreEqual(4, rgb4.ARGB.Length);
Assert.AreEqual(255, rgb4.ARGB[0]);
Assert.AreEqual(255, rgb4.ARGB[1]);
Assert.AreEqual(0, rgb4.ARGB[2]);
Assert.AreEqual(0, rgb4.ARGB[3]);
// Tint doesn't have the alpha
Assert.AreEqual(3, rgb4.GetRgbWithTint().Length);
Assert.AreEqual(255, rgb4.GetRgbWithTint()[0]);
Assert.AreEqual(0, rgb4.GetRgbWithTint()[1]);
Assert.AreEqual(0, rgb4.GetRgbWithTint()[2]);
// Turn on tinting, and check it behaves
// TODO These values are suspected to be wrong...
rgb4.Tint = (0.4);
Assert.IsTrue(rgb4.HasTint);
Assert.AreEqual(0.4, rgb4.Tint);
Assert.AreEqual(3, rgb4.GetRgbWithTint().Length);
Assert.AreEqual(255, rgb4.GetRgbWithTint()[0]);
Assert.AreEqual(102, rgb4.GetRgbWithTint()[1]);
Assert.AreEqual(102, rgb4.GetRgbWithTint()[2]);
}
public void TestIndexedColour()
{
XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("48779.xlsx");
// Check the CTColor is as expected
XSSFColor indexed = (XSSFColor)wb.GetCellStyleAt(1).FillBackgroundColorColor;
Assert.AreEqual(true, indexed.GetCTColor().IsSetIndexed());
Assert.AreEqual(64, indexed.GetCTColor().indexed);
Assert.AreEqual(false, indexed.GetCTColor().IsSetRgb());
Assert.AreEqual(null, indexed.GetCTColor().GetRgb());
// Now check the XSSFColor
// Note - 64 is a special "auto" one with no rgb equiv
Assert.AreEqual(64, indexed.Indexed);
Assert.AreEqual(null, indexed.RGB);
Assert.AreEqual(null, indexed.GetRgbWithTint());
Assert.AreEqual(null, indexed.ARGBHex);
Assert.IsFalse(indexed.HasAlpha);
Assert.IsFalse(indexed.HasTint);
// Now Move to one with indexed rgb values
indexed.Indexed = (59);
Assert.AreEqual(true, indexed.GetCTColor().IsSetIndexed());
Assert.AreEqual(59, indexed.GetCTColor().indexed);
Assert.AreEqual(false, indexed.GetCTColor().IsSetRgb());
Assert.AreEqual(null, indexed.GetCTColor().GetRgb());
Assert.AreEqual(59, indexed.Indexed);
Assert.AreEqual("FF333300", indexed.ARGBHex);
Assert.AreEqual(3, indexed.RGB.Length);
Assert.AreEqual(0x33, indexed.RGB[0]);
Assert.AreEqual(0x33, indexed.RGB[1]);
Assert.AreEqual(0x00, indexed.RGB[2]);
Assert.AreEqual(4, indexed.ARGB.Length);
Assert.AreEqual(255, indexed.ARGB[0]);
Assert.AreEqual(0x33, indexed.ARGB[1]);
Assert.AreEqual(0x33, indexed.ARGB[2]);
Assert.AreEqual(0x00, indexed.ARGB[3]);
// You don't Get tinted indexed colours, sorry...
Assert.AreEqual(null, indexed.GetRgbWithTint());
}
public void TestGetFillForegroundColor()
{
XSSFWorkbook wb = new XSSFWorkbook();
StylesTable styles = wb.GetStylesSource();
Assert.AreEqual(1, wb.NumCellStyles);
Assert.AreEqual(2, styles.GetFills().Count);
XSSFCellStyle defaultStyle = (XSSFCellStyle)wb.GetCellStyleAt((short)0);
Assert.AreEqual(IndexedColors.Automatic.Index, defaultStyle.FillForegroundColor);
Assert.AreEqual(null, defaultStyle.FillForegroundColorColor);
Assert.AreEqual(FillPatternType.NoFill, defaultStyle.FillPattern);
XSSFCellStyle customStyle = (XSSFCellStyle)wb.CreateCellStyle();
customStyle.FillPattern = (FillPatternType.SolidForeground);
Assert.AreEqual(FillPatternType.SolidForeground, customStyle.FillPattern);
Assert.AreEqual(3, styles.GetFills().Count);
customStyle.FillForegroundColor = (IndexedColors.BrightGreen.Index);
Assert.AreEqual(IndexedColors.BrightGreen.Index, customStyle.FillForegroundColor);
Assert.AreEqual(4, styles.GetFills().Count);
for (int i = 0; i < 3; i++)
{
XSSFCellStyle style = (XSSFCellStyle)wb.CreateCellStyle();
style.FillPattern = (FillPatternType.SolidForeground);
Assert.AreEqual(FillPatternType.SolidForeground, style.FillPattern);
Assert.AreEqual(4, styles.GetFills().Count);
style.FillForegroundColor = (IndexedColors.BrightGreen.Index);
Assert.AreEqual(IndexedColors.BrightGreen.Index, style.FillForegroundColor);
Assert.AreEqual(4, styles.GetFills().Count);
}
Assert.IsNotNull(XSSFTestDataSamples.WriteOutAndReadBack(wb));
}
public void TestGetFillForegroundColor()
{
XSSFWorkbook wb = new XSSFWorkbook();
StylesTable styles = wb.GetStylesSource();
Assert.AreEqual(1, wb.NumCellStyles);
Assert.AreEqual(2, styles.GetFills().Count);
XSSFCellStyle defaultStyle = (XSSFCellStyle)wb.GetCellStyleAt((short)0);
Assert.AreEqual(IndexedColors.AUTOMATIC.Index, defaultStyle.FillForegroundColor);
Assert.AreEqual(null, defaultStyle.FillForegroundColorColor);
Assert.AreEqual(FillPatternType.NO_FILL, defaultStyle.FillPattern);
XSSFCellStyle customStyle = (XSSFCellStyle)wb.CreateCellStyle();
customStyle.FillPattern = (FillPatternType.SOLID_FOREGROUND);
Assert.AreEqual(FillPatternType.SOLID_FOREGROUND, customStyle.FillPattern);
Assert.AreEqual(3, styles.GetFills().Count);
customStyle.FillForegroundColor = (IndexedColors.BRIGHT_GREEN.Index);
Assert.AreEqual(IndexedColors.BRIGHT_GREEN.Index, customStyle.FillForegroundColor);
Assert.AreEqual(4, styles.GetFills().Count);
for (int i = 0; i < 3; i++)
{
XSSFCellStyle style = (XSSFCellStyle)wb.CreateCellStyle();
style.FillPattern = (FillPatternType.SOLID_FOREGROUND);
Assert.AreEqual(FillPatternType.SOLID_FOREGROUND, style.FillPattern);
Assert.AreEqual(4, styles.GetFills().Count);
style.FillForegroundColor = (IndexedColors.BRIGHT_GREEN.Index);
Assert.AreEqual(IndexedColors.BRIGHT_GREEN.Index, style.FillForegroundColor);
Assert.AreEqual(4, styles.GetFills().Count);
}
}
public void TestGetFillForegroundColor()
{
XSSFWorkbook wb = new XSSFWorkbook();
StylesTable styles = wb.GetStylesSource();
Assert.AreEqual(1, wb.NumCellStyles);
Assert.AreEqual(2, styles.GetFills().Count);
XSSFCellStyle defaultStyle = (XSSFCellStyle)wb.GetCellStyleAt((short)0);
Assert.AreEqual(IndexedColors.Automatic.Index, defaultStyle.FillForegroundColor);
Assert.AreEqual(null, defaultStyle.FillForegroundColorColor);
Assert.AreEqual(FillPattern.NoFill, defaultStyle.FillPattern);
XSSFCellStyle customStyle = (XSSFCellStyle)wb.CreateCellStyle();
customStyle.FillPattern = (FillPattern.SolidForeground);
Assert.AreEqual(FillPattern.SolidForeground, customStyle.FillPattern);
Assert.AreEqual(3, styles.GetFills().Count);
customStyle.FillForegroundColor = (IndexedColors.BrightGreen.Index);
Assert.AreEqual(IndexedColors.BrightGreen.Index, customStyle.FillForegroundColor);
Assert.AreEqual(4, styles.GetFills().Count);
for (int i = 0; i < 3; i++)
{
XSSFCellStyle style = (XSSFCellStyle)wb.CreateCellStyle();
style.FillPattern = (FillPattern.SolidForeground);
Assert.AreEqual(FillPattern.SolidForeground, style.FillPattern);
Assert.AreEqual(4, styles.GetFills().Count);
style.FillForegroundColor = (IndexedColors.BrightGreen.Index);
Assert.AreEqual(IndexedColors.BrightGreen.Index, style.FillForegroundColor);
Assert.AreEqual(4, styles.GetFills().Count);
}
Assert.IsNotNull(XSSFTestDataSamples.WriteOutAndReadBack(wb));
}
public void TestCloneStyleDiffWB()
{
XSSFWorkbook wbOrig = new XSSFWorkbook();
Assert.AreEqual(1, wbOrig.NumberOfFonts);
Assert.AreEqual(0, wbOrig.GetStylesSource().GetNumberFormats().Count);
XSSFFont fnt = (XSSFFont)wbOrig.CreateFont();
fnt.FontName = ("TestingFont");
Assert.AreEqual(2, wbOrig.NumberOfFonts);
Assert.AreEqual(0, wbOrig.GetStylesSource().GetNumberFormats().Count);
XSSFDataFormat fmt = (XSSFDataFormat)wbOrig.CreateDataFormat();
fmt.GetFormat("MadeUpOne");
fmt.GetFormat("MadeUpTwo");
XSSFCellStyle orig = (XSSFCellStyle)wbOrig.CreateCellStyle();
orig.Alignment = (HorizontalAlignment.Right);
orig.SetFont(fnt);
orig.DataFormat = (fmt.GetFormat("Test##"));
Assert.IsTrue(HorizontalAlignment.Right == orig.Alignment);
Assert.IsTrue(fnt == orig.GetFont());
Assert.IsTrue(fmt.GetFormat("Test##") == orig.DataFormat);
Assert.AreEqual(2, wbOrig.NumberOfFonts);
Assert.AreEqual(3, wbOrig.GetStylesSource().GetNumberFormats().Count);
// Now a style on another workbook
XSSFWorkbook wbClone = new XSSFWorkbook();
Assert.AreEqual(1, wbClone.NumberOfFonts);
Assert.AreEqual(0, wbClone.GetStylesSource().GetNumberFormats().Count);
Assert.AreEqual(1, wbClone.NumCellStyles);
XSSFDataFormat fmtClone = (XSSFDataFormat)wbClone.CreateDataFormat();
XSSFCellStyle clone = (XSSFCellStyle)wbClone.CreateCellStyle();
Assert.AreEqual(1, wbClone.NumberOfFonts);
Assert.AreEqual(0, wbClone.GetStylesSource().GetNumberFormats().Count);
Assert.IsFalse(HorizontalAlignment.Right == clone.Alignment);
Assert.IsFalse("TestingFont" == clone.GetFont().FontName);
clone.CloneStyleFrom(orig);
Assert.AreEqual(2, wbClone.NumberOfFonts);
Assert.AreEqual(2, wbClone.NumCellStyles);
Assert.AreEqual(1, wbClone.GetStylesSource().GetNumberFormats().Count);
Assert.AreEqual(HorizontalAlignment.Right, clone.Alignment);
Assert.AreEqual("TestingFont", clone.GetFont().FontName);
Assert.AreEqual(fmtClone.GetFormat("Test##"), clone.DataFormat);
Assert.IsFalse(fmtClone.GetFormat("Test##") == fmt.GetFormat("Test##"));
// Save it and re-check
XSSFWorkbook wbReload = (XSSFWorkbook)XSSFTestDataSamples.WriteOutAndReadBack(wbClone);
Assert.AreEqual(2, wbReload.NumberOfFonts);
Assert.AreEqual(2, wbReload.NumCellStyles);
Assert.AreEqual(1, wbReload.GetStylesSource().GetNumberFormats().Count);
XSSFCellStyle reload = (XSSFCellStyle)wbReload.GetCellStyleAt((short)1);
Assert.AreEqual(HorizontalAlignment.Right, reload.Alignment);
Assert.AreEqual("TestingFont", reload.GetFont().FontName);
Assert.AreEqual(fmtClone.GetFormat("Test##"), reload.DataFormat);
Assert.IsFalse(fmtClone.GetFormat("Test##") == fmt.GetFormat("Test##"));
Assert.IsNotNull(XSSFTestDataSamples.WriteOutAndReadBack(wbOrig));
Assert.IsNotNull(XSSFTestDataSamples.WriteOutAndReadBack(wbClone));
}
public void TestBug49702()
{
// First try with a new file
XSSFWorkbook wb = new XSSFWorkbook();
// Should have one style
Assert.AreEqual(1, wb.NumCellStyles);
wb.GetCellStyleAt((short)0);
try
{
wb.GetCellStyleAt((short)1);
Assert.Fail("Shouldn't be able to get style at 1 that doesn't exist");
}
catch (ArgumentOutOfRangeException) { }
// Add another one
ICellStyle cs = wb.CreateCellStyle();
cs.DataFormat = ((short)11);
// Re-check
Assert.AreEqual(2, wb.NumCellStyles);
wb.GetCellStyleAt((short)0);
wb.GetCellStyleAt((short)1);
try
{
wb.GetCellStyleAt((short)2);
Assert.Fail("Shouldn't be able to get style at 2 that doesn't exist");
}
catch (ArgumentOutOfRangeException) { }
// Save and reload
XSSFWorkbook nwb = (XSSFWorkbook)XSSFTestDataSamples.WriteOutAndReadBack(wb);
Assert.AreEqual(2, nwb.NumCellStyles);
nwb.GetCellStyleAt((short)0);
nwb.GetCellStyleAt((short)1);
try
{
nwb.GetCellStyleAt((short)2);
Assert.Fail("Shouldn't be able to Get style at 2 that doesn't exist");
}
catch (ArgumentOutOfRangeException) { }
// Now with an existing file
wb = XSSFTestDataSamples.OpenSampleWorkbook("sample.xlsx");
Assert.AreEqual(3, wb.NumCellStyles);
wb.GetCellStyleAt((short)0);
wb.GetCellStyleAt((short)1);
wb.GetCellStyleAt((short)2);
try
{
wb.GetCellStyleAt((short)3);
Assert.Fail("Shouldn't be able to Get style at 3 that doesn't exist");
}
catch (ArgumentOutOfRangeException) { }
}
public void TestGetCellStyleAt()
{
XSSFWorkbook workbook = new XSSFWorkbook();
short i = 0;
//get default style
ICellStyle cellStyleAt = workbook.GetCellStyleAt(i);
Assert.IsNotNull(cellStyleAt);
//get custom style
StylesTable styleSource = workbook.GetStylesSource();
XSSFCellStyle customStyle = new XSSFCellStyle(styleSource);
XSSFFont font = new XSSFFont();
font.FontName = ("Verdana");
customStyle.SetFont(font);
int x = styleSource.PutStyle(customStyle);
cellStyleAt = workbook.GetCellStyleAt((short)x);
Assert.IsNotNull(cellStyleAt);
}
public void TestGetFillForegroundColor()
{
XSSFWorkbook wb = new XSSFWorkbook();
StylesTable styles = wb.GetStylesSource();
Assert.AreEqual(1, wb.NumCellStyles);
Assert.AreEqual(2, styles.GetFills().Count);
XSSFCellStyle defaultStyle = (XSSFCellStyle)wb.GetCellStyleAt((short)0);
Assert.AreEqual(IndexedColors.AUTOMATIC.Index, defaultStyle.FillForegroundColor);
Assert.AreEqual(null, defaultStyle.FillForegroundColorColor);
Assert.AreEqual(FillPatternType.NO_FILL, defaultStyle.FillPattern);
XSSFCellStyle customStyle = (XSSFCellStyle)wb.CreateCellStyle();
customStyle.FillPattern = (FillPatternType.SOLID_FOREGROUND);
Assert.AreEqual(FillPatternType.SOLID_FOREGROUND, customStyle.FillPattern);
Assert.AreEqual(3, styles.GetFills().Count);
customStyle.FillForegroundColor = (IndexedColors.BRIGHT_GREEN.Index);
Assert.AreEqual(IndexedColors.BRIGHT_GREEN.Index, customStyle.FillForegroundColor);
Assert.AreEqual(4, styles.GetFills().Count);
for (int i = 0; i < 3; i++)
{
XSSFCellStyle style = (XSSFCellStyle)wb.CreateCellStyle();
style.FillPattern = (FillPatternType.SOLID_FOREGROUND);
Assert.AreEqual(FillPatternType.SOLID_FOREGROUND, style.FillPattern);
Assert.AreEqual(4, styles.GetFills().Count);
style.FillForegroundColor = (IndexedColors.BRIGHT_GREEN.Index);
Assert.AreEqual(IndexedColors.BRIGHT_GREEN.Index, style.FillForegroundColor);
Assert.AreEqual(4, styles.GetFills().Count);
}
}
public void Test51037()
{
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet s = wb.CreateSheet() as XSSFSheet;
ICellStyle defaultStyle = wb.GetCellStyleAt((short)0);
Assert.AreEqual(0, defaultStyle.Index);
ICellStyle blueStyle = wb.CreateCellStyle();
blueStyle.FillForegroundColor=(IndexedColors.AQUA.Index);
blueStyle.FillPattern=(FillPatternType.SOLID_FOREGROUND);
Assert.AreEqual(1, blueStyle.Index);
ICellStyle pinkStyle = wb.CreateCellStyle();
pinkStyle.FillForegroundColor=(IndexedColors.PINK.Index);
pinkStyle.FillPattern=(FillPatternType.SOLID_FOREGROUND);
Assert.AreEqual(2, pinkStyle.Index);
// Starts empty
Assert.AreEqual(1, s.GetCTWorksheet().sizeOfColsArray());
CT_Cols cols = s.GetCTWorksheet().GetColsArray(0);
Assert.AreEqual(0, cols.sizeOfColArray());
// Add some rows and columns
XSSFRow r1 = s.CreateRow(0) as XSSFRow;
XSSFRow r2 = s.CreateRow(1) as XSSFRow;
r1.CreateCell(0);
r1.CreateCell(2);
r2.CreateCell(0);
r2.CreateCell(3);
// Check no style is there
Assert.AreEqual(1, s.GetCTWorksheet().sizeOfColsArray());
Assert.AreEqual(0, cols.sizeOfColArray());
Assert.AreEqual(defaultStyle, s.GetColumnStyle(0));
Assert.AreEqual(defaultStyle, s.GetColumnStyle(2));
Assert.AreEqual(defaultStyle, s.GetColumnStyle(3));
// Apply the styles
s.SetDefaultColumnStyle(0, pinkStyle);
s.SetDefaultColumnStyle(3, blueStyle);
// Check
Assert.AreEqual(pinkStyle, s.GetColumnStyle(0));
Assert.AreEqual(defaultStyle, s.GetColumnStyle(2));
Assert.AreEqual(blueStyle, s.GetColumnStyle(3));
Assert.AreEqual(1, s.GetCTWorksheet().sizeOfColsArray());
Assert.AreEqual(2, cols.sizeOfColArray());
Assert.AreEqual(1, cols.GetColArray(0).min);
Assert.AreEqual(1, cols.GetColArray(0).max);
Assert.AreEqual(pinkStyle.Index, cols.GetColArray(0).style);
Assert.AreEqual(4, cols.GetColArray(1).min);
Assert.AreEqual(4, cols.GetColArray(1).max);
Assert.AreEqual(blueStyle.Index, cols.GetColArray(1).style);
// Save, re-load and re-check
wb = XSSFTestDataSamples.WriteOutAndReadBack(wb) as XSSFWorkbook;
s = wb.GetSheetAt(0) as XSSFSheet;
defaultStyle = wb.GetCellStyleAt(defaultStyle.Index);
blueStyle = wb.GetCellStyleAt(blueStyle.Index);
pinkStyle = wb.GetCellStyleAt(pinkStyle.Index);
Assert.AreEqual(pinkStyle, s.GetColumnStyle(0));
Assert.AreEqual(defaultStyle, s.GetColumnStyle(2));
Assert.AreEqual(blueStyle, s.GetColumnStyle(3));
}
public void Bug57880()
{
Console.WriteLine("long time test, run over 1 minute.");
int numStyles = 33000;
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet s = wb.CreateSheet("TestSheet") as XSSFSheet;
XSSFDataFormat fmt = wb.GetCreationHelper().CreateDataFormat() as XSSFDataFormat;
for (int i = 1; i < numStyles; i++)
{
short df = fmt.GetFormat("test" + i);
// Format indexes will be wrapped beyond 32,676
Assert.AreEqual(164 + i, df & 0xffff);
// Create a style and use it
XSSFCellStyle style = wb.CreateCellStyle() as XSSFCellStyle;
Assert.AreEqual(i, style.UIndex);
style.DataFormat = (/*setter*/df);
XSSFCell c = s.CreateRow(i).CreateCell(0, CellType.Numeric) as XSSFCell;
c.CellStyle = (/*setter*/style);
c.SetCellValue(i);
}
//wb = XSSFTestDataSamples.WriteOutAndReadBack(wb) as XSSFWorkbook;
// using temp file instead of ByteArrayOutputStream because of OOM in gump run
FileInfo tmp = TempFile.CreateTempFile("poi-test", ".bug57880");
FileStream fos = new FileStream(tmp.FullName, FileMode.Create, FileAccess.ReadWrite);
wb.Write(fos);
fos.Close();
wb.Close();
fmt = null; s = null; wb = null;
// System.gc();
wb = new XSSFWorkbook(tmp.FullName);
fmt = wb.GetCreationHelper().CreateDataFormat() as XSSFDataFormat;
s = wb.GetSheetAt(0) as XSSFSheet;
for (int i = 1; i < numStyles; i++)
{
XSSFCellStyle style = wb.GetCellStyleAt((short)i) as XSSFCellStyle;
Assert.IsNotNull(style);
Assert.AreEqual(i, style.UIndex);
Assert.AreEqual(164 + i, style.DataFormat & 0xffff);
Assert.AreEqual("test" + i, style.GetDataFormatString());
}
wb.Close();
tmp.Delete();
}
