Spread Windows Forms 14.0
Spread Windows Forms 14.0 Product Documentation / Import and Export Reference / Excel-Formatted Files Import / Sheet Settings Imported
In This Topic
    Sheet Settings Imported
    In This Topic

    This table summarizes how the sheet settings are handled when Spread imports data from an Excel-formatted file. These properties are members of the FpSpread class unless otherwise noted.

    Excel Setting Related Spread Property Remarks

    Active sheet

    ActiveSheet

    ActiveSheetIndex

    Spread imports this setting from Excel.

    Cell overflow

    AllowCellOverflow

    Spread sets the AllowCellOverflow property to True. (Cells can always overflow in Excel.)

    Clipboard shortcut key support

    AutoClipboard

    ClipboardOptions

    Spread reads the value of this setting, and sets the AutoClipboard property. Excel always excludes headings from Clipboard operations. Excel stores this setting in the system registry.

    Color

    BackColor ForeColor

    Spread imports this setting from Excel.

    Drag and drop

    AllowDragDrop

    Excel stores this setting in the system registry. Spread reads the value of this setting, and sets the AllowDragDrop property.

    Frozen panes

     

    See the frozen rows and columns in Row and Column Settings Imported.

    Grid lines

     

    See the grid lines section in Row and Column Settings Imported.

    Printing

     

    Refer to the Print Settings Imported.

    Scroll bars

    HorizontalScrollBarPolicy

    VerticalScrollBarPolicy

    Spread imports this setting from Excel.

    Shapes and Camera Shapes Shapes and Camera Shapes Shapes are imported as shapes (BIFF8 only).

    Split bar and Panes

    Several properties related to viewports.

    Spread imports panes with split bars. In Spread, panes are referred to as viewports.

    Worksheets

    Worksheet names

    Sheets

    SheetView.SheetName

    Spread imports this setting from Excel.

    Zoom

    ZoomFactor

    Spread imports this setting from Excel.

    Custom Names

    Spread enables cross-sheet references when importing Excel-formatted files. This means that Excel workbook level custom names are imported as Spread workbook level custom names.

    See Also