public void AssetFrd_GenerateReport_Inheritance_ColumnOrdinalsRemainInOrder()
{
var data = new List <AssetFrdDefinition>()
{
UnitTestHelper.GenerateRandomData <AssetFrdDefinition>(),
UnitTestHelper.GenerateRandomData <AssetFrdDefinition>(),
UnitTestHelper.GenerateRandomData <AssetFrdDefinition>(),
UnitTestHelper.GenerateRandomData <AssetFrdDefinition>(),
UnitTestHelper.GenerateRandomData <AssetFrdDefinition>()
};
var workbook = new Workbook();
workbook.Worksheets.Add();
var worksheet = workbook.Worksheets[0];
var generator = new WorksheetGenerator();
generator.GenerateFromDefinition(worksheet, data);
var cell = worksheet.Cells["F2"];
var style = cell.GetStyle();
Assert.AreEqual(ReportFormatValues.CurrencyFormat, style.Custom);
cell = worksheet.Cells["BY2"];
style = cell.GetStyle();
Assert.AreEqual(ReportFormatValues.CurrencyFormat, style.Custom);
//workbook.Save(@"C:\Temp\AssetFrd.xls", new XlsSaveOptions(SaveFormat.Excel97To2003));
}
public void ProjectOnOffChargeDefinition_WorksheetStyle_WorksheetRowWithValueExternal_InstanceIsInjectedAndExecuted()
{
var generator = new WorksheetGenerator();
generator.GenerateFromDefinition(this._worksheet, this._projectOnOffChargeDefinitions);
Assert.AreEqual("XXX", this._worksheet.Cells["A3"].Value);
}
public void ProjectOnOffChargeDefinition_WorksheetStyle_WorksheetRowSpansMultipleColumns_CellsAreMergedTogether()
{
var generator = new WorksheetGenerator();
generator.GenerateFromDefinition(this._worksheet, this._projectOnOffChargeDefinitions);
Assert.IsTrue(this._worksheet.Cells["G2"].IsMerged);
}
public void ProjectOnOffChargeDefinition_WorksheetStyle_WorksheetRowWithFormula_FormulaIsApplied()
{
var generator = new WorksheetGenerator();
generator.GenerateFromDefinition(this._worksheet, this._projectOnOffChargeDefinitions);
Assert.IsTrue(this._worksheet.Cells["B1"].IsFormula);
}
public void ProjectOnOffChargeDefinition_GenerateReport_DevelopmentAid_OutputToFile()
{
var generator = new WorksheetGenerator();
generator.GenerateFromDefinition(this._worksheet, this._projectOnOffChargeDefinitions);
//this._workbook.Save(@"C:\Temp\ProjectOnOffCharge.xls", new XlsSaveOptions(SaveFormat.Excel97To2003));
}
public void ProjectOnOffChargeDefinition_WorksheetStyle_WorksheetRowWithValueNoRow_AdditionalRowInsertedAtEnd()
{
var generator = new WorksheetGenerator();
generator.GenerateFromDefinition(this._worksheet, this._projectOnOffChargeDefinitions);
Assert.AreEqual("Extra", this._worksheet.Cells["A10"].Value);
}
public void ProjectOnOffChargeDefinition_WorksheetStyle_MultipleWorksheetRowForSameRow_RowsAreMergedTogether()
{
var generator = new WorksheetGenerator();
generator.GenerateFromDefinition(this._worksheet, this._projectOnOffChargeDefinitions);
Assert.AreEqual("FY 2011 - 2012", this._worksheet.Cells["G2"].Value);
Assert.AreEqual("FY 2012 - 2013", this._worksheet.Cells["S2"].Value);
}
public void ProjectOnOffChargeDefinition_WorksheetStyle_HeightApplied_RowHasHeightApplied()
{
var generator = new WorksheetGenerator();
generator.GenerateFromDefinition(this._worksheet, this._projectOnOffChargeDefinitions);
Assert.AreEqual(60.8D, this._worksheet.Cells.Rows[3].Height);
Assert.AreNotEqual(60.8D, this._worksheet.Cells.Rows[2].Height);
Assert.AreNotEqual(60.8D, this._worksheet.Cells.Rows[4].Height);
}
public void Initialize()
{
_worksheetExporter = new WorksheetGenerator();
_reportDefinitionData = new List <GenericReportDefinition>()
{
new GenericReportDefinition()
{
FirstName = "Walter",
LastName = "White",
OnList = false,
Salary = 23985.56m
},
new GenericReportDefinition()
{
FirstName = "Jessie",
LastName = "Pinkman",
OnList = false,
Salary = 1233985.56m,
VoluntaryContribution = 923.93m
},
new GenericReportDefinition()
{
FirstName = "Hank",
LastName = "Schrader",
OnList = false,
Salary = 53585.56m
}
};
_moreReportDefinitionData = new List <AnotherReportDefinition>()
{
new AnotherReportDefinition()
{
FirstName = "Walter",
LastName = "White",
OnList = false,
Salary = 23985.56m
},
new AnotherReportDefinition()
{
FirstName = "Jessie",
LastName = "Pinkman",
OnList = false,
Salary = 1233985.56m,
VoluntaryContribution = 923.93m
},
new AnotherReportDefinition()
{
FirstName = "Hank",
LastName = "Schrader",
OnList = false,
Salary = 53585.56m
}
};
}
public void ProjectOnOffChargeDefinition_WorksheetColumnHeaderStyle_HeaderHasRightBorder_CheckBorderTypeAndColorSet()
{
var generator = new WorksheetGenerator();
generator.GenerateFromDefinition(this._worksheet, this._projectOnOffChargeDefinitions);
var border = this._worksheet.Cells["C4"].GetStyle().Borders[BorderType.RightBorder];
Assert.AreEqual(CellBorderType.Thin, border.LineStyle);
Assert.AreEqual(ColorTranslator.FromHtml(ColorValues.Black).ToKnownColor(), border.Color.ToKnownColor());
}
