menu

ASP.NET Web Forms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class PageSetupBaseImpl

    Show / Hide Table of Contents

    Class PageSetupBaseImpl

    Summary description for PageSetupBaseImpl.

    Inheritance
    System.Object
    CommonObject
    PageSetupBaseImpl
    ChartPageSetupImpl
    PageSetupImpl
    Implements
    System.IDisposable
    IPageSetupBase
    IParentApplication
    IBiffStorage
    Inherited Members
    CommonObject.m_bIsDisposed
    CommonObject.FindParent(Type)
    CommonObject.FindParent(Type, Boolean)
    CommonObject.FindParent(Object, Type)
    CommonObject.FindParent(Object, Type, Boolean)
    CommonObject.FindParents(Type[])
    CommonObject.FindParent(Type[])
    CommonObject.SetParent(Object)
    CommonObject.CheckDisposed()
    CommonObject.AddReference()
    CommonObject.ReleaseReference()
    CommonObject.OnDispose()
    CommonObject.Application
    CommonObject.Parent
    CommonObject.AppImplementation
    CommonObject.ReferenceCount
    System.Object.ToString()
    System.Object.Equals(System.Object)
    System.Object.Equals(System.Object, System.Object)
    System.Object.ReferenceEquals(System.Object, System.Object)
    System.Object.GetHashCode()
    System.Object.GetType()
    System.Object.MemberwiseClone()
    Namespace: Syncfusion.XlsIO.Implementation
    Assembly: Syncfusion.XlsIO.Base.dll
    Syntax
    public class PageSetupBaseImpl : CommonObject, IDisposable, IPageSetupBase, IParentApplication, IBiffStorage

    Constructors

    PageSetupBaseImpl(IApplication, Object)

    Sets application and parent fields.

    Declaration
    public PageSetupBaseImpl(IApplication application, object parent)
    Parameters
    Type Name Description
    IApplication application

    Application object for the page setup.

    System.Object parent

    Parent object for the page setup.

    Fields

    DEFAULT_BOTTOMMARGIN

    Value of the bottom margin by default.

    Declaration
    public const double DEFAULT_BOTTOMMARGIN = 1
    Field Value
    Type Description
    System.Double

    DEFAULT_LEFTMARGIN

    Value of the left margin by default.

    Declaration
    public const double DEFAULT_LEFTMARGIN = 0.75
    Field Value
    Type Description
    System.Double

    DEFAULT_RIGHTMARGIN

    Value of the right margin by default.

    Declaration
    public const double DEFAULT_RIGHTMARGIN = 0.75
    Field Value
    Type Description
    System.Double

    DEFAULT_TOPMARGIN

    Value of the top margin by default.

    Declaration
    public const double DEFAULT_TOPMARGIN = 1
    Field Value
    Type Description
    System.Double

    m_arrFooters

    Array of footers: 0 - left footer, 1 - center footer, 2 - right footer.

    Declaration
    [CLSCompliant(false)]
    protected string[] m_arrFooters
    Field Value
    Type Description
    System.String[]

    m_arrHeaders

    Array of headers: 0 - left header, 1 - center header, 2 - right header.

    Declaration
    [CLSCompliant(false)]
    protected string[] m_arrHeaders
    Field Value
    Type Description
    System.String[]

    m_backgroundImage

    Contains background image.

    Declaration
    [CLSCompliant(false)]
    protected BitmapRecord m_backgroundImage
    Field Value
    Type Description
    BitmapRecord

    m_bHCenter

    Whether to center between horizontal margins.

    Declaration
    protected bool m_bHCenter
    Field Value
    Type Description
    System.Boolean

    m_bVCenter

    Whether to center between vertical margins.

    Declaration
    protected bool m_bVCenter
    Field Value
    Type Description
    System.Boolean

    m_dBottomMargin

    This record contains information about worksheet bottom margin.

    Declaration
    [CLSCompliant(false)]
    protected double m_dBottomMargin
    Field Value
    Type Description
    System.Double

    m_dLeftMargin

    This record contains information about worksheet left margin.

    Declaration
    [CLSCompliant(false)]
    protected double m_dLeftMargin
    Field Value
    Type Description
    System.Double

    m_dRightMargin

    This record contains information about worksheet right margin.

    Declaration
    [CLSCompliant(false)]
    protected double m_dRightMargin
    Field Value
    Type Description
    System.Double

    m_dTopMargin

    This record contains information about worksheet top margin.

    Declaration
    [CLSCompliant(false)]
    protected double m_dTopMargin
    Field Value
    Type Description
    System.Double

    m_headerFooter

    Stores print setup options.

    Declaration
    [CLSCompliant(false)]
    protected HeaderAndFooterRecord m_headerFooter
    Field Value
    Type Description
    HeaderAndFooterRecord

    m_setup

    Stores print setup options.

    Declaration
    [CLSCompliant(false)]
    protected PrintSetupRecord m_setup
    Field Value
    Type Description
    PrintSetupRecord

    m_unknown

    Unknown record. This record contains additional information about system printer. If such record is found, it is stored, otherwise we is skipped.

    Declaration
    [CLSCompliant(false)]
    protected PrinterSettingsRecord m_unknown
    Field Value
    Type Description
    PrinterSettingsRecord

    Properties

    AlignHFWithPageMargins

    Indicates whether the header and footer margins are aligned with page margins. Read/Write Boolean.

    Declaration
    public bool AlignHFWithPageMargins { get; set; }
    Property Value
    Type Description
    System.Boolean

    AutoFirstPageNumber

    Indicates whether FirstPageNumber is set to Auto or not.

    Declaration
    public bool AutoFirstPageNumber { get; set; }
    Property Value
    Type Description
    System.Boolean

    BackgoundImage

    Gets / sets background image.

    Declaration
    public Bitmap BackgoundImage { get; set; }
    Property Value
    Type Description
    System.Drawing.Bitmap

    BlackAndWhite

    True if elements of the document will be printed in black and white. Read/write Boolean.

    Declaration
    public bool BlackAndWhite { get; set; }
    Property Value
    Type Description
    System.Boolean

    BottomMargin

    Gets or sets the size of the bottom margin, in inches. Read / write Double.

    Declaration
    public double BottomMargin { get; set; }
    Property Value
    Type Description
    System.Double

    CenterFooter

    Gets or sets the center part of the footer. Read / write String. Special Formatting symbols: &P Current page number &N Page count &D Current date &T Current time &A Sheet name (BIFF5-BIFF8) &F File name without path &Z File path without file name (BIFF8X) &G Picture (BIFF8X) &B Bold on/off (BIFF2-BIFF4) &I Italic on/off (BIFF2-BIFF4) &U Underlining on/off &E Double underlining on/off (BIFF5-BIFF8) &S Strikeout on/off &X Superscript on/off (BIFF5-BIFF8) &Y Subscript on/off (BIFF5-BIFF8) &"[FONTNAME]" Set new font [FONTNAME] &"[FONTNAME],[FONTSTYLE]" Set new font with specified style [FONTSTYLE]. The style [fontstyle] is in most cases one of Regular, Bold, Italic, or Bold Italic. But this setting is dependent on the used font, it may differ (localised style names, or Standard, Oblique, ...). (BIFF5-BIFF8) &[FONTHEIGHT] Set font height in points ([FONTHEIGHT] is a decimal value). If this command is followed by a plain number to be printed in the header, it will be separated from the font height with a space character.

    Declaration
    public string CenterFooter { get; set; }
    Property Value
    Type Description
    System.String

    CenterFooterImage

    Gets / set image for center part of the footer.

    Declaration
    public Image CenterFooterImage { get; set; }
    Property Value
    Type Description
    System.Drawing.Image

    CenterHeader

    Gets or sets the center part of the header. Read/write String. Special Formatting symbols: &P Current page number &N Page count &D Current date &T Current time &A Sheet name (BIFF5-BIFF8) &F File name without path &Z File path without file name (BIFF8X) &G Picture (BIFF8X) &B Bold on/off (BIFF2-BIFF4) &I Italic on/off (BIFF2-BIFF4) &U Underlining on/off &E Double underlining on/off (BIFF5-BIFF8) &S Strikeout on/off &X Superscript on/off (BIFF5-BIFF8) &Y Subscript on/off (BIFF5-BIFF8) &"[FONTNAME]" Set new font [FONTNAME] &"[FONTNAME],[FONTSTYLE]" Set new font with specified style [FONTSTYLE]. The style [fontstyle] is in most cases one of Regular, Bold, Italic, or Bold Italic. But this setting is dependent on the used font, it may differ (localised style names, or Standard, Oblique, ...). (BIFF5-BIFF8) &[FONTHEIGHT] Set font height in points ([FONTHEIGHT] is a decimal value). If this command is followed by a plain number to be printed in the header, it will be separated from the font height with a space character.

    Declaration
    public string CenterHeader { get; set; }
    Property Value
    Type Description
    System.String

    CenterHeaderImage

    Gets / set image for center part of the header.

    Declaration
    public Image CenterHeaderImage { get; set; }
    Property Value
    Type Description
    System.Drawing.Image

    CenterHorizontally

    True if the sheet is centered horizontally on the page when it is printed. Read/write Boolean.

    Declaration
    public bool CenterHorizontally { get; set; }
    Property Value
    Type Description
    System.Boolean

    CenterVertically

    True if the sheet is centered vertically on the page when it is printed. Read/write Boolean.

    Declaration
    public bool CenterVertically { get; set; }
    Property Value
    Type Description
    System.Boolean

    Copies

    Number of copies to print.

    Declaration
    public int Copies { get; set; }
    Property Value
    Type Description
    System.Int32

    DifferentFirstPageHF

    True - The header / footer of the first page is different with other pages.False otherwise.

    Declaration
    public bool DifferentFirstPageHF { get; set; }
    Property Value
    Type Description
    System.Boolean

    DifferentOddAndEvenPagesHF

    True - The header/footer odd pages are differed with even page. False otherwise.

    Declaration
    public bool DifferentOddAndEvenPagesHF { get; set; }
    Property Value
    Type Description
    System.Boolean

    Draft

    True if the sheet will be printed without graphics. Read/write Boolean.

    Declaration
    public bool Draft { get; set; }
    Property Value
    Type Description
    System.Boolean

    EvenPage

    Gets values for even page

    Declaration
    public IPage EvenPage { get; }
    Property Value
    Type Description
    IPage

    FirstPage

    Gets values for first page

    Declaration
    public IPage FirstPage { get; }
    Property Value
    Type Description
    IPage

    FirstPageNumber

    Gets or sets the first page number that will be used when this sheet is printed.

    Declaration
    public short FirstPageNumber { get; set; }
    Property Value
    Type Description
    System.Int16

    FitToPagesTall

    Returns or sets the height of the pages that the worksheet will be scaled to when it is printed. Applies only to worksheets. Read/write Boolean.

    Declaration
    public int FitToPagesTall { get; set; }
    Property Value
    Type Description
    System.Int32

    FitToPagesWide

    Returns or sets the width of the pages the worksheet will be scaled to when it is printed. Applies only to worksheets. Read/write Boolean.

    Declaration
    public int FitToPagesWide { get; set; }
    Property Value
    Type Description
    System.Int32

    FooterMargin

    Gets or sets the distance from the bottom of the page to the footer, in inches. Read/write Double.

    Declaration
    public double FooterMargin { get; set; }
    Property Value
    Type Description
    System.Double

    FullFooterString

    Gets footer full string. Read/write.

    Declaration
    public string FullFooterString { get; set; }
    Property Value
    Type Description
    System.String

    FullHeaderString

    Represents full header string. Read/write.

    Declaration
    public string FullHeaderString { get; set; }
    Property Value
    Type Description
    System.String

    HeaderMargin

    Gets or sets the distance from the top of the page to the header, in inches. Read/write Double.

    Declaration
    public double HeaderMargin { get; set; }
    Property Value
    Type Description
    System.Double

    HFScaleWithDoc

    Indicates whether the header and footer are scaled with document scaling.Read/Write Boolean.

    Declaration
    public bool HFScaleWithDoc { get; set; }
    Property Value
    Type Description
    System.Boolean

    HResolution

    Gets / sets horizontal resolution in dpi.

    Declaration
    public int HResolution { get; set; }
    Property Value
    Type Description
    System.Int32

    IsFitToPage

    Indicates whether fit to page mode is selected.

    Declaration
    public virtual bool IsFitToPage { get; set; }
    Property Value
    Type Description
    System.Boolean

    IsNotValidSettings

    True if paper size, scaling factor, paper orientation (portrait / landscape), print resolution, and number of copies are not initialized.

    Declaration
    public bool IsNotValidSettings { get; }
    Property Value
    Type Description
    System.Boolean

    LeftFooter

    Gets or sets the left part of the footer. Read/write String.

    Declaration
    public string LeftFooter { get; set; }
    Property Value
    Type Description
    System.String
    Remarks

    Special Formatting symbols: &P Current page number &N Page count &D Current date &T Current time &A Sheet name (BIFF5-BIFF8) &F File name without path &Z File path without file name (BIFF8X) &G Picture (BIFF8X) &B Bold on/off (BIFF2-BIFF4) &I Italic on/off (BIFF2-BIFF4) &U Underlining on/off &E Double underlining on/off (BIFF5-BIFF8) &S Strikeout on/off &X Superscript on/off (BIFF5-BIFF8) &Y Subscript on/off (BIFF5-BIFF8) &"[FONTNAME]" Set new font [FONTNAME] &"[FONTNAME],[FONTSTYLE]" Set new font with specified style [FONTSTYLE]. The style [fontstyle] is in most cases one of Regular, Bold, Italic, or Bold Italic. But this setting is dependent on the used font, it may differ (localized style names, or Standard, Oblique, ...). (BIFF5-BIFF8) &[FONTHEIGHT] Set font height in points ([FONTHEIGHT] is a decimal value). If this command is followed by a plain number to be printed in the header, it will be separated from the font height with a space character.

    LeftFooterImage

    Gets / set image for left part of the footer.

    Declaration
    public Image LeftFooterImage { get; set; }
    Property Value
    Type Description
    System.Drawing.Image

    LeftHeader

    Gets or sets the left part of the header. Read/write String.

    Declaration
    public string LeftHeader { get; set; }
    Property Value
    Type Description
    System.String
    Remarks

    Special Formatting symbols: &P Current page number &N Page count &D Current date &T Current time &A Sheet name (BIFF5-BIFF8) &F File name without path &Z File path without file name (BIFF8X) &G Picture (BIFF8X) &B Bold on/off (BIFF2-BIFF4) &I Italic on/off (BIFF2-BIFF4) &U Underlining on/off &E Double underlining on/off (BIFF5-BIFF8) &S Strikeout on/off &X Superscript on/off (BIFF5-BIFF8) &Y Subscript on/off (BIFF5-BIFF8) &"[FONTNAME]" Set new font [FONTNAME] &"[FONTNAME],[FONTSTYLE]" Set new font with specified style [FONTSTYLE]. The style [fontstyle] is in most cases one of Regular, Bold, Italic, or Bold Italic. But this setting is dependent on the used font, it may differ (localised style names, or Standard, Oblique, ...). (BIFF5-BIFF8) &[FONTHEIGHT] Set font height in points ([FONTHEIGHT] is a decimal value). If this command is followed by a plain number to be printed in the header, it will be separated from the font height with a space character.

    LeftHeaderImage

    Gets / set image for left part of the header.

    Declaration
    public Image LeftHeaderImage { get; set; }
    Property Value
    Type Description
    System.Drawing.Image

    LeftMargin

    Gets or sets the size of the left margin, in inches. Read/write Double.

    Declaration
    public double LeftMargin { get; set; }
    Property Value
    Type Description
    System.Double

    NeedDataArray

    Indicates whether data array is required by this record.

    Declaration
    public bool NeedDataArray { get; }
    Property Value
    Type Description
    System.Boolean

    Order

    Gets or sets the order that Microsoft Excel uses to number pages when printing a large worksheet. Read / write ExcelOrder.

    Declaration
    public ExcelOrder Order { get; set; }
    Property Value
    Type Description
    ExcelOrder

    Orientation

    Portrait or landscape printing mode. Read/write ExcelPageOrientation.

    Declaration
    public ExcelPageOrientation Orientation { get; set; }
    Property Value
    Type Description
    ExcelPageOrientation

    PageHeight

    Returns page width in points. Read-only.

    Declaration
    public double PageHeight { get; }
    Property Value
    Type Description
    System.Double

    PageWidth

    Returns page width in points. Read-only.

    Declaration
    public double PageWidth { get; }
    Property Value
    Type Description
    System.Double

    PaperSize

    Gets or sets the size of the paper. Read / write ExcelPaperSize.

    Declaration
    public ExcelPaperSize PaperSize { get; set; }
    Property Value
    Type Description
    ExcelPaperSize

    PrintComments

    Gets or sets the way comments are printed with the sheet. Read/write ExcelPrintLocation.

    Declaration
    public ExcelPrintLocation PrintComments { get; set; }
    Property Value
    Type Description
    ExcelPrintLocation

    PrintErrors

    Sets or returns an ExcelPrintErrors constant specifying the type of print error displayed. This feature allows users to suppress the display of error values when printing a worksheet. Read/write.

    Declaration
    public ExcelPrintErrors PrintErrors { get; set; }
    Property Value
    Type Description
    ExcelPrintErrors

    PrintNotes

    True if cell notes are printed as end notes with the sheet. Applies only to worksheets. Read/write Boolean.

    Declaration
    public bool PrintNotes { get; set; }
    Property Value
    Type Description
    System.Boolean

    PrintQuality

    Gets or sets the print quality. Read / write ushort.

    Declaration
    public int PrintQuality { get; set; }
    Property Value
    Type Description
    System.Int32

    RecordCode

    Returns code of the biff storage. Read-only.

    Declaration
    public int RecordCode { get; }
    Property Value
    Type Description
    System.Int32

    RightFooter

    Gets or sets the right part of the footer. Read / write String.

    Declaration
    public string RightFooter { get; set; }
    Property Value
    Type Description
    System.String
    Remarks

    Special Formatting symbols: &P Current page number &N Page count &D Current date &T Current time &A Sheet name (BIFF5-BIFF8) &F File name without path &Z File path without file name (BIFF8X) &G Picture (BIFF8X) &B Bold on/off (BIFF2-BIFF4) &I Italic on/off (BIFF2-BIFF4) &U Underlining on/off &E Double underlining on/off (BIFF5-BIFF8) &S Strikeout on/off &X Superscript on/off (BIFF5-BIFF8) &Y Subscript on/off (BIFF5-BIFF8) &"[FONTNAME]" Set new font [FONTNAME] &"[FONTNAME],[FONTSTYLE]" Set new font with specified style [FONTSTYLE]. The style [fontstyle] is in most cases one of Regular, Bold, Italic, or Bold Italic. But this setting is dependent on the used font, it may differ (localised style names, or Standard, Oblique, ...). (BIFF5-BIFF8) &[FONTHEIGHT] Set font height in points ([FONTHEIGHT] is a decimal value). If this command is followed by a plain number to be printed in the header, it will be separated from the font height with a space character.

    RightFooterImage

    Gets / set image for right part of the footer.

    Declaration
    public Image RightFooterImage { get; set; }
    Property Value
    Type Description
    System.Drawing.Image

    RightHeader

    Gets or sets the right part of the header. Read / write String. Special Formatting symbols: &P Current page number &N Page count &D Current date &T Current time &A Sheet name (BIFF5-BIFF8) &F File name without path &Z File path without file name (BIFF8X) &G Picture (BIFF8X) &B Bold on/off (BIFF2-BIFF4) &I Italic on/off (BIFF2-BIFF4) &U Underlining on/off &E Double underlining on/off (BIFF5-BIFF8) &S Strikeout on/off &X Superscript on/off (BIFF5-BIFF8) &Y Subscript on/off (BIFF5-BIFF8) &"[FONTNAME]" Set new font [FONTNAME] &"[FONTNAME],[FONTSTYLE]" Set new font with specified style [FONTSTYLE]. The style [fontstyle] is in most cases one of Regular, Bold, Italic, or Bold Italic. But this setting is dependent on the used font, it may differ (localised style names, or Standard, Oblique, ...). (BIFF5-BIFF8) &[FONTHEIGHT] Set font height in points ([FONTHEIGHT] is a decimal value). If this command is followed by a plain number to be printed in the header, it will be separated from the font height with a space character.

    Declaration
    public string RightHeader { get; set; }
    Property Value
    Type Description
    System.String

    RightHeaderImage

    Gets / set image for right part of the header.

    Declaration
    public Image RightHeaderImage { get; set; }
    Property Value
    Type Description
    System.Drawing.Image

    RightMargin

    Returns or sets the size of the right margin, in inches. Read/write Double.

    Declaration
    public double RightMargin { get; set; }
    Property Value
    Type Description
    System.Double

    StreamPos

    Indicates record position in stream. This is a utility member of class and is used only in the serialization process. Does not influence the data.

    Declaration
    public long StreamPos { get; set; }
    Property Value
    Type Description
    System.Int64

    TopMargin

    Gets or sets the size of the top margin, in points. Read/write Double.

    Declaration
    public double TopMargin { get; set; }
    Property Value
    Type Description
    System.Double

    TypeCode

    Returns type code of the biff storage. Read-only.

    Declaration
    public TBIFFRecord TypeCode { get; }
    Property Value
    Type Description
    TBIFFRecord

    VResolution

    Gets / sets vertical resolution in dpi.

    Declaration
    public int VResolution { get; set; }
    Property Value
    Type Description
    System.Int32

    Zoom

    Gets or sets a percentage (between 10 and 400 percent) by which Microsoft Excel will scale the worksheet for printing. Applies only to worksheets. Read/write ushort.

    Declaration
    public int Zoom { get; set; }
    Property Value
    Type Description
    System.Int32

    Methods

    CreateHeaderFooterString(String[])

    Function combines header or footer strings array to one format string.

    Declaration
    protected string CreateHeaderFooterString(string[] parts)
    Parameters
    Type Name Description
    System.String[] parts

    Array which must contain only 3 elements.

    Returns
    Type Description
    System.String

    Combined format string.

    Exceptions
    Type Condition
    System.ArgumentNullException

    When parameter is null.

    System.ArgumentException

    When number of strings in parts is not 3.

    Dispose()

    Dispose Page Setup Base

    Declaration
    public override void Dispose()
    Overrides
    CommonObject.Dispose()

    FillStream(BinaryWriter, DataProvider, IEncryptor, Int32)

    Save record data to stream.

    Declaration
    public int FillStream(BinaryWriter writer, DataProvider provider, IEncryptor encryptor, int streamPosition)
    Parameters
    Type Name Description
    System.IO.BinaryWriter writer

    Writer that will receive record data.

    DataProvider provider

    Object that provides access to the data.

    IEncryptor encryptor

    Object to encrypt data.

    System.Int32 streamPosition

    Position in the output stream. Used to increase performance.

    Returns
    Type Description
    System.Int32

    Size of the record.

    Exceptions
    Type Condition
    System.ArgumentNullException

    If writer is NULL.

    System.ApplicationException

    If m_iLength of internal record data array is less than zero.

    FillStreamEnd(BinaryWriter, DataProvider, IEncryptor, Int32)

    Fills stream with some records after main page setup records.

    Declaration
    protected virtual int FillStreamEnd(BinaryWriter writer, DataProvider provider, IEncryptor encryptor, int streamPosition)
    Parameters
    Type Name Description
    System.IO.BinaryWriter writer

    Writer to write records into.

    DataProvider provider

    Object that gives access to the temporary buffer.

    IEncryptor encryptor

    Object to encrypt data.

    System.Int32 streamPosition

    Position in the output stream. Used to increase performance.

    Returns
    Type Description
    System.Int32

    Size of the serialized data.

    FillStreamStart(BinaryWriter, DataProvider, IEncryptor, Int32)

    Fills stream with some records before main page setup records.

    Declaration
    protected virtual int FillStreamStart(BinaryWriter writer, DataProvider provider, IEncryptor encryptor, int streamPosition)
    Parameters
    Type Name Description
    System.IO.BinaryWriter writer

    Writer to write records into.

    DataProvider provider

    Object that gives access to the temporary buffer.

    IEncryptor encryptor

    Object to encrypt data.

    System.Int32 streamPosition

    Position in the output stream. Used to increase performance.

    Returns
    Type Description
    System.Int32

    Size of the serialized data.

    FindParents()

    Find parent Worksheet.

    Declaration
    protected virtual void FindParents()
    Exceptions
    Type Condition
    System.ArgumentException

    Can't find parent worksheet.

    GetOrCreateRecord(IList, ref Int32, TBIFFRecord)

    Returns record of the specified type from the array of Biff records and sets its position after the returned record.

    Declaration
    [CLSCompliant(false)]
    protected BiffRecordRaw GetOrCreateRecord(IList data, ref int pos, TBIFFRecord type)
    Parameters
    Type Name Description
    System.Collections.IList data

    Array of Biff records.

    System.Int32 pos

    Starting from this position, record must be searched.

    TBIFFRecord type

    Type of the needed record.

    Returns
    Type Description
    Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw

    Biff record if it was found, null otherwise.

    GetRecordUpdatePos(IList, ref Int32)

    Returns current record from the Biff records array and updates its position by 1.

    Declaration
    [CLSCompliant(false)]
    protected BiffRecordRaw GetRecordUpdatePos(IList data, ref int pos)
    Parameters
    Type Name Description
    System.Collections.IList data

    Array of Biff records.

    System.Int32 pos

    Position of the record in the array that will be returned.

    Returns
    Type Description
    Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw

    Current record from array.

    GetRecordUpdatePos(IList, ref Int32, TBIFFRecord)

    Returns record of the specified type from the array of Biff records and sets its position after the returned record.

    Declaration
    [CLSCompliant(false)]
    protected BiffRecordRaw GetRecordUpdatePos(IList data, ref int pos, TBIFFRecord type)
    Parameters
    Type Name Description
    System.Collections.IList data

    Array of Biff records.

    System.Int32 pos

    Starting from this position, record must be searched.

    TBIFFRecord type

    Type of the needed record.

    Returns
    Type Description
    Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw

    Biff record if it was found, null otherwise.

    GetStoreSize(ExcelVersion)

    Size of the required storage space. Read-only.

    Declaration
    public virtual int GetStoreSize(ExcelVersion version)
    Parameters
    Type Name Description
    ExcelVersion version
    Returns
    Type Description
    System.Int32

    Parse(IList<BiffRecordRaw>, Int32)

    Parses page setup.

    Declaration
    public virtual int Parse(IList<BiffRecordRaw> data, int position)
    Parameters
    Type Name Description
    System.Collections.Generic.IList<Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw> data

    Array with biff records.

    System.Int32 position

    Starting position.

    Returns
    Type Description
    System.Int32

    Position after parsing.

    ParseHeaderFooterString(String)

    This function splits header or footer into three parts left, center, and right.

    Declaration
    protected string[] ParseHeaderFooterString(string strToSplit)
    Parameters
    Type Name Description
    System.String strToSplit

    Header (footer) string that will be split into parts: left, center, right.

    Returns
    Type Description
    System.String[]

    Array of split strings.

    ParseRecord(BiffRecordRaw)

    Parses record.

    Declaration
    [CLSCompliant(false)]
    protected virtual bool ParseRecord(BiffRecordRaw record)
    Parameters
    Type Name Description
    Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw record

    Record to parse.

    Returns
    Type Description
    System.Boolean

    True if record was successfully parsed, false otherwise.

    Serialize(OffsetArrayList)

    Adds all records to OffsetArrayList.

    Declaration
    [CLSCompliant(false)]
    public virtual void Serialize(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    OffsetArrayList which will get all records.

    Exceptions
    Type Condition
    System.ArgumentNullException

    When at least one of the internal records is null.

    SerializeEndRecords(OffsetArrayList)

    Serializes some records after main page setup block.

    Declaration
    [CLSCompliant(false)]
    protected virtual void SerializeEndRecords(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    OffsetArrayList to serialize into.

    SerializeStartRecords(OffsetArrayList)

    Serializes some records before main page setup block.

    Declaration
    [CLSCompliant(false)]
    protected virtual void SerializeStartRecords(OffsetArrayList records)
    Parameters
    Type Name Description
    OffsetArrayList records

    OffsetArrayList to serialize into.

    SetChanged()

    This method is called after changes to the page setup. Sets Saved property of the parent workbook to the False state.

    Declaration
    protected void SetChanged()

    WriteUShortRecord(BinaryWriter, DataProvider, IEncryptor, TBIFFRecord, UInt16, Int32)

    Writes record that contains single UInt16 value into the writer.

    Declaration
    [CLSCompliant(false)]
    protected int WriteUShortRecord(BinaryWriter writer, DataProvider provider, IEncryptor encryptor, TBIFFRecord code, ushort value, int streamPosition)
    Parameters
    Type Name Description
    System.IO.BinaryWriter writer

    Writer to write value into.

    DataProvider provider

    Object that gives access to the temporary buffer.

    IEncryptor encryptor

    Object to encrypt data.

    TBIFFRecord code

    Record code to write.

    System.UInt16 value

    Value to write.

    System.Int32 streamPosition

    Position in the output stream, used to reduce Flush calls of the writer.BaseStream.

    Returns
    Type Description
    System.Int32

    Size of the written data.

    Implements

    System.IDisposable
    IPageSetupBase
    IParentApplication
    IBiffStorage
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved