Execution is stuck infinitely at workbook.calculateFormula().
And not even getting any error while processing some excel files.
Which version of Aspose.Cells for Node.js via Java you are using? Could you please zip and attach some sample Excel files where you are getting this issue. We will check your issue soon.
18-Locations-PO.zip (6.4 MB)
Hi,
PFA the attached excel file for given aspose.cells issue.
current version that we are using of aspose.cells is 23.1.0
@grenerobotics
By using the following sample code for testing on v24.3, the code can run normally.
The sample code as follows:
var aspose = aspose || {};
aspose.cells = require("aspose.cells");
const customFontsDir = '18-Locations-PO.xlsb';
var workbook = new aspose.cells.Workbook(customFontsDir);
workbook.calculateFormula();
Would you like to upgrade to v24.3 and test it again?
aspose license error.png (41.1 KB)
PFA the screenshot of error after updating aspose.cells to latest version.
As suggested, After upgrading getting the following error.
The subscription included in this license allows free upgrades until 2023-09-22, but this version of the product was released on 2024-03-11. Please renew the subscription or use
a previous version of the product.
As the error suggests, and I am afraid, your current license is expired (on 2023-09-22), so you cannot use any API version/fix of the product that is released after this date. To use latest versions/fixes, you got to upgrade your subscription to get new license. You may contact our sales team for it.
FYI, when you purchase a license for a product, you are authorized to use the license file with any new (and upcoming (official versions)) versions or hot fixes of the component for the next whole year. Moreover, your license will never expire if you continue to use your license with the product’s version/hotfix that should be released before your subscription expiry date.
As a side note, could you try using v23.9 or v23.8 that you can use with your current license if it works fine?
aspose.com Subscription 230908005900 Invoice 230908005900 2023-09-22 2024-09-22 (1).pdf (112.3 KB)
Hi, please check I already renewed the order. My current license expiry date is Sep 2024.
@grenerobotics
Thank you for your feedback. After obtaining the new license, please use the latest version v24.3 for testing. If you still encounter issues, please share your sample files and test code, and we will check it soon.
Moreover, please make sure to use new license as it seems your application is still using your older license.
As suggested, After upgrading getting the following error.
The subscription included in this license allows free upgrades until 2023-09-22, but this version of the product was released on 2024-03-11. Please renew the subscription or use
a previous version of the product.
aspose license error.png (41.1 KB)
The error suggests that you are still using your older license (instead of new license) in your application, so kindly replace your older license with newer license to be used. Please debug your licensing code and check which license file it is using?
Hi,
Hi,
After upgrading aspose.cells to latest version i.e. 24.3.0
and using below code snippet:
var aspose = aspose || {};
aspose.cells = require(“aspose.cells”);
const customFontsDir = ‘18-Locations-PO-5 (2).xlsb’;
var workbook = new aspose.cells.Workbook(customFontsDir);
workbook.calculateFormula();
console.log(“after calculate formula”);
still execution is stuck at workbook.calculateFormula();
I tested and it works instantly using your sample code template XLSB file (you attached earlier).
Could you please add a line to your code segment to check which version of the API you are using and make sure you are using the latest version of the API.
var aspose = aspose || {};
aspose.cells = require("aspose.cells");
console.log(aspose.cells.CellsHelper.getVersion());
const customFontsDir = '18-Locations-PO.xlsb';
var workbook = new aspose.cells.Workbook(customFontsDir);
workbook.calculateFormula();
console.log("after calculate formula");
Give us console or print log here.
Thanks for the new XLSB file.
I was able to to reproduce the issue as you mentioned using new template XLSB file. I found that execution stuck for sometime and then found “java.lang.OutOfMemoryError: Java heap space” at workbook.calculateFormula() method.
var aspose = aspose || {};
aspose.cells = require("aspose.cells");
console.log(aspose.cells.CellsHelper.getVersion());
var workbook = new aspose.cells.Workbook("18-Locations-PO-5 (2).xlsb");
workbook.calculateFormula();
console.log("after calculate formula");
We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNODEJSJAVA-63
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.
We are pleased to inform you that your issue (logged as “CELLSNODEJSJAVA-63”) has been resolved. The fix/enhancement will be included in the next release (Aspose.Cells v24.4) scheduled for release in April (next month). You will be notified when the next version is released.
Please tell when the next version is going to be released.
Is the fix/enhancement will be included in the next release (Aspose.Cells v24.4) scheduled for release in April (next month)?
Thankyou
We released the new version of Aspose.Cells for Node.js via Java v24.4 one or two days ago. Please download and try Aspose.Cells for Node.js via Java v24.4, and let us know if your issue is fixed in it.
Thank you so much for your support.