Update settings in Spread Settings tab and Sheet Settings tab

Update settings in Spread Settings tab and Sheet Settings tab

Posted by: thanh.minh.le on 9 August 2023, 10:20 pm EST

• 

  thanh.minh.le

  • Post Options:
  • Link
    Copy

  Posted 9 August 2023, 10:20 pm EST - Updated 9 August 2023, 10:46 pm EST

  Hi, I would like to ask if is there a way to set the default settings in the Settings tabs. For example, in the image below, I want to uncheck/check and disable some of the default options when I open Spread Settings.
  
  

  

  1187×748 46.4 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 10 August 2023, 2:08 am EST

  Hi,

  The Spread/Sheets Dialog show the Spread/Sheets properties defined in the Spread/Sheet.

  For example, to check the “Allow Drag and Drop” and uncheck the “Allow Drag and Merge” on Spread Settings Dialog, you could use the following options on the Spread.

  [code]
  
  // Workbook Settings
  
  // Uncheck User Drag Drop
  
  spread.options.allowUserDragDrop = false;

  // Check Allow Drag And Merge
  
  spread.options.allowUserDragMerge = true;

  // Change Resize Mode
  
  spread.options.rowResizeMode = GC.Spread.Sheets.ResizeMode.split
  
  [/code];

  You could refer to the following APIs on all the workbook options available: https://www.grapecity.com/spreadjs/api/v15/interfaces/GC.Spread.Sheets.IWorkbookOptions

  Similarly, for unchecking the “Allow OverFlow” option on Sheet Settings Dialog, you could use the following options on Sheet.

  // Worksheet Options
  sheet.options.allowCellOverflow = false;

  You could refer to the following options available on WorkSheet: https://www.grapecity.com/spreadjs/api/interfaces/GC.Spread.Sheets.IWorksheetOptions#interface-iworksheetoptions

  To disable the checkboxes, you could modify the SpreadSettingDialogTemplate/ SheetSettingDialogTemplate dialogs and add a class name to disable the element.

  You could refer to the following code snippet:

  // Get the Spread Settings Template
  var spreadSettingsTemplate = GC.Spread.Sheets.Designer.getTemplate(GC.Spread.Sheets.Designer.TemplateNames.SpreadSettingDialogTemplate);
  // Get the Allow User Drag Drop CheckBox
  let allowUserDragDropCheckbox = spreadSettingsTemplate.content[0].children[0].children[0].children[0].children[2].children[0].children[0];
  // Add Disabled Class Name
  allowUserDragDropCheckbox.className = "disabledClass";
  // Reregister the template
  GC.Spread.Sheets.Designer.registerTemplate(GC.Spread.Sheets.Designer.TemplateNames.SpreadSettingDialogTemplate, spreadSettingsTemplate);
  
  // Get the Sheets Settings Template
  var sheetSettingsTemplate = GC.Spread.Sheets.Designer.getTemplate(GC.Spread.Sheets.Designer.TemplateNames.SheetSettingDialogTemplate);
  // Add Disabled Class Name
  let allowOverFlowCheckBox = sheetSettingsTemplate.content[0].children[0].children[0].children[0].children[0].children[1].children[1];
  // Add Disabled Class Name
  allowOverFlowCheckBox.className = "disabledClass";
  // Reregister the template
  GC.Spread.Sheets.Designer.registerTemplate(GC.Spread.Sheets.Designer.TemplateNames.SheetSettingDialogTemplate, sheetSettingsTemplate);

  Sample: https://jscodemine.grapecity.com/share/UNMfoiV9OkySLrXwyY5lNQ/?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"%2Findex.html"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  References:

  SheetSettingDialog Template: https://www.grapecity.com/spreadjs/api/v15/designer/classes/GC.Spread.Sheets.Designer.TemplateNames#sheetsettingdialogtemplate

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

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

  IComponentBase Options: https://www.grapecity.com/spreadjs/api/v16/designer/interfaces/GC.Spread.Sheets.Designer.IComponentBaseOption#interface-icomponentbaseoption

  Regards,

  Ankit