How to put predefined values when I execute format cells command

How to put predefined values when I execute format cells command

Posted by: gagandeep.singh on 2 January 2024, 8:29 am EST

• 

  gagandeep.singh

  • Post Options:
  • Link
    Copy

  Posted 2 January 2024, 8:29 am EST

  Hi there,

  I have one action where I execute spread command like this:

  if (e.key === "F8") {
              spreadObject.commandManager().execute({
                  cmd: "formatCells"
              });
          }

  And it opens up format cell pop-up, but it has default values selected like black font color and etc. I am wondering if I can open the pop up with pre-defined values?

  Thanks

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 2 January 2024, 8:57 pm EST

  Hi,

  After investigating the issue at our end, we could not find a suitable solution for the issue mentioned. Hence, we have escalated this issue to the dev team for further investigation and resolution of the same. The internal tracking ID for the issue is:SJS-22133. Please be rest assured that we will keep you updated on the progress of the issue.

  Regards

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 15 January 2024, 4:23 pm EST - Updated 15 January 2024, 4:28 pm EST

  Hi,

  Apologies for the delayed response.

  The values(e.g. font fore color, back color etc) in the format cell dialog are shown as per the style applied to the cell. This behavior is by design. Even if the cell has no style applied explicitly, it has some style that it gets from its parent row, parent column, and parent sheet level.
  
  You can find the actual style on a cell with sheet.getActualStyle() method. You may refer to https://developer.mescius.com/spreadjs/docs/getstarted/objectinh to learn more about object inheritance in SpreadJS.

  So, even if a cell has no style applied with fore color black, format dialog still shows “black” color in fore color as default because it takes this color from the default style of the sheet in which the fore color is “black” by default.

  Please refer to the attached sample for more understanding.

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

  

  References:

  sheet.getActualStyle(): https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#getactualstyle

  Regards