1 Topic by dls (edited by dls 05/28/2023 10:58:51 am)

  • dls
  • Senior Member
  • Offline
  • From: UK
  • Registered: 02/23/2010
  • Posts: 63

Topic: Excel output error

I'm still using FA 2.3.22 for various reasons and happy with it. 
I have just installed the Transaction import module which is working ok (as far as I have used it so far). However, now since installing the module, when generating reports under Banking & General Ledger-Reports and Analysis and directing to Excel, the format has an error so the file doesn't load properly. Viewing in a Hex editor it now adds 0D 0A (CRLF) to the start of the file. By deleting these the file will open correctly as it always has previously.

Has anyone had this problem? Seen a similar issue on here but only with a workaround.

  • From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 654

Re: Excel output error

Support on older versions is difficult. A lot has been changed in FA and PHP both..

www.boxygen.pk

boxygen's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Excel output error

Check which version of Excel you are using.
The module worked well with Excel 2007.
Try saving as xls format and try too.

apmuthu's Website