internal ForegroundColor ToForegroundColor()
{
ForegroundColor clr = new ForegroundColor();
if (this.Auto != null)
{
clr.Auto = this.Auto.Value;
}
if (this.Indexed != null)
{
clr.Indexed = this.Indexed.Value;
}
if (this.Rgb != null)
{
clr.Rgb = new HexBinaryValue(this.Rgb);
}
if (this.Theme != null)
{
clr.Theme = this.Theme.Value;
}
if (this.Tint != null && this.Tint.Value != 0.0)
{
clr.Tint = this.Tint.Value;
}
return(clr);
}
public void CanConvertXLColorToColorType()
{
var xlColor1 = XLColor.Red;
var xlColor2 = XLColor.FromIndex(20);
var xlColor3 = XLColor.FromTheme(XLThemeColor.Accent1);
var xlColor4 = XLColor.FromTheme(XLThemeColor.Accent2, 0.4);
var color1 = new ForegroundColor().FromClosedXMLColor <ForegroundColor>(xlColor1);
var color2 = new ForegroundColor().FromClosedXMLColor <ForegroundColor>(xlColor2);
var color3 = new BackgroundColor().FromClosedXMLColor <BackgroundColor>(xlColor3);
var color4 = new BackgroundColor().FromClosedXMLColor <BackgroundColor>(xlColor4);
Assert.AreEqual("FFFF0000", color1.Rgb.Value);
Assert.IsNull(color1.Indexed);
Assert.IsNull(color1.Theme);
Assert.IsNull(color1.Tint);
Assert.IsNull(color2.Rgb);
Assert.AreEqual(20, color2.Indexed.Value);
Assert.IsNull(color2.Theme);
Assert.IsNull(color2.Tint);
Assert.IsNull(color3.Rgb);
Assert.IsNull(color3.Indexed);
Assert.AreEqual(4, color3.Theme.Value);
Assert.IsNull(color3.Tint);
Assert.IsNull(color4.Rgb);
Assert.IsNull(color4.Indexed);
Assert.AreEqual(5, color4.Theme.Value);
Assert.AreEqual(0.4, color4.Tint.Value);
}
internal ForegroundColor ToForegroundColor()
{
var clr = new ForegroundColor();
if (Auto != null)
{
clr.Auto = Auto.Value;
}
if (Indexed != null)
{
clr.Indexed = Indexed.Value;
}
if (Rgb != null)
{
clr.Rgb = new HexBinaryValue(Rgb);
}
if (Theme != null)
{
clr.Theme = Theme.Value;
}
if ((Tint != null) && (Tint.Value != 0.0))
{
clr.Tint = Tint.Value;
}
return(clr);
}
internal void FromForegroundColor(ForegroundColor clr)
{
SetAllNull();
if (clr.Auto != null)
{
Auto = clr.Auto.Value;
}
if (clr.Indexed != null)
{
Indexed = clr.Indexed.Value;
}
if (clr.Rgb != null)
{
Rgb = clr.Rgb.Value;
}
if (clr.Theme != null)
{
Theme = clr.Theme.Value;
}
if (clr.Tint != null)
{
Tint = clr.Tint.Value;
}
SetDisplayColor();
}
public void Save()
{
var configuration = GetSettingsDtoForSave();
if (configuration == null)
{
return;
}
using (new SecurityDisabler())
{
configuration.Edit(
p =>
{
configuration[LastScriptSettingFieldName] = HttpUtility.HtmlEncode(LastScript);
((CheckboxField)configuration.Fields[SaveLastScriptSettingFieldName]).Checked = SaveLastScript;
((CheckboxField)configuration.Fields[LiveAutocompletionSettingFieldName]).Checked = LiveAutocompletion;
configuration[HostWidthSettingFieldName] = HostWidth.ToString(CultureInfo.InvariantCulture);
configuration[ForegroundColorSettingFieldName] = ForegroundColor.ToString();
configuration[BackgroundColorSettingFieldName] = BackgroundColor.ToString();
configuration[FontSizeSettingFieldName] = FontSize.ToString();
configuration[FontFamilySettingFieldName] = FontFamily;
if (IsPersonalized)
{
configuration.Fields[FieldIDs.DisplayName].Reset();
}
});
}
}
public static bool Save()
{
bool returnValue;
try
{
using (RegistryKey registryKey = OpenRegistryKey())
{
registryKey.SetValue(BACKGROUND_COLOR, BackgroundColor.ToArgb(), RegistryValueKind.DWord);
registryKey.SetValue(BACKGROUND_IMAGE, BackgroundImage, RegistryValueKind.String);
registryKey.SetValue(BORDER_COLOR, BorderColor.ToArgb(), RegistryValueKind.DWord);
registryKey.SetValue(FADE_DELAY, FadeDelay, RegistryValueKind.DWord);
registryKey.SetValue(FADESPEED, FadeSpeed, RegistryValueKind.DWord);
registryKey.SetValue(FOREGROUND_COLOR, ForegroundColor.ToArgb(), RegistryValueKind.DWord);
registryKey.SetValue(MAXIMUM_CACHE_ITEMS, MaximumCacheItems, RegistryValueKind.DWord);
registryKey.SetValue(RANDOM_VERSE, RandomVerse.ToString(), RegistryValueKind.String);
registryKey.SetValue(TEXT_FONT, TextFont.ToStringEx());
registryKey.SetValue(TITLE_FONT, TitleFont.ToStringEx());
registryKey.Close();
}
returnValue = true;
}
catch (Exception e)
{
Logging.LogException(e);
returnValue = false;
}
return(returnValue);
}
public void Fill(Point point)
{
Color regionColor = _img.GetPixel(point.X, point.Y);
if ((point.X == 0 || _img.GetPixel(point.X - 1, point.Y).ToArgb() == ForegroundColor.ToArgb()) &&
(point.Y == 0 || _img.GetPixel(point.X, point.Y - 1).ToArgb() == ForegroundColor.ToArgb()) &&
(point.X == _img.Width - 1 || _img.GetPixel(point.X + 1, point.Y).ToArgb() == ForegroundColor.ToArgb()) &&
(point.Y == _img.Height - 1 || _img.GetPixel(point.X, point.Y + 1).ToArgb() == ForegroundColor.ToArgb()))
{
return;
}
int[,] flags = new int[_img.Width, _img.Height];
Fill(point, regionColor, flags);
for (int y = 0; y < _img.Height; y++)
{
for (int x = 0; x < _img.Width; x++)
{
if (flags[x, y] > 0)
{
_img.SetPixel(x, y, ForegroundColor);
}
}
}
this.Invalidate();
}
/// <summary>
/// Create a new fill
/// </summary>
/// <param name="fillColorRgb">The foreground color of the fill</param>
/// <param name="pattern">The fill pattern</param>
/// <returns></returns>
public static Fill CreateFill(string fillColorRgb, PatternValues?pattern = null)
{
PatternFill patternFill = new PatternFill();
if (!string.IsNullOrEmpty(fillColorRgb))
{
patternFill.PatternType = pattern ?? PatternValues.Solid;
ForegroundColor foregroundColor = new ForegroundColor()
{
Rgb = fillColorRgb
};
BackgroundColor backgroundColor = new BackgroundColor()
{
Indexed = (UInt32Value)64U
};
patternFill.Append(foregroundColor);
patternFill.Append(backgroundColor);
}
else
{
patternFill.PatternType = pattern ?? PatternValues.None;
}
return(new Fill(patternFill));
}
private static UInt32Value CreateFill(Stylesheet templateSheetobj, string colorCode)
{
PatternFill patternFill = new PatternFill()
{
PatternType = PatternValues.Solid
};
ForegroundColor fgColor = new ForegroundColor()
{
Rgb = colorCode
};
BackgroundColor bgBolor = new BackgroundColor()
{
Indexed = (UInt32Value)64U
};
patternFill.Append(fgColor);
patternFill.Append(bgBolor);
Fill fill = new Fill(patternFill);
templateSheetobj.Fills.Append(fill);
UInt32Value result = templateSheetobj.Fills.Count;
templateSheetobj.Fills.Count++;
return(result);
}
private void SetTextStyle(TextView view)
{
if (view.Handle == IntPtr.Zero)
{
return;
}
if (Font.Size > 0)
{
view.SetTextSize(ComplexUnitType.Sp, (float)Font.Size);
}
if (!string.IsNullOrEmpty(Font.Name))
{
var format = (Android.Graphics.TypefaceStyle)Font.Formatting;
view.SetTypeface(Android.Graphics.Typeface.Create(Font.Name, format), format);
}
if (!ForegroundColor.IsDefaultColor)
{
view.SetTextColor(ForegroundColor.ToColor());
}
if (!BackgroundColor.IsDefaultColor)
{
view.SetBackgroundColor(BackgroundColor.ToColor());
}
}
protected void DrawHintAndInput()
{
if (!Experiment.Config.Gui.InputBarVisibility)
{
return;
}
/* Draw Hint */
if (HintText != null)
{
SharedBrush.Color = new Color(ForegroundColor.ToVector3(), 0.7F);
RenderTarget.DrawText(HintText, InputTextFormat, new RawRectangleF(10, 0, Width - 10, InputBoxHeight / 2),
SharedBrush, D2D1.DrawTextOptions.None);
}
/* Draw user input text */
if (InputTextLayout != null)
{
var rect = HintText == null
? new RawRectangleF(10, 5, Width - 10, InputBoxHeight - 5)
: new RawRectangleF(10, InputBoxHeight / 2, Width - 10, InputBoxHeight);
InputTextLayout.MaxWidth = rect.Right - rect.Left;
InputTextLayout.MaxHeight = rect.Bottom - rect.Top;
InputTextLayout.Draw(_customColorRenderer, rect.Left, rect.Top);
}
/* Draw Input Box Bottom Line */
SharedBrush.Color = ForegroundColor;
RenderTarget.DrawLine(new RawVector2(10, InputBoxHeight + 2), new RawVector2(Width - 10, InputBoxHeight + 2), SharedBrush, 2);
}
private PSStyle()
{
Formatting = new FormattingData();
Progress = new ProgressConfiguration();
Foreground = new ForegroundColor();
Background = new BackgroundColor();
}
public static Fills GenerateFills()
{
Fills fills1 = new Fills()
{
Count = (UInt32Value)3U
};
Fill fill1 = new Fill();
PatternFill patternFill1 = new PatternFill()
{
PatternType = PatternValues.None
};
fill1.Append(patternFill1);
Fill fill2 = new Fill();
PatternFill patternFill2 = new PatternFill()
{
PatternType = PatternValues.Gray125
};
fill2.Append(patternFill2);
Fill fill3 = new Fill();
PatternFill patternFill3 = new PatternFill()
{
PatternType = PatternValues.Solid
};
ForegroundColor foregroundColor1 = new ForegroundColor() /*Theme = (UInt32Value)0U, Tint = -0.14999847407452621D*/ Rgb
{
} // IsEqual
private int ComputeHashCode()
{
var hash = ForegroundColor.GetHashCode();
hash = HashTool.AddHashCode(hash, BackgroundColor);
hash = HashTool.AddHashCode(hash, FontFamily);
hash = HashTool.AddHashCode(hash, FontSize);
return(hash);
} // ComputeHashCode
public void ConvertBackThrowsException()
{
// Arrange
var conv = new ForegroundColor();
// Act
// Assert
ExceptionAssert.Throws <NotSupportedException>(() => conv.ConvertBack(null, null, null, null));
}
/// <summary>
/// Creates a duplicate of the current value.
/// </summary>
/// <returns>The cloned value.</returns>
/// <remarks>This method is a deep copy clone.</remarks>
public object Clone()
{
var clone = (OpenExcelFill)MemberwiseClone();
clone.PatternType = (EnumValue <PatternValues>)PatternType?.Clone();
clone.ForegroundColor = (ForegroundColor)ForegroundColor?.Clone();
clone.BackgroundColor = (BackgroundColor)BackgroundColor?.Clone();
return(clone);
}
/// <summary>
/// persist settings to registry
/// </summary>
public void Save()
{
// Create or get existing Registry subkey
RegistryKey key = Registry.CurrentUser.CreateSubKey("SOFTWARE\\todoscreensaver");
key.SetValue("file", DataPath);
key.SetValue("close_mode", (int)ScreensaverCloseMode);
key.SetValue("background_color", BackgroundColor.ToString());
key.SetValue("foreground_color", ForegroundColor.ToString());
}
private UInt32Value SetCellStyle(System.Drawing.Color fillColor, bool locked)
{
Fill fill = new Fill();
PatternFill patternFill = new PatternFill()
{
PatternType = PatternValues.Solid
};
ForegroundColor foregroundColor1 = new ForegroundColor()
{
Rgb = System.Drawing.Color.FromArgb(fillColor.A, fillColor.R, fillColor.G, fillColor.B).Name
};
BackgroundColor backgroundColor1 = new BackgroundColor()
{
Indexed = (UInt32Value)64U
};
patternFill.Append(foregroundColor1);
patternFill.Append(backgroundColor1);
fill.Append(patternFill);
ExcelStyleSheet.Fills.Count++;
ExcelStyleSheet.Fills.Append(fill);
CellFormat myCellFormat =
new CellFormat
{
FontId = (UInt32Value)0U,
FillId = (UInt32Value)ExcelStyleSheet.Fills.Count - 1,
ApplyFill = true,
NumberFormatId = (UInt32Value)0U,
FormatId = (UInt32Value)0U,
BorderId = (UInt32Value)1U,
ApplyBorder = true,
ApplyProtection = true
};
Alignment alignment = new Alignment()
{
WrapText = true
};
myCellFormat.Append(alignment);
if (!locked)
{
Protection protection = new Protection()
{
Locked = false
};
myCellFormat.Append(protection);
}
ExcelStyleSheet.CellFormats.Count++;
ExcelStyleSheet.CellFormats.Append(myCellFormat);
return((UInt32Value)ExcelStyleSheet.CellFormats.Count - 1);
}
public void ConvertInvalidValueResultsInUnset()
{
// Arrange
var conv = new ForegroundColor();
// Act
object converted = conv.Convert(123, null, null, null);
// Assert
Assert.AreEqual(DependencyProperty.UnsetValue, converted);
}
public int CompareTo(ConsolePlusTheme other)
{
int foreCompare = BackgroundColor.CompareTo(other.BackgroundColor);
if (foreCompare != 0)
{
return(foreCompare);
}
return(ForegroundColor.CompareTo(other.ForegroundColor));
}
private static ForegroundColor CreateForegroundColor(System.Drawing.Color color)
{
var ligthGrayForegroundColor = new ForegroundColor
{
Rgb = new HexBinaryValue {
Value = color.ToHexValue()
}
};
return(ligthGrayForegroundColor);
}
/// <summary>
/// Returns a hash code for this instance.
/// </summary>
/// <returns>
/// A hash code for this instance, suitable for use in hashing algorithms and data structures like a hash table.
/// </returns>
public override int GetHashCode()
{
unchecked
{
int hash = 17;
hash = hash * 23 + Char.GetHashCode();
hash = hash * 23 + ForegroundColor.GetHashCode();
hash = hash * 23 + BackgroundColor.GetHashCode();
return(hash);
}
}
public override int GetHashCode()
{
int hash = Text?.GetHashCode() ?? -1;
hash ^= BackgroundColor.GetHashCode();
hash ^= ForegroundColor.GetHashCode();
hash ^= FontAttributes.GetHashCode();
hash ^= FontSize.GetHashCode();
hash ^= Command?.GetHashCode() ?? -1;
hash ^= CommandParameter?.GetHashCode() ?? -1;
return(hash);
}
/// <summary>
/// Computes the hash code for this object.
/// </summary>
/// <returns>The hash code.</returns>
public override int GetHashCode()
{
// Overflow is fine, just wrap
unchecked
{
var hash = 17;
hash = (hash * 23) + Content.GetHashCode();
hash = (hash * 23) + ForegroundColor.GetHashCode();
hash = (hash * 23) + BackgroundColor.GetHashCode();
return(hash);
}
}
public virtual void SaveToFile(BinaryWriter stream)
{
//Program.WriteLine(" * Saving {0} {1}...", this.GetType(), ID ?? "????");
Toolkit.SaveExpectation(stream, "ENTT");
stream.Write(ID ?? "<Null>");
stream.Write((char)Glyph);
BackgroundColor.SaveToFile(stream);
ForegroundColor.SaveToFile(stream);
stream.Write((byte)XPosition);
stream.Write((byte)YPosition);
stream.Write((byte)0); //was Flow
stream.Write(Blocking);
}
public override int GetHashCode()
{
unchecked
{
int hash = 17;
hash = hash * 23 + PatternType.GetHashCode();
hash = hash * 23 + ForegroundColor?.GetHashCode() ?? 0;
hash = hash * 23 + BackgroundColor?.GetHashCode() ?? 0;
return(hash);
}
}
/// <summary>
/// Compare to
/// </summary>
/// <param name="other">Other</param>
/// <returns>Comparison result</returns>
public int CompareTo(BufferCell other)
{
int ret = Character.CompareTo(other.Character);
if (ret == 0)
{
ret = ForegroundColor.CompareTo(other.ForegroundColor);
if (ret == 0)
{
ret = BackgroundColor.CompareTo(other.BackgroundColor);
}
}
return(ret);
}
public void RedBackgroundResultsInWhiteColor()
{
// Arrange
var conv = new ForegroundColor();
// Act
object color = conv.Convert("ff0000", null, null, null);
// Assert
SolidColorBrush brush = color as SolidColorBrush;
Assert.IsNotNull(brush);
Assert.AreEqual(Colors.White, brush.Color);
}
public void LightGrayResultsInBlack()
{
// Arrange
var conv = new ForegroundColor();
// Act
object color = conv.Convert("cccccc", null, null, null);
// Assert
SolidColorBrush brush = color as SolidColorBrush;
Assert.IsNotNull(brush);
Assert.AreEqual(Colors.Black, brush.Color);
}
public void AppendRtf(StringBuilder r, Dictionary <int, int> colorTable, Dictionary <string, int> fontTable)
{
var a = false;
if (FontName != null && FontName.Length > 0)
{
var ci = fontTable[FontName];
r.AppendFormat(@"\f{0}", ci);
a = true;
}
if (FontSize > 1)
{
r.AppendFormat(@"\fs{0}", (int)(2 * FontSize + 0.5f));
a = true;
}
if (ForegroundColor != null)
{
var ci = colorTable[ForegroundColor.ToArgb()];
r.AppendFormat(@"\cf{0}", ci);
a = true;
}
if (BackgroundColor != null)
{
var ci = colorTable[BackgroundColor.ToArgb()];
r.AppendFormat(@"\highlight{0}", ci);
a = true;
}
if (UnderlineStyle != UnderlineStyle.None)
{
var ci = colorTable[UnderlineColor.ToArgb()];
r.AppendFormat(@"\ulc{0}\ulwave", ci);
a = true;
}
if (!string.IsNullOrEmpty(Link))
{
//r.AppendFormat (@"{{{{\field{{\*\fldinst{{HYPERLINK ""{0}"" }}}}{{\fldrslt{{\ul ", Link.Replace ('\"', ' '));
r.Append(@"\ul");
a = true;
}
if (a)
{
r.Append(' ');
}
}
// Generates content of workbookStyles.
private void GenerateWorkbookStylesContent(WorkbookStylesPart workbookStyles)
{
Stylesheet stylesheet1 = new Stylesheet(){ MCAttributes = new MarkupCompatibilityAttributes(){ Ignorable = "x14ac" } };
stylesheet1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
stylesheet1.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
NumberingFormats numberingFormats1 = new NumberingFormats(){ Count = (UInt32Value)1U };
NumberingFormat numberingFormat1 = new NumberingFormat(){ NumberFormatId = (UInt32Value)43U, FormatCode = "_(* #,##0.00_);_(* \\(#,##0.00\\);_(* \"-\"??_);_(@_)" };
numberingFormats1.Append(numberingFormat1);
Fonts fonts1 = new Fonts(){ Count = (UInt32Value)4U, KnownFonts = true };
Font font1 = new Font();
FontSize fontSize1 = new FontSize(){ Val = 11D };
Color color1 = new Color(){ Theme = (UInt32Value)1U };
FontName fontName1 = new FontName(){ Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering(){ Val = 2 };
FontScheme fontScheme1 = new FontScheme(){ Val = FontSchemeValues.Minor };
font1.Append(fontSize1);
font1.Append(color1);
font1.Append(fontName1);
font1.Append(fontFamilyNumbering1);
font1.Append(fontScheme1);
Font font2 = new Font();
Bold bold1 = new Bold();
FontSize fontSize2 = new FontSize(){ Val = 11D };
Color color2 = new Color(){ Theme = (UInt32Value)1U };
FontName fontName2 = new FontName(){ Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering2 = new FontFamilyNumbering(){ Val = 2 };
FontScheme fontScheme2 = new FontScheme(){ Val = FontSchemeValues.Minor };
font2.Append(bold1);
font2.Append(fontSize2);
font2.Append(color2);
font2.Append(fontName2);
font2.Append(fontFamilyNumbering2);
font2.Append(fontScheme2);
Font font3 = new Font();
Bold bold2 = new Bold();
Italic italic1 = new Italic();
FontSize fontSize3 = new FontSize(){ Val = 11D };
Color color3 = new Color(){ Rgb = "FFFF0000" };
FontName fontName3 = new FontName(){ Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering3 = new FontFamilyNumbering(){ Val = 2 };
FontScheme fontScheme3 = new FontScheme(){ Val = FontSchemeValues.Minor };
font3.Append(bold2);
font3.Append(italic1);
font3.Append(fontSize3);
font3.Append(color3);
font3.Append(fontName3);
font3.Append(fontFamilyNumbering3);
font3.Append(fontScheme3);
Font font4 = new Font();
Italic italic2 = new Italic();
FontSize fontSize4 = new FontSize(){ Val = 11D };
Color color4 = new Color(){ Rgb = "FFFF0000" };
FontName fontName4 = new FontName(){ Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering4 = new FontFamilyNumbering(){ Val = 2 };
FontScheme fontScheme4 = new FontScheme(){ Val = FontSchemeValues.Minor };
font4.Append(italic2);
font4.Append(fontSize4);
font4.Append(color4);
font4.Append(fontName4);
font4.Append(fontFamilyNumbering4);
font4.Append(fontScheme4);
fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);
Fills fills1 = new Fills(){ Count = (UInt32Value)4U };
Fill fill1 = new Fill();
PatternFill patternFill1 = new PatternFill(){ PatternType = PatternValues.None };
fill1.Append(patternFill1);
Fill fill2 = new Fill();
PatternFill patternFill2 = new PatternFill(){ PatternType = PatternValues.Gray125 };
fill2.Append(patternFill2);
Fill fill3 = new Fill();
PatternFill patternFill3 = new PatternFill(){ PatternType = PatternValues.Solid };
ForegroundColor foregroundColor1 = new ForegroundColor(){ Theme = (UInt32Value)0U, Tint = -4.9989318521683403E-2D };
BackgroundColor backgroundColor1 = new BackgroundColor(){ Indexed = (UInt32Value)64U };
patternFill3.Append(foregroundColor1);
patternFill3.Append(backgroundColor1);
fill3.Append(patternFill3);
Fill fill4 = new Fill();
PatternFill patternFill4 = new PatternFill(){ PatternType = PatternValues.Solid };
ForegroundColor foregroundColor2 = new ForegroundColor(){ Rgb = "FFFFFFCC" };
BackgroundColor backgroundColor2 = new BackgroundColor(){ Indexed = (UInt32Value)64U };
patternFill4.Append(foregroundColor2);
patternFill4.Append(backgroundColor2);
fill4.Append(patternFill4);
fills1.Append(fill1);
fills1.Append(fill2);
fills1.Append(fill3);
fills1.Append(fill4);
Borders borders1 = new Borders(){ Count = (UInt32Value)2U };
Border border1 = new Border();
LeftBorder leftBorder1 = new LeftBorder();
RightBorder rightBorder1 = new RightBorder();
TopBorder topBorder1 = new TopBorder();
BottomBorder bottomBorder1 = new BottomBorder();
DiagonalBorder diagonalBorder1 = new DiagonalBorder();
border1.Append(leftBorder1);
border1.Append(rightBorder1);
border1.Append(topBorder1);
border1.Append(bottomBorder1);
border1.Append(diagonalBorder1);
Border border2 = new Border();
LeftBorder leftBorder2 = new LeftBorder();
RightBorder rightBorder2 = new RightBorder();
TopBorder topBorder2 = new TopBorder(){ Style = BorderStyleValues.Thin };
Color color5 = new Color(){ Indexed = (UInt32Value)64U };
topBorder2.Append(color5);
BottomBorder bottomBorder2 = new BottomBorder();
DiagonalBorder diagonalBorder2 = new DiagonalBorder();
border2.Append(leftBorder2);
border2.Append(rightBorder2);
border2.Append(topBorder2);
border2.Append(bottomBorder2);
border2.Append(diagonalBorder2);
borders1.Append(border1);
borders1.Append(border2);
CellStyleFormats cellStyleFormats1 = new CellStyleFormats(){ Count = (UInt32Value)1U };
CellFormat cellFormat1 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U };
cellStyleFormats1.Append(cellFormat1);
CellFormats cellFormats1 = new CellFormats(){ Count = (UInt32Value)16U };
CellFormat cellFormat2 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U };
CellFormat cellFormat3 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true };
Alignment alignment1 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center };
cellFormat3.Append(alignment1);
CellFormat cellFormat4 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true };
CellFormat cellFormat5 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true };
Alignment alignment2 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Left };
cellFormat5.Append(alignment2);
CellFormat cellFormat6 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true };
Alignment alignment3 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center };
cellFormat6.Append(alignment3);
CellFormat cellFormat7 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true };
Alignment alignment4 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center };
cellFormat7.Append(alignment4);
CellFormat cellFormat8 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true };
Alignment alignment5 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Right };
cellFormat8.Append(alignment5);
CellFormat cellFormat9 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true };
Alignment alignment6 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Left };
cellFormat9.Append(alignment6);
CellFormat cellFormat10 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true };
Alignment alignment7 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center };
cellFormat10.Append(alignment7);
CellFormat cellFormat11 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyAlignment = true };
Alignment alignment8 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center };
cellFormat11.Append(alignment8);
CellFormat cellFormat12 = new CellFormat(){ NumberFormatId = (UInt32Value)43U, FontId = (UInt32Value)2U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true };
CellFormat cellFormat13 = new CellFormat(){ NumberFormatId = (UInt32Value)9U, FontId = (UInt32Value)0U, FillId = (UInt32Value)3U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFill = true, ApplyAlignment = true };
Alignment alignment9 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Left };
cellFormat13.Append(alignment9);
CellFormat cellFormat14 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFill = true, ApplyAlignment = true };
Alignment alignment10 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center };
cellFormat14.Append(alignment10);
CellFormat cellFormat15 = new CellFormat(){ NumberFormatId = (UInt32Value)37U, FontId = (UInt32Value)2U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true, ApplyAlignment = true };
Alignment alignment11 = new Alignment(){ Horizontal = HorizontalAlignmentValues.Center };
cellFormat15.Append(alignment11);
CellFormat cellFormat16 = new CellFormat(){ NumberFormatId = (UInt32Value)43U, FontId = (UInt32Value)2U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyNumberFormat = true, ApplyFont = true, ApplyFill = true, ApplyBorder = true };
CellFormat cellFormat17 = new CellFormat(){ NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)2U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyFill = true, ApplyBorder = true };
cellFormats1.Append(cellFormat2);
cellFormats1.Append(cellFormat3);
cellFormats1.Append(cellFormat4);
cellFormats1.Append(cellFormat5);
cellFormats1.Append(cellFormat6);
cellFormats1.Append(cellFormat7);
cellFormats1.Append(cellFormat8);
cellFormats1.Append(cellFormat9);
cellFormats1.Append(cellFormat10);
cellFormats1.Append(cellFormat11);
cellFormats1.Append(cellFormat12);
cellFormats1.Append(cellFormat13);
cellFormats1.Append(cellFormat14);
cellFormats1.Append(cellFormat15);
cellFormats1.Append(cellFormat16);
cellFormats1.Append(cellFormat17);
CellStyles cellStyles1 = new CellStyles(){ Count = (UInt32Value)1U };
CellStyle cellStyle1 = new CellStyle(){ Name = "Normal", FormatId = (UInt32Value)0U, BuiltinId = (UInt32Value)0U };
cellStyles1.Append(cellStyle1);
DifferentialFormats differentialFormats1 = new DifferentialFormats(){ Count = (UInt32Value)0U };
TableStyles tableStyles1 = new TableStyles(){ Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium2", DefaultPivotStyle = "PivotStyleLight16" };
StylesheetExtensionList stylesheetExtensionList1 = new StylesheetExtensionList();
StylesheetExtension stylesheetExtension1 = new StylesheetExtension(){ Uri = "{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}" };
stylesheetExtension1.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
DocumentFormat.OpenXml.Office2010.Excel.SlicerStyles slicerStyles1 = new DocumentFormat.OpenXml.Office2010.Excel.SlicerStyles(){ DefaultSlicerStyle = "SlicerStyleLight1" };
stylesheetExtension1.Append(slicerStyles1);
//StylesheetExtension stylesheetExtension2 = new StylesheetExtension(){ Uri = "{9260A510-F301-46a8-8635-F512D64BE5F5}" };
//stylesheetExtension2.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");
//X15.TimelineStyles timelineStyles1 = new X15.TimelineStyles(){ DefaultTimelineStyle = "TimeSlicerStyleLight1" };
//stylesheetExtension2.Append(timelineStyles1);
stylesheetExtensionList1.Append(stylesheetExtension1);
//stylesheetExtensionList1.Append(stylesheetExtension2);
stylesheet1.Append(numberingFormats1);
stylesheet1.Append(fonts1);
stylesheet1.Append(fills1);
stylesheet1.Append(borders1);
stylesheet1.Append(cellStyleFormats1);
stylesheet1.Append(cellFormats1);
stylesheet1.Append(cellStyles1);
stylesheet1.Append(differentialFormats1);
stylesheet1.Append(tableStyles1);
stylesheet1.Append(stylesheetExtensionList1);
workbookStyles.Stylesheet = stylesheet1;
}
private UInt32Value SetCellStyle(System.Drawing.Color fillColor, bool locked)
{
Fill fill = new Fill();
PatternFill patternFill = new PatternFill() { PatternType = PatternValues.Solid };
ForegroundColor foregroundColor1 = new ForegroundColor() { Rgb = System.Drawing.Color.FromArgb(fillColor.A, fillColor.R, fillColor.G, fillColor.B).Name };
BackgroundColor backgroundColor1 = new BackgroundColor() { Indexed = (UInt32Value)64U };
patternFill.Append(foregroundColor1);
patternFill.Append(backgroundColor1);
fill.Append(patternFill);
ExcelStyleSheet.Fills.Count++;
ExcelStyleSheet.Fills.Append(fill);
CellFormat myCellFormat =
new CellFormat
{
FontId = (UInt32Value)0U,
FillId = (UInt32Value)ExcelStyleSheet.Fills.Count - 1,
ApplyFill = true,
NumberFormatId = (UInt32Value)0U,
FormatId = (UInt32Value)0U,
BorderId = (UInt32Value)1U,
ApplyBorder = true,
ApplyProtection = true
};
Alignment alignment = new Alignment() { WrapText = true };
myCellFormat.Append(alignment);
if (!locked)
{
Protection protection = new Protection() { Locked = false };
myCellFormat.Append(protection);
}
ExcelStyleSheet.CellFormats.Count++;
ExcelStyleSheet.CellFormats.Append(myCellFormat);
return (UInt32Value)ExcelStyleSheet.CellFormats.Count - 1;
}
internal ForegroundColor ToForegroundColor()
{
ForegroundColor clr = new ForegroundColor();
if (this.Auto != null) clr.Auto = this.Auto.Value;
if (this.Indexed != null) clr.Indexed = this.Indexed.Value;
if (this.Rgb != null) clr.Rgb = new HexBinaryValue(this.Rgb);
if (this.Theme != null) clr.Theme = this.Theme.Value;
if (this.Tint != null && this.Tint.Value != 0.0) clr.Tint = this.Tint.Value;
return clr;
}
internal void FromForegroundColor(ForegroundColor clr)
{
this.SetAllNull();
if (clr.Auto != null) this.Auto = clr.Auto.Value;
if (clr.Indexed != null) this.Indexed = clr.Indexed.Value;
if (clr.Rgb != null) this.Rgb = clr.Rgb.Value;
if (clr.Theme != null) this.Theme = clr.Theme.Value;
if (clr.Tint != null) this.Tint = clr.Tint.Value;
this.SetDisplayColor();
}
//описвывает форматы ячеек
protected void GenWorkbookStylesPart(WorkbookStylesPart workbookStylesPart)
{
Stylesheet stylesheet = new Stylesheet();
Fonts fonts1 = new Fonts();
Font font1 = new Font();
Font font2 = new Font();
FontSize fontSize2 = new FontSize() { Val = 11D };
Color color1 = new Color() { Rgb = "FF00B050" };
FontName fontName2 = new FontName() { Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 2 };
FontCharSet fontCharSet1 = new FontCharSet() { Val = 204 };
font2.Append(fontSize2);
font2.Append(color1);
font2.Append(fontName2);
font2.Append(fontFamilyNumbering1);
font2.Append(fontCharSet1);
//fonts1.Append(font2);
fonts1.Append(font1);
Fills fills1 = new Fills();
Fill fill1 = new Fill();
Fill fill2 = new Fill();
Fill fill3 = new Fill();
PatternFill patternFill3 = new PatternFill() { PatternType = PatternValues.Solid };
ForegroundColor foregroundColor1 = new ForegroundColor() { Rgb = "0000FF" };
patternFill3.Append(foregroundColor1);
fill3.Append(patternFill3);
fills1.Append(fill1);
fills1.Append(fill2);
fills1.Append(fill3);
Borders borders1 = new Borders();
Border border1 = new Border();
borders1.Append(border1);
//Переопределяем номера формата 164U, 166U, 167U, 168U,
NumberingFormats numberingFormats1 = new NumberingFormats() { Count = (UInt32Value)3U };
NumberingFormat numberingFormat1 = new NumberingFormat() { NumberFormatId = (UInt32Value)164U, FormatCode = "[$-F800]dddd\\,\\ mmmm\\ dd\\,\\ yyyy" };
NumberingFormat numberingFormat2 = new NumberingFormat() { NumberFormatId = (UInt32Value)166U, FormatCode = "#,##0.000\"р.\"" };
NumberingFormat numberingFormat3 = new NumberingFormat() { NumberFormatId = (UInt32Value)167U, FormatCode = "#,##0\"р.\"" }; //"#,##0.00\"р.\"" };
NumberingFormat numberingFormat4 = new NumberingFormat() { NumberFormatId = (UInt32Value)168U, FormatCode = "#,##0.00\"р.\"" };
numberingFormats1.Append(numberingFormat1);
numberingFormats1.Append(numberingFormat2);
numberingFormats1.Append(numberingFormat3);
numberingFormats1.Append(numberingFormat4);
CellFormats cellFormats1 = new CellFormats() { Count = (UInt32Value)6U };
CellFormat cellFormat2 = new CellFormat() { NumberFormatId = (UInt32Value)0U }; // Формат № 0 по умолчанию общий
CellFormat cellFormat3 = new CellFormat() { NumberFormatId = (UInt32Value)164U }; // Формат № 1 для дат FormatCode = "[$-F800]dddd\\,\\ mmmm\\ dd\\,\\ yyyy"
CellFormat cellFormat4 = new CellFormat() { NumberFormatId = (UInt32Value)166U }; //формат № 2 для денег по тысяч. ###,### <-- (number/ 1000)
CellFormat cellFormat5 = new CellFormat() { NumberFormatId = (UInt32Value)14U }; //формат № 3 для дат * 14.03.2015
CellFormat cellFormat6 = new CellFormat() { NumberFormatId = (UInt32Value)2U }; //формат № 4 для чисел
CellFormat cellFormat7 = new CellFormat() { NumberFormatId = (UInt32Value)1U }; //более подходящий формат № 5U для чисел (5U)
CellFormat cellFormat8 = new CellFormat() { NumberFormatId = (UInt32Value)165U };//формат №6U для денег по умолчанию
CellFormat cellFormat9 = new CellFormat() { NumberFormatId = (UInt32Value)167U };// формат №7U для денег(переопределенный) по три разряда ### ### р.
CellFormat cellFormat10 = new CellFormat() { NumberFormatId = (UInt32Value)168U };// формат №8U для денег(переопределенный) ### ###,00 р.
cellFormats1.Append(cellFormat2);
cellFormats1.Append(cellFormat3);
cellFormats1.Append(cellFormat4);
cellFormats1.Append(cellFormat5);
cellFormats1.Append(cellFormat6);
cellFormats1.Append(cellFormat7);
cellFormats1.Append(cellFormat8);
cellFormats1.Append(cellFormat9);
cellFormats1.Append(cellFormat10);
stylesheet.Append(numberingFormats1);
stylesheet.Append(fonts1);
stylesheet.Append(fills1);
stylesheet.Append(borders1);
stylesheet.Append(cellFormats1);
workbookStylesPart.Stylesheet = stylesheet;
}
= DependencyProperty.Register(nameof(ForegroundColor), typeof(Color), typeof(AccentProvider), new PropertyMetadata(0));
