Export to XLSX with formulas not correct

Export to XLSX with formulas not correct

Posted by: darin on 10 April 2019, 7:37 am EST

• 

  darin

  • Post Options:
  • Link
    Copy

  Posted 10 April 2019, 7:37 am EST

  AR11
  
  See attached RPX, PDF, and XLSX. The RPX creates the PDF fine, notice the far right column (turns) calculates correctly throughout the report. But, if you look at the XLSX it is not - most are zero when they should not be. Not sure how the PDF and XLSX versions could be different.
  
  Any ideas?PDFXLScalculation.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 10 April 2019, 7:56 am EST

  Darin,

  Could you please try this in “Format” event of GroupFooter/ReportFooter instead of “BeforePrint” event.
  
  Also, if possible could you please share the sample DB so that I can run the report at my end.

  Thanks.

• 

  darin

  • Post Options:
  • Link
    Copy

  Posted 10 April 2019, 9:51 am EST

  Putting it in the Format instead of before print made no change to the XLS report.

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 12 April 2019, 5:00 am EST

  Darin,

  I am not able to reproduce with my sample report and database. Could you please provide the sample Db of your report so that I can replicate the issue at my end?

  Thanks.