public void Write(ISpreadsheetWriter spreadsheetWriter)
{
spreadsheetWriter.CurrentPosition = StartPosition;
var scoresStartPosition = new Point(StartOfStudentsColumn, AchievedScoresRow);
var scoresEndPosition = new Point(StartOfStudentsColumn + NumberOfStudents, AchievedScoresRow);
spreadsheetWriter
.SetFontBold(true)
.Write("Gemiddelde aantal punten")
.SetFontBold(false)
.MoveRight()
.PlaceStandardFormula(scoresStartPosition, scoresEndPosition, FormulaType.AVERAGE)
.NewLine();
var gradesStartPosition = new Point(StartOfStudentsColumn, GradesRow);
var gradesEndPosition = new Point(StartOfStudentsColumn + NumberOfStudents, GradesRow);
spreadsheetWriter
.SetFontBold(true)
.Write("Gemiddelde cijfer")
.SetFontBold(false)
.MoveRight()
.PlaceStandardFormula(gradesStartPosition, gradesEndPosition, FormulaType.AVERAGE);
}
public void Write(ISpreadsheetWriter spreadsheetWriter)
{
spreadsheetWriter.CurrentPosition = StartPoint;
spreadsheetWriter
.SetFontBold(true)
.SetBorder(BorderStyle.Double, BorderDirection.Bottom, Color.Black)
.Write("Totaal")
.SetFontBold(false);
int columnsBetweenFirstPoint = ScoreTopPoint.X - spreadsheetWriter.CurrentPosition.X;
for (int i = 0; i < columnsBetweenFirstPoint; i++)
{
spreadsheetWriter.MoveRight();
spreadsheetWriter.Write(string.Empty);
}
const int maximumPointsColumn = 1;
int numberOfScoreColumns = NumberOfStudents + maximumPointsColumn;
for (int columnIndex = 0; columnIndex < numberOfScoreColumns; columnIndex++)
{
var startPosition = new Point(spreadsheetWriter.CurrentPosition.X, ScoreTopPoint.Y);
var lastQuestionRowOffset = 1;
var endPosition = new Point(spreadsheetWriter.CurrentPosition.X, spreadsheetWriter.CurrentPosition.Y - lastQuestionRowOffset);
spreadsheetWriter
.PlaceStandardFormula(startPosition, endPosition, FormulaType.SUM)
.MoveRight();
}
}
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();
}
public void Write(ISpreadsheetWriter spreadsheetWriter)
{
spreadsheetWriter.CurrentPosition = StartPoint;
spreadsheetWriter
.SetFontBold(true)
.Write("Configuratie");
spreadsheetWriter
.NewLine()
.Write("Normering")
.SetFontBold(false)
.MoveRight()
.Write(StandardizationFactor.Value);
StandardizationfactorPosition = spreadsheetWriter.CurrentPosition;
spreadsheetWriter
.NewLine()
.SetFontBold(true)
.Write("Minimale cijfer")
.SetFontBold(false)
.MoveRight()
.Write(MinimumGrade.Value);
MinimumGradePosition = spreadsheetWriter.CurrentPosition;
}
