internal static string GetFormatCode(IExtendedFormat format) { if (format.NumberFormat != null) { if (BuiltInNumberFomrat.ContainsKey(format.NumberFormat.NumberFormatId) && (BuiltInNumberFomrat[format.NumberFormat.NumberFormatId] != format.NumberFormat.NumberFormatCode)) { BuiltInNumberFomrat[format.NumberFormat.NumberFormatId] = format.NumberFormat.NumberFormatCode; return(format.NumberFormat.NumberFormatCode); } if (BuiltInNumberFomrat2.ContainsKey(format.NumberFormat.NumberFormatCode) && (BuiltInNumberFomrat2[format.NumberFormat.NumberFormatCode] != format.NumberFormat.NumberFormatId)) { BuiltInNumberFomrat2[format.NumberFormat.NumberFormatCode] = format.NumberFormat.NumberFormatId; return(format.NumberFormat.NumberFormatCode); } if (!_customNumberFormat.ContainsKey(format.NumberFormat.NumberFormatCode)) { _customNumberFormat.Add(format.NumberFormat.NumberFormatCode, format.NumberFormat.NumberFormatId); } return(format.NumberFormat.NumberFormatCode); } if (BuiltInNumberFomrat.ContainsKey(format.NumberFormatIndex)) { return(BuiltInNumberFomrat[format.NumberFormatIndex]); } if (LanguageIndepedentNumberFormat.ContainsKey(format.NumberFormatIndex)) { return(LanguageIndepedentNumberFormat[format.NumberFormatIndex]); } return("General"); }
internal static XFRecrod GetXFBiffRecord(IExtendedFormat style, ushort fontID, IExcelWriter writer) { XFRecrod recrod = new XFRecrod { FontIndex = fontID, FillPatternBackgroundColor = (byte)writer.GetPaletteColor(style.PatternBackgroundColor), FillPatternColor = (byte)writer.GetPaletteColor(style.PatternColor), FillPatternIndex = (byte)style.FillPattern, HAlignment = (byte)style.HorizontalAlign, VAlignment = (byte)style.VerticalAlign, IndentLevel = style.Indent, IsF123Prefix = style.IsFirstSymbolApostrophe, IsHidden = style.IsHidden, JustifyLastCharacter = style.IsJustfyLastLine, IsLocked = style.IsLocked, IsShrinkContent = style.IsShrinkToFit, IsWordWrap = style.IsWordWrap, Direction = (byte)style.ReadingOrder, TextRotation = (byte)style.Rotation, LeftBorderColorIndex = (byte)writer.GetPaletteColor(style.Border.Left.Color), LeftBorderLine = (byte)style.Border.Left.LineStyle, RightBorderColorIndex = (byte)writer.GetPaletteColor(style.Border.Right.Color), RightBorderLine = (byte)style.Border.Right.LineStyle, TopBorderColorIndex = (byte)writer.GetPaletteColor(style.Border.Top.Color), TopBorderLine = (byte)style.Border.Top.LineStyle, BottomBorderColorIndex = (byte)writer.GetPaletteColor(style.Border.Bottom.Color), BottomBorderLine = (byte)style.Border.Bottom.LineStyle, ApplyAlignment = style.ApplyAlignment, ApplyBorder = style.ApplyBorder, ApplyFont = style.ApplyFont, ApplyFill = style.ApplyFill, ApplyNumberFormat = style.ApplyNumberFormat, ApplyProtection = style.ApplyProtection }; if ((style is ExtendedFormat) && (style as ExtendedFormat).IsStyleFormat) { recrod.IsStyleXF = true; recrod.ParentXFIndex = 0xfff; } else { recrod.IsStyleXF = false; if (style.ParentFormatID.HasValue) { recrod.ParentXFIndex = (ushort)style.ParentFormatID.Value; } else { recrod.ParentXFIndex = 15; } } if (style.NumberFormat != null) { recrod.FormatIndex = (ushort)style.NumberFormat.NumberFormatId; return(recrod); } recrod.FormatIndex = (ushort)style.NumberFormatIndex; return(recrod); }
public static string GetFormatCode(IExtendedFormat format) { if (format.NumberFormat != null) { return(format.NumberFormat.NumberFormatCode); } if (_builtInNumberFomrat.ContainsKey(format.NumberFormatIndex)) { return(_builtInNumberFomrat[format.NumberFormatIndex]); } return(null); }
private void InitExcelColumnDefaultFormat() { this._columnFormat = ExtendedFormat.Default; if (this._owner != null) { if (this._owner.ExtendedFormats == null) { this._owner.ExtendedFormats = new Dictionary <int, IExtendedFormat>(); } this.FormatId = this._owner.ExtendedFormats.Count; this._owner.ExtendedFormats.Add(this._owner.ExtendedFormats.Count, this._columnFormat); } }
private void Init() { this.Is1904Date = false; this._precisionAsDisplay = true; this._recalculateBeforeSave = true; this.SaveExternalLinks = false; this._calculationMode = ExcelCalculationMode.Automatic; this._maximumIterations = 100; this._isIterataCalculate = false; this._maximumChange = 0.001; this._externWorkbooks = null; this._customOrFunctionNameList = null; this._builtInNameList = null; this._namedCellRanges = null; this._excelCellFormats = null; this._defaultCellFormat = null; this._excelCellFormats = null; this._defaultCellFormat = null; this._styleList = null; this._tableStyles = null; this._operator = null; this._sheets = null; this.FirstDisplayedTabIndex = 0; this.SelectedTabCount = 0; this._activeSheetIndex = 0; this.ActivePaneIndex = 0; this.TabStripPolicy = ExcelTabStripPolicy.Always; this._tabStripRatio = 0.6; this.VerticalScrollBarPolicy = ExcelScrollBarPolicy.AsNeeded; this.HorizontalScrollBarPolicy = ExcelScrollBarPolicy.AsNeeded; this._referenceStyle = ExcelReferenceStyle.A1; this.Locked = false; this.ExcelRect = null; this.IsWindowHidden = false; this.IsWindowDisplayAsIcon = false; if (this.ColorPalette != null) { this.ColorPalette = null; } if (this.DifferentialFormattings != null) { this.DifferentialFormattings = null; } this.Theme = null; }
public void SetExcelDefaultCellFormat(IExtendedFormat style) { this._workbook.DefaultCellFormat = style; }
public void SetExcelCellFormat(IExtendedFormat style) { Dictionary <int, IExtendedFormat> excelCellFormats = this._workbook.ExcelCellFormats; excelCellFormats.Add(excelCellFormats.Keys.Count, style); }