GridJS - need the option to set the ReCalculateOnOpen

Aspose.Cells Product Family
1

Hi

When we work with WorkBook class we have the option to avoid calculation on on opening (i.e. - set the workbook.Settings.ReCalculateOnOpen to false)

Is this option available also for GridJS framework, when we load a workbook to the client and would like to avoid the calculations?

Thank for your support,
Ori

2

@orik,

Such an option may not be available in Aspose.Cells.GridJs. We have logged an investigation ticket with an id “CELLSGRIDJS-527” for your requirements. We will look into it soon.

Once we have an update on it, we will let you know here.

3

OK, thanks!

Looking forward for update on it.

Best regards,
Ori

4

We will open a new api for direct import file through Workbook object in the next version

public void ImportExcelFile(Workbook wb)

Currently ,you can also use the stream way to import workbook

Aspose.Cells.Workbook wb=new Aspose.Cells.Workbook("your file path");
                //do your workbook initlization
                 wb.Settings.ReCalculateOnOpen = false;
                using (MemoryStream ms=  new MemoryStream())
                { wb.Save(ms, SaveFormat.Xlsx);
                    
                    wbj.ImportExcelFile(  ms, GridLoadFormat.Auto);
                }

However ReCalculateOnOpen doesnot take affect in current version
We will fix this issue in next version

5

Hi Peter,

Thanks for your replay
I’ sorry, but I’m not sure I fully understand…

You suggested to use ReCalculateOnOpen of a Workbook, but you are saying it doesn’t work?

It doesn’t work at all?
Or it doesn’t work in the example you attached when using with GridJS?

Thanks
Ori

6

@orik,

As we told you, ReCalculateOnOpen won’t work even you use the stream way (as suggested) to import the workbook in the current version.

We will fix the issue in our upcoming version.

7

The fix is ready now.
The official release will be ready at next month.

8

Thank you!

Is there a way to be notified when a new version is released?

9

@orik,

The fix will be included in our next (regular) release: Aspose.Cells for .NET v22.3. The next version is scheduled to be published in the second week of March, 2022. You will be notified in this thread once the release is published.

10

@orik
You can now get it through nuget ,the latest version is 22.3