https://bz.apache.org/bugzilla/show_bug.cgi?id=63463
--- Comment #2 from David Gauntt <dmgau...@uab.edu> --- I ran into this problem a while back, developed a workaround, and forgot to submit a bug report. My workaround is listed below; I will submit a patch sometime in the next week or two. sheet.shiftRows(nFirstRow, nLastRow, nNumToShift); if (bApplyBugFix) { for (int nRow = nFirstDstRow; nRow <= nLastDstRow; ++nRow) { final XSSFRow row = sheet.getRow(nRow); if (row != null) { String msg = "Row[rownum=" + row.getRowNum() + "] contains cell(s) included in a multi-cell array formula. " + "You cannot change part of an array."; for (Cell c : row) { ((XSSFCell) c).updateCellReferencesForShifting(msg); } } } } -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org