GridJsWorkbook and AbstractCalculationEngine

Aspose.Cells Product Family
,
1

I am using the GridJsWorkbook sample from this link:

Lets say that I have a custom calculation engine set using this code:

            Workbook workbook = new Workbook(fstream);

            // Create an instance of CustomEngine
            CustomEngine engine = new CustomEngine();

            // Create an instance of CalculationOptions
            CalculationOptions opts = new CalculationOptions();

            // Assign the CalculationOptions.CustomEngine property to the instance of CustomEngine
            opts.CustomEngine = engine;

            // Recalculate all formulas in Workbook using the custom calculation engine
            workbook.CalculateFormula(opts);

Does the GridJSWorkbook supports setting of custom calculation engine? I do have a number of user defined functions I would like to implement there.

Thanks

2

we will implement it in the next release version

3

Can you show your implemention code for Calculate method,
We need to envaluate it .

4

Thanks for the quick update.
Attached is the sample in our NON Js version.
We do want to have the similar capability in the GridJsWorkbook.
calculate_net.zip (8.1 KB)

5

We’ve check your file ,we will support it

6

Thank you - looking forward.

7

Please try the latest version v22.2, which you can get it through nuget

And also please check the document here:

8

Great, we will try.
BTW: Which license is required for this component?

9

@eyalmolad,

Please note, Aspose.Cells.GridJs is included in Aspose.Cells for .NET package, so if you bought the license for Aspose.Cells for .NET, you can use the same license for GridJs too.

Should you have further queries regarding licensing, feel free to post in Aspose.Pruchase section.