private void Spreadsheet_WorkbookLoaded(object sender, Syncfusion.UI.Xaml.Spreadsheet.Helpers.WorkbookLoadedEventArgs args)
{
foreach (var sheet in args.GridCollection)
{
sheet.FillSeriesController.AllowFillSeries = false;
}
}
private void Spreadsheet_WorkbookLoaded(object sender, Syncfusion.UI.Xaml.Spreadsheet.Helpers.WorkbookLoadedEventArgs args)
{
foreach (var sheet in args.GridCollection)
{
if (sheet.Worksheet.AutoFilters.FilterRange != null)
{
sheet.Worksheet.AutoFilters.FilterRange = null;
}
}
}
//To freeze 5 rows and 3 columns.
private void SpreadSheetControl_WorkbookLoaded(object sender, Syncfusion.UI.Xaml.Spreadsheet.Helpers.WorkbookLoadedEventArgs args)
{
//To maintain the freeze state in saved work sheet.
spreadSheetControl.Workbook.ActiveSheet.Range[5, 3].FreezePanes();
//To freeze the rows and columns in the view
var gridModel = spreadSheetControl.ActiveGrid;
gridModel.FrozenColumns = 3;
gridModel.FrozenRows = 5;
}
private void AssociatedObject_WorkbookLoaded(object sender, Syncfusion.UI.Xaml.Spreadsheet.Helpers.WorkbookLoadedEventArgs args)
{
foreach (var grid in args.GridCollection)
{
grid.CreateGridColumn = CreateSpreadsheetColumnExt;
var renderer = new SpreadsheetTemplateCellRenderer();
grid.CellRenderers.Add("ArrowTemplate", renderer);
grid.QueryRange += Grid_QueryRange;
AssociatedObject.SetRowColumnHeadersVisibility(false);
}
AssociatedObject.Protect(true, true, "");
AssociatedObject.ProtectSheet(AssociatedObject.ActiveSheet, "", Syncfusion.XlsIO.ExcelSheetProtection.None);
}
