internal void FromDifferentialType(X14.DifferentialType dt) { this.SetAllNull(); List <System.Drawing.Color> listempty = new List <System.Drawing.Color>(); if (dt.Font != null) { HasFont = true; this.fontReal = new SLFont(SLConstants.OfficeThemeMajorLatinFont, SLConstants.OfficeThemeMinorLatinFont, listempty, listempty); this.fontReal.FromFont(dt.Font); } if (dt.NumberingFormat != null) { HasNumberingFormat = true; this.nfFormatCode = new SLNumberingFormat(); this.nfFormatCode.FromNumberingFormat(dt.NumberingFormat); } if (dt.Fill != null) { HasFill = true; this.fillReal = new SLFill(listempty, listempty); this.fillReal.FromFill(dt.Fill); } if (dt.Alignment != null) { HasAlignment = true; this.alignReal = new SLAlignment(); this.alignReal.FromAlignment(dt.Alignment); } if (dt.Border != null) { HasBorder = true; this.borderReal = new SLBorder(listempty, listempty); this.borderReal.FromBorder(dt.Border); } if (dt.Protection != null) { HasProtection = true; this.protectionReal = new SLProtection(); this.protectionReal.FromProtection(dt.Protection); } Sync(); }
private void SetAllNull() { List <System.Drawing.Color> listempty = new List <System.Drawing.Color>(); this.alignReal = new SLAlignment(); HasAlignment = false; this.protectionReal = new SLProtection(); HasProtection = false; this.nfFormatCode = new SLNumberingFormat(); HasNumberingFormat = false; this.fontReal = new SLFont(SLConstants.OfficeThemeMajorLatinFont, SLConstants.OfficeThemeMinorLatinFont, listempty, listempty); HasFont = false; this.fillReal = new SLFill(listempty, listempty); HasFill = false; this.borderReal = new SLBorder(listempty, listempty); HasBorder = false; }
internal SLBorder Clone() { SLBorder b = new SLBorder(this.listThemeColors, this.listIndexedColors); b.HasLeftBorder = this.HasLeftBorder; b.bpLeftBorder = this.bpLeftBorder.Clone(); b.HasRightBorder = this.HasRightBorder; b.bpRightBorder = this.bpRightBorder.Clone(); b.HasTopBorder = this.HasTopBorder; b.bpTopBorder = this.bpTopBorder.Clone(); b.HasBottomBorder = this.HasBottomBorder; b.bpBottomBorder = this.bpBottomBorder.Clone(); b.HasDiagonalBorder = this.HasDiagonalBorder; b.bpDiagonalBorder = this.bpDiagonalBorder.Clone(); b.HasVerticalBorder = this.HasVerticalBorder; b.bpVerticalBorder = this.bpVerticalBorder.Clone(); b.HasHorizontalBorder = this.HasHorizontalBorder; b.bpHorizontalBorder = this.bpHorizontalBorder.Clone(); b.DiagonalUp = this.DiagonalUp; b.DiagonalDown = this.DiagonalDown; b.Outline = this.Outline; return(b); }
internal void WriteStylesheet() { int i = 0; SLStyle styleSL = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); for (i = 0; i < listStyle.Count; ++i) { styleSL.FromHash(listStyle[i]); if (styleSL.nfFormatCode.FormatCode.Length > 0) { this.SaveToStylesheetNumberingFormat(styleSL.nfFormatCode.ToHash()); } if (styleSL.HasFont) { this.SaveToStylesheetFont(styleSL.fontReal.ToHash()); } if (styleSL.HasFill) { this.SaveToStylesheetFill(styleSL.fillReal.ToHash()); } if (styleSL.HasBorder) { this.SaveToStylesheetBorder(styleSL.borderReal.ToHash()); } } if (wbp.WorkbookStylesPart != null) { int diff = 0; WorkbookStylesPart wbsp = wbp.WorkbookStylesPart; if (dictStyleNumberingFormat.Count > 0) { if (dictStyleNumberingFormat.Count == 1 && dictStyleNumberingFormatHash.ContainsKey(SLConstants.NumberFormatGeneral) && dictStyleNumberingFormatHash[SLConstants.NumberFormatGeneral] == 0) { // it just contains our "default" number format, so don't do anything. } else { wbsp.Stylesheet.NumberingFormats = new NumberingFormats(); List<int> listKeys = dictStyleNumberingFormat.Keys.ToList<int>(); listKeys.Sort(); if (listKeys[0] == 0 && dictStyleNumberingFormat[listKeys[0]].Equals(SLConstants.NumberFormatGeneral, StringComparison.InvariantCultureIgnoreCase)) { listKeys.RemoveAt(0); } wbsp.Stylesheet.NumberingFormats.Count = (uint)listKeys.Count; SLNumberingFormat nfSL; for (i = 0; i < listKeys.Count; ++i) { nfSL = new SLNumberingFormat(); nfSL.FromHash(dictStyleNumberingFormat[listKeys[i]]); wbsp.Stylesheet.NumberingFormats.Append(new NumberingFormat() { NumberFormatId = (uint)listKeys[i], FormatCode = SLTool.XmlWrite(nfSL.FormatCode) }); } } } if (listStyleFont.Count > countStyleFont) { if (wbsp.Stylesheet.Fonts == null) { wbsp.Stylesheet.Fonts = new Fonts(); } wbsp.Stylesheet.Fonts.Count = (uint)listStyleFont.Count; diff = listStyleFont.Count - countStyleFont; for (i = 0; i < diff; ++i) { wbsp.Stylesheet.Fonts.Append(new Font() { InnerXml = listStyleFont[i + countStyleFont] }); } } if (listStyleFill.Count > countStyleFill) { if (wbsp.Stylesheet.Fills == null) { wbsp.Stylesheet.Fills = new Fills(); } wbsp.Stylesheet.Fills.Count = (uint)listStyleFill.Count; diff = listStyleFill.Count - countStyleFill; for (i = 0; i < diff; ++i) { wbsp.Stylesheet.Fills.Append(new Fill() { InnerXml = listStyleFill[i + countStyleFill] }); } } if (listStyleBorder.Count > countStyleBorder) { if (wbsp.Stylesheet.Borders == null) { wbsp.Stylesheet.Borders = new Borders(); } wbsp.Stylesheet.Borders.Count = (uint)listStyleBorder.Count; diff = listStyleBorder.Count - countStyleBorder; SLBorder borderSL = new SLBorder(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); for (i = 0; i < diff; ++i) { borderSL.FromHash(listStyleBorder[i + countStyleBorder]); wbsp.Stylesheet.Borders.Append(borderSL.ToBorder()); } } int iCanonicalCellStyleFormatId = 0; SLStyle styleCanonical = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); styleCanonical.FormatCode = this.NumberFormatGeneralText; styleCanonical.fontReal.FromHash(listStyleFont[0]); styleCanonical.Fill.SetPatternType(PatternValues.None); styleCanonical.Border = new SLBorder(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); iCanonicalCellStyleFormatId = this.SaveToStylesheetCellStylesFormat(styleCanonical.ToHash()); this.TranslateStylesToStyleIds(ref styleCanonical); if (listStyleCellStyleFormat.Count > countStyleCellStyleFormat) { if (wbsp.Stylesheet.CellStyleFormats == null) { wbsp.Stylesheet.CellStyleFormats = new CellStyleFormats(); } wbsp.Stylesheet.CellStyleFormats.Count = (uint)listStyleCellStyleFormat.Count; diff = listStyleCellStyleFormat.Count - countStyleCellStyleFormat; styleSL = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); for (i = 0; i < diff; ++i) { styleSL.FromHash(listStyleCellStyleFormat[i + countStyleCellStyleFormat]); this.TranslateStylesToStyleIds(ref styleSL); wbsp.Stylesheet.CellStyleFormats.Append(styleSL.ToCellFormat()); } } if (listStyle.Count > countStyle) { if (wbsp.Stylesheet.CellFormats == null) { wbsp.Stylesheet.CellFormats = new CellFormats(); } wbsp.Stylesheet.CellFormats.Count = (uint)listStyle.Count; diff = listStyle.Count - countStyle; styleSL = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); for (i = 0; i < diff; ++i) { styleSL.FromHash(listStyle[i + countStyle]); this.TranslateStylesToStyleIds(ref styleSL); styleSL.CellStyleFormatId = (uint)iCanonicalCellStyleFormatId; if (styleSL.NumberFormatId != styleCanonical.NumberFormatId) styleSL.ApplyNumberFormat = true; if (styleSL.FontId != styleCanonical.FontId) styleSL.ApplyFont = true; if (styleSL.FillId != styleCanonical.FillId) styleSL.ApplyFill = true; if (styleSL.BorderId != styleCanonical.BorderId) styleSL.ApplyBorder = true; if (styleSL.HasAlignment) styleSL.ApplyAlignment = true; if (styleSL.HasProtection) styleSL.ApplyProtection = true; wbsp.Stylesheet.CellFormats.Append(styleSL.ToCellFormat()); } } if (listStyleCellStyle.Count > countStyleCellStyle) { if (wbsp.Stylesheet.CellStyles == null) { wbsp.Stylesheet.CellStyles = new CellStyles(); } wbsp.Stylesheet.CellStyles.Count = (uint)listStyleCellStyle.Count; diff = listStyleCellStyle.Count - countStyleCellStyle; SLCellStyle csSL = new SLCellStyle(); for (i = 0; i < diff; ++i) { csSL.FromHash(listStyleCellStyle[i + countStyleCellStyle]); wbsp.Stylesheet.CellStyles.Append(csSL.ToCellStyle()); } } if (listStyleDifferentialFormat.Count > countStyleDifferentialFormat) { if (wbsp.Stylesheet.DifferentialFormats == null) { wbsp.Stylesheet.DifferentialFormats = new DifferentialFormats(); } wbsp.Stylesheet.DifferentialFormats.Count = (uint)listStyleDifferentialFormat.Count; diff = listStyleDifferentialFormat.Count - countStyleDifferentialFormat; for (i = 0; i < diff; ++i) { wbsp.Stylesheet.DifferentialFormats.Append(new DifferentialFormat() { InnerXml = listStyleDifferentialFormat[i + countStyleDifferentialFormat] }); } } if (listStyleTableStyle.Count > countStyleTableStyle) { if (wbsp.Stylesheet.TableStyles == null) { wbsp.Stylesheet.TableStyles = new TableStyles(); } wbsp.Stylesheet.TableStyles.Count = (uint)listStyleTableStyle.Count; if (this.TableStylesDefaultTableStyle.Length > 0) { wbsp.Stylesheet.TableStyles.DefaultTableStyle = this.TableStylesDefaultTableStyle; } if (this.TableStylesDefaultPivotStyle.Length > 0) { wbsp.Stylesheet.TableStyles.DefaultPivotStyle = this.TableStylesDefaultPivotStyle; } diff = listStyleTableStyle.Count - countStyleTableStyle; SLTableStyle tsSL = new SLTableStyle(); for (i = 0; i < diff; ++i) { tsSL.FromHash(listStyleTableStyle[i + countStyleTableStyle]); wbsp.Stylesheet.TableStyles.Append(tsSL.ToTableStyle()); } } // we're not touching Colors here, so there shouldn't be anything to update } else { WorkbookStylesPart wbsp = wbp.AddNewPart<WorkbookStylesPart>(); using (MemoryStream ms = new MemoryStream()) { using (StreamWriter sw = new StreamWriter(ms)) { sw.Write("<x:styleSheet xmlns:x=\"http://schemas.openxmlformats.org/spreadsheetml/2006/main\">"); if (dictStyleNumberingFormat.Count > 0) { if (dictStyleNumberingFormat.Count == 1 && dictStyleNumberingFormatHash.ContainsKey(SLConstants.NumberFormatGeneral) && dictStyleNumberingFormatHash[SLConstants.NumberFormatGeneral] == 0) { // it just contains our "default" number format, so don't do anything. } else { List<int> listKeys = dictStyleNumberingFormat.Keys.ToList<int>(); listKeys.Sort(); if (listKeys[0] == 0 && dictStyleNumberingFormat[listKeys[0]].Equals(SLConstants.NumberFormatGeneral, StringComparison.InvariantCultureIgnoreCase)) { listKeys.RemoveAt(0); } sw.Write("<x:numFmts count=\"{0}\">", listKeys.Count); for (i = 0; i < listKeys.Count; ++i) { sw.Write("<x:numFmt numFmtId=\"{0}\" formatCode=\"{1}\" />", listKeys[i], SLTool.XmlWrite(dictStyleNumberingFormat[listKeys[i]])); } sw.Write("</x:numFmts>"); } } sw.Write("<x:fonts count=\"{0}\">", listStyleFont.Count); for (i = 0; i < listStyleFont.Count; ++i) { sw.Write("<x:font>{0}</x:font>", listStyleFont[i]); } sw.Write("</x:fonts>"); sw.Write("<x:fills count=\"{0}\">", listStyleFill.Count); for (i = 0; i < listStyleFill.Count; ++i) { sw.Write("<x:fill>{0}</x:fill>", listStyleFill[i]); } sw.Write("</x:fills>"); List<System.Drawing.Color> listempty = new List<System.Drawing.Color>(); sw.Write("<x:borders count=\"{0}\">", listStyleBorder.Count); SLBorder slb; for (i = 0; i < listStyleBorder.Count; ++i) { slb = new SLBorder(listempty, listempty); slb.FromHash(listStyleBorder[i]); slb.Sync(); sw.Write("<x:border"); if (slb.DiagonalUp != null) sw.Write(" diagonalUp=\"{0}\"", slb.DiagonalUp.Value ? "1" : "0"); if (slb.DiagonalDown != null) sw.Write(" diagonalDown=\"{0}\"", slb.DiagonalDown.Value ? "1" : "0"); if (slb.Outline != null && !slb.Outline.Value) sw.Write(" outline=\"0\""); sw.Write(">"); // by "default" always have left, right, top, bottom and diagonal borders, even if empty? sw.Write(SLBorderProperties.WriteToXmlTag("left", slb.LeftBorder)); sw.Write(SLBorderProperties.WriteToXmlTag("right", slb.RightBorder)); sw.Write(SLBorderProperties.WriteToXmlTag("top", slb.TopBorder)); sw.Write(SLBorderProperties.WriteToXmlTag("bottom", slb.BottomBorder)); sw.Write(SLBorderProperties.WriteToXmlTag("diagonal", slb.DiagonalBorder)); if (slb.HasVerticalBorder) sw.Write(SLBorderProperties.WriteToXmlTag("vertical", slb.VerticalBorder)); if (slb.HasHorizontalBorder) sw.Write(SLBorderProperties.WriteToXmlTag("horizontal", slb.HorizontalBorder)); sw.Write("</x:border>"); } sw.Write("</x:borders>"); int iCanonicalCellStyleFormatId = 0; SLStyle styleCanonical = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); styleCanonical.FormatCode = this.NumberFormatGeneralText; styleCanonical.fontReal.FromHash(listStyleFont[0]); styleCanonical.Fill.SetPatternType(PatternValues.None); styleCanonical.Border = new SLBorder(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); iCanonicalCellStyleFormatId = this.SaveToStylesheetCellStylesFormat(styleCanonical.ToHash()); this.TranslateStylesToStyleIds(ref styleCanonical); sw.Write("<x:cellStyleXfs count=\"{0}\">", listStyleCellStyleFormat.Count); for (i = 0; i < listStyleCellStyleFormat.Count; ++i) { styleSL = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, listempty, listempty); styleSL.FromHash(listStyleCellStyleFormat[i]); this.TranslateStylesToStyleIds(ref styleSL); sw.Write(styleSL.WriteToXmlTag()); } sw.Write("</x:cellStyleXfs>"); sw.Write("<x:cellXfs count=\"{0}\">", listStyle.Count); for (i = 0; i < listStyle.Count; ++i) { styleSL = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, listempty, listempty); styleSL.FromHash(listStyle[i]); this.TranslateStylesToStyleIds(ref styleSL); styleSL.CellStyleFormatId = (uint)iCanonicalCellStyleFormatId; if (styleSL.NumberFormatId != styleCanonical.NumberFormatId) styleSL.ApplyNumberFormat = true; if (styleSL.FontId != styleCanonical.FontId) styleSL.ApplyFont = true; if (styleSL.FillId != styleCanonical.FillId) styleSL.ApplyFill = true; if (styleSL.BorderId != styleCanonical.BorderId) styleSL.ApplyBorder = true; if (styleSL.HasAlignment) styleSL.ApplyAlignment = true; if (styleSL.HasProtection) styleSL.ApplyProtection = true; sw.Write(styleSL.WriteToXmlTag()); } sw.Write("</x:cellXfs>"); sw.Write("<x:cellStyles count=\"{0}\">", listStyleCellStyle.Count); SLCellStyle csSL; for (i = 0; i < listStyleCellStyle.Count; ++i) { csSL = new SLCellStyle(); csSL.FromHash(listStyleCellStyle[i]); sw.Write(csSL.WriteToXmlTag()); } sw.Write("</x:cellStyles>"); sw.Write("<x:dxfs count=\"{0}\">", listStyleDifferentialFormat.Count); for (i = 0; i < listStyleDifferentialFormat.Count; ++i) { sw.Write("<x:dxf>{0}</x:dxf>", listStyleDifferentialFormat[i]); } sw.Write("</x:dxfs>"); sw.Write("<x:tableStyles count=\"{0}\"", listStyleTableStyle.Count); if (this.TableStylesDefaultTableStyle.Length > 0) { sw.Write(" defaultTableStyle=\"{0}\"", this.TableStylesDefaultTableStyle); } if (this.TableStylesDefaultPivotStyle.Length > 0) { sw.Write(" defaultPivotStyle=\"{0}\"", this.TableStylesDefaultPivotStyle); } sw.Write(">"); SLTableStyle tsSL; for (i = 0; i < listStyleTableStyle.Count; ++i) { tsSL = new SLTableStyle(); tsSL.FromHash(listStyleTableStyle[i]); sw.Write(tsSL.WriteToXmlTag()); } sw.Write("</x:tableStyles>"); sw.Write("</x:styleSheet>"); sw.Flush(); ms.Position = 0; wbsp.FeedData(ms); } } // end of writing new stylesheet } }
internal void LoadStylesheet() { countStyle = 0; listStyle = new List<string>(); dictStyleHash = new Dictionary<string, int>(); NumberFormatGeneralId = -1; NumberFormatGeneralText = SLConstants.NumberFormatGeneral; NextNumberFormatId = SLConstants.CustomNumberFormatIdStartIndex; dictStyleNumberingFormat = new Dictionary<int, string>(); dictStyleNumberingFormatHash = new Dictionary<string, int>(); countStyleFont = 0; listStyleFont = new List<string>(); dictStyleFontHash = new Dictionary<string, int>(); countStyleFill = 0; listStyleFill = new List<string>(); dictStyleFillHash = new Dictionary<string, int>(); countStyleBorder = 0; listStyleBorder = new List<string>(); dictStyleBorderHash = new Dictionary<string, int>(); countStyleCellStyle = 0; listStyleCellStyle = new List<string>(); dictStyleCellStyleHash = new Dictionary<string, int>(); countStyleCellStyleFormat = 0; listStyleCellStyleFormat = new List<string>(); dictStyleCellStyleFormatHash = new Dictionary<string, int>(); countStyleDifferentialFormat = 0; listStyleDifferentialFormat = new List<string>(); dictStyleDifferentialFormatHash = new Dictionary<string, int>(); countStyleTableStyle = 0; listStyleTableStyle = new List<string>(); dictStyleTableStyleHash = new Dictionary<string, int>(); int i = 0; string sHash = string.Empty; if (wbp.WorkbookStylesPart != null) { WorkbookStylesPart wbsp = wbp.WorkbookStylesPart; this.NextNumberFormatId = SLConstants.CustomNumberFormatIdStartIndex; this.StylesheetColors = null; using (OpenXmlReader oxr = OpenXmlReader.Create(wbsp)) { while (oxr.Read()) { if (oxr.ElementType == typeof(NumberingFormats)) { NumberingFormat nf; using (OpenXmlReader oxrNF = OpenXmlReader.Create((NumberingFormats)oxr.LoadCurrentElement())) { while (oxrNF.Read()) { if (oxrNF.ElementType == typeof(NumberingFormat)) { nf = (NumberingFormat)oxrNF.LoadCurrentElement(); if (nf.NumberFormatId != null && nf.FormatCode != null) { i = (int)nf.NumberFormatId.Value; sHash = nf.FormatCode.Value; dictStyleNumberingFormat[i] = sHash; dictStyleNumberingFormatHash[sHash] = i; if (sHash.Equals(SLConstants.NumberFormatGeneral, StringComparison.InvariantCultureIgnoreCase)) { this.NumberFormatGeneralText = sHash; this.NumberFormatGeneralId = i; } // if there's a number format greater than the next number, // obviously we want to increment. // if there's a current number equal to the next number, // we want to increment because this number exists! // Emphasis on *next* number if (i >= this.NextNumberFormatId) { this.NextNumberFormatId = this.NextNumberFormatId + 1; } } } } } } else if (oxr.ElementType == typeof(Fonts)) { SLFont fontSL; using (OpenXmlReader oxrFont = OpenXmlReader.Create((Fonts)oxr.LoadCurrentElement())) { while (oxrFont.Read()) { if (oxrFont.ElementType == typeof(Font)) { fontSL = new SLFont(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); fontSL.FromFont((Font)oxrFont.LoadCurrentElement()); this.ForceSaveToStylesheetFont(fontSL.ToHash()); } } } countStyleFont = listStyleFont.Count; } else if (oxr.ElementType == typeof(Fills)) { SLFill fillSL; using (OpenXmlReader oxrFill = OpenXmlReader.Create((Fills)oxr.LoadCurrentElement())) { while (oxrFill.Read()) { if (oxrFill.ElementType == typeof(Fill)) { fillSL = new SLFill(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); fillSL.FromFill((Fill)oxrFill.LoadCurrentElement()); this.ForceSaveToStylesheetFill(fillSL.ToHash()); } } } countStyleFill = listStyleFill.Count; } else if (oxr.ElementType == typeof(Borders)) { SLBorder borderSL; using (OpenXmlReader oxrBorder = OpenXmlReader.Create((Borders)oxr.LoadCurrentElement())) { while (oxrBorder.Read()) { if (oxrBorder.ElementType == typeof(Border)) { borderSL = new SLBorder(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); borderSL.FromBorder((Border)oxrBorder.LoadCurrentElement()); this.ForceSaveToStylesheetBorder(borderSL.ToHash()); } } } countStyleBorder = listStyleBorder.Count; } else if (oxr.ElementType == typeof(CellStyleFormats)) { SLStyle styleSL; using (OpenXmlReader oxrCellStyleFormats = OpenXmlReader.Create((CellStyleFormats)oxr.LoadCurrentElement())) { while (oxrCellStyleFormats.Read()) { if (oxrCellStyleFormats.ElementType == typeof(CellFormat)) { styleSL = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); styleSL.FromCellFormat((CellFormat)oxrCellStyleFormats.LoadCurrentElement()); this.TranslateStyleIdsToStyles(ref styleSL); this.ForceSaveToStylesheetCellStylesFormat(styleSL.ToHash()); } } } countStyleCellStyleFormat = listStyleCellStyleFormat.Count; } else if (oxr.ElementType == typeof(CellFormats)) { SLStyle styleSL; using (OpenXmlReader oxrCellFormats = OpenXmlReader.Create((CellFormats)oxr.LoadCurrentElement())) { while (oxrCellFormats.Read()) { if (oxrCellFormats.ElementType == typeof(CellFormat)) { styleSL = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); styleSL.FromCellFormat((CellFormat)oxrCellFormats.LoadCurrentElement()); this.TranslateStyleIdsToStyles(ref styleSL); this.ForceSaveToStylesheet(styleSL.ToHash()); } } } countStyle = listStyle.Count; } else if (oxr.ElementType == typeof(CellStyles)) { SLCellStyle csSL; using (OpenXmlReader oxrCellStyles = OpenXmlReader.Create((CellStyles)oxr.LoadCurrentElement())) { while (oxrCellStyles.Read()) { if (oxrCellStyles.ElementType == typeof(CellStyle)) { csSL = new SLCellStyle(); csSL.FromCellStyle((CellStyle)oxrCellStyles.LoadCurrentElement()); this.ForceSaveToStylesheetCellStyle(csSL.ToHash()); } } } countStyleCellStyle = listStyleCellStyle.Count; } else if (oxr.ElementType == typeof(DifferentialFormats)) { SLDifferentialFormat dfSL; using (OpenXmlReader oxrDiff = OpenXmlReader.Create((DifferentialFormats)oxr.LoadCurrentElement())) { while (oxrDiff.Read()) { if (oxrDiff.ElementType == typeof(DifferentialFormat)) { dfSL = new SLDifferentialFormat(); dfSL.FromDifferentialFormat((DifferentialFormat)oxrDiff.LoadCurrentElement()); this.ForceSaveToStylesheetDifferentialFormat(dfSL.ToHash()); } } } countStyleDifferentialFormat = listStyleDifferentialFormat.Count; } else if (oxr.ElementType == typeof(TableStyles)) { TableStyles tss = (TableStyles)oxr.LoadCurrentElement(); SLTableStyle tsSL; i = 0; using (OpenXmlReader oxrTableStyles = OpenXmlReader.Create(tss)) { while (oxrTableStyles.Read()) { if (oxrTableStyles.ElementType == typeof(TableStyle)) { tsSL = new SLTableStyle(); tsSL.FromTableStyle((TableStyle)oxrTableStyles.LoadCurrentElement()); sHash = tsSL.ToHash(); listStyleTableStyle.Add(sHash); dictStyleTableStyleHash[sHash] = i; ++i; } } } countStyleTableStyle = listStyleTableStyle.Count; if (tss.DefaultTableStyle != null) { this.TableStylesDefaultTableStyle = tss.DefaultTableStyle.Value; } else { this.TableStylesDefaultTableStyle = string.Empty; } if (tss.DefaultPivotStyle != null) { this.TableStylesDefaultPivotStyle = tss.DefaultPivotStyle.Value; } else { this.TableStylesDefaultPivotStyle = string.Empty; } } else if (oxr.ElementType == typeof(Colors)) { this.StylesheetColors = (Colors)(oxr.LoadCurrentElement().CloneNode(true)); } } } // Force a "General" number format to be saved. // Upper case is used by LibreOffice. Is it case insensitive? if (this.NumberFormatGeneralId < 0) { if (!dictStyleNumberingFormat.ContainsKey(0)) { this.NumberFormatGeneralId = 0; this.NumberFormatGeneralText = SLConstants.NumberFormatGeneral; dictStyleNumberingFormat[this.NumberFormatGeneralId] = this.NumberFormatGeneralText; dictStyleNumberingFormatHash[this.NumberFormatGeneralText] = this.NumberFormatGeneralId; } else { this.NumberFormatGeneralId = this.NextNumberFormatId; this.NumberFormatGeneralText = SLConstants.NumberFormatGeneral; dictStyleNumberingFormat[this.NumberFormatGeneralId] = this.NumberFormatGeneralText; dictStyleNumberingFormatHash[this.NumberFormatGeneralText] = this.NumberFormatGeneralId; ++this.NextNumberFormatId; } } if (listStyleFont.Count == 0) { SLFont fontSL = new SLFont(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); fontSL.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); fontSL.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.SaveToStylesheetFont(fontSL.ToHash()); } if (listStyleFill.Count == 0) { SLFill fillNone = new SLFill(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); fillNone.SetPatternType(PatternValues.None); this.SaveToStylesheetFill(fillNone.ToHash()); SLFill fillGray125 = new SLFill(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); fillGray125.SetPatternType(PatternValues.Gray125); this.SaveToStylesheetFill(fillGray125.ToHash()); } else { // make sure there's at least a "none" pattern SLFill fillNone = new SLFill(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); fillNone.SetPatternType(PatternValues.None); this.SaveToStylesheetFill(fillNone.ToHash()); } // make sure there's at least an empty border SLBorder borderEmpty = new SLBorder(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); this.SaveToStylesheetBorder(borderEmpty.ToHash()); int iCanonicalCellStyleFormatId = 0; SLStyle style = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); style.FormatCode = this.NumberFormatGeneralText; style.fontReal.FromHash(listStyleFont[0]); style.Fill.SetPatternType(PatternValues.None); style.Border = new SLBorder(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); // there's at least one cell style format iCanonicalCellStyleFormatId = this.SaveToStylesheetCellStylesFormat(style.ToHash()); // there's at least one style style.CellStyleFormatId = (uint)iCanonicalCellStyleFormatId; this.SaveToStylesheet(style.ToHash()); if (listStyleCellStyle.Count == 0) { SLCellStyle csNormal = new SLCellStyle(); csNormal.Name = "Normal"; //csNormal.FormatId = 0; csNormal.FormatId = (uint)iCanonicalCellStyleFormatId; csNormal.BuiltinId = 0; this.SaveToStylesheetCellStyle(csNormal.ToHash()); } } else { // no numbering format by default this.NextNumberFormatId = SLConstants.CustomNumberFormatIdStartIndex; this.NumberFormatGeneralId = 0; this.NumberFormatGeneralText = SLConstants.NumberFormatGeneral; dictStyleNumberingFormat[this.NumberFormatGeneralId] = this.NumberFormatGeneralText; dictStyleNumberingFormatHash[this.NumberFormatGeneralText] = this.NumberFormatGeneralId; SLFont fontDefault = new SLFont(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); fontDefault.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); fontDefault.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.SaveToStylesheetFont(fontDefault.ToHash()); SLFill fillNone = new SLFill(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); fillNone.SetPatternType(PatternValues.None); this.SaveToStylesheetFill(fillNone.ToHash()); SLFill fillGray125 = new SLFill(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); fillGray125.SetPatternType(PatternValues.Gray125); this.SaveToStylesheetFill(fillGray125.ToHash()); SLBorder borderEmpty = new SLBorder(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); this.SaveToStylesheetBorder(borderEmpty.ToHash()); int iCanonicalCellStyleFormatId = 0; SLStyle style = new SLStyle(SimpleTheme.MajorLatinFont, SimpleTheme.MinorLatinFont, SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); style.FormatCode = this.NumberFormatGeneralText; style.Font = fontDefault; style.Fill = fillNone; style.Border = borderEmpty; iCanonicalCellStyleFormatId = this.SaveToStylesheetCellStylesFormat(style.ToHash()); style.CellStyleFormatId = (uint)iCanonicalCellStyleFormatId; this.SaveToStylesheet(style.ToHash()); SLCellStyle csNormal = new SLCellStyle(); csNormal.Name = "Normal"; //csNormal.FormatId = 0; csNormal.FormatId = (uint)iCanonicalCellStyleFormatId; csNormal.BuiltinId = 0; this.SaveToStylesheetCellStyle(csNormal.ToHash()); this.TableStylesDefaultTableStyle = SLConstants.DefaultTableStyle; this.TableStylesDefaultPivotStyle = SLConstants.DefaultPivotStyle; } }
internal void TranslateStylesToStyleIds(ref SLStyle style) { style.Sync(); if (style.nfFormatCode.FormatCode.Length > 0) { style.NumberFormatId = (uint)this.SaveToStylesheetNumberingFormat(style.nfFormatCode.ToHash()); } else { style.NumberFormatId = (uint)this.NumberFormatGeneralId; } if (style.HasFont) { style.FontId = (uint)this.SaveToStylesheetFont(style.fontReal.ToHash()); } else { style.FontId = (uint)this.SaveToStylesheetFont(listStyleFont[0]); } if (style.HasFill) { style.FillId = (uint)this.SaveToStylesheetFill(style.fillReal.ToHash()); } else { SLFill fill = new SLFill(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); fill.SetPatternType(PatternValues.None); style.FillId = (uint)this.SaveToStylesheetFill(fill.ToHash()); } if (style.HasBorder) { style.BorderId = (uint)this.SaveToStylesheetBorder(style.borderReal.ToHash()); } else { SLBorder border = new SLBorder(SimpleTheme.listThemeColors, SimpleTheme.listIndexedColors); style.BorderId = (uint)this.SaveToStylesheetBorder(border.ToHash()); } }
/// <summary> /// Apply a named cell style. Existing styles are kept, unless the chosen named cell style overrides those styles. /// </summary> /// <param name="NamedCellStyle">The named cell style to be applied.</param> public void ApplyNamedCellStyle(SLNamedCellStyleValues NamedCellStyle) { SLFont font; SLFill fill; SLBorder border; switch (NamedCellStyle) { case SLNamedCellStyleValues.Normal: RemoveFormatCode(); font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); this.Font = font; RemoveFill(); RemoveBorder(); // normal is the only one that removes alignment RemoveAlignment(); break; case SLNamedCellStyleValues.Bad: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0x9C, 0, 0x06); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xC7, 0xCE)); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Good: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0, 0x61, 0); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(System.Drawing.Color.FromArgb(0xFF, 0xC6, 0xEF, 0xCE)); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Neutral: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0x9C, 0x65, 0); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xEB, 0x9C)); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Calculation: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.Bold = true; font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0xFA, 0x7D, 0); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(System.Drawing.Color.FromArgb(0xFF, 0xF2, 0xF2, 0xF2)); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; border = new SLBorder(this.listThemeColors, this.listIndexedColors); border.LeftBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x7F, 0x7F, 0x7F); border.LeftBorder.BorderStyle = BorderStyleValues.Thin; border.RightBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x7F, 0x7F, 0x7F); border.RightBorder.BorderStyle = BorderStyleValues.Thin; border.TopBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x7F, 0x7F, 0x7F); border.TopBorder.BorderStyle = BorderStyleValues.Thin; border.BottomBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x7F, 0x7F, 0x7F); border.BottomBorder.BorderStyle = BorderStyleValues.Thin; this.Border = border; break; case SLNamedCellStyleValues.CheckCell: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.Bold = true; font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(System.Drawing.Color.FromArgb(0xFF, 0xA5, 0xA5, 0xA5)); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; border = new SLBorder(this.listThemeColors, this.listIndexedColors); border.LeftBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x3F, 0x3F, 0x3F); border.LeftBorder.BorderStyle = BorderStyleValues.Double; border.RightBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x3F, 0x3F, 0x3F); border.RightBorder.BorderStyle = BorderStyleValues.Double; border.TopBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x3F, 0x3F, 0x3F); border.TopBorder.BorderStyle = BorderStyleValues.Double; border.BottomBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x3F, 0x3F, 0x3F); border.BottomBorder.BorderStyle = BorderStyleValues.Double; this.Border = border; break; case SLNamedCellStyleValues.ExplanatoryText: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.Italic = true; font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0x7F, 0x7F, 0x7F); this.Font = font; // no change to fill // no change to border break; case SLNamedCellStyleValues.Input: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0x3F, 0x3F, 0x76); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xCC, 0x99)); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; border = new SLBorder(this.listThemeColors, this.listIndexedColors); border.LeftBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x7F, 0x7F, 0x7F); border.LeftBorder.BorderStyle = BorderStyleValues.Thin; border.RightBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x7F, 0x7F, 0x7F); border.RightBorder.BorderStyle = BorderStyleValues.Thin; border.TopBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x7F, 0x7F, 0x7F); border.TopBorder.BorderStyle = BorderStyleValues.Thin; border.BottomBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x7F, 0x7F, 0x7F); border.BottomBorder.BorderStyle = BorderStyleValues.Thin; this.Border = border; break; case SLNamedCellStyleValues.LinkedCell: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0xFA, 0x7D, 0); this.Font = font; // no change to fill border = new SLBorder(this.listThemeColors, this.listIndexedColors); border.BottomBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0x80, 0x01); border.BottomBorder.BorderStyle = BorderStyleValues.Double; this.Border = border; break; case SLNamedCellStyleValues.Note: // no change to format code // Note doesn't change font or font size fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(System.Drawing.Color.FromArgb(0xFF, 0xFF, 0xFF, 0xCC)); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; border = new SLBorder(this.listThemeColors, this.listIndexedColors); border.LeftBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0xB2, 0xB2, 0xB2); border.LeftBorder.BorderStyle = BorderStyleValues.Thin; border.RightBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0xB2, 0xB2, 0xB2); border.RightBorder.BorderStyle = BorderStyleValues.Thin; border.TopBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0xB2, 0xB2, 0xB2); border.TopBorder.BorderStyle = BorderStyleValues.Thin; border.BottomBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0xB2, 0xB2, 0xB2); border.BottomBorder.BorderStyle = BorderStyleValues.Thin; this.Border = border; break; case SLNamedCellStyleValues.Output: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.Bold = true; font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0x3F, 0x3F, 0x3F); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(System.Drawing.Color.FromArgb(0xFF, 0xF2, 0xF2, 0xF2)); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; border = new SLBorder(this.listThemeColors, this.listIndexedColors); border.LeftBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x3F, 0x3F, 0x3F); border.LeftBorder.BorderStyle = BorderStyleValues.Thin; border.RightBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x3F, 0x3F, 0x3F); border.RightBorder.BorderStyle = BorderStyleValues.Thin; border.TopBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x3F, 0x3F, 0x3F); border.TopBorder.BorderStyle = BorderStyleValues.Thin; border.BottomBorder.Color = System.Drawing.Color.FromArgb(0xFF, 0x3F, 0x3F, 0x3F); border.BottomBorder.BorderStyle = BorderStyleValues.Thin; this.Border = border; break; case SLNamedCellStyleValues.WarningText: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.FontColor = System.Drawing.Color.FromArgb(0xFF, 0xFF, 0, 0); this.Font = font; // no change to fill // no change to border break; case SLNamedCellStyleValues.Heading1: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.Heading1FontSize); font.Bold = true; font.SetFontThemeColor(SLThemeColorIndexValues.Dark2Color); this.Font = font; // no change to fill border = new SLBorder(this.listThemeColors, this.listIndexedColors); border.BottomBorder.SetBorderThemeColor(SLThemeColorIndexValues.Accent1Color); border.BottomBorder.BorderStyle = BorderStyleValues.Thick; this.Border = border; break; case SLNamedCellStyleValues.Heading2: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.Heading2FontSize); font.Bold = true; font.SetFontThemeColor(SLThemeColorIndexValues.Dark2Color); this.Font = font; // no change to fill border = new SLBorder(this.listThemeColors, this.listIndexedColors); border.BottomBorder.SetBorderThemeColor(SLThemeColorIndexValues.Accent1Color, 0.499984740745262); border.BottomBorder.BorderStyle = BorderStyleValues.Thick; this.Border = border; break; case SLNamedCellStyleValues.Heading3: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.Bold = true; font.SetFontThemeColor(SLThemeColorIndexValues.Dark2Color); this.Font = font; // no change to fill border = new SLBorder(this.listThemeColors, this.listIndexedColors); border.BottomBorder.SetBorderThemeColor(SLThemeColorIndexValues.Accent1Color, 0.399975585192419); border.BottomBorder.BorderStyle = BorderStyleValues.Medium; this.Border = border; break; case SLNamedCellStyleValues.Heading4: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.Bold = true; font.SetFontThemeColor(SLThemeColorIndexValues.Dark2Color); this.Font = font; // no change to fill // no change to border break; case SLNamedCellStyleValues.Title: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Major, SLConstants.TitleFontSize); font.Bold = true; font.SetFontThemeColor(SLThemeColorIndexValues.Dark2Color); this.Font = font; // no change to fill // no change to border break; case SLNamedCellStyleValues.Total: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.Bold = true; font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; // no change to fill border = new SLBorder(this.listThemeColors, this.listIndexedColors); border.TopBorder.SetBorderThemeColor(SLThemeColorIndexValues.Accent1Color); border.TopBorder.BorderStyle = BorderStyleValues.Thin; border.BottomBorder.SetBorderThemeColor(SLThemeColorIndexValues.Accent1Color); border.BottomBorder.BorderStyle = BorderStyleValues.Double; this.Border = border; break; case SLNamedCellStyleValues.Accent1: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent1Color); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent1Percentage20: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent1Color, 0.799981688894314); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent1Percentage40: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent1Color, 0.599993896298105); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent1Percentage60: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent1Color, 0.399975585192419); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent2: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent2Color); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent2Percentage20: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent2Color, 0.799981688894314); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent2Percentage40: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent2Color, 0.599993896298105); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent2Percentage60: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent2Color, 0.399975585192419); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent3: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent3Color); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent3Percentage20: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent3Color, 0.799981688894314); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent3Percentage40: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent3Color, 0.599993896298105); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent3Percentage60: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent3Color, 0.399975585192419); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent4: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent4Color); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent4Percentage20: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent4Color, 0.799981688894314); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent4Percentage40: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent4Color, 0.599993896298105); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent4Percentage60: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent4Color, 0.399975585192419); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent5: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent5Color); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent5Percentage20: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent5Color, 0.799981688894314); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent5Percentage40: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent5Color, 0.599993896298105); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent5Percentage60: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent5Color, 0.399975585192419); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent6: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent6Color); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent6Percentage20: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent6Color, 0.799981688894314); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent6Percentage40: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Dark1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent6Color, 0.599993896298105); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Accent6Percentage60: // no change to format code font = new SLFont(this.MajorFont, this.MinorFont, this.listThemeColors, this.listIndexedColors); font.SetFont(FontSchemeValues.Minor, SLConstants.DefaultFontSize); font.SetFontThemeColor(SLThemeColorIndexValues.Light1Color); this.Font = font; fill = new SLFill(this.listThemeColors, this.listIndexedColors); fill.SetPatternForegroundColor(SLThemeColorIndexValues.Accent6Color, 0.399975585192419); fill.SetPatternType(PatternValues.Solid); this.Fill = fill; // no change to border break; case SLNamedCellStyleValues.Comma: this.FormatCode = "_(* #,##0.00_);_(* \\(#,##0.00\\);_(* \"-\"??_);_(@_)"; // not using the "builtin" format ID //this.nfFormatCode.NumberFormatId = 43; // the font, fill and border are not changed // TODO get "actual" comma character from regional settings? break; case SLNamedCellStyleValues.Comma0: this.FormatCode = "_(* #,##0_);_(* \\(#,##0\\);_(* \"-\"_);_(@_)"; // not using the "builtin" format ID //this.nfFormatCode.NumberFormatId = 41; // the font, fill and border are not changed // TODO get "actual" comma character from regional settings? break; case SLNamedCellStyleValues.Currency: this.FormatCode = "_(\"$\"* #,##0.00_);_(\"$\"* \\(#,##0.00\\);_(\"$\"* \"-\"??_);_(@_)"; // not using the "builtin" format ID //this.nfFormatCode.NumberFormatId = 44; // the font, fill and border are not changed // TODO get "actual" currency character from regional settings? break; case SLNamedCellStyleValues.Currency0: this.FormatCode = "_(\"$\"* #,##0_);_(\"$\"* \\(#,##0\\);_(\"$\"* \"-\"_);_(@_)"; // not using the "builtin" format ID //this.nfFormatCode.NumberFormatId = 42; // the font, fill and border are not changed // TODO get "actual" currency character from regional settings? break; case SLNamedCellStyleValues.Percentage: this.FormatCode = "0%"; // not using the "builtin" format ID //this.nfFormatCode.NumberFormatId = 9; // the font, fill and border are not changed break; } }
/// <summary> /// Remove any existing border properties. /// </summary> public void RemoveBorder() { this.BorderId = null; this.borderReal = new SLBorder(this.listThemeColors, this.listIndexedColors); HasBorder = false; }
private void SetAllNull() { List<System.Drawing.Color> listempty = new List<System.Drawing.Color>(); this.alignReal = new SLAlignment(); HasAlignment = false; this.protectionReal = new SLProtection(); HasProtection = false; this.nfFormatCode = new SLNumberingFormat(); HasNumberingFormat = false; this.fontReal = new SLFont(SLConstants.OfficeThemeMajorLatinFont, SLConstants.OfficeThemeMinorLatinFont, listempty, listempty); HasFont = false; this.fillReal = new SLFill(listempty, listempty); HasFill = false; this.borderReal = new SLBorder(listempty, listempty); HasBorder = false; }
internal void FromDifferentialType(X14.DifferentialType dt) { this.SetAllNull(); List<System.Drawing.Color> listempty = new List<System.Drawing.Color>(); if (dt.Font != null) { HasFont = true; this.fontReal = new SLFont(SLConstants.OfficeThemeMajorLatinFont, SLConstants.OfficeThemeMinorLatinFont, listempty, listempty); this.fontReal.FromFont(dt.Font); } if (dt.NumberingFormat != null) { HasNumberingFormat = true; this.nfFormatCode = new SLNumberingFormat(); this.nfFormatCode.FromNumberingFormat(dt.NumberingFormat); } if (dt.Fill != null) { HasFill = true; this.fillReal = new SLFill(listempty, listempty); this.fillReal.FromFill(dt.Fill); } if (dt.Alignment != null) { HasAlignment = true; this.alignReal = new SLAlignment(); this.alignReal.FromAlignment(dt.Alignment); } if (dt.Border != null) { HasBorder = true; this.borderReal = new SLBorder(listempty, listempty); this.borderReal.FromBorder(dt.Border); } if (dt.Protection != null) { HasProtection = true; this.protectionReal = new SLProtection(); this.protectionReal.FromProtection(dt.Protection); } Sync(); }
internal SLBorder Clone() { SLBorder b = new SLBorder(this.listThemeColors, this.listIndexedColors); b.HasLeftBorder = this.HasLeftBorder; b.bpLeftBorder = this.bpLeftBorder.Clone(); b.HasRightBorder = this.HasRightBorder; b.bpRightBorder = this.bpRightBorder.Clone(); b.HasTopBorder = this.HasTopBorder; b.bpTopBorder = this.bpTopBorder.Clone(); b.HasBottomBorder = this.HasBottomBorder; b.bpBottomBorder = this.bpBottomBorder.Clone(); b.HasDiagonalBorder = this.HasDiagonalBorder; b.bpDiagonalBorder = this.bpDiagonalBorder.Clone(); b.HasVerticalBorder = this.HasVerticalBorder; b.bpVerticalBorder = this.bpVerticalBorder.Clone(); b.HasHorizontalBorder = this.HasHorizontalBorder; b.bpHorizontalBorder = this.bpHorizontalBorder.Clone(); b.DiagonalUp = this.DiagonalUp; b.DiagonalDown = this.DiagonalDown; b.Outline = this.Outline; return b; }