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
  • Jump To Answer

  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

  

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 11 October 2024, 2:26 am EST

  Hi,

  The mentioned issue related to the Chart Formatting not being updated has been fixed in the latest version V17.1.7 of the SpreadJS. Kindly upgrade to the latest version of SpreadJS.

  You could also download the latest version using the following link: http://cdn.mescius.com/spreadjs/17.1.7/Files/SpreadJS.Release.17.1.7.zip

  Let us know if you still face the same issue.

  Regards,

  Ankit