FlexSheet Export - Maintaining ItemFormatter changes

FlexSheet Export - Maintaining ItemFormatter changes

Posted by: brandon.grime on 26 August 2019, 8:02 am EST

• 

  brandon.grime

  • Post Options:
  • Link
    Copy

  Posted 26 August 2019, 8:02 am EST - Updated 3 October 2022, 7:31 pm EST

  Hey,

  I have a FlexSheet with custom footer calculations. I use itemFormatter to change a cell value to have a percent symbol instead of a dollar sign, since it falls under a monetary column. When I export though, the itemFormatter change reverts and the dollar sign reappears. Any way to fix this? See pictures below.

  

  1853×182 7.72 KB

  

  1754×177 8.33 KB

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 27 August 2019, 4:03 am EST

  Hi Brandon,

  To apply cell style while exporting the FlexSheet to Excel, you will need to first create an instance of Workbook class from the FlexSheet and then customize the cell. Please refer to the sample below:

  https://stackblitz.com/edit/react-1xyvtx

  Regards,
  
  Ashwin