Package pt.utl.ist.fenix.tools.util.excel

Examples of pt.utl.ist.fenix.tools.util.excel.StyledExcelSpreadsheet.addCell()

102
103
104
105
106
107
108
109
110
111
112
        for (final ExecutionCourse executionCourse : executionSemester.getAssociatedExecutionCoursesSet()) {
            for (final CourseLoad courseLoad : executionCourse.getCourseLoadsSet()) {
                for (final Shift shift : courseLoad.getShiftsSet()) {
                    spreadsheet.newRow();
                    spreadsheet.addCell(getDepartmentString(executionCourse));
                    spreadsheet.addCell(executionCourse.getDegreePresentationString());
                    spreadsheet.addCell(executionCourse.getName());
                    spreadsheet.addCell(shift.getNome());
                    spreadsheet.addCell(courseLoad.getType().getFullNameTipoAula());
                    final BigDecimal competenceCourseLoad =
                            new BigDecimal(getCompetenceCourseLoad(courseLoad)).setScale(2, RoundingMode.HALF_EVEN);
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
            for (final CourseLoad courseLoad : executionCourse.getCourseLoadsSet()) {
                for (final Shift shift : courseLoad.getShiftsSet()) {
                    spreadsheet.newRow();
                    spreadsheet.addCell(getDepartmentString(executionCourse));
                    spreadsheet.addCell(executionCourse.getDegreePresentationString());
                    spreadsheet.addCell(executionCourse.getName());
                    spreadsheet.addCell(shift.getNome());
                    spreadsheet.addCell(courseLoad.getType().getFullNameTipoAula());
                    final BigDecimal competenceCourseLoad =
                            new BigDecimal(getCompetenceCourseLoad(courseLoad)).setScale(2, RoundingMode.HALF_EVEN);
                    final BigDecimal curricularCourseLoad =
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
                for (final Shift shift : courseLoad.getShiftsSet()) {
                    spreadsheet.newRow();
                    spreadsheet.addCell(getDepartmentString(executionCourse));
                    spreadsheet.addCell(executionCourse.getDegreePresentationString());
                    spreadsheet.addCell(executionCourse.getName());
                    spreadsheet.addCell(shift.getNome());
                    spreadsheet.addCell(courseLoad.getType().getFullNameTipoAula());
                    final BigDecimal competenceCourseLoad =
                            new BigDecimal(getCompetenceCourseLoad(courseLoad)).setScale(2, RoundingMode.HALF_EVEN);
                    final BigDecimal curricularCourseLoad =
                            new BigDecimal(getCurricularCourseLoad(courseLoad)).setScale(2, RoundingMode.HALF_EVEN);
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
                    spreadsheet.newRow();
                    spreadsheet.addCell(getDepartmentString(executionCourse));
                    spreadsheet.addCell(executionCourse.getDegreePresentationString());
                    spreadsheet.addCell(executionCourse.getName());
                    spreadsheet.addCell(shift.getNome());
                    spreadsheet.addCell(courseLoad.getType().getFullNameTipoAula());
                    final BigDecimal competenceCourseLoad =
                            new BigDecimal(getCompetenceCourseLoad(courseLoad)).setScale(2, RoundingMode.HALF_EVEN);
                    final BigDecimal curricularCourseLoad =
                            new BigDecimal(getCurricularCourseLoad(courseLoad)).setScale(2, RoundingMode.HALF_EVEN);
                    final BigDecimal executionLoad = courseLoad.getTotalQuantity().setScale(2, RoundingMode.HALF_EVEN);
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
                    final BigDecimal curricularCourseLoad =
                            new BigDecimal(getCurricularCourseLoad(courseLoad)).setScale(2, RoundingMode.HALF_EVEN);
                    final BigDecimal executionLoad = courseLoad.getTotalQuantity().setScale(2, RoundingMode.HALF_EVEN);
                    final BigDecimal shiftCourseLoad = getShiftCourseLoad(shift).setScale(2, RoundingMode.HALF_EVEN);
                    if (competenceCourseLoad.signum() < 0) {
                        spreadsheet.addCell(getCompetenceCourseLoadStrings(courseLoad), redStyle);
                    } else {
                        spreadsheet.addCell(competenceCourseLoad);
                    }
                    if (!competenceCourseLoad.equals(curricularCourseLoad) || curricularCourseLoad.signum() < 0) {
                        spreadsheet.addCell(getCurricularCourseLoadString(courseLoad), redStyle);
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
                    final BigDecimal executionLoad = courseLoad.getTotalQuantity().setScale(2, RoundingMode.HALF_EVEN);
                    final BigDecimal shiftCourseLoad = getShiftCourseLoad(shift).setScale(2, RoundingMode.HALF_EVEN);
                    if (competenceCourseLoad.signum() < 0) {
                        spreadsheet.addCell(getCompetenceCourseLoadStrings(courseLoad), redStyle);
                    } else {
                        spreadsheet.addCell(competenceCourseLoad);
                    }
                    if (!competenceCourseLoad.equals(curricularCourseLoad) || curricularCourseLoad.signum() < 0) {
                        spreadsheet.addCell(getCurricularCourseLoadString(courseLoad), redStyle);
                    } else {
                        spreadsheet.addCell(curricularCourseLoad);
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
                        spreadsheet.addCell(getCompetenceCourseLoadStrings(courseLoad), redStyle);
                    } else {
                        spreadsheet.addCell(competenceCourseLoad);
                    }
                    if (!competenceCourseLoad.equals(curricularCourseLoad) || curricularCourseLoad.signum() < 0) {
                        spreadsheet.addCell(getCurricularCourseLoadString(courseLoad), redStyle);
                    } else {
                        spreadsheet.addCell(curricularCourseLoad);
                    }
                    if (!executionLoad.equals(curricularCourseLoad)) {
                        spreadsheet.addCell(executionLoad, redStyle);
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
                        spreadsheet.addCell(competenceCourseLoad);
                    }
                    if (!competenceCourseLoad.equals(curricularCourseLoad) || curricularCourseLoad.signum() < 0) {
                        spreadsheet.addCell(getCurricularCourseLoadString(courseLoad), redStyle);
                    } else {
                        spreadsheet.addCell(curricularCourseLoad);
                    }
                    if (!executionLoad.equals(curricularCourseLoad)) {
                        spreadsheet.addCell(executionLoad, redStyle);
                    } else {
                        spreadsheet.addCell(executionLoad);
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
                        spreadsheet.addCell(getCurricularCourseLoadString(courseLoad), redStyle);
                    } else {
                        spreadsheet.addCell(curricularCourseLoad);
                    }
                    if (!executionLoad.equals(curricularCourseLoad)) {
                        spreadsheet.addCell(executionLoad, redStyle);
                    } else {
                        spreadsheet.addCell(executionLoad);
                    }
                    if (!shiftCourseLoad.equals(executionLoad)) {
                        if (isLargeDifference(shiftCourseLoad, executionLoad,
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
                        spreadsheet.addCell(curricularCourseLoad);
                    }
                    if (!executionLoad.equals(curricularCourseLoad)) {
                        spreadsheet.addCell(executionLoad, redStyle);
                    } else {
                        spreadsheet.addCell(executionLoad);
                    }
                    if (!shiftCourseLoad.equals(executionLoad)) {
                        if (isLargeDifference(shiftCourseLoad, executionLoad,
                                competenceCourseLoad.divide(new BigDecimal(14), 2, RoundingMode.HALF_EVEN))) {
                            spreadsheet.addCell(shiftCourseLoad, redStyle);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.