Created attachment 32424 [details]
XSSF some nonblank cells reporting as blank

My code just exports the Attributes tab of the attached spreadsheet.

The problematic cells are:

Attribute Master tab

Row 16 

Columns N and P (values 500 and 10) reported as blank.


There are some others

When I open the XLS in LibreOffice, the affected rows are SLIGHTLY thicker vertically than others. Strange.

code:

  public List<String[]> extractList(XSSFSheet tab, Integer columnWidthLimit, boolean padToWidth, boolean skipHeaderRow)
  {
    List<String[]> rows = new ArrayList<>();
    Iterator<Row> rowIterator = tab.iterator();

    boolean first = true;
    while (rowIterator.hasNext())
    {
      if (skipHeaderRow && first)
      {
        first = false;
        continue;
      }

      Row row = rowIterator.next();
      Iterator<Cell> cellIterator = row.cellIterator();
      int cellCount = 0;
      List<String> rowData = new ArrayList<>();
      while (cellIterator.hasNext())
      {
        if (columnWidthLimit != null && cellCount >= columnWidthLimit)
        {
          break;
        }
        Cell cell = cellIterator.next();
        if (cellCount == 5)
        {
          System.out.println("" + rowData.get(4));
        }
        if (cellCount > 5)
        {
          System.out.print("::" + cellCount + "::" + cell.getCellType() + "::");
        }
        switch (cell.getCellType())
        {
          case Cell.CELL_TYPE_BOOLEAN:
            rowData.add("" + cell.getBooleanCellValue());
            break;
          case Cell.CELL_TYPE_NUMERIC:
            rowData.add("" + cell.getNumericCellValue());
            break;
          case Cell.CELL_TYPE_STRING:
            rowData.add("" + cell.getStringCellValue());
            break;
          case Cell.CELL_TYPE_BLANK:
            rowData.add("");
            break;
          case Cell.CELL_TYPE_FORMULA:
            rowData.add("#FORMULA");
            break;
          case Cell.CELL_TYPE_ERROR:
            rowData.add("#ERROR");
            break;
          default:
            rowData.add("#UNKNOWN");
            break;
        }
        if (cellCount > 5)
        {
          System.out.println(rowData.get(rowData.size() - 1));
        }

        cellCount++;
      }
      if (padToWidth && columnWidthLimit != null)
      {
        if (cellCount < columnWidthLimit)
        {
          for (int i = cellCount; i < columnWidthLimit; i++)
          {
            rowData.add("");
          }
        }
      }
      rows.add(rowData.toArray(new String[rowData.size()]));
    }
    return rows;
  }
}