oxfam's avatar
oxfam
Experienced Cover User
7 years ago
Status:
Done

Export to Excel: Remove leading characters

When you export from AccountRight Plus 2016.3, to an Excel file (.xlsx) the GL account values appear with an extra character on the end.  It's ANSI 13.  This is really annoying for any formulas or macros that use the GL account values.

This problem doesn't occur when exporting to .csv files.

Do you think you could "clean" this up.  I put clean in quotes as Excel's Clean() function fixes the problem.

 

"Get rid of the non-printing character (ANSI 13) from GL accounts when exporting to Excel"

Reporting
Setup

3 Comments

Sort By
  • Steven_M's avatar
    Steven_M
    Former Staff
    6 years ago
    Status changed:
    New
    to
    Done

    Hi Everyone

    With the release of AccountRight 2017.2 the account number and name indentation on reports sent to Excel have been removed.

     

    You can find out more information about this and other changes, including information on obtaining AccountRight 2017.2 from AccountRight 2017.2 now available

  • oxfam's avatar
    oxfam
    Experienced Cover User
    6 years ago

    Does this also apply to AccountRight 2018.2 too, or just 2017.2?

  • Steven_M's avatar
    Steven_M
    Former Staff
    6 years ago

    Hi oxfam

     

    The change was introduced with the AccountRight 2017.2 range and has carried across to the AccountRight 2018.2 product.