/// <summary> /// Get the spreadsheet's theme settings. /// </summary> /// <returns></returns> public SLThemeSettings GetThemeSettings() { SLThemeSettings ts = new SLThemeSettings(); ts.ThemeName = SimpleTheme.ThemeName; ts.MajorLatinFont = SimpleTheme.MajorLatinFont; ts.MinorLatinFont = SimpleTheme.MinorLatinFont; ts.Dark1Color = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Dark1Color]; ts.Light1Color = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Light1Color]; ts.Dark2Color = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Dark2Color]; ts.Light2Color = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Light2Color]; ts.Accent1Color = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Accent1Color]; ts.Accent2Color = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Accent2Color]; ts.Accent3Color = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Accent3Color]; ts.Accent4Color = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Accent4Color]; ts.Accent5Color = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Accent5Color]; ts.Accent6Color = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Accent6Color]; ts.Hyperlink = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.Hyperlink]; ts.FollowedHyperlinkColor = SimpleTheme.listThemeColors[(int)SLThemeColorIndexValues.FollowedHyperlinkColor]; return ts; }
internal SLSimpleTheme(WorkbookPart wbp, SLThemeSettings Settings) { LoadIndexedColors(wbp); InitialiseThemeColors(); InternalThemeType = SLThemeTypeValues.Office; bool bHasTheme = (wbp.ThemePart != null) ? true : false; if (bHasTheme) { // load in default values in case the theme file has missing values LoadBuiltinTheme(SLThemeTypeValues.Office); LoadTheme(wbp); } else { LoadBuiltinTheme(SLThemeTypeValues.Office); this.sThemeName = Settings.ThemeName; this.sMajorLatinFont = Settings.MajorLatinFont; this.sMinorLatinFont = Settings.MinorLatinFont; listThemeColors[(int)SLThemeColorIndexValues.Dark1Color] = Settings.Dark1Color; listThemeColors[(int)SLThemeColorIndexValues.Light1Color] = Settings.Light1Color; listThemeColors[(int)SLThemeColorIndexValues.Dark2Color] = Settings.Dark2Color; listThemeColors[(int)SLThemeColorIndexValues.Light2Color] = Settings.Light2Color; listThemeColors[(int)SLThemeColorIndexValues.Accent1Color] = Settings.Accent1Color; listThemeColors[(int)SLThemeColorIndexValues.Accent2Color] = Settings.Accent2Color; listThemeColors[(int)SLThemeColorIndexValues.Accent3Color] = Settings.Accent3Color; listThemeColors[(int)SLThemeColorIndexValues.Accent4Color] = Settings.Accent4Color; listThemeColors[(int)SLThemeColorIndexValues.Accent5Color] = Settings.Accent5Color; listThemeColors[(int)SLThemeColorIndexValues.Accent6Color] = Settings.Accent6Color; listThemeColors[(int)SLThemeColorIndexValues.Hyperlink] = Settings.Hyperlink; listThemeColors[(int)SLThemeColorIndexValues.FollowedHyperlinkColor] = Settings.FollowedHyperlinkColor; for (int i = 0; i < listThemeColors.Count; ++i) { listThemeColorsHex[i] = string.Format("{0}{1}{2}", listThemeColors[i].R.ToString("x2"), listThemeColors[i].G.ToString("x2"), listThemeColors[i].B.ToString("x2")); } } CalculateRowColumnInfo(); }
private void InitialiseStylesheetWhatNots(SLThemeSettings ThemeSettings) { SimpleTheme = new SLSimpleTheme(wbp, ThemeSettings); this.LoadStylesheet(); }
/// <summary> /// Create a new spreadsheet with a custom theme. /// </summary> /// <param name="ThemeSettings">Custom theme settings.</param> public SLDocument(SLThemeSettings ThemeSettings) { memstream = new MemoryStream(); xl = SpreadsheetDocument.Create(memstream, SpreadsheetDocumentType.Workbook); wbp = xl.AddWorkbookPart(); IsNewSpreadsheet = true; slwb = new SLWorkbook(); this.DocumentProperties = new SLDocumentProperties(); this.DocumentProperties.Created = DateTime.UtcNow.ToString(SLConstants.W3CDTF); InitialiseAutoFitCache(); LoadBuiltInNumberingFormats(); InitialiseStylesheetWhatNots(ThemeSettings); LoadSharedStringTable(); InitialiseNewSpreadsheet(); }