- 이슈 임포트 시 cell null 이중체크

이민희

2022-02-08 079da7d7e3c08c4c38898d508b7568b5e451f5b3

 src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java

@@ -3481,7 +3481,7 @@
            if (cellType < Cell.CELL_TYPE_BLANK) {
                if (cellType == Cell.CELL_TYPE_STRING)
                {
                    if (cell.getStringCellValue() != null) {
                    if (cell.getStringCellValue() != null && !cell.getStringCellValue().equals("")) {
                        return false;
                    }
                } else {
@@ -3491,9 +3491,6 @@
        }
        return true;
    }




    //  엑셀 필드에 있는 정보를 이슈 form 으로 옮긴다.
    private IssueForm setIssueFormToExcelField(Row row, int rowIndex, Map<String, Priority> priorityMaps,
@@ -3508,17 +3505,21 @@
        //  제목, 내용, 프로젝트 키, 이슈 타입, 우선순위, 중요도, 담당자, 시작일, 종료일, 사용자 정의 필드
        for (int cellIndex = 0; cellIndex < headers.size(); cellIndex++) {
            Cell cell = row.getCell(cellIndex);
            boolean isNull = cellNullCheck(cell);

            boolean isNull = true;
            String cellStr = "";

            if (!isNull) {
                cellStr = CommonUtil.convertExcelStringToCell(cell);
            if (cell != null) {
                isNull = cellNullCheck(cell);

                //  공백 제거
                cell.setCellValue(cellStr.trim());
            } else {
                cell.setCellValue(cellStr);
                if (!isNull) {
                    cellStr = CommonUtil.convertExcelStringToCell(cell);

                    //  공백 제거
                    cell.setCellValue(cellStr.trim());
                } else {
                    cell.setCellValue(cellStr);
                }
            }

            switch (cellIndex) {