Downloaded flexsheet is showing incorrect data

Downloaded flexsheet is showing incorrect data

Posted by: chayankar209 on 1 June 2018, 1:01 am EST

• 

  chayankar209

  • Post Options:
  • Link
    Copy

  Posted 1 June 2018, 1:01 am EST

  Hello,

  I have initialized a flexsheet with data & charts. The sheet contains computed cells, i.e, the value of a range of cells are computed using custom functions.

  But when I am downloading the flexsheet, computed cells are showing irrelevant data like #DIV/0! & #VALUE!

  Also the chart is not showing up. Below is the code to download flexsheet. Please suggest necessary changes and configuration

  DownloadExcel(){
  
  let fileName = ‘Test Report_’ + Date.now;
  
  FlexGridXlsxConverter.saveAsync(this.flxSheet, { includeColumnHeaders: true }, fileName,(data)=>{},(error)=>{console.log(error.toString())});
  
  }

• 

  chayankar209

  • Post Options:
  • Link
    Copy

  Posted 3 June 2018, 7:11 pm EST

  This is an urgent requirement. I need your assistance badly. Looking forward to hearing from you !

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 4 June 2018, 12:27 am EST

  Hi,
  
  We are sorry, with the current release build this feature is not supported. We have created requests for these features with tracking ID: 325519 & 325520.
  
  These feature may be implemented in future releases if found feasible.

  ~Manish

• 

  chayankar209

  • Post Options:
  • Link
    Copy

  Posted 4 June 2018, 6:52 pm EST

  I have managed to remove the garbage value from the sheet. The problem was setting ‘includeColumnHeaders’ to true, which added an extra row, thus the cell reference was getting disrupted.

  DownloadExcel ()
  
  {
  
  let fileName = ‘Test Report_’ + Date.now;
  
  FlexGridXlsxConverter.save(this.flxSheet, { includeColumnHeaders: true }, fileName);
  
  }

  On setting ‘includeColumnHeaders’ to false, resolved the garbage value issue.

  On checking the code sample to add chart in flexsheet in this link: https://stackblitz.com/edit/angular-c3yvz5?file=app/app.component.ts

  I found that the chart is being hosted inside newly created ‘div’ (HTML element). It is directly not hosted on top of flex control, hence the chart is not getting downloaded along with flexsheet.

  I want the chart to stay embedded in flexsheet so that it is present in the downloaded file.

  Thank you !!

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 5 June 2018, 5:07 pm EST

  Hi,
  
  Thank you for notifying us.
  
  The issue for embedding chart in Exported FlexSheet is with the development team.

  We will let you know as we get any update on this.

  ~Manish

• 

  chayankar209

  • Post Options:
  • Link
    Copy

  Posted 13 June 2018, 10:58 pm EST

  Hi !!

  Any update on the requested feature where charts will be embeddded in flexsheet ?

  This is with the development team you said earlier

  Thank you,
  
  Chayan Kar

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 15 June 2018, 3:42 am EST

  Hi,
  
  We are sorry indeed for delay on this. This issue is still with the development team. We will update you on this as we get any update on this.

  ~Manish

• 

  chayankar209

  • Post Options:
  • Link
    Copy

  Posted 24 June 2018, 4:49 pm EST

  Hello,

  May I know the status of my request for embedding flexchart in flexsheet ? You can reach me here: chayan.kar@mindteck.com

  Thank you,
  
  Chayan Kar

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 26 June 2018, 10:47 pm EST

  HI,
  
  We are sorry indeed.
  
  We are still unable to provide an update on this request. This is still with the development team.
  
  We will let you know as we get an update on this.

  ~Manish