Suggest adding the following:
1 - Locking of cell data and protecting worksheet(s)
2 - Setting of more formatting data than just bold/underline/italic
3 - Ability to hide/show a worksheet
As our solution is cloud based I cannot just add these myself so am forced to log as an idea.
Comments
You can start by implementing this awesome contribution: github.com/AlexanderDeniskin/NAV/tree/master/ExcelBuffer
Category: Development
Further issues have arisen as I've continued down the functionality - Need the ability or choice to save as a macro enabled workbook .xlsm instead of it always being forced into .xlsx format.
A shame it isn't on the roadmap currently hopefully this receives some votes.
Category: Development
Business Central Team (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