https://bz.apache.org/bugzilla/show_bug.cgi?id=63463

--- Comment #3 from David Gauntt <dmgau...@uab.edu> ---
Oops!  Left a couple of lines out of my workaround

  sheet.shiftRows(nFirstRow, nLastRow, nNumToShift);
  if (bApplyBugFix) {
   final int nFirstDstRow = nFirstRow + nNumToShift;
   final int nLastDstRow = nLastRow + nNumToShift;

   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

Reply via email to