Table Style Doesn't match Excel styles

Table Style Doesn't match Excel styles

Posted by: justin.arias on 14 February 2020, 3:42 pm EST

• 

  justin.arias

  • Post Options:
  • Link
    Copy

  Posted 14 February 2020, 3:42 pm 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.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 18 February 2020, 5:37 am 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