internal SLConditionalFormatAutoMinMaxValues TranslateToAutoMinMaxValues(ConditionalFormatValueObjectValues Type)
{
SLConditionalFormatAutoMinMaxValues result = SLConditionalFormatAutoMinMaxValues.Percentile;
switch (Type)
{
case ConditionalFormatValueObjectValues.Formula:
result = SLConditionalFormatAutoMinMaxValues.Formula;
break;
case ConditionalFormatValueObjectValues.Max:
result = SLConditionalFormatAutoMinMaxValues.Value;
break;
case ConditionalFormatValueObjectValues.Min:
result = SLConditionalFormatAutoMinMaxValues.Value;
break;
case ConditionalFormatValueObjectValues.Number:
result = SLConditionalFormatAutoMinMaxValues.Number;
break;
case ConditionalFormatValueObjectValues.Percent:
result = SLConditionalFormatAutoMinMaxValues.Percent;
break;
case ConditionalFormatValueObjectValues.Percentile:
result = SLConditionalFormatAutoMinMaxValues.Percentile;
break;
}
return(result);
}
internal SLConditionalFormatAutoMinMaxValues TranslateToAutoMinMaxValues(ConditionalFormatValueObjectValues Type)
{
SLConditionalFormatAutoMinMaxValues result = SLConditionalFormatAutoMinMaxValues.Percentile;
switch (Type)
{
case ConditionalFormatValueObjectValues.Formula:
result = SLConditionalFormatAutoMinMaxValues.Formula;
break;
case ConditionalFormatValueObjectValues.Max:
result = SLConditionalFormatAutoMinMaxValues.Value;
break;
case ConditionalFormatValueObjectValues.Min:
result = SLConditionalFormatAutoMinMaxValues.Value;
break;
case ConditionalFormatValueObjectValues.Number:
result = SLConditionalFormatAutoMinMaxValues.Number;
break;
case ConditionalFormatValueObjectValues.Percent:
result = SLConditionalFormatAutoMinMaxValues.Percent;
break;
case ConditionalFormatValueObjectValues.Percentile:
result = SLConditionalFormatAutoMinMaxValues.Percentile;
break;
}
return result;
}
private ConditionalFormatValueObject GetConditionalFormatValueObjectByIndex(IXLConditionalFormat cf, int index, ConditionalFormatValueObjectValues defaultType)
{
var conditionalFormatValueObject = new ConditionalFormatValueObject();
if (cf.ContentTypes.TryGetValue(index, out var contentType))
{
conditionalFormatValueObject.Type = contentType.ToOpenXml();
}
else
{
conditionalFormatValueObject.Type = defaultType;
}
if (cf.Values.TryGetValue(index, out var value1) && value1?.Value != null)
{
conditionalFormatValueObject.Val = value1.Value;
}
return(conditionalFormatValueObject);
}
