Hi,

I tried to set data format string (such as #,##0.00) using Style.Custom property but didn't work.

Here is my code:

Hi,

Thanks for considering Aspose.

Well, in the new Aspose.Cells versions, we put some work and optimized its performance. So, if you need to apply some style formattings a whole column / row, you should use Cells.ApplyColumnStyle / ApplyRowStyle() methods which we introduced recently.

Consult the following code for you need:

   Workbook wb = new Workbook();
   Worksheet sheet = wb.Worksheets[0];
   Style style;
   StyleFlag flag;
   style = sheet.Cells.Columns[0].Style;  
   //Or add a new style like the following.
   //style = wb.Styles[wb.Styles.Add()];    
   style.Custom = "#,##0";
   flag = new StyleFlag();
   flag.NumberFormat = true;
   sheet.Cells.ApplyColumnStyle(0,style, flag);
   wb.Save("d:\\test\\style_column.xls");

Thank you.

Please try following code:

StyleFlag numberFormatFlag = new StyleFlag();

numberFormatFlag.NumberFormat = true;

 NumericColumnStyle.Custom = "#,##0";

cells.Columns[iPos].ApplyStyle(NumericColumnStyle, numberFormatFlag);