[]
Follow the below steps to disable the "Table" field button from the "INSERT" tab.
Access the default configuration and identify the command associated with the "Table" button, in this case, the insertTable
command.
// Configure Workbook and Worksheet
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"));
var activeSheet = spread.getActiveSheet();
// Access the default config
var config = GC.Spread.Sheets.Designer.DefaultConfig;
console.log(config);
// Find the below snippet for "Table" button
// "ribbon": [
// {
// ...
//
// "id": "insert",
// "text": "INSERT",
// "buttonGroups": [
// {
// "label": "Table",
// "thumbnailClass": "ribbon-thumbnail-table",
// "commandGroup": {
// "commands": [
// "insertTable" // Associated command
// ]
// }
// }]
// }]
Apply getCommand method on the above command (insertTable
) to identify its state expression.
console.log(GC.Spread.Sheets.Designer.getCommand('insertTable'));
// commandName: "insertTable"
// enableContext: "AllowInsertTable && !IsProtected"
Set the above command to commandMap in your project and disable the respective state expression by setting the enableContext
option.
config.commandMap = {
insertTable: {
commandName: "insertTable",
// To disable the Table button
enableContext: "!AllowInsertTable"
}
}
Initialize the designer instance by passing the config
parameter for customizable configuration.
var designer = new GC.Spread.Sheets.Designer.Designer(document.getElementById("designerHost"), config, spread);
The below output will be generated: