internal void FromConditionalFormattingValueObject(X14.ConditionalFormattingValueObject cfvo)
{
this.SetAllNull();
if (cfvo.Formula != null)
{
this.Formula = cfvo.Formula.Text;
}
this.Type = cfvo.Type.Value;
if (cfvo.GreaterThanOrEqual != null)
{
this.GreaterThanOrEqual = cfvo.GreaterThanOrEqual.Value;
}
}
internal X14.ConditionalFormattingValueObject ToConditionalFormattingValueObject()
{
X14.ConditionalFormattingValueObject cfvo = new X14.ConditionalFormattingValueObject();
if (this.Formula.Length > 0)
{
if (this.Formula.StartsWith("="))
{
cfvo.Formula = new Excel.Formula(this.Formula.Substring(1));
}
else
{
cfvo.Formula = new Excel.Formula(this.Formula);
}
}
cfvo.Type = this.Type;
if (!this.GreaterThanOrEqual) cfvo.GreaterThanOrEqual = this.GreaterThanOrEqual;
return cfvo;
}
internal X14.ConditionalFormattingValueObject ToConditionalFormattingValueObject()
{
X14.ConditionalFormattingValueObject cfvo = new X14.ConditionalFormattingValueObject();
if (this.Formula.Length > 0)
{
if (this.Formula.StartsWith("="))
{
cfvo.Formula = new Excel.Formula(this.Formula.Substring(1));
}
else
{
cfvo.Formula = new Excel.Formula(this.Formula);
}
}
cfvo.Type = this.Type;
if (!this.GreaterThanOrEqual)
{
cfvo.GreaterThanOrEqual = this.GreaterThanOrEqual;
}
return(cfvo);
}
public override void WriteOpenXml(OpenXmlWriter writer)
{
X14.ConditionalFormatting cf = new X14.ConditionalFormatting();
cf.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");
ReferenceSequence referenceSequence = new ReferenceSequence();
referenceSequence.Text = $"{SpreadsheetHelper.ExcelColumnFromNumber(RangeStart.ColumnIndex)}{RangeStart.RowIndex}:{SpreadsheetHelper.ExcelColumnFromNumber(RangeEnd.ColumnIndex)}{RangeEnd.RowIndex}";
X14.ConditionalFormattingRule conditionalFormattingRule = new X14.ConditionalFormattingRule()
{
Type = ConditionalFormatValues.IconSet, Priority = 1, Id = Guid.NewGuid().ToString("B").ToUpper()
};
X14.IconSet iconSet1 = new X14.IconSet()
{
IconSetTypes = new EnumValue <IconSetTypeValues>(IconSetTypeValues.FourTrafficLights), ShowValue = false, Custom = true
};
//ConditionalFormattingIcon
var conditionalFormattingIcon1 = new X14.ConditionalFormattingIcon()
{
IconSet = X14.IconSetTypeValues.NoIcons, IconId = (UInt32Value)0U
};
var conditionalFormattingIcon2 = new X14.ConditionalFormattingIcon()
{
IconSet = X14.IconSetTypeValues.ThreeSymbols2, IconId = (UInt32Value)2U
};
var conditionalFormattingIcon3 = new X14.ConditionalFormattingIcon()
{
IconSet = X14.IconSetTypeValues.ThreeSymbols, IconId = (UInt32Value)1U
};
var conditionalFormattingIcon4 = new X14.ConditionalFormattingIcon()
{
IconSet = X14.IconSetTypeValues.ThreeSymbols, IconId = (UInt32Value)0U
};
X14.ConditionalFormattingValueObject conditionalFormattingValueObject1 = new X14.ConditionalFormattingValueObject()
{
Type = X14.ConditionalFormattingValueObjectTypeValues.Numeric
};
Formula formula1 = new Formula();
formula1.Text = "0";
conditionalFormattingValueObject1.Append(formula1);
X14.ConditionalFormattingValueObject conditionalFormattingValueObject2 = new X14.ConditionalFormattingValueObject()
{
Type = X14.ConditionalFormattingValueObjectTypeValues.Numeric
};
Formula formula2 = new Formula();
formula2.Text = "1";
conditionalFormattingValueObject2.Append(formula2);
X14.ConditionalFormattingValueObject conditionalFormattingValueObject3 = new X14.ConditionalFormattingValueObject()
{
Type = X14.ConditionalFormattingValueObjectTypeValues.Numeric
};
Formula formula3 = new Formula();
formula3.Text = "2";
conditionalFormattingValueObject3.Append(formula3);
X14.ConditionalFormattingValueObject conditionalFormattingValueObject4 = new X14.ConditionalFormattingValueObject()
{
Type = X14.ConditionalFormattingValueObjectTypeValues.Numeric
};
Formula formula4 = new Formula();
formula4.Text = "3";
conditionalFormattingValueObject4.Append(formula4);
iconSet1.Append(
conditionalFormattingValueObject1
, conditionalFormattingValueObject2
, conditionalFormattingValueObject3
, conditionalFormattingValueObject4
, conditionalFormattingIcon1
, conditionalFormattingIcon2
, conditionalFormattingIcon3
, conditionalFormattingIcon4
);
conditionalFormattingRule.Append(iconSet1);
cf.Append(conditionalFormattingRule);
cf.Append(referenceSequence);
writer.WriteElement(cf);
}
