web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

GP2016 Smartlist- Change default font when exporting to Excel?

(1) ShareShare
ReportReport
Posted on by 334

Hello,

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

Thanks!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    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

  • NorK Profile Picture
    334 on at

    Hello,

    Is there any documentation on these options?

    Thanks!

  • Jen Kuntz Profile Picture
    3,220 on at

    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!

  • L Vail Profile Picture
    65,271 on at

    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
    3,220 on at

    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... :)

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans