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.