public override object ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, object value)
{
if (value is string)
{
FormatBase result = null;
string className = (string)value;
switch (className)
{
case "Boolean":
result = new BooleanFormat();
break;
case "Currency":
result = new CurrencyFormat();
break;
case "Custom":
result = new CustomFormat();
break;
case "Date":
result = new DateFormat();
break;
case "General":
result = new GeneralFormat();
break;
case "Number":
result = new NumberFormat();
break;
case "Percent":
result = new PercentFormat();
break;
case "Time":
result = new TimeFormat();
break;
}
return(result);
}
return(base.ConvertFrom(context, culture, value));
}
public void ApplyFormat(IXLCell cell, object column, bool formatWithEuros = false)
{
BooleanFormat booleanFormat = new BooleanFormat();
booleanFormat.SetFormat(cell, column, _configurationDataFormat);
NumericFormat numericaFormat = new NumericFormat();
if (formatWithEuros)
{
_configurationDataFormat.NumericFormat = "0.00 €";
}
else
{
_configurationDataFormat.NumericFormat = "0.00";
}
numericaFormat.SetFormat(cell, column, _configurationDataFormat);
DateTimeFormat datetimeFormat = new DateTimeFormat();
datetimeFormat.SetFormat(cell, column, _configurationDataFormat);
TextFormat textFormat = new TextFormat();
textFormat.SetFormat(cell, column, _configurationDataFormat);
}
/// <summary>
/// Converts the boolean value of this instance to a string.
/// </summary>
/// <param name="booleanFormat">A BooleanFormat value.
/// Example: BooleanFormat.PassFail would return "Pass" if true and "Fail" if false.</param>
/// <returns>Boolean formatted string</returns>
public static string ToString(this bool value, BooleanFormat booleanFormat)
{
string booleanFormatString = Enum.GetName(booleanFormat.GetType(), booleanFormat);
return ParseBooleanString(value, booleanFormatString);
}
public BooleanFormatAttribute(BooleanFormat format) : base() => Format = format;
/*
* <propertyDescription name="Microsoft.SDKSample.DirectoryLevel" formatID="{581CF603-2925-4acf-BB5A-3D3EB39EACD3}" propID="3">
* <description>Number of directory levels to this item.</description>
* <searchInfo inInvertedIndex="false" isColumn="false,
* <typeInfo canStackBy="false" type="Int32"/>
* <labelInfo label="Directory Level"/>
* </propertyDescription>
*/
internal XmlElement GetXmlPropertyDescription(XmlDocument doc)
{
var desc = doc.CreateElement("propertyDescription");
desc.SetAttribute("name", CanonicalName);
desc.SetAttribute("formatID", FormatId.ToString("B").ToUpper());
desc.SetAttribute("propID", PropertyId.ToString());
var search = doc.CreateElement("searchInfo");
search.SetAttribute("inInvertedIndex", InInvertedIndex.ToString());
if (IsColumn)
{
search.SetAttribute("isColumn", IsColumn.ToString());
search.SetAttribute("isColumnSparse", IsColumnSparse.ToString());
search.SetAttribute("columnIndexType", ColumnIndexType.ToString());
}
if (MaxSize != 512)
{
search.SetAttribute("maxSize", MaxSize.ToString());
}
if (Mnemonics != null && Mnemonics.Length > 0)
{
search.SetAttribute("mnemonics", Mnemonics);
}
desc.AppendChild(search);
var label = doc.CreateElement("labelInfo");
label.SetAttribute("label", DisplayName);
label.SetAttribute("sortDescription", SortDescription.ToString());
if (EditInvitation != null && EditInvitation.Length > 0)
{
label.SetAttribute("invitationText", EditInvitation);
}
if (HideLabel)
{
label.SetAttribute("hideLabel", HideLabel.ToString());
}
desc.AppendChild(label);
var type = doc.CreateElement("typeInfo");
type.SetAttribute("type", Type.ToString());
if (GroupingRange != PropertyGroupingRange.Discrete)
{
type.SetAttribute("groupingRange", GroupingRange.ToString());
}
if (IsInnate)
{
type.SetAttribute("isInnate", IsInnate.ToString());
}
if (IsInnate && CanBePurged)
{
type.SetAttribute("canBePurged", CanBePurged.ToString());
}
//if (MultipleValues)
type.SetAttribute("multipleValues", MultipleValues.ToString());
if (IsGroup)
{
type.SetAttribute("isGroup", IsGroup.ToString());
}
if (AggregationType != PropertyAggregationType.Default)
{
type.SetAttribute("aggregationType", AggregationType.ToString());
}
if (IsTreeProperty)
{
type.SetAttribute("isTreeProperty", IsTreeProperty.ToString());
}
if (IsViewable)
{
type.SetAttribute("isViewable", IsViewable.ToString());
}
if (SearchRawValue)
{
type.SetAttribute("searchRawValue", SearchRawValue.ToString());
}
if (ConditionType != PropertyConditionType.String)
{
type.SetAttribute("conditionType", ConditionType.ToString());
}
if (ConditionOperation != ConditionOperationConfigured.Equal)
{
type.SetAttribute("defaultOperation", ConditionOperation.ToString());
}
desc.AppendChild(type);
var display = doc.CreateElement("displayInfo");
display.SetAttribute("displayType", DisplayType.ToString());
if (DisplayType == PropertyDisplayType.String && StringFormat != StringFormat.General)
{
var format = doc.CreateElement("stringFormat");
format.SetAttribute("formatAs", StringFormat.ToString());
display.AppendChild(format);
}
if (DisplayType == PropertyDisplayType.Boolean && BooleanFormat != BooleanFormat.YesNo)
{
var format = doc.CreateElement("booleanFormat");
format.SetAttribute("formatAs", BooleanFormat.ToString());
display.AppendChild(format);
}
if (DisplayType == PropertyDisplayType.Number && NumberFormat != NumberFormat.General)
{
var format = doc.CreateElement("numberFormat");
format.SetAttribute("formatAs", NumberFormat.ToString());
display.AppendChild(format);
}
if (DisplayType == PropertyDisplayType.DateTime && DateTimeFormat != DateTimeFormat.General)
{
var format = doc.CreateElement("dateTimeFormat");
format.SetAttribute("formatAs", DateTimeFormat.ToString());
display.AppendChild(format);
}
if (DefaultColumnWidth != 20)
{
display.SetAttribute("defaultColumnWidth", DefaultColumnWidth.ToString());
}
if (Alignment != PropertyAlignmentType.Left)
{
display.SetAttribute("alignment", Alignment.ToString());
}
//if (RelativeDescriptionType != RelativeDescriptionType.General)
// display.SetAttribute("relativeDescriptionType", RelativeDescriptionType.ToString());
if (DefaultSortDirection != SortDirection.Ascending)
{
display.SetAttribute("defaultSortDirection", DefaultSortDirection.ToString());
}
if (EditControl != EditControl.Default)
{
var edit = doc.CreateElement("editControl");
edit.SetAttribute("control", EditControl.ToString());
display.AppendChild(edit);
}
desc.AppendChild(display);
return(desc);
}
