Control cell height with ribbonn

Control cell height with ribbonn

Posted by: serdarhoja on 5 March 2023, 2:46 pm EST

• 

  serdarhoja

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 March 2023, 2:46 pm EST

  Hello Dear Grapecity team!
  
  I want to auto change cell height, when I increase or decrease font size from ribbon (When I click only to increase or decrease button, I mean without clicking to “AutoFit Row height” or “AutoFit Column width”). How can I do it? Is it possible?

  Thank you for your help!

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 5 March 2023, 9:58 pm EST

  Hi Serdar,

  When you change the font size of text in a cell using font size options in ribbon, then Desinger.setFontSize command is executed.

  You can create a custom command which executes Designer.setFontSize command as well as ‘autoFitRow’ command inside it. Then you can override the execute method of Designer.setFontSize command to execute your custom command.

  You can get Designer.setFontSize command by using GC.Spread.Sheets.Designer.getCommand() method and commandManager.register() method to register your custom command with command mananger.

  You can also use ‘autoFitColumn’ command inside the custom command similarly.

  Please refer to the attached sample for further understanding.

  Sample: https://jscodemine.grapecity.com/share/Qlf9SGJgG0mdccvwpts9xw/?defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Please let us know if you still face any problem.

  Doc references:

  CommandManager: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Commands.CommandManager

  GC.Spread.Sheets.Designer.getCommand(): https://www.grapecity.com/spreadjs/api/designer/modules/GC.Spread.Sheets.Designer#getcommand

  autoFitRow command: https://www.grapecity.com/spreadjs/api/modules/GC.Spread.Sheets.Commands#autofitrow

  Regards,

  Ankit

• 

  serdarhoja

  • Post Options:
  • Link
    Copy

  Posted 6 March 2023, 7:44 am EST

  Hi Anket,

  Thank you very much for your quick response and so helpful solution. It solved my issue.

  Regards, Serdar