public void Write(ISpreadsheetWriter spreadsheetWriter)
{
for (int index = HeaderRow; index < TotalRow; index++)
{
var y = index + 1;
for (int columnIndex = 1; columnIndex <= MostRightColumn; columnIndex++)
{
spreadsheetWriter.CurrentPosition = new Point(columnIndex, y);
spreadsheetWriter.SetHorizontalAlignment(HorizontalAlignment.Center);
if (AssignmentBottomRows.Contains(y))
{
spreadsheetWriter.SetBorder(BorderStyle.Thin, BorderDirection.Bottom, Color.Black);
}
spreadsheetWriter.ApplyStyling();
spreadsheetWriter.ResetStyling();
}
}
}
public void Write(ISpreadsheetWriter spreadsheetWriter)
{
spreadsheetWriter.CurrentPosition = StartPosition;
spreadsheetWriter
.SetFontBold(true)
.SetBorder(BorderStyle.Double, BorderDirection.Bottom, Color.Black)
.Write("Cijfer")
.SetFontBold(false);
int columnsBetweenFirstPoint = ScoresStartColumn - spreadsheetWriter.CurrentPosition.X;
for (int i = 0; i < columnsBetweenFirstPoint; i++)
{
spreadsheetWriter.MoveRight();
spreadsheetWriter.Write(string.Empty);
}
ICellRange maximumScoreCell = spreadsheetWriter.GetCellRange(MaximumScorePosition);
ICellRange standardizationFactorCell = spreadsheetWriter.GetCellRange(StandardizationFactorPosition);
ICellRange minimumGradeCell = spreadsheetWriter.GetCellRange(MinimumGradePosition);
const int maximumPointsColumn = 1;
int numberOfScoreColumns = NumberOfStudents + maximumPointsColumn;
spreadsheetWriter.SetFormat("0.0");
for (int columnIndex = 0; columnIndex < numberOfScoreColumns; columnIndex++)
{
var achievedScorePosition = new Point(spreadsheetWriter.CurrentPosition.X, AchievedScoresRow);
ICellRange achievedScoreCell = spreadsheetWriter.GetCellRange(achievedScorePosition);
spreadsheetWriter
.PlaceLessThanRule(5.5, Color.Red)
.PlaceCustomFormula(SetupGradeFormula(achievedScoreCell,
maximumScoreCell,
standardizationFactorCell,
minimumGradeCell))
.MoveRight();
}
spreadsheetWriter.ResetStyling();
}
