We have to format Excel cells based on below conditions.
Value is Positive Number - We have to apply currency separator.
Value is Negative Number - We have to apply currency separator with brackets and red color
Value is Zero - We have to display dash (-)
Aspose.Cells.Range range = cells.CreateRange(0, 0, 10, 15);
Style stl = workbook.CreateStyle();
StyleFlag flg = new StyleFlag();
stl = worksheet.Workbook.CreateStyle();
stl.Font.Size = 11;
stl.Custom = “#,##0;(#,##0)”;
flg = new StyleFlag();
flg.Font = true;
flg.NumberFormat = true;
How to achieve above requirement?