Create custom textCellType

Create custom textCellType

Posted by: thom.prosch on 29 August 2023, 10:27 pm EST

• 

  thom.prosch

  • Post Options:
  • Link
    Copy

  Posted 29 August 2023, 10:27 pm EST

  Hi,

  I would like to create a custom textCellType and I only want to override the paint method.

  let textCellType = function () { };
  textCellType.prototype = new GC.Spread.Sheets.CellTypes.Base();
  textCellType.prototype.paint = function (ctx, value, x, y, w, h, style, context) { }

  If I do this, the cell does not react on input anymore, ie. on typing or doublicking the cell the editor is not shown up.

  Do I need to override another method?

  Thanks, Thom

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 30 August 2023, 11:04 pm EST

  Hi Thom,

  Instead of Base Class, you need to use the Text Class so that you could edit the Cell by typing or double clicking the cell.

  Kindly refer to the following code snippet. If you use the Text Class, you don’t want to override any other method and you could simply override only the paint method.

  function TextCellType() {
  }
  TextCellType.prototype = new GC.Spread.Sheets.CellTypes.Text();
  TextCellType.prototype.paint = function (ctx, value, x, y, w, h, style, options) {
      //Paints a cell on the canvas. 
      style.backColor = "yellow";
      GC.Spread.Sheets.CellTypes.Text.prototype.paint.apply(this, [ctx, value, x, y, w, h, style, options]);
  };
  
  sheet.getRange(0, 0, 5, 1).cellType(new TextCellType());

  In the above code snippet, the paint method has been overridden and backColor “yellow” is set.

  Sample: https://jscodemine.grapecity.com/share/7he7_j7aYUW3AH7a1MFYvA/?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"}

  Please let us know if you face any issues.

  References:

  Text Class: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.CellTypes.Text

  Text Class paint method: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.CellTypes.Text#paint

  Regards,

  Ankit