/// <summary> /// Remove an assigned category from one of the sheet categories. /// </summary> /// <param name="categoryName"></param> public static Boolean RemoveSheetCategory(Sheet sheet, String categoryName) { Boolean returnValue = default(Boolean); CategoryItem categoryItem = default(CategoryItem); try { //User must select a Category Item. categoryItem = SelectCategoryItem(sheet, categoryName, "Select a Category Item to Remove from existing Sheet Cells. Note: Cells without selected Item will be permanently deleted.", 0, false); if (categoryItem != null) { _ValueChanging = true; //move it sheet.AssignCategory(categoryName, Category.SheetCategoryType.None, categoryItem); _ValueChanging = false; //refresh //Refresh(); returnValue = true; } } catch (Exception ex) { Log.Write(ex, MethodBase.GetCurrentMethod(), EventLogEntryType.Error); _ValueChanging = false; throw; } return(returnValue); }
/// <summary> /// Changed an assigned category to another sheet category. /// </summary> /// <param name="sheet"></param> /// <param name="category"></param> /// <param name="categoryType"></param> public static Boolean MoveSheetCategory(Sheet sheet, String categoryName, Category.SheetCategoryType categoryType) { Boolean returnValue = default(Boolean); try { _ValueChanging = true; //move it sheet.AssignCategory(categoryName, categoryType, (CategoryItem)null); _ValueChanging = false; //refresh //Refresh(); returnValue = true; } catch (Exception ex) { Log.Write(ex, MethodBase.GetCurrentMethod(), EventLogEntryType.Error); _ValueChanging = false; throw; } return(returnValue); }