internal IconSet ToIconSet()
{
IconSet ics = new IconSet();
if (this.IconSetType != SLIconSetValues.ThreeTrafficLights1)
{
ics.IconSetValue = SLIconSet.TranslateInternalSetToIconSet(this.IconSetType);
}
if (!this.ShowValue)
{
ics.ShowValue = this.ShowValue;
}
if (!this.Percent)
{
ics.Percent = this.Percent;
}
if (this.Reverse)
{
ics.Reverse = this.Reverse;
}
foreach (SLConditionalFormatValueObject cfvo in this.Cfvos)
{
ics.Append(cfvo.ToConditionalFormatValueObject());
}
return(ics);
}
public ConditionalFormattingRule Convert(IXLConditionalFormat cf, Int32 priority, XLWorkbook.SaveContext context)
{
var conditionalFormattingRule = new ConditionalFormattingRule { Type = cf.ConditionalFormatType.ToOpenXml(), Priority = priority };
var iconSet = new IconSet {ShowValue = !cf.ShowIconOnly, Reverse = cf.ReverseIconOrder, IconSetValue = cf.IconSetStyle.ToOpenXml()};
Int32 count = cf.Values.Count;
for(Int32 i=1;i<= count; i++ )
{
var conditionalFormatValueObject = new ConditionalFormatValueObject { Type = cf.ContentTypes[i].ToOpenXml(), Val = cf.Values[i].Value, GreaterThanOrEqual = cf.IconSetOperators[i] == XLCFIconSetOperator.EqualOrGreaterThan};
iconSet.Append(conditionalFormatValueObject);
}
conditionalFormattingRule.Append(iconSet);
return conditionalFormattingRule;
}
internal IconSet ToIconSet()
{
IconSet ics = new IconSet();
if (this.IconSetValue != IconSetValues.ThreeTrafficLights1) ics.IconSetValue = this.IconSetValue;
if (!this.ShowValue) ics.ShowValue = this.ShowValue;
if (!this.Percent) ics.Percent = this.Percent;
if (this.Reverse) ics.Reverse = this.Reverse;
foreach (SLConditionalFormatValueObject cfvo in this.Cfvos)
{
ics.Append(cfvo.ToConditionalFormatValueObject());
}
return ics;
}
public ConditionalFormattingRule Convert(IXLConditionalFormat cf, Int32 priority, XLWorkbook.SaveContext context)
{
var conditionalFormattingRule = XLCFBaseConverter.Convert(cf, priority);
var iconSet = new IconSet {
ShowValue = !cf.ShowIconOnly, Reverse = cf.ReverseIconOrder, IconSetValue = cf.IconSetStyle.ToOpenXml()
};
Int32 count = cf.Values.Count;
for (Int32 i = 1; i <= count; i++)
{
var conditionalFormatValueObject = new ConditionalFormatValueObject {
Type = cf.ContentTypes[i].ToOpenXml(), Val = cf.Values[i].Value, GreaterThanOrEqual = cf.IconSetOperators[i] == XLCFIconSetOperator.EqualOrGreaterThan
};
iconSet.Append(conditionalFormatValueObject);
}
conditionalFormattingRule.Append(iconSet);
return(conditionalFormattingRule);
}