public override void VisitContainedRecords(RecordVisitor rv)
{
for (int i = 0; i < _cfHeaders.Count; i++)
{
CFRecordsAggregate subAgg = (CFRecordsAggregate)_cfHeaders[i];
subAgg.VisitContainedRecords(rv);
}
}
public ConditionalFormattingTable(RecordStream rs)
{
IList temp = new ArrayList();
while (rs.PeekNextClass() == typeof(CFHeaderRecord))
{
temp.Add(CFRecordsAggregate.CreateCFAggregate(rs));
}
_cfHeaders = temp;
}
public void UpdateFormulasAfterCellShift(FormulaShifter shifter, int externSheetIndex)
{
for (int i = 0; i < _cfHeaders.Count; i++)
{
CFRecordsAggregate subAgg = (CFRecordsAggregate)_cfHeaders[i];
bool shouldKeep = subAgg.UpdateFormulasAfterCellShift(shifter, externSheetIndex);
if (!shouldKeep)
{
_cfHeaders.RemoveAt(i);
i--;
}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="HSSFConditionalFormatting"/> class.
/// </summary>
/// <param name="workbook">The workbook.</param>
/// <param name="cfAggregate">The cf aggregate.</param>
public HSSFConditionalFormatting(HSSFWorkbook workbook, CFRecordsAggregate cfAggregate)
{
if (workbook == null)
{
throw new ArgumentException("workbook must not be null");
}
if (cfAggregate == null)
{
throw new ArgumentException("cfAggregate must not be null");
}
_workbook = workbook;
this.cfAggregate = cfAggregate;
}
/**
* @return index of the newly added CF header aggregate
*/
public int Add(CFRecordsAggregate cfAggregate)
{
_cfHeaders.Add(cfAggregate);
return(_cfHeaders.Count - 1);
}
/**
* @return index of the newly added CF header aggregate
*/
public int Add(CFRecordsAggregate cfAggregate)
{
_cfHeaders.Add(cfAggregate);
return _cfHeaders.Count - 1;
}
/// <summary>
/// Allows to Add a new Conditional Formatting Set to the sheet.
/// </summary>
/// <param name="regions">list of rectangular regions to apply conditional formatting rules</param>
/// <param name="cfRules">Set of up to three conditional formatting rules</param>
/// <returns>index of the newly Created Conditional Formatting object</returns>
public int AddConditionalFormatting(CellRangeAddress[] regions, IConditionalFormattingRule[] cfRules)
{
if (regions == null)
{
throw new ArgumentException("regions must not be null");
}
if (cfRules == null)
{
throw new ArgumentException("cfRules must not be null");
}
if (cfRules.Length == 0)
{
throw new ArgumentException("cfRules must not be empty");
}
if (cfRules.Length > 3)
{
throw new ArgumentException("Number of rules must not exceed 3");
}
CFRuleRecord[] rules = new CFRuleRecord[cfRules.Length];
for (int i = 0; i != cfRules.Length; i++)
{
rules[i] = ((HSSFConditionalFormattingRule)cfRules[i]).CfRuleRecord;
}
CFRecordsAggregate cfra = new CFRecordsAggregate(regions, rules);
return _conditionalFormattingTable.Add(cfra);
}