Celltype when cell clicked

Celltype when cell clicked

Posted by: baloghbencefacebook on 4 November 2021, 9:55 am EST

• 

  baloghbencefacebook

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 November 2021, 9:55 am EST

  I tried to modify a cell’s type when I click it. This is the code I used:

  workbook.bind(GCSheets.Events.CellClick, (e: EventParam, info: any) => {
  
  let cellType = new GCSheets.CellTypes.ComboBox();
  
  cellType.items([“a”, “b”]);

  this.getWorkbook().getActiveSheet().getCell(info.row, info.col).cellType(cellType);
  

  });

  The ▼ icon appears, but when I click it, the dropdown does not appear and the editor functions like a textbox.

• 

  baloghbencefacebook

  • Post Options:
  • Link
    Copy

  Posted 5 November 2021, 5:19 am EST

  Im using the react version of 14.2.2

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 8 November 2021, 5:21 am EST

  Hi,

  For this, you need to use startEdit method. Please refer to the following code snippet and let me know if you face any issues.

  
  var GCSheets = GC.Spread.Sheets;
          spread.bind(GCSheets.Events.CellClick, (e, info) => {
              let cellType = new GCSheets.CellTypes.ComboBox();
              cellType.items(["a", "b"]);
  
              info.sheet.getCell(info.row, info.col).cellType(cellType);
              info.sheet.startEdit()
          });
      }
  
  

  sample: https://jscodemine.grapecity.com/share/mVhB3FkPmEOXn9DuoMfXHw/?isEmbed=true&isExplorerShow=false

  API References:
  
  startEdit: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Worksheet~startEdit.html
  
  regards
  
  Avinash