public void TestCloneStyleSameWB()
{
HSSFWorkbook wb = new HSSFWorkbook();
Font fnt = wb.CreateFont();
fnt.FontName = ("TestingFont");
Assert.AreEqual(5, wb.NumberOfFonts);
NPOI.SS.UserModel.CellStyle orig = wb.CreateCellStyle();
orig.Alignment = (HorizontalAlignment.RIGHT);
orig.SetFont(fnt);
orig.DataFormat = ((short)18);
Assert.AreEqual(HorizontalAlignment.RIGHT, orig.Alignment);
Assert.AreEqual(fnt, orig.GetFont(wb));
Assert.AreEqual(18, orig.DataFormat);
NPOI.SS.UserModel.CellStyle clone = wb.CreateCellStyle();
Assert.AreNotEqual(HorizontalAlignment.RIGHT, clone.Alignment);
Assert.AreNotEqual(fnt, clone.GetFont(wb));
Assert.AreNotEqual(18, clone.DataFormat);
clone.CloneStyleFrom(orig);
Assert.AreEqual(HorizontalAlignment.RIGHT, clone.Alignment);
Assert.AreEqual(fnt, clone.GetFont(wb));
Assert.AreEqual(18, clone.DataFormat);
Assert.AreEqual(5, wb.NumberOfFonts);
}
public void TestDoesNoHarmIfNothingToDo()
{
HSSFWorkbook wb = new HSSFWorkbook();
Font f = wb.CreateFont();
f.FontName = ("Testing");
NPOI.SS.UserModel.CellStyle s = wb.CreateCellStyle();
s.SetFont(f);
Assert.AreEqual(5, wb.NumberOfFonts);
Assert.AreEqual(22, wb.NumCellStyles);
// Optimise fonts
HSSFOptimiser.OptimiseFonts(wb);
Assert.AreEqual(5, wb.NumberOfFonts);
Assert.AreEqual(22, wb.NumCellStyles);
Assert.AreEqual(f, s.GetFont(wb));
// Optimise styles
HSSFOptimiser.OptimiseCellStyles(wb);
Assert.AreEqual(5, wb.NumberOfFonts);
Assert.AreEqual(22, wb.NumCellStyles);
Assert.AreEqual(f, s.GetFont(wb));
}
/// <summary>
/// Sets the value.
/// </summary>
/// <param name="rowPos">The row pos.</param>
/// <param name="columnPos">The column pos.</param>
/// <param name="value">The value.</param>
/// <param name="header">if set to <c>true</c> [header].</param>
public void SetValue(int rowPos, int columnPos, string value, bool header)
{
NPOI.SS.UserModel.Cell cell = GetCell(rowPos, columnPos);
if (value == null)
{
value = "";
}
//Setting value to the cell
cell.SetCellValue(value);
if (_headerStyle != null && _dataStyle != null)
{
if (header)
{
cell.RichStringCellValue.ApplyFont(_headerStyle.GetFont(_workbook));
}
else
{
cell.RichStringCellValue.ApplyFont(_dataStyle.GetFont(_workbook));
}
}
}
public void TestCloneStyleDiffWB()
{
HSSFWorkbook wbOrig = new HSSFWorkbook();
Font fnt = wbOrig.CreateFont();
fnt.FontName = ("TestingFont");
Assert.AreEqual(5, wbOrig.NumberOfFonts);
DataFormat fmt = wbOrig.CreateDataFormat();
fmt.GetFormat("MadeUpOne");
fmt.GetFormat("MadeUpTwo");
NPOI.SS.UserModel.CellStyle orig = wbOrig.CreateCellStyle();
orig.Alignment = (HorizontalAlignment.RIGHT);
orig.SetFont(fnt);
orig.DataFormat = (fmt.GetFormat("Test##"));
Assert.AreEqual(HorizontalAlignment.RIGHT, orig.Alignment);
Assert.AreEqual(fnt, orig.GetFont(wbOrig));
Assert.AreEqual(fmt.GetFormat("Test##"), orig.DataFormat);
// Now a style on another workbook
HSSFWorkbook wbClone = new HSSFWorkbook();
Assert.AreEqual(4, wbClone.NumberOfFonts);
DataFormat fmtClone = wbClone.CreateDataFormat();
NPOI.SS.UserModel.CellStyle clone = wbClone.CreateCellStyle();
Assert.AreEqual(4, wbClone.NumberOfFonts);
Assert.AreNotEqual(HorizontalAlignment.RIGHT, clone.Alignment);
Assert.AreNotEqual("TestingFont", clone.GetFont(wbClone).FontName);
clone.CloneStyleFrom(orig);
Assert.AreEqual(HorizontalAlignment.RIGHT, clone.Alignment);
Assert.AreEqual("TestingFont", clone.GetFont(wbClone).FontName);
Assert.AreEqual(fmtClone.GetFormat("Test##"), clone.DataFormat);
Assert.AreNotEqual(fmtClone.GetFormat("Test##"), fmt.GetFormat("Test##"));
Assert.AreEqual(5, wbClone.NumberOfFonts);
}