/// <summary>
/// Gets Conditional Formatting object at a particular index
/// @param index
/// of the Conditional Formatting object to fetch
/// </summary>
/// <param name="index">Conditional Formatting object</param>
/// <returns></returns>
public IConditionalFormatting GetConditionalFormattingAt(int index)
{
CFRecordsAggregate cf = _conditionalFormattingTable.Get(index);
if (cf == null)
{
return(null);
}
return(new HSSFConditionalFormatting(_sheet, cf));
}
private void GetChildren()
{
RecordAggregate record = (RecordAggregate)this.Record;
if (record is RowRecordsAggregate)
{
IEnumerator recordenum = ((RowRecordsAggregate)record).GetEnumerator();
while (recordenum.MoveNext())
{
if (recordenum.Current is RowRecord)
{
this.Nodes.Add(new RecordTreeNode((RowRecord)recordenum.Current));
}
}
CellValueRecordInterface[] valrecs = ((RowRecordsAggregate)record).GetValueRecords();
for (int j = 0; j < valrecs.Length; j++)
{
CellValueRecordTreeNode cvrtn = new CellValueRecordTreeNode(valrecs[j]);
if (valrecs[j] is FormulaRecordAggregate)
{
FormulaRecordAggregate fra = ((FormulaRecordAggregate)valrecs[j]);
cvrtn.ImageKey = "Folder";
if (fra.FormulaRecord != null)
{
cvrtn.Nodes.Add(new RecordTreeNode(fra.FormulaRecord));
}
if (fra.StringRecord != null)
{
cvrtn.Nodes.Add(new RecordTreeNode(fra.StringRecord));
}
}
this.Nodes.Add(cvrtn);
}
}
else if (record is ColumnInfoRecordsAggregate)
{
IEnumerator recordenum = ((ColumnInfoRecordsAggregate)record).GetEnumerator();
while (recordenum.MoveNext())
{
if (recordenum.Current is ColumnInfoRecord)
{
this.Nodes.Add(new RecordTreeNode((ColumnInfoRecord)recordenum.Current));
}
}
}
else if (record is PageSettingsBlock)
{
PageSettingsBlock psb = (PageSettingsBlock)record;
MockRecordVisitor rv = new MockRecordVisitor();
psb.VisitContainedRecords(rv);
foreach (Record rec in rv.Records)
{
this.Nodes.Add(new RecordTreeNode(rec));
}
}
else if (record is MergedCellsTable)
{
foreach (CellRangeAddress subRecord in ((MergedCellsTable)record).MergedRegions)
{
this.Nodes.Add(new CellRangeAddressTreeNode(subRecord));
}
}
else if (record is ConditionalFormattingTable)
{
ConditionalFormattingTable cft = (ConditionalFormattingTable)record;
for (int j = 0; j < cft.Count; j++)
{
CFRecordsAggregate cfra = cft.Get(j);
AbstractRecordTreeNode headernode = new RecordTreeNode(cfra.Header);
this.Nodes.Add(headernode);
for (int k = 0; k < cfra.NumberOfRules; k++)
{
this.Nodes.Add(new RecordTreeNode(cfra.GetRule(k)));
}
}
}
else if (record is WorksheetProtectionBlock)
{
WorksheetProtectionBlock wpb = (WorksheetProtectionBlock)record;
MockRecordVisitor rv = new MockRecordVisitor();
wpb.VisitContainedRecords(rv);
foreach (Record rec in rv.Records)
{
this.Nodes.Add(new RecordTreeNode(rec));
}
}
}