NPOI setting different cell format

Viewed 31612

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

so output should be like this 12345 -> 12 345; 425 -> 425; 41,2 -> 41,2; 4578,25 -> 4 578,25

        short doubleFormat = hssfOutputWorkBook.CreateDataFormat().GetFormat("#,##0.###");
        short intFormat = hssfOutputWorkBook.CreateDataFormat().GetFormat("#,##0");
        for (i = 0; i <= 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;
                    }}}}
1 Answers
Related