diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs index c00a463..003742c 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs @@ -50,7 +50,7 @@ private XLColor(XLThemeColor themeColor) { _themeColor = themeColor; - _themeTint = 1; + _themeTint = 0; _hashCode = 7 ^ _themeColor.GetHashCode() ^ _themeTint.GetHashCode(); HasValue = true; _colorType = XLColorType.Theme; diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs index cebe6ec..0e66171 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Save.cs @@ -2967,7 +2967,7 @@ else { foregroundColor.Theme = (UInt32)fillInfo.Fill.PatternColor.ThemeColor; - if (fillInfo.Fill.PatternColor.ThemeTint != 1) + if (fillInfo.Fill.PatternColor.ThemeTint != 0) foregroundColor.Tint = fillInfo.Fill.PatternColor.ThemeTint; } patternFill.AppendChild(foregroundColor); @@ -2983,7 +2983,7 @@ else { backgroundColor.Theme = (UInt32)fillInfo.Fill.PatternBackgroundColor.ThemeColor; - if (fillInfo.Fill.PatternBackgroundColor.ThemeTint != 1) + if (fillInfo.Fill.PatternBackgroundColor.ThemeTint != 0) backgroundColor.Tint = fillInfo.Fill.PatternBackgroundColor.ThemeTint; } patternFill.AppendChild(backgroundColor); @@ -3108,7 +3108,7 @@ else { color.Theme = (UInt32)xlColor.ThemeColor; - if (xlColor.ThemeTint != 1) + if (xlColor.ThemeTint != 0) color.Tint = xlColor.ThemeTint; } return color; @@ -3124,7 +3124,7 @@ else { color.Theme = (UInt32)xlColor.ThemeColor; - if (xlColor.ThemeTint != 1) + if (xlColor.ThemeTint != 0) color.Tint = xlColor.ThemeTint; } return color; diff --git a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs index a209a19..dbd8023 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs @@ -15,20 +15,11 @@ { private static void Main(string[] args) { - var wbSource = new XLWorkbook(@"c:\temp\original.xlsm"); + var wbTarget = new XLWorkbook(); - - foreach (var ws in wbSource.Worksheets) - { - wbTarget.AddWorksheet(ws); - } - - foreach (var r in wbSource.NamedRanges) - { - wbTarget.NamedRanges.Add(r.Name, r.Ranges); - } - - wbTarget.SaveAs(@"c:\temp\saved.xlsm"); + var ws = wbTarget.AddWorksheet("Sheet1"); + ws.FirstCell().Style.Fill.BackgroundColor = XLColor.FromTheme(XLThemeColor.Accent1); + wbTarget.SaveAs(@"c:\temp\saved.xlsx"); Console.WriteLine("Done"); //Console.ReadLine(); }