Cumulative formatting

Aspose.Cells Product Family
1

Is it possible to do cumulative formatting? For example, I want to individually format various cell font colours, then want the whole column to be bold AS WELL by applying a style to the column range. This seems to nullify all the individual cells’ formats and apply ONLY the bold for the column. Is there any way around this?

2

Please set whole column first then set individual cells.

Excel excel = new Excel();
Cells cells = excel.Worksheets[0].Cells;

cells.Columns[0].Style.Font.IsBold = true;

cells[0, 0].PutValue("hello");
cells[0, 0].Style.Font.Color = Color.Red;

cells[1, 0].PutValue("world");
cells[1, 0].Style.Font.Color = Color.Blue;