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 = StartPoint; var questionNamesCollumns = NumberOfVersions; spreadsheetWriter .SetBorder(BorderStyle.Thin, BorderDirection.Bottom, Color.Black) .SetHorizontalAlignment(HorizontalAlignment.Center) .SetFontBold(true) .Write("Opgave"); for (int i = 0; i < questionNamesCollumns; i++) { spreadsheetWriter.MoveRight(); spreadsheetWriter.Write(string.Empty); } spreadsheetWriter .Write("Punten") .ResetStyling(); ScoresHeaderPosition = spreadsheetWriter.CurrentPosition; LastQuestionRow = PrintAssignments(spreadsheetWriter); }
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(); }