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 XML file to the input map folder.

Using Code

Set the options in the method.

Example

This example specifies the Excel compatibility option.

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

Copy Code

fpSpread1.LoadXmlInputMapFile("ExcelCompatibility.imp");

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

VB	Copy Code
FpSpread1.LoadXmlInputMapFile("ExcelCompatibility.imp") 'FpSpread1.LoadXmlInputMapFile("ExcelCompatibility.imp", FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused, FarPoint.Win.Spread.OperationMode.Normal)

Copy Code

FpSpread1.LoadXmlInputMapFile("ExcelCompatibility.imp")

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

Using the Spread Designer

Select the Settings menu and then select the Input Map icon located under the Other Settings section.
Click the Load Input Maps button to load the Excel compatibility file.
Select OK.
From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.