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

  • 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.

    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.

    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.

  • 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

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels