Spread.Sheets Worksheet tab font color

Posted by: adrien.corbin on 4 April 2018, 2:43 pm EST

    • Post Options:
    • Link

    Posted 4 April 2018, 2:43 pm EST

    We are moving from spreadJS 9 to 11.

    We used (SpreadJS 9) to give the tab color this “rgba(255,255,255,0)” which would be transparent white and the font color was black.

    Now (SpreadJS 11) with the same tab color “rgba(255,255,255,0)”, the font color is white.

    After some testing, I tried “rgba(0,0,0,0)”, which would give me black font color, but any other values with full transparency give me with font color.

    Shouldn’t font color always be black if transparency is set to 1 or 100%?

    Thanks

  • Posted 4 April 2018, 3:24 pm EST

    Just to clarify (could not find a way to edit post), following line is backward

    Shouldn’t font color always be black if transparency is set to 0 (full transparency)?

    Note: Currently tested on 11.0.0, will be testing shortly on 11.0.6

  • Posted 5 April 2018, 11:20 am EST

    Hello,

    I tested this issue with SpreadJS v11.0.6 and found that the setting the SheetTab color to

    rgba(255,255,255,0) sets the background color to white for SheetTab. If you mat the SheetTab 100% transparent it will show the white background color of SheetTab which overrides the SheetTab font color.

    However if I set the transparency level to anything between 1 and 100 the Font color is retained as black.

    spread.getSheet(0).options.sheetTabColor = “rgba(255,255,255,0.1)”;

    Thanks,

    Deepak Sharma

Need extra support?

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

Learn More

Forum Channels