Table Style Doesn't match Excel styles

Posted by: justin.arias on 14 February 2020, 6:42 am EST

  • Posted 14 February 2020, 6:42 am EST

    Hi, we offer the ability to export a spread to excel. However in cases where a user exports a spread containing a styled table, the table and font color are not the same in excel.

    Is there a way to match the styles? This causes also causes an issue in dark styles where the text becomes black on black in excel.
  • Replied 17 February 2020, 8:37 pm EST

    Hi Justin,
    Are you serializing the JSON while exporting the SpreadSheet to Excel? If yes, are you setting the ignoreStyle to true?
    If yes, you should not set the ignoreStyle since it ignores the existing styling.

    Please share the code snippet used for styling the cell and exporting the Spread to Excel.

    Regards,
    Manish Gupta
Need extra support?

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

Learn More

Forum Channels