5

Right now we are very limited to what formatting we can apply to the Excel spreadsheet when programmically export it. Basically, we are using functions in Excel Buffer table, which allows us to Bold, Underline, etc. I understand that you do not want to give an ability to use other objects (including Excel) for security reasons.

So the idea is to add dedicated Excel codeunit that will allow us to have more control over Excel Exports. Namely, add background color, borders, format text with color, wrap text, align text in the cell, fit columns, etc. Many customers are asking for custom exports and this feature will be a welcome addition.

Category: Development
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team