/** * Adds a copy of HSSFConditionalFormatting object to the sheet * <p>This method could be used to copy HSSFConditionalFormatting object * from one sheet to another. For example: * <pre> * HSSFConditionalFormatting cf = sheet.GetConditionalFormattingAt(index); * newSheet.AddConditionalFormatting(cf); * </pre> * * @param cf HSSFConditionalFormatting object * @return index of the new Conditional Formatting object */ public int AddConditionalFormatting(IConditionalFormatting cf) { XSSFConditionalFormatting xcf = (XSSFConditionalFormatting)cf; CT_Worksheet sh = _sheet.GetCTWorksheet(); sh.AddNewConditionalFormatting().Set(xcf.GetCTConditionalFormatting());//this is already copied in Set -> .Copy()); ommitted return(sh.SizeOfConditionalFormattingArray() - 1); }
public int AddConditionalFormatting(IConditionalFormatting cf) { XSSFConditionalFormatting conditionalFormatting = (XSSFConditionalFormatting)cf; CT_Worksheet ctWorksheet = this._sheet.GetCTWorksheet(); ctWorksheet.AddNewConditionalFormatting().Set(conditionalFormatting.GetCTConditionalFormatting()); return(ctWorksheet.SizeOfConditionalFormattingArray() - 1); }