Unplanned
Last Updated: 04 Jun 2025 16:24 by Thomas
IGK
Created on: 06 May 2022 04:25
Category: SpreadProcessing
Type: Bug Report
1
SpreadProcessing: Add API that allows one to manipulate the macros inside a Workbook
Add API that allows one to manipulate the macros inside a Workbook.
3 comments
Thomas
Posted on: 04 Jun 2025 16:24

Hello,

Thanks for your comment, I upvoted this feature and followed it to be notified.

For your remark on Using Charts using spreadsheet, in the cross-platform support part it says it is not supported (cf image below), and that's actually my problem, I can't use windows libraries because I'm in a linux environment so I can't create charts in my spreadsheet exports

 

That's why I said this feature could be a work around to this problem as the macro doesn't need to be executed when created but when the user want when the excel file is opened and the macro will work (kind of an ugly hack but enough for our end-users)
Regards,

Thomas

ADMIN
Dess | Tech Support Engineer, Principal
Posted on: 04 Jun 2025 14:07

Hello, Thomas,

Currently, RadSpreadProcessing provides support for the XLSM format (macro-enabled spreadsheet created by Microsoft Excel). However, macros are only preserved during import and export. They cannot be executed or changed in the code with the current implementation.

The public feedback portal allows us to be better aware of the needs of our customers by reviewing all requests and measuring their popularity. Our roadmap and priorities depend largely on the business value and customers' demand for specific features, and we take into account the most popular requests when planning our future development efforts. 

We are doing everything in our power to answer customer requests and needs by resolving these tasks as fast as possible, but some receive less attention than others, which is why they can sometimes be delayed, just like this. 

I can suggest you to cast your vote for them in order to increase their priority in our backlog and to make sure you are keeping track of it by subscribing if you haven't already. 

Regarding the charts inside a worksheet, you can also have a look at the Using Charts article summarizing the currently available functionality that may be applicable for the scenario you need to cover. If you have any further questions, you may consider submitting a support ticket from your Telerik account. Thus, the support engineers would provide further assistance.

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Thomas
Posted on: 04 Jun 2025 10:11

In my case, this feature could be nice

We can only use standard .net libraries (so no windows) because of that we don't have a solution to generate graph inside the excel file (except creating a image but that's not really nice)

So this solution could be a work-around to prepare a macro which generate the graph, and the end-user could use this macro to generate them