Share your ideas for improving. Vote on ideas and discuss them with the MYOB product development team.

Product Ideas

Export to Excel: Remove leading characters

Experienced Cover User

24Posts

1Kudos

1Solutions

24 Posts
Experienced Cover User
Australia

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"

Current Status: Done
Last Changed: August 2018

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

3 Comments
Steven_M
45,180 Posts
Former Staff

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
Experienced Cover User
24 Posts
Experienced Cover User

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

Steven_M
45,180 Posts
Former Staff

Hi @oxfam

 

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