How to set thinner Grid lines in spreadsheets like Excel?
By default, GridLines look thicker in SpreadsheetControl than MS Excel. However when you want to change that into thinner grid lines, like MS Excel, then you can set the UseGuidelineSetToRenderBorder property of GridControl to “True”. You can get the GridControl from spreadsheet by subscribing the WorkbookLoaded and WorkSheetAdded events of SpreadsheetControl like the following code snippet.
WorkbookLoaded Event:
C#
this.spreadSheetControl.WorkBookLoaded += spreadSheetControl_WorkBookLoaded;
void spreadSheetControl_WorkBookLoaded(object sender, WorkbookLoadedEventArgs args)
{
foreach (var grid in args.GridCollection)
{
grid.UseGuidelineSetToRenderBorder = true;
}
}
WorkSheetAdded Event:
C#
this.spreadSheetControl.WorkSheetAdded += spreadSheetControl_WorkSheetAdded;
void spreadSheetControl_WorkSheetAdded(object sender, WorkSheetAddedEventArgs args)
{
var grid = this.spreadSheetControl.GridProperties.ActiveSpreadsheetGrid;
grid.UseGuidelineSetToRenderBorder = true;
}
Conclusion
I hope you enjoyed learning about how to set thinner Grid lines in spreadsheets like Excel.
You can refer to our WPF Spreadsheet feature tour
page to know about its
other groundbreaking feature representations. You can also explore our
WPF Spreadsheet documentation
to understand how to create and
manipulate data.
For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls.
If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!
