Cell click block

Cell click block

Posted by: pedro.moraes on 25 July 2023, 3:49 pm EST

• 

  pedro.moraes

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 July 2023, 3:49 pm EST - Updated 25 July 2023, 3:54 pm EST

  Hello,

  I would like to know how do I make the border of my selected cell not appear? Or cancel the click?

  

  756×679 84.5 KB

  And is there a way to enable and disable this bar easily?

  

  753×301 32.4 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 26 July 2023, 5:24 am EST

  Hi Pedro,

  You could use the following css to hide the border of the selected cell:

  .gc-selection {
      border-color: transparent;
  }

  To disable the editing on the Cell, you could use the EditStarting Event and cancel the operation:

  sheet.bind(GC.Spread.Sheets.Events.EditStarting, function (sender, args) {
      // Check Condition
      // Stop Editing on Cell A1
      if (args.row === 0 && args.col === 0) {
          args.cancel = true;
      }
  });

  You could add the following css to the .gc-formulaBar class to make it disabled:

   .checked {
           pointer-events: none;
   }

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

  You could also set the protection on the sheet and lock the cells. Refer to the following docs: https://www.grapecity.com/spreadjs/docs/features/worksheet/celllock#site_main_content-doc-content_title

  References:

  EditStarting Event: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.Events#editstarting

  Kindly refer to the attached sample and let us know if you face any issues.

  Regards,

  Ankit