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

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

130
131
132
133
134
135
136
137
138
139
140
                        spreadsheet.addCell(executionLoad);
                    }
                    if (!shiftCourseLoad.equals(executionLoad)) {
                        if (isLargeDifference(shiftCourseLoad, executionLoad,
                                competenceCourseLoad.divide(new BigDecimal(14), 2, RoundingMode.HALF_EVEN))) {
                            spreadsheet.addCell(shiftCourseLoad, redStyle);
                        } else {
                            spreadsheet.addCell(shiftCourseLoad, yellowStyle);
                        }
                    } else {
                        spreadsheet.addCell(shiftCourseLoad);
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
                    if (!shiftCourseLoad.equals(executionLoad)) {
                        if (isLargeDifference(shiftCourseLoad, executionLoad,
                                competenceCourseLoad.divide(new BigDecimal(14), 2, RoundingMode.HALF_EVEN))) {
                            spreadsheet.addCell(shiftCourseLoad, redStyle);
                        } else {
                            spreadsheet.addCell(shiftCourseLoad, yellowStyle);
                        }
                    } else {
                        spreadsheet.addCell(shiftCourseLoad);
                    }
                    spreadsheet.addCell(shift.getAssociatedLessonsSet().size());
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
                            spreadsheet.addCell(shiftCourseLoad, redStyle);
                        } else {
                            spreadsheet.addCell(shiftCourseLoad, yellowStyle);
                        }
                    } else {
                        spreadsheet.addCell(shiftCourseLoad);
                    }
                    spreadsheet.addCell(shift.getAssociatedLessonsSet().size());
                    spreadsheet.addCell(getLessonInstanceCount(shift));
                }
            }
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
                            spreadsheet.addCell(shiftCourseLoad, yellowStyle);
                        }
                    } else {
                        spreadsheet.addCell(shiftCourseLoad);
                    }
                    spreadsheet.addCell(shift.getAssociatedLessonsSet().size());
                    spreadsheet.addCell(getLessonInstanceCount(shift));
                }
            }
        }
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
                        }
                    } else {
                        spreadsheet.addCell(shiftCourseLoad);
                    }
                    spreadsheet.addCell(shift.getAssociatedLessonsSet().size());
                    spreadsheet.addCell(getLessonInstanceCount(shift));
                }
            }
        }

        final HSSFSheet sheet = wb.getSheetAt(0);
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
        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 =
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.