Is there a way to prevent the list Validation dropdown arrow from showing

Is there a way to prevent the list Validation dropdown arrow from showing

Posted by: adisa.craig on 2 October 2019, 3:30 pm EST

• 

  adisa.craig

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 2 October 2019, 3:30 pm EST

  When the cell is protected we don’t want the user to see the dropdown arrow that shows up when there is a list validator. Is there a way we can prevent it from showing up?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 3 October 2019, 4:31 am EST

  Hi Adisa,

  You could hide the list dropdown button by using the inCellDropdown method of data validator. Please refer to the following code snippet:

  // create formula validator
    const dv = GC.Spread.Sheets.DataValidation.createListValidator("A,B,C,D");
  // disable dropdown
    dv.inCellDropdown(false);
  // set validator
    sheet.setDataValidator(1, 1, dv);
  

  API reference:
  
  • inCellDropdown method: http://help.grapecity.com/spread/SpreadSheets12/webframe.html#SpreadJS~GC.Spread.Sheets.DataValidation.DefaultDataValidator~inCellDropdown.html

  Regards
  
  Sharad