Exporting to Excel Issue with Column Formatting

Exporting to Excel Issue with Column Formatting

Posted by: kamlesh.joshi on 11 May 2018, 10:39 am EST

• 

  kamlesh.joshi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 May 2018, 10:39 am EST

  I recently upgraded from Active Report 6 to Active Report 12. I had decimal fields in my reports, when i used to export them to excel ,it exports them as number with decimals earlier.
  
  After upgrading to ActiveReport 12. I am getting them as Text Field in Excel,with green small icon in cell.
  
  Is there any simple way to rectify this issue.

  Thanks,
  
  Kamlesh

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 14 May 2018, 2:20 am EST

  Hi Kamlesh,

  Try setting the OutputFormat property of the TextBox to #,##0.00

• 

  kamlesh.joshi

  • Post Options:
  • Link
    Copy

  Posted 15 May 2018, 8:57 am EST

  I tried that to set the TextBox OutPutFormat property to #,##0.00,But still no luck.
  
  Still it is exporting to Text.

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 16 May 2018, 12:42 am EST

  What type of field in the database is your TextBox bound to? Can you please attach your report file here? I would like to see what could be causing the behavior.