title: How to get more than 255 columns in an excel sheet using Apache POI 3.6
body: <p>I'm creating a calendar in excel. Column 1 is 01.01.2010 (dd.MM.yyyy), Column 2 is 02.01.2010 and so on. </p>
  
  <p>This is my code:</p>
  
  <pre><code>int day_cell = 0;
  
  for(int i = 0; i &lt; days.size(); i++)
  {
       Date day = days.get(i);
  
       HSSFCell cell = row.createCell(day_cell++);
       cell.setCellValue(day.toString());
  }
  </code></pre>
  
  <p>When I get to column 256 POI throws this exception:</p>
  
  <pre><code>java.lang.IllegalArgumentException: Invalid column index (256).  Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
  at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:926)
  at org.apache.poi.hssf.usermodel.HSSFCell.&lt;init&gt;(HSSFCell.java:162)
  at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:141)
  at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:119)
  </code></pre>
  
  <p>I found this bug-report suggesting it was fixed in the 3.6 release. We were using 3.5 but changing to 3.6 doesn't seem to do any good. Anyone got any tips?</p>
  
  <p><a href="https://issues.apache.org/bugzilla/show_bug.cgi?id=46806" rel="noreferrer">https://issues.apache.org/bugzilla/show_bug.cgi?id=46806</a></p>
  
  <p>Edit: Seems like the bug-issue was about formulas..</p>