In the chart when i change the Format of the number did not reflect

In the chart when i change the Format of the number did not reflect

Posted by: ricardo.aleixo on 19 August 2024, 2:45 pm EST

• 

  ricardo.aleixo

  • Post Options:
  • Link
    Copy

  Posted 19 August 2024, 2:45 pm EST - Updated 19 August 2024, 2:51 pm EST

  Hi.

  I created a chart with some values for exemple 15000/ 20000/ 5000/ 46000.
  
  

  

  1354×826 71.6 KB

  When i applied some format number for exemple ‘General’ to ‘Currency’ it did not apply in the chart at the time as we can see in Excel.

  • here is a picture of numbers format but not appling in the chart.
    
    
    

    1354×826 83.6 KB

  Don’t know if susposte to be a functionality but isn’t work.

  To apply the format of number in the chart, i need to create another one with those Format.

  

  1373×848 77.7 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 20 August 2024, 2:06 am EST - Updated 20 August 2024, 2:12 am EST

  Hi,

  It seems like an issue of the SpreadJS. I have escalated it to the concerned dev team for further investigation. The internal tracking id for the same is SJS-26063. I will let you know when there is further information on this from the dev team.

  You could use the following code as a workaround for now:

  spread.commandManager().addListener("listener", (info) => {
      if(info.command && info.command.cmd === "Designer.setFormatter") {
          let selection = info.command.selections[0];
          for(let i = selection.col; i < selection.col + selection.colCount; i++) {
              let sheet = spread.getSheetFromName(info.command.sheetName);
              sheet.setColumnWidth(i, sheet.getColumnWidth(i));
          }
      }
  })

  Workaround Sample: https://jscodemine.mescius.io/share/bqEp2EJ-eEagT5ktNvnWpA/?defaultOpen={"OpenedFileName"%3A["%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Regards,

  Ankit