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); }