Using the Excel Compatibility Input Maps

You can specify whether to use the default Spread input maps or the Excel compatibility input maps. You can also specify the input map mode and the operation mode. Some actions may not apply to certain modes such as starting cell editing with read-only mode.

Use the LoadXmlInputMapFile method to load the Excel compatibility file or other input map file. Spread installs a default Excel compatibility file to the product bin folder.

Using Code

Set the options in the LoadXmlInputMapFile method.

Example

This example specifies the Excel compatibility option.

fpSpread1.LoadXmlInputMapFile("ExcelCompatibility.imp");
//fpSpread1.LoadXmlInputMapFile("ExcelCompatibility.imp", FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused, FarPoint.Win.Spread.OperationMode.Normal);

fpSpread1.LoadXmlInputMapFile("ExcelCompatibility.imp")
'fpSpread1.LoadXmlInputMapFile("ExcelCompatibility.imp", FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused, FarPoint.Win.Spread.OperationMode.Normal)

Using the Spread Designer

1. Select the Settings menu and then select the Input Map icon located under the Other Settings section.

2. Click the Load Input Maps button to load the Excel compatibility file.

3. Select OK.

4. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.

See Also

Default Map for Excel Compatibility

Keyboard Interaction

Underlying Keystroke Processing

Factors of Keyboard Map Usage

Default Keyboard Navigation

Default Keyboard Maps

Deactivating the Default Keyboard Map

Changing the Default Keyboard Map

Using Input Maps with Action Maps

Customizing the Input Maps

Changing an Input Map for a Child View

Saving and Loading Map Files