Applying 2 or more styles for a single cell

Posted by: vivek.reddyz on 1 August 2022, 2:31 am EST

  • Posted 1 August 2022, 2:31 am EST

    Hi team ,
    I am using fromJson() method to get the json data for the sheet. I want to apply 2 different styles in a particular cell . For example , I have a cell with value "200, (-30%)" . In this example, 200 should be in bold and since percentage is a negative number i.e(-30%) it should be in red . I am attaching a screenshot for your reference.


    Could you please provide a solution for this?
  • Replied 1 August 2022, 5:00 pm EST

    Hi Vivek,

    SpreadJS supports rich text through which you can set different text styles in one cell. You can also create your own custom cell type to match your requirement. You can refer to the following demos.

    Rich Text Demo:

    Custom Cell Type Demo:

  • Replied 3 August 2022, 9:22 pm EST

    Hi team ,
    We are not using .setValue() method to set data inside the cell. We are using fromJson() method. How can we set rich text to different cells inside the json?

  • Replied 7 August 2022, 3:42 pm EST

    Hi Vivek,

    You can define the rich Text structure as shown in the rich Text Demo:

    Later for setting the rich text inside the json, you can use the following:

    richTextJSON.value.richText = richText;
    richTextJSON.value.text = text;

    where richText is the structure of the rich text.

    You can refer to the following sample that I have created for you:

Need extra support?

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

Learn More

Forum Channels