Creating a custom "Spread Setting" pop up selection

Creating a custom "Spread Setting" pop up selection

Posted by: fcherny on 8 January 2024, 5:26 pm EST

• 

  fcherny

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 January 2024, 5:26 pm EST - Updated 8 January 2024, 5:31 pm EST

  In the Designer Ribbon, is there a way to customize one of the pop up windows? I’d like to remove the “Allow Auto Create Hyperlink” option from the Spread Settings window (see attached).

  

  2377×1499 383 KB

  (I captured this screen shot from the demo page)

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 9 January 2024, 2:19 am EST

  Hi,

  You could update the “SpreadSettingDialog” template to remove the “Allow Auto Create Hyperlink” option. Use the “getTemplate()” method to get the “SpreadSettingDialog” template and “registerTemplate()” method to register the template.

  Refer to the following code snippet:

  // Get the "SpreadSettingDialogTemplate"
  let spreadSettingsTemplate = GC.Spread.Sheets.Designer.getTemplate(GC.Spread.Sheets.Designer.TemplateNames.SpreadSettingDialogTemplate);
  
  // Remove the option "allowAutoCreateHyperlink"
  spreadSettingsTemplate.content[0].children[0].children[0].children[0].children[2].children[0].children = 
  spreadSettingsTemplate.content[0].children[0].children[0].children[0].children[2].children[0].children
  .filter(item => item.bindingPath !== "allowAutoCreateHyperlink");
  
  // Additionally adjust the width of the Column So that there is no overlapping of the text
  spreadSettingsTemplate.content[0].children[0].children[0].children[0].children[2].children[0].width = "300px";
  
  // Register the "SpreadSettingDialogTemplate" with updated options
  GC.Spread.Sheets.Designer.registerTemplate(GC.Spread.Sheets.Designer.TemplateNames.SpreadSettingDialogTemplate, spreadSettingsTemplate);

  Further, you could set the Spread options using the following code:

  // Additionally set the "allowAutoCreateHyperlink" option
  spread.options.allowAutoCreateHyperlink = false;   // Default is true

  Sample: https://jscodemine.grapecity.com/share/lzhP1P4ckE2ajtDs6UK9uQ/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  References:

  getTemplate method: https://developer.mescius.com/spreadjs/api/v15/designer/modules/GC.Spread.Sheets.Designer#gettemplate

  SpreadSettingDialog Template: https://developer.mescius.com/spreadjs/api/v15/designer/classes/GC.Spread.Sheets.Designer.TemplateNames#spreadsettingdialogtemplate

  registerTemplate method: https://developer.mescius.com/spreadjs/api/designer/modules/GC.Spread.Sheets.Designer#registertemplate

  Workbook Options: https://developer.mescius.com/spreadjs/api/v17/classes/GC.Spread.Sheets.Workbook#options

  TemplateNames Class: https://developer.mescius.com/spreadjs/api/designer/classes/GC.Spread.Sheets.Designer.TemplateNames#class-templatenames

  Regards,

  Ankit

• 

  fcherny

  • Post Options:
  • Link
    Copy

  Posted 9 January 2024, 1:21 pm EST

  That did it. Thanks!