Plans for Macro Support?

Aspose.Cells Product Family
1

Hello,

I have a template with in-cell macros (to calculate forecast values for each month across a fiscal year).

I generate a workbook from data in the database and add formulas. Some are too complicated to use normal Excel formula syntax, hence, we use Macros.

The problem I'm having is that if I generate this workbook, then open it in Aspose, the cell values are undefined (#NAME?).

I know that if I open it in Excel (in a trusted location), i can get the cell values calculated.

My question is, do you have any plans on allow the execution of macros if the workbook is in a trusted location?

(Attached is an example).

Thanks

-frank

2

Hi,

Thank you for sharing the sample application.

I am afraid your requested feature of running macros programmatically through Aspose.Cells is not supported. Aspose.Cells only supports to preserve the macros. It does not support to run macros. The feature is already in our to-do list (Issue ID: CELLSNET-13561) and we will check if we can support this feature in our future release.

Sorry for any inconvenience caused,

3

Hi,

Thanks for using Aspose.Cells.

We only plan to create,
manipulate or embed VBA codes/ macros later. We however cannot support
to run or execute macros. Does it fit your needs?