Hi,
I am using Aspose.Cells latest version to create the output of a report and saving it as pdf and serve to the client. However, I need to use solid borders for all data cells instead of the dashed borders (which is default when printgridlines is true).
I have tried the below, which lets me change the color and thickness, but borders are always dashed:
Aspose.Cells.Range range = workbook.Worksheets[0].Cells.CreateRange(0, 0, workbook.Worksheets[0].Cells.MaxDataRow, workbook.Worksheets[0].Cells.MaxDataColumn);
Aspose.Cells.Style style = range[0, 0].GetStyle();
style.SetBorder(Aspose.Cells.BorderType.BottomBorder, Aspose.Cells.CellBorderType.Hair, System.Drawing.Color.Blue);
style.SetBorder(Aspose.Cells.BorderType.TopBorder, Aspose.Cells.CellBorderType.Hair, System.Drawing.Color.Blue);
style.SetBorder(Aspose.Cells.BorderType.LeftBorder, Aspose.Cells.CellBorderType.Hair, System.Drawing.Color.Blue);
style.SetBorder(Aspose.Cells.BorderType.RightBorder, Aspose.Cells.CellBorderType.Hair, System.Drawing.Color.Blue);
range.SetStyle(style);
Please advise on how can I simple mimic selecting a range of cells in MS Excel and choosing "all borders" option.
Thanks.