Set selected "Import" option File

Set selected "Import" option File

Posted by: nguyenthanhtuu1995 on 8 November 2022, 9:46 pm EST

• 

  nguyenthanhtuu1995

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 November 2022, 9:46 pm EST - Updated 8 November 2022, 9:51 pm EST

  Hi teams,
  
  I want set default selected for “IMPORT” in FILE option. please give me solution.
  
  Thanks and best regards!.
  
  

  

  1374×738 15.5 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 9 November 2022, 10:28 pm EST

  Hi,

  You can overwrite the ‘fileMenuPanel’ command’s getState method and set the activeCategory_main to “Import”. Please refer to the following code snippet and the sample below:

  
  let fileMenuCmd = GC.Spread.Sheets.Designer.getCommand('fileMenuPanel');
  let fileMenuCmdState = fileMenuCmd.getState(designer);
  
  let config = GC.Spread.Sheets.Designer.DefaultConfig;
  config.commandMap = {
      fileMenuPanel: {
          ...fileMenuCmd,
          getState: function () {
              // Set the active category to "Import"
              fileMenuCmdState.activeCategory_main = "Import";
              return fileMenuCmdState;
          }
      }
  }
  
  designer.setConfig(config);
  

  Sample: https://jscodemine.grapecity.com/share/5FHt9oJWUk_hkfyG_zRBpA/

  References:

  fileMenuPanel command: https://www.grapecity.com/spreadjs/api/designer/classes/GC.Spread.Sheets.Designer.CommandNames#filemenupanel

  getCommand method: https://www.grapecity.com/spreadjs/api/designer/modules/GC.Spread.Sheets.Designer#getcommand

  setConfig method: https://www.grapecity.com/spreadjs/api/designer/classes/GC.Spread.Sheets.Designer.Designer#setconfig

  Alternatively, you could use the following code to set the default option:

  designer.setData("fileMenuSetting",{activeCategory_main:"Import"});

  Regards,

  Ankit

• 

  nguyenthanhtuu1995

  • Post Options:
  • Link
    Copy

  Posted 10 November 2022, 6:24 pm EST

  Yep thanks @ankit.kumar. i tried and success.