// Methods internal ExcelWorksheet(string name, ExcelWorksheetCollection parent) { this.defaultColumnWidth = 0x924; this.outlineRowButtonsBelow = true; this.outlineColumnButtonsRight = true; this.pageBreakViewZoom = 60; this.zoom = 100; this.windowOptions = WorksheetWindowOptions.ShowOutlineSymbols | (WorksheetWindowOptions.DefaultGridLineColor | (WorksheetWindowOptions.ShowGridLines | (WorksheetWindowOptions.ShowZeroValues | WorksheetWindowOptions.ShowSheetHeaders))); this.paperSize = 0; this.scalingFactor = 0xff; this.startPageNumber = 1; this.fitWorksheetWidthToPages = 0; this.fitWorksheetHeightToPages = 0; this.setupOptions = SetupOptions.Landscape; this.printResolution = 0; this.verticalPrintResolution = 0; this.headerMargin = 0.5; this.footerMargin = 0.5; this.numberOfCopies = 1; this.name = name; this.parent = parent; this.rows = new ExcelRowCollection(this); this.columns = new ExcelColumnCollection(this); this.mergedRanges = new MergedCellRanges(this); this.horizontalPageBreaks = new HorizontalPageBreakCollection(); this.verticalPageBreaks = new VerticalPageBreakCollection(); }
internal ExcelWorksheet(string name, ExcelWorksheetCollection parent, ExcelWorksheet sourceWorksheet) { this.defaultColumnWidth = 0x924; this.outlineRowButtonsBelow = true; this.outlineColumnButtonsRight = true; this.pageBreakViewZoom = 60; this.zoom = 100; this.windowOptions = WorksheetWindowOptions.ShowOutlineSymbols | (WorksheetWindowOptions.DefaultGridLineColor | (WorksheetWindowOptions.ShowGridLines | (WorksheetWindowOptions.ShowZeroValues | WorksheetWindowOptions.ShowSheetHeaders))); this.paperSize = 0; this.scalingFactor = 0xff; this.startPageNumber = 1; this.fitWorksheetWidthToPages = 0; this.fitWorksheetHeightToPages = 0; this.setupOptions = SetupOptions.Landscape; this.printResolution = 0; this.verticalPrintResolution = 0; this.headerMargin = 0.5; this.footerMargin = 0.5; this.numberOfCopies = 1; this.name = name; this.parent = parent; this.protectedWorksheet = sourceWorksheet.protectedWorksheet; this.rows = new ExcelRowCollection(this, sourceWorksheet.rows); this.columns = new ExcelColumnCollection(this, sourceWorksheet.columns); this.defaultColumnWidth = sourceWorksheet.defaultColumnWidth; this.mergedRanges = new MergedCellRanges(this, sourceWorksheet.mergedRanges); this.outlineRowButtonsBelow = sourceWorksheet.outlineRowButtonsBelow; this.outlineColumnButtonsRight = sourceWorksheet.outlineColumnButtonsRight; if (sourceWorksheet.PreservedWorksheetRecords != null) { this.PreservedWorksheetRecords = new PreservedRecords(sourceWorksheet.PreservedWorksheetRecords); } this.windowOptions = sourceWorksheet.windowOptions & ((WorksheetWindowOptions)(-1537)); this.firstVisibleRow = sourceWorksheet.firstVisibleRow; this.firstVisibleColumn = sourceWorksheet.firstVisibleColumn; this.pageBreakViewZoom = sourceWorksheet.pageBreakViewZoom; this.zoom = sourceWorksheet.zoom; this.horizontalPageBreaks = new HorizontalPageBreakCollection(sourceWorksheet.horizontalPageBreaks); this.verticalPageBreaks = new VerticalPageBreakCollection(sourceWorksheet.verticalPageBreaks); this.paperSize = sourceWorksheet.paperSize; this.scalingFactor = sourceWorksheet.scalingFactor; this.startPageNumber = sourceWorksheet.startPageNumber; this.fitWorksheetWidthToPages = sourceWorksheet.fitWorksheetWidthToPages; this.fitWorksheetHeightToPages = sourceWorksheet.fitWorksheetHeightToPages; this.setupOptions = sourceWorksheet.setupOptions; this.printResolution = sourceWorksheet.printResolution; this.verticalPrintResolution = sourceWorksheet.verticalPrintResolution; this.headerMargin = sourceWorksheet.headerMargin; this.footerMargin = sourceWorksheet.footerMargin; this.numberOfCopies = sourceWorksheet.numberOfCopies; this.namedRanges = new NamedRangeCollection(this, sourceWorksheet.NamedRanges); }
///<summary> ///Converts the name record range to RPN bytes. ///</summary> ///<param name="range">The range to be converted.</param> ///<param name="sheetName">Sheet' name.</param> ///<param name="worksheets">The worksheets collection.</param> public static byte[] ConvertNameRecordRangeToRpnBytes(CellRange range, string sheetName, ExcelWorksheetCollection worksheets) { FormulaToken token1 = null; string text1 = string.Empty; if ((range.Width == 1) && (range.Height == 1)) { Match match1 = RefFormulaToken.IsCellRegex.Match(range.ToString()); string text2 = NameRecord.ConvertToAbsolute(match1.Groups["Row"].Value); string text3 = NameRecord.ConvertToAbsolute(match1.Groups["Column"].Value); text1 = sheetName + "!" + text3 + text2; token1 = new Ref3dFormulaToken(FormulaTokenCode.Ref3d1); } else { Match match2 = AreaFormulaToken.IsCellRangeRegex.Match(range.ToString()); string text4 = NameRecord.ConvertToAbsolute(match2.Groups["Row1"].Value); string text5 = NameRecord.ConvertToAbsolute(match2.Groups["Column1"].Value); string text6 = NameRecord.ConvertToAbsolute(match2.Groups["Row2"].Value); string text7 = NameRecord.ConvertToAbsolute(match2.Groups["Column2"].Value); string[] textArray1 = new string[] { sheetName, "!", text5, text4, ":", text7, text6 }; text1 = string.Concat(textArray1); token1 = new Area3dFormulaToken(FormulaTokenCode.Area3d1); } object[] objArray1 = new object[] { text1, worksheets }; token1.DelayInitialize(objArray1); return(token1.ConvertToBytes()); }