Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

GP2016 Smartlist- Change default font when exporting to Excel?

Posted on by 290

Hello,

Is there a way to set the default font when exporting Smartlists to Excel?

Thanks!

*This post is locked for comments

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at
    RE: GP2016 Smartlist- Change default font when exporting to Excel?

    Update for those on this thread. I did some research and Smartlist appears to use the default system font when exporting to Excel. I tested a few different things and other than actually changing the registry on your computer to alter the default font for this, the only viable solution is what Leslie suggests, which is consider using Export Solutions and templates with the fonts you want.

    Sad but true... :)

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: GP2016 Smartlist- Change default font when exporting to Excel?

    I'd head out to the internet looking for free webinars. You could create a template with the correct default fonts that you could use for multiple Favorite's. Can you give us a little more information on what you are trying to do?

    Leslie

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at
    RE: GP2016 Smartlist- Change default font when exporting to Excel?

    I've had this exact same question and will try to find out if there is an excel stylesheet somewhere that it uses that a user could edit... I'd love to know myself!

  • NorK Profile Picture
    NorK 290 on at
    RE: GP2016 Smartlist- Change default font when exporting to Excel?

    Hello,

    Is there any documentation on these options?

    Thanks!

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: GP2016 Smartlist- Change default font when exporting to Excel?

    Yes there is. You need to create an export solution that can change the font after (or before) you feed the data to Excel. Also, have you considered using an Excel template to hook directly to Excel ?

    Kind regards,

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans