Spread Windows Forms 8.0 Product Documentation
Sheet Settings Imported

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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback