Free Support Forum - aspose.com

Problem with setting Column.Style.Custom

Aspose.Cells Product Family
#1

Hi,

I am using Aspose.Cells 4.4.2.1 with the following code:

worksheet.Cells.Columns[colIdx].Style.Custom = "dd/mm/yyyy";

The contents of the column remain in the default format.

I have also tried creating a style and applying it, like this:

Style style = worksheet.Workbook.Styles[worksheet.Workbook.Styles.Add()];

style.Custom = "dd/mm/yyyy";

StyleFlag flag = new StyleFlag();

worksheet.Cells.ApplyColumnStyle(colIdx, style, flag);

That doesn't work either, nor does worksheet.Cells.Columns[colIdx].ApplyStyle(...).

Thanks for your help.

#2

I had a similar problem last week, check http://www.aspose.com/community/forums/thread/123703/the-method-to-set-the-style-has-changed-again.aspx

#3

Hi,

Kindly try the latest version 4.4.3. http://www.aspose.com/community/files/51/file-format-components/aspose.cells/entry121851.aspx

I have tested it using the following sample code and it works fine.

Workbook wb = new Workbook();
Worksheet sheet = wb.Worksheets[0];
Style style;
StyleFlag flag;

style = wb.Styles[wb.Styles.Add()];
style.Custom = "dd/mm/yyyy";
flag = new StyleFlag();
flag.NumberFormat = true;

sheet.Cells.ApplyColumnStyle(0,style, flag);

wb.Save("d:\\test\\customcolumnstyle.xls");

Thank you.