title: NPOI setting different cell format
body: <p>i have problem setting different format in each cell, i want to set number format to thousand separator and thousand separator with 3 decimals, when number is not integer, here is my code, i think problem look like each cell format is set by last fomat setting in for cycle</p>
  
  <p>so output should be like this
  12345 -> 12 345; 425 -> 425; 41,2 -> 41,2; 4578,25 -> 4 578,25</p>
  
  <pre><code>        short doubleFormat = hssfOutputWorkBook.CreateDataFormat().GetFormat("#,##0.###");
          short intFormat = hssfOutputWorkBook.CreateDataFormat().GetFormat("#,##0");
          for (i = 0; i &lt;= unorderedSheet.LastRowNum; i++)
          {
              NPOI.SS.UserModel.IRow newRow = orderedSheet.CreateRow(i);
              NPOI.SS.UserModel.IRow oldRow = unorderedSheet.GetRow(i);
              if (oldRow != null)
              {
                  foreach (ICell oldCell in oldRow.Cells)
                  {
                      ICell newCell = newRow.CreateCell(mapping[n]);
                      switch (oldCell.CellType)
                      { 
                          case CellType.NUMERIC:
                              newCell.SetCellType(CellType.NUMERIC);
                              newCell.SetCellValue(oldCell.NumericCellValue);
                              if (numberHasDecimals(oldCell.NumericCellValue))
                              {
                                  newCell.CellStyle.DataFormat = doubleFormat;
                              }
                              else
                              {
                                  newCell.CellStyle.DataFormat = intFormat;                
                              }
                              break;
                          default:
                              newCell.SetCellValue(oldCell.ToString());
                              break;
                      }}}}
  </code></pre>